A mistake that I can see it. :(( 1

[C05MIN]

show tables' at line 1
mysql> show tables
-> ;
+--------------------+
| Tables_in_librarie |
+--------------------+
| carti |
| tabel_test |
+--------------------+
2 rows in set (0.02 sec)

mysql> set insert_id=#;
-> ALTER TABLE carti ADD id_carte INT UNSIGNED NOT NULL AUTO_INCREMENT FIRST , ADD INDEX (id_carte);
ERROR 1064: You have an error in your SQL syntax near 'ALTER TABLE carti ADD id_
carte INT UNSIGNED NOT NULL AUTO_INCREMENT FIRST , ADD ' at line 2
mysql>


Please help me. I search the syntax over and over
And I am receiving the same ERROR.

 

[r937]

remove the set insert_id=#;


rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[C05MIN]

Thanks for that.
I am a beginner and it shows!!
Thanks allot.