Sunday, July 12th, 2009
In order to insert value 0 in a field that is set as primary key for a MySQL table you need to execute the following query prior to any insert query:
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
Now you can successfully run the insert query with 0 set as value for a primary key, ...
Posted in MySQL, Programming | No Comments »
Monday, November 24th, 2008
Disabling foreign key checks in MySQL is usefull when you are dealing with tables that use foreign keys (InnoDB engine).
[caption id="attachment_105" align="alignleft" width="205" caption="MySQL logo"][/caption]
You can not delete (drop) multiple tables, a parent table or a child table until you disable foreign key checks four your current database.
The sql command ...
Posted in MySQL, Programming | 1 Comment »
Home
