MySQL:insert at mysql cmd line when using auto_increment
Posted: Thu May 23, 2002 4:27 am
Given the example table;
CREATE TABLE mytable
(
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
desc VARCHAR(30) NOT NULL
);
How do I insert records at the command line to utilise the auto_increment feature of MySQL.
i.e. INSERT INTO mytable VALUES(?,"description");
Any assistance will be greatly appreciated.
-Dickey
CREATE TABLE mytable
(
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
desc VARCHAR(30) NOT NULL
);
How do I insert records at the command line to utilise the auto_increment feature of MySQL.
i.e. INSERT INTO mytable VALUES(?,"description");
Any assistance will be greatly appreciated.
-Dickey