OT: Show Constraint_type

[Peter Normann]

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]

Show Constraint_type

[Nguyen, Phong]

Good morning All,

What Mysql command show us CONSTRAINT_TYPE value as UNIQUE, PRIMARY KEY, or
FOREIGN KEY of and schema?

Thanks.Nguyen. 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Show Constraint_type

[SGreen]

Nguyen, Phong [EMAIL PROTECTED] wrote on 08/05/2005 08:26:58 AM:

 Good morning All,
 
 What Mysql command show us CONSTRAINT_TYPE value as UNIQUE, PRIMARY KEY, 
or
 FOREIGN KEY of and schema?
 
 Thanks.Nguyen. 
 

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

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Re: Show Constraint_type

[Gleb Paharenko]

Hello.





I think you should use the SHOW statements:

  http://dev.mysql.com/doc/mysql/en/show-create-table.html

http://dev.mysql.com/doc/mysql/en/show-index.html







Nguyen, Phong [EMAIL PROTECTED] wrote:

 Good morning All,

 

 What Mysql command show us CONSTRAINT_TYPE value as UNIQUE, PRIMARY KEY, or

 FOREIGN KEY of and schema?

 

 Thanks.Nguyen. 

 

 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]