huey2672的专栏

有时会遇到一种情况，当数据表中

sudo apt-get install mysql-client-5.5sudo apt-get install mysql-server-5.5

现在有张数据表users：CREATE TABLE users ( userid INT(10) UNSIGNED NOT NULL, username VARCHAR(100) UNIQUE, passwd VARCHAR(100) DEFAULT '123456', PRIMARY KEY (userid)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

数据库的导出：1. 进入MySQL目录下的bin文件夹，cd MySQL中到bin文件夹的目录（或者直接将windows的环境变量path中添加该目录）：如，cd C:\Program Files\MySQL\MySQL Server 4.1\bin2. 导出数据库，mysqldump -u 用户名 -p 数据库名 > 导出的文件名 ：如，mysqldump -u root -p

READ UNCOMMITTED （未提交度）在READ UNCOMMITTED

数值类型日期时间类型字符串类型

#数据库创建数据库CREATE DATABASE dream;

SYSDATE() returns the time at which it executes. This differs from the behavior for NOW(), which returns a constant time that indicates the time at which the statement began to execute. (Within a stor

字符串函数ASCII(str)说明：返回字符串str最左边字符的ASCII值[sql] view plaincopymysql>   SELECT ASCII('2');          -> 50  mysql>   SELECT ASCII(2);          -> 50  mysql>   SELEC