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
MySQL基本操作
[mysql@redhat ~]$ cat .my.cnf[mysql]user=rootpassword=root[mysqld]datadir=/mysql/mysql-5.0.41-linux-i686/data[mysql@redhat ~]$ cd /mysql/mysql-5.0.41-linux-i686[mysql@redhat mysql-5.0.41-linux-i686]$ ...
MySQL数据字典
law
The origin of "B-tree"
The origin of "B-tree" has never been explained by the authors. ... "balanced," "broad," or "bushy" might apply. Others suggest that the "B" stands for Boeing. [Bayer and McCreight were at Boeing Scie...
启动mysql时报错的解决(mysql 5.0.45 redhat as 43)
启动mysql时报错:Starting mysqld daemon with databases from /var/lib/mysqlSTOPPING server from pid file /var/run/mysqld/mysqld.pid071112 00:22:06 mysqld ended查看日志:#less /var/log/mysqld.log其中有...
十月怀胎,一朝分娩,《基于linux的Oracle数据库管理》完工
06年12月开始着手,到07年2月完成讲义雏形,然后讲授一遍。07年7月签订出版合同,又重新修改,花了半年时间,算起来也差不多花了10个月,今天终于把书稿寄给出版社了,可以歇一下了。预计2008年3月出版,但愿自己的...