《用MySQL创建数据库和数据库表》由会员分享，可在线阅读，更多相关《用MySQL创建数据库和数据库表（4页珍藏版）》请在装配图网上搜索。
1、用MySQL创建数据库和数据库表帐户luowei505050 的专栏类别数据库#用 MySQL 创建数据库和数据库表#1、使用SHOW语句找出在服务器上当前存在什么数据库:SHOW DATABASES;#2、创建一个数据库 db1create database db1;#3、选择你所创建的数据库use db1;#use test;#4、创建一个数据库表create tabIe t_person (FNamevarchar(20),Fageint);# 5、显示表的结构：SHOW TABLES;#查看表中数据seIect * from t_person;# 6、往表中加入记录Insert Int
2、o t_person(FName,FAge) vaIues(Jim,25);Insert Into t_person(FName,FAge) vaIues(green,38);Insert Into t_person(FName,FAge) values(kate,20);Insert Into t_person(FName,FAge) values(john,23);Insert Into t_person(FName,FAge) values(tom,28);Insert Into t_person(FName,FAge) values(daviy,30);#查看表中数据select *
3、from t_person;# 7、用文本方式将数据装入一个数据库表LOAD DATA LOCAL INFILE mytable.txt INTO TABLE pet;#其它操作insert into t_person(fname) values(lily);insert into t_person values(poly,22);updatet_person set fage=30;updatet_person set fage=20 where fname=tom;updatet_person set fage=50 where fname=tom or fname=jim;delete
4、from t_person where fname=jim;delete from t_person where fage30;delete from t_person;drop table t_person;#=CREATE TABLE t_employee (fnumbervarchar(10),fnamevarchar(20),fageint,fsalaryint);insert into t_employee(fnumber,fname,fage,fsalary) values(001,tom,20,5000);insert into t_employee(fnumber,fname,
5、fage,fsalary) values(002,jim,23,3000);insert into t_employee(fnumber,fname,fage,fsalary) values(003,lily,30,6000);insert into t_employee(fnumber,fname,fage,fsalary) values(004,lucy,19,2000);insert into t_employee(fnumber,fname,fage,fsalary) values(004,tomjim,19,2000);select * from t_employee where fname like %m%;select * from t_employee where fname like j%;select * from t_employee where fsalary4000 and fsalary5000;select * from t_employee order by FSalaryasc; #升序 select * from t_employee order by FSalarydesc; #降序 select * from t_employee;#= use test;drop database db1;
用MySQL创建数据库和数据库表
