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 (回车)