mysql常见命令
1. 启动 mysqlmysql -u root -p
2. 修改密码:
mysqladmin -u用户名 -p旧密码 password 新密码
3. 显示命令
复制代码 代码如下:
show databases;
use mydb;
show tables;
describe tablename;
create database databasename;
create table tablename;
drop table tablename;
drop database databasename;
delete from tablename;
select * from tablename;
insert into tablename values('','');
4. 从文件中导入mysql
mysql -u root -p
本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u/14819/showart_2117204.html
页:
[1]