-
编辑 删除
MySQL中的事务处理
事务处理[@more@]
-
编辑 删除
MySQL中的describe命令
mysql> help describeName: 'DESCRIBE'Description:Syntax:{DESCRIBE | DESC} tbl_name [col_name | wild]DESCRIBE provides information about the columns in a table. It is ashortcut for SHOW COLUMNS FROM. As of MySQL 5.0.1, these statementsalso display information for views. (See [HELP SHOW COLUMNS].)URL: http://dev.mysql.com/doc/refman/5.0/en/describe.html[@more@]
-
编辑 删除
MySQL中的show命令
mysql> help showName: 'SHOW'Description:SHOW has many forms that provide information about databases, tables,columns, or status information about the server. This section describesthose following:SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [LIKE 'pattern']SHOW CREATE DATABASE db_nameSHOW CREATE FUNCTION funcnameSHOW CREATE PROCEDURE procnameSHOW CREATE TABLE tbl_nameSHOW DATABASES [LIKE 'pattern']SHOW ENGINE engine_name {LOGS | STATUS }SHOW [STORAGE] ENGINESSHOW ERRORS [LIMIT [offset,] r
