 | | | String length of SQl-Statements, creating table | String length of SQl-Statements, creating table 2006-11-03 - By Peter Prinzen
Back
Hi,
I'm creating a table with ADO and ODBC, and use therefor a CONExecute
"SQL..." w SQL="CREATE TABLE /*!32300 IF NOT EXISTS*/ test.table `ID`
INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, ...". No problem so far, but
two questions: When I create a more complicated table, I get an error,
I guess because the SQL-string is too long. Are there any limits?
Another point: How can I create and ALTER an existing table, to create
the table column after column? Are there any functions to get a list
of existing columns?
The last one: I copied the "CREATE TABLE /*!32300 IF NOT EXISTS*/
from soem other i-net forum. But I would like to know the meaning of
"/*!32300 IF NOT EXISTS*/ ". Any hints here?
Thanks a lot
Peter
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=mysql@(protected)
|
|
|