mysql常用SQL语句
一、表的导入导出语句及时间字符串部分处理函数
导出数据库所有表的结构 mysqldump -uroot -proot db_name -d > d:/export_db.sql(结尾不用分号)
导出数据库某个表的结构 mysqldump -uroot -proot db_name table_name -d > d:/export_table.sql(结尾不用分号)
导入SQL文件 source e:/test.sql;
清空表 truncate table table_name;
利用正则删除全英文的记录 delete from table_name where (select name REGEXP '^[-&(),.a-zA-Z_;[:blank:] ]+$')=1
当前时间加4小时 select date_add(now(), interval 4 hour); 输出:2009-10-27 12:47:57
连接字符串 select concat('first',' end') ; 输出:first end
替换字符串 select replace('abcabc','a','e'); 输出:ebcebc
二、select into 和 insert into select 两种表复制语句
select * into destTbl from srcTbl
insert into destTbl(fld1, fld2) select fld1, 5 from srcTbl
以上两句都是将 srcTbl 的数据插入到 destTbl,但两句又有区别的:
* 第一句(select into from)要求目标表(destTbl)不存在,因为在插入时会自动创建。
* 第二句(insert i
相关文档:
代码如下:
1 String command = " cmd /c C:/Program Files/MySQL/MySQL Server 5.0/bin>mysqldump -h localhost -u root -p aijia > E:/aijia.dmp " ;
2 try {
3 Process process& ......
USE AdventureWorks
GO
CREATE PROC spEmployee
AS
SELECT * from Humanresources.Employee
EXEC spEmployee
ALTER PROC spEmployee
AS SELECT EmployeeID from Humanresources.Employee
drop proc spEmployee
ALTER PROC spEmployee
@LastName nvarchar(50) = NULL
AS
IF @LastName IS NULL
SELECT * f ......
查询一天:
select * from table where to_days(column_time) = to_days(now());
select * from table where date(column_time) = curdate();
查询一周:
select * from table where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(column_time);
查询一个月:
select * from table where DATE_SUB(CUR ......
http://blog.csdn.net/digyso888/archive/2008/12/18/3552981.aspx
MySQL安装的图解5.0.28 收藏
MySQL安装的图解(最新版) 打开下载的mysql安装文件mysql-5.0.27-win32.zip,双击解压缩,运行“setup.exe”,出现如下界面:
mysql安装向导启动,按“Next”继续
选择� ......