mysql 语句积累

 

1、插入语句

 

INSERT INTO t_member (id, name, email) VALUES
    (1, 'nick', 'nick@126.com'),
    (4, 'angel','angel@163.com'),
    (7, 'brank','ba198@126.com');

UPDATE t_member SET name='nick', email='nick@126.com' WHERE id=1;

 

mysqli_query("set names  utf8"); 设置字符集

mysql  修改密码

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');

 

--改变表的编码，为utf8mb4
alter table `topic_video_comment`   convert to character set  utf8mb4;

 

mysql  设置账号 密码

CREATE USER 'username'@'host' IDENTIFIED BY 'password';

授权

GRANT privileges ON databasename.tablename TO 'username'@'host'

• GRANT ALL  ON *.*  TO 'hhb'@'localhost';
• flush privileges;

mysql   ssh 远程连接方法

http://blog.sina.com.cn/s/blog_48f9c0840100tp5h.html