1、一、安裝數(shù)據(jù)庫可視化工具Navicat for MySQL二、新建一個鏈接1.配置鏈接，確認連接成功2.測試是否成功3.提示成功4.確定三、操作數(shù)據(jù)庫1.選中要操作的數(shù)據(jù)庫2.選中查詢3.新建查詢四、操作數(shù)據(jù)庫表1.增 INSERT INTO語法：INSERT INTO table_name( field1, field2,.fieldN)VALUES( value1 ,value2,.valueN);例子INSERT INTO t_staff (staffName, sex, email, mobile) VALUES 系('統(tǒng)管理員 ', NULL, '',

2、 '19911112222');2.刪 delete語法：DELETE FROM table_name WHEREClause 例子：刪除t_staff 表里面的數(shù)據(jù)delete from t_staff where staffName =苗丹3.改 UPDATE語法：UPDATE table_name SET field1=new- value1 , field2=new- value2 WHEREClause 例子：UPDATEt_staffSETid='21',departmentId=NULL,userRoleId='0',staffCo

3、de='dev',password='96e79218965eb72c92a549dd5a330112',staffName='系統(tǒng)管理員',sex=NULL,email='',mobile='19911112222', phone='', age=NULL, birthday=NULL, idCard='', creatorId=NULL, createTime='2017-03-1413:49:00', updatorId='21',updateT

4、ime='2018-01-1514:28:50',status='0', token=NULL, serviceId=NULL,ts='2018-02-26 11:24:25', dr='0', lastlogintime='2018-02-26 11:24:25', authorizeid='23', authorizetime='2017-09-0816:51:54',userstatus='1',orgtype=NULL,city=NULL,servicecou

5、nt='0',qualification=NULL,qualificationaudit=NULL,invitermobile=NULL,score=NULL,totalmoney=NULL,hisscore=NULL,histotalmoney=NULL, cardmobile=NULL, bankname=NULL, bankno=NULL, bankcode=NULL, bindbankdate=NULL WHERE (id='21');4.查 select語法：SELECT column_name , column_nameFROM table_name

6、 WHEREClause LIMIT N OFFSET M控制查詢條目數(shù)1）查詢某張表t_staff 為例* :代表所有如果只是單查其中某幾個字段，select 后面跟字段名select * from t_staff2）帶上條件的查詢（where ）select * from t_staff where staffName =苗丹3）查詢固定的幾個字段select staffCode,staffName,mobile from t_staff where staffName =苗丹4）控制條目數(shù)limitselect * from t_staff LIMIT 0,10 從 0 開始，查 10

7、條數(shù)據(jù)5.查詢where語法：SELECT field1, field2,.fieldN FROM table_name1, table_name2. WHERE condition1 AND ORcondition2.6.排序order by語法：SELECT field1, field2,.fieldN table_name1, table_name2.ORDER BY field1, field2. ASC DESC例子：select * from t_staff where staffName like '%苗 %' and score >3 ORDER BY score desc7.關(guān)聯(lián)查詢left join例子：SELE