一个查询语句的sql 如何 做 ?如果是一个表 很简单 mysqldump -uroot -proot om usertablename >user.sql
现在是一个select 语句 问该如何导出
如果利用上面的语句来实现 mysqldump ... "select * from usertablename where date>'2010-01-01' "?
这个语句完整写法???
现在是一个select 语句 问该如何导出
如果利用上面的语句来实现 mysqldump ... "select * from usertablename where date>'2010-01-01' "?
这个语句完整写法???
mysql Ver 14.14 Distrib 5.1.42, for pc-linux-gnu (i686) using readline 5.1
Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Usage: mysql [OPTIONS] [database]
-?, --help Display this help and exit.
-I, --help Synonym for -?
--auto-rehash Enable automatic rehashing. One doesn't need to use
'rehash' to get table and field completion, but startup
and reconnecting may take a longer time. Disable with
--disable-auto-rehash.
-A, --no-auto-rehash
No automatic rehashing. One has to use 'rehash' to get总是 错误
才是ok 的 反复测试好多次 幸亏有好的linux能力 否则这个bug难找到 另外i用 工具 navcat 可以用 elect * from a into outfile 'c:\aaa.sql'”;
会发现他 在 test 的目录 下 生成 c:a.sql
insert into valuse (+data)
格式 能方便不同数据库之间的 移植