数据库语句

mysql -u root -p
密码


show databases;

use lesson

create table myuser
show tables
describe myuser
select * from myuser

create table myuser1111(username char(20) not null, password char(20) not null);


create table card(id char(30) not null, name char(30) not null,cardnumber char(30) not null,sex char(30) not null,department char(30) not null,kaoqin char(30) not null,menjin char(30) not null,qiyong char(30) not null,shuoming char(30) not null);

create table book_list(bookName char(30) not null,publishDate char(30) not null,price char(30) not null,author char(30) not null);


insert into myuser(username,password)values('a',1);
insert into book_list(bookName,publishDate,price,author)values('《PHP程序设计基础》','2014-8','40','传智播客研发部');
insert into book_list(bookName,publishDate,price,author)values('《JavaScript程序设计基础》','2014-8','30','传智播客研发部');

insert into book_list(bookName,publishDate,price,author)values('《Java从入门到放弃》','2014-8','99','传智播客研发部');

insert into account(username,password)values('a',1);


alter table imooc_admin change password password char(50) not null;

//SELECT CONCAT(username,'lijianli'),password FROM myuser;

select username = 'lijianli' from myuser;

SELECT (username,'lijianli') FROM myuser;

DELETE FROM myuser where username='a';

DROP TABLE myuser;

DROP DATABASE lesson;




create table myuser2(emlpoyeeID char(30) not null, employeeName char(30) not null, employeeCardID char(30) not null,employeeSex char(30) not null,partment char(30) not null,ischeck char(30) not null,isdoor char(30) not null, isstart char(30) not null,extra char(30) not null);

insert into myuser2(emlpoyeeID,employeeName,employeeCardID,employeeSex,partment,ischeck,isdoor,isstart,extra)values('13354156','lijianli','123456','male','it','y','y','y','nothing');


emlpoyeeID  employeeName employeeCardID employeeSex partment ischeck isdoor isstart extra


关键字查找:
select * from rfid_admin where concat(id,cardid,username,usertype,sex,email,phone,apartment,logintime) like '%{$keywords}%';


1、连接到本机上的MYSQL。
首先打开DOS窗口,然后进入目录mysql\bin,再键入命令mysql -u root -p,回车后提示你输密码.注意用户名前可以有空格也可以没有空格,但是密码前必须没有空格,否则让你重新输入密码。

如果刚安装好MYSQL,超级用户root是没有密码的,故直接回车即可进入到MYSQL中了,MYSQL的提示符是: mysql>

2、连接到远程主机上的MYSQL。假设远程主机的IP为:110.110.110.110,用户名为root,密码为abcd123。则键入以下命令:
    mysql -h110.110.110.110 -u root -p 123;(注:u与root之间可以不用加空格,其它也一样)

3、退出MYSQL命令: exit (回车)

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值