Suppose you have two table one is child table (profile) and second is parent table (login) .You can get this error when setting a foreign ...
READ MORE +
Showing posts with label MYSQL. Show all posts
Showing posts with label MYSQL. Show all posts
How to take scheduled Backup with MySQL in windows ?
Step 1: First you need to install MySQL Server with MySQL Administrator.I hope that it is installed well in your Computer. Step 2: Click ...
READ MORE +
How to solve MySQL server gone away error 2006 problem (if .sql file size is too large )?
When you try to import large file ( if you are working with big BLOB columns) , like i am trying to import 140 MB size .sql file, then MyS...
READ MORE +
How to select Last One Year Records in MYSQL?
SELECT * FROM < table_name > WHERE < date_field > BETWEEN DATE_SUB(NOW(), INTERVAL 1 YEAR ) AND NOW(); Similarly, You ...
READ MORE +
How to select Last One Month Records in MYSQL?
SELECT * FROM < table_name > WHERE < date_field > BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH ) AND NOW(); Similarly, You...
READ MORE +
How to select Records between Today and Last 30 Days in MYSQL?
SELECT * FROM < table_name > WHERE < date_field > BETWEEN DATE_SUB(NOW(), INTERVAL 30 DAY ) AND NOW(); Similarly, You ...
READ MORE +
Subscribe to:
Posts
(
Atom
)