文章分类 - MySql面试题2024
摘要:mysql> alter table test add age tinyint(2) after id;
阅读全文
摘要:mysql> update test set name='oldgirl' where id=1;
阅读全文
摘要:mysql> select * from test where name='oldboy';
阅读全文
摘要:mysql> insert into test (id,name) values (2,'老男孩'),(3,'oldboyedu');
阅读全文
摘要:mysql> insert into test (id,name) values (1,'oldboy');
阅读全文
摘要:mysql> desc test; mysql> show create table test\G
阅读全文
摘要:mysql> create table test (id int(4),name varchar(16)) engine=InnoDB default charset=gbk;
阅读全文
摘要:mysql> select user,host from mysql.user;
阅读全文
摘要:mysql> show grants for oldboy@'localhost';
阅读全文
摘要:mysql> grant select,update,insert,delete,alter on oldboy.* to oldboy@'localhost' identified by '123456';
阅读全文
摘要:mysql> create database oldboy default character set gbk; mysql> show create database oldboy;
阅读全文
摘要:mysql> use T1; mysql> show tables;
阅读全文
摘要:# mysql -V mysql> select version();
阅读全文
摘要:mysql> show variables like "%charac%";
阅读全文
摘要:单实例登陆 mysql -uroot -p123456 多实例登陆 mysql -uroot -p123456 -S /data/3306/mysql.sock
阅读全文
摘要:方法一 mysqladmin -u root -p123456 password 'abc123' #比较常用 方法二(sql语句修改) update mysql.user set password=password(123456) where user='root' and host='local
阅读全文
摘要:lsof -i:3306 netstat -tunlp|grep 3306 ss -tulnp|grep 3306
阅读全文
摘要:开启服务: service mysqld start /init.d/mysqld start safe_mysql & 关闭服务: service mysqld stop /etc/init.d/mysqld stop mysqladmin -uroot -p123456 shutdown
阅读全文