mysql入门

转到mysql目录

mysql -uroot -p  //然后输入密码

mysql-> ip -u用户 -p密码;  //连接远程主机

create database; 库名; 

show databases; 显示所有的数据库。

drop database 库名；

create table item( id int(10), name vachar(20) NOT NULL, sex varchar(20) NOT NILL );

mysql> select *FROM fillz;  //显示数据
+--------+------+
| Id | nn |
+--------+------+
| 000152 | 152 |
| 000008 | 9 |
| 023120 | 563 |
+--------+------+
3 rows in set (0.00 sec)

mysql> show columns from fillz； //显示结构

+-------+--------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------------------+------+-----+---------+-------+
| Id | int(6) unsigned zerofill | YES | | NULL | |
| nn | int(6) | YES | | NULL | |
+-------+--------------------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> show status;//查看状态

mysql> show processlist;//查看进程