MySQL下复制表格的方法
Friday, 27. February 2009, 05:28:46
CREATE TABLE new_table LIKE original_table; INSERT INTO new_table SELECT * FROM original_table;
这样做的好处是同时复制表格的主键等。
如果只是复制数据:
CREATE TABLE new_table AS SELECT * FROM original_table;
即可。
无不用其“极”
Friday, 27. February 2009, 05:28:46
CREATE TABLE new_table LIKE original_table; INSERT INTO new_table SELECT * FROM original_table;
CREATE TABLE new_table AS SELECT * FROM original_table;
Sunday, 10. February 2008, 08:42:17
Thursday, 14. June 2007, 02:57:59
Friday, 9. February 2007, 00:56:07
Thursday, 8. February 2007, 04:03:33
Tuesday, 1. August 2006, 02:01:18
Monday, 24. July 2006, 06:12:54

Sunday, 21. May 2006, 00:14:17
Thursday, 18. May 2006, 10:51:51
[mysql] default-character-set = sjis [mysqld] default-character-set = utf8 init_connect="SET NAMES sjis" [mysqldump] default-character-set = binary
Wednesday, 19. April 2006, 09:32:32
mysqlshow -u root -p
mysqladmin -u root -p shutdown
[mysqld_safe] datadir = /opt/oss/var/mysql
[mysqld_safe] datadir = /opt/oss/var/mysql/data
mkdir -p /optoss/var/mysql/data
mv test /opt/oss/var/mysql/data
openpkg rc mysql start
Showing posts 1 - 10 of 12.
| S | M | T | W | T | F | S |
|---|---|---|---|---|---|---|
|
| ||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| 8 | 9 | 10 | 11 | 12 | 13 | 14 |
| 15 | 16 | 17 | 18 | 19 | 20 | 21 |
| 22 | 23 | 24 | 25 | 26 | 27 | 28 |
| 29 | 30 | |||||
LinuxSir
Linux中坚站
为Linux工程师提供技术动力
打造中国最大的UNIX/LINIX资讯站
My mirror, my window, the bridge connecting you and I.
关注:php,mysql,ajax ,linux, js,开源
有用的Opera菜单
なにもあたらしくない
By Adam Li
By Satoru Watanabe
by singway
by 摸鱼儿
by Somh
by 法师
by yumumao
Maybe I was a Bird in another Life !
投放广告挣美元,可用PayPal接收付款
免费网页模板
数据表格样式收集