mysql常见命令
http://www.cnblogs.com/bluecobra/archive/2012/01/11/2318922.html
0、mysql服务的启动与停止 net stop mysql net start mysql
导入frm表,先停止服务,再将database拷到data下,將ibdata1复制进去(原ibdata1要备份)
1、打包成.sql
dos下,cd C:\Program Files\MySQL\MySQL Server 5.5\bin (dos下,不要 ;复制dos下的,标记再复制,复制到dos,右击粘贴)
mysqldump --user root --password = 123456 epos_server >d:\epos.sql
或者mysqldump -h 127.0.0.1 -u root -p123456 epos_server >d:\epos.sql
PS:-h 127.0.0.1可以省略。
mysql.exe -h 127.0.0.1 -u root -p123456
2、导入到数据库
mysql下,create database epos;
use epos;
source d:/aa.sql;
3、常见操作命令(_表示1个字符 %表示0-n个字符)
create database base; create table frm;create table mytable(name varchar(32),passwd varchar(20));
show databases; show tables; (先use base;)
drop database base;
insert into mytable values("name","dfas","11")
update mytable set sex="f" where id="1"
truncate table;
4、清空表中记录 delete from 表名;
5、修改数据库编码
查看:show variables like 'character%'; show variables like 'collation_%
';
修改:set
character_set_client = utf8 ;
my.ini中增加
[mysqld]
default-character-set=utf8
character-set-server=utf8
character-set-filesystem =utf8