Re: I'd like to know SQL query for table description.

Hello. See: http://dev.mysql.com/doc/mysql/en/SHOW_CREATE_TABLE.html ninjajs <[EMAIL PROTECTED]> wrote: > Hi. ALL > > i have a database in MySQL. > > A middleware request to MySQL DB server. > > and then, result is table description. > > ex) > dbms_type,table_name,column_nam

RE: I'd like to know SQL query for table description.

[snip] and then, result is table description. ex) dbms_type,table_name,column_name,data_type,data_size,constraint_type What SQL query can I get this information ? [/snip] DESCRIBE `tablename`; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: I'd like to know SQL query for table description.

Try this query - show table status from YourDatabaseName; ninjajs wrote: Hi. ALL i have a database in MySQL. A middleware request to MySQL DB server. and then, result is table description. ex) dbms_type,table_name,column_name,data_type,data_size,constraint_type What SQL query can I get this infor

I'd like to know SQL query for table description.

Hi. ALL i have a database in MySQL. A middleware request to MySQL DB server. and then, result is table description. ex) dbms_type,table_name,column_name,data_type,data_size,constraint_type What SQL query can I get this information ? thank you. -- MySQL General Mailing List For list archive