Hi everybody, [EMAIL PROTECTED] wrote:
> I believe you are looking for the SHOW CREATE TABLE > command. If I am using the MySQL CLI, I prefer the output > formatted with the \G terminator instead of the ; > terminator like this > > SHOW CREATE TABLE tablename\G This is a life saver - I wasn't even aware of the \G terminator. While we are at it, is there any way to cancel a query you just executed? If, for example, you accidently executed a query in the mysql console that would return a million records, is it possible to cancel that query from the console? Pressing ctrl-c would kill the client... Peter Normann -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]