: When creating a table can you use multiple Table_Options?
:
: The O'Reilly "Managing & Using MySQL" show on page 288 a
: table been created
: with two options "...)AUTO_INCREMENT = 1, TYPE=InnoDB;"
No commas used to seperate multiple options. Here is an example I just
tried out, and I am afraid your book may be wrong ;-)
mysql> SELECT VERSION();
+-----------+
| VERSION() |
+-----------+
| 3.23.54 |
+-----------+
mysql> CREATE TABLE test (
-> id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY)
-> TYPE=MyISAM AUTO_INCREMENT=10;
mysql> INSERT INTo test SET id=NULL;
mysql> SELECT * FROM test;
+----+
| id |
+----+
| 10 |
+----+
Good luck
Sherzod
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
