https://blog.youkuaiyun.com/flanetzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/flanet/article/details/20563363https://blog.youkuaiyun.com/flanet/article/details/20563363flanetWed, 05 Mar 2014 19:02:06 +0800https://blog.youkuaiyun.com/flanet/article/details/8848468https://blog.youkuaiyun.com/flanet/article/details/8848468flanetThu, 25 Apr 2013 10:49:20 +0800https://blog.youkuaiyun.com/flanet/article/details/8838808https://blog.youkuaiyun.com/flanet/article/details/8838808flanetTue, 23 Apr 2013 11:18:05 +0800https://blog.youkuaiyun.com/flanet/article/details/8737985https://blog.youkuaiyun.com/flanet/article/details/8737985flanetFri, 29 Mar 2013 18:48:55 +0800https://blog.youkuaiyun.com/flanet/article/details/8737979https://blog.youkuaiyun.com/flanet/article/details/8737979flanetFri, 29 Mar 2013 18:47:31 +0800 create table MyClass( > id int(4) not null primary key auto_increment, > name char(20) not null, > sex int(4) not null default '0', > degree double(16,2)); 2]]>https://blog.youkuaiyun.com/flanet/article/details/8737967https://blog.youkuaiyun.com/flanet/article/details/8737967flanetFri, 29 Mar 2013 18:44:12 +0800 create database xhkdb; 2、显示所有的数据库 命令：show databases （注意：最后有个s） mysql> show databases; 3、删除数据库 命令：drop database 例如：删除名为 xhkdb的数据库 mysql> drop da]]>https://blog.youkuaiyun.com/flanet/article/details/8737963https://blog.youkuaiyun.com/flanet/article/details/8737963flanetFri, 29 Mar 2013 18:43:11 +0800 2、退出MySQL：quit或exit]]>https://blog.youkuaiyun.com/flanet/article/details/8737958https://blog.youkuaiyun.com/flanet/article/details/8737958flanetFri, 29 Mar 2013 18:41:54 +0800 导出的文件名(数据库默认编码是latin1) mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql 2.导出一个表 mysqldump -u 用户名 -p 数据库名 表名> 导出的文件名 mysqldump -u wcnc]]>https://blog.youkuaiyun.com/flanet/article/details/8737354https://blog.youkuaiyun.com/flanet/article/details/8737354flanetFri, 29 Mar 2013 16:36:17 +0800https://blog.youkuaiyun.com/flanet/article/details/8732008https://blog.youkuaiyun.com/flanet/article/details/8732008flanetThu, 28 Mar 2013 16:13:08 +0800https://blog.youkuaiyun.com/flanet/article/details/8713060https://blog.youkuaiyun.com/flanet/article/details/8713060flanetSun, 24 Mar 2013 16:10:16 +0800https://blog.youkuaiyun.com/flanet/article/details/8712271https://blog.youkuaiyun.com/flanet/article/details/8712271flanetSun, 24 Mar 2013 11:46:25 +0800https://blog.youkuaiyun.com/flanet/article/details/8640802https://blog.youkuaiyun.com/flanet/article/details/8640802flanetWed, 06 Mar 2013 10:08:26 +0800https://blog.youkuaiyun.com/flanet/article/details/8544730https://blog.youkuaiyun.com/flanet/article/details/8544730flanetSat, 26 Jan 2013 15:35:32 +0800https://blog.youkuaiyun.com/flanet/article/details/8544710https://blog.youkuaiyun.com/flanet/article/details/8544710flanetSat, 26 Jan 2013 15:30:28 +0800https://blog.youkuaiyun.com/flanet/article/details/8539176https://blog.youkuaiyun.com/flanet/article/details/8539176flanetThu, 24 Jan 2013 17:37:53 +0800https://blog.youkuaiyun.com/flanet/article/details/8524426https://blog.youkuaiyun.com/flanet/article/details/8524426flanetMon, 21 Jan 2013 13:27:04 +0800https://blog.youkuaiyun.com/flanet/article/details/8505448https://blog.youkuaiyun.com/flanet/article/details/8505448flanetTue, 15 Jan 2013 14:01:56 +0800https://blog.youkuaiyun.com/flanet/article/details/8505364https://blog.youkuaiyun.com/flanet/article/details/8505364flanetTue, 15 Jan 2013 13:45:08 +0800https://blog.youkuaiyun.com/flanet/article/details/8504997https://blog.youkuaiyun.com/flanet/article/details/8504997flanetTue, 15 Jan 2013 11:47:01 +0800