1.创建数据库
CREATE DATABASE IF NOT EXISTS mydatabase;
2.创建表
CREATE TABLE IF NOT EXISTS mytable (colum1 int primary key auto_increment, colum2 char(32), colum3 vchar(2048)....);
创建一个数据表,并设置第一个字段为主键且自动增长;
3.查询
select * from mytable where name='xiaohua';
select concat(last_name, ',' ,first_name) as full_name from mytable order by full_name;
4.更改数据库
use database1;
use database2;
5.获取当前的数据库名称
select database();
显示说有数据库的名称;
show databases;