1.MySQL基础

1、创建一个数据库：

create database db_test;

2、创建一个表：

1MySQL [mysql]> use db_test;
2Database changed
3MySQL [db_test]> create table tb_test ( id int(11) primary key, name varchar(25), salary float );
4Query OK, 0 rows affected (0.37 sec)

3、查看表结构：

1MySQL [db_test]> desc tb_test;
2+--------+-------------+------+-----+---------+-------+
3| Field  | Type        | Null | Key | Default | Extra |
4+--------+-------------+------+-----+---------+-------+
5| id     | int(11)     | NO   | PRI | NULL    |       |
6| name   | varchar(25) | YES  |     | NULL    |       |
7| salary | float       | YES  |     | NULL    |       |
8+--------+-------------+------+-----+---------+-------+

4、向表内插入数据和查看数据：

1MySQL [db_test]> insert into tb_test (id,name,salary)  VALUES(1,'斯**',*000),(2,'刘**',*000);
2Query OK, 2 rows affected (0.07 sec)
3Records: 2  Duplicates: 0  Warnings: 0
4
5MySQL [db_test]> select * from db_test.tb_test;
6+----+-----------+--------+
7| id | name      | salary |
8+----+-----------+--------+
9|  1 | 斯**    |   *000 |
10|  2 | 刘**    |   *000 |
11+----+-----------+--------+
122 rows in set (0.03 sec)

※ 为MySQL的root用户设置密码(在第一次安装完后)：

mysqladmin -u root password 'newpassword'

※

※

※

※

※