mysql增删改查和基本操作

2018年4月23日作者张舫

1. 增:

insert into table_name (id,name) values(0,'尹当')

1	insert into table_name (id,name) values(0,'尹当')

2.删数据:

delete from table_name where id=1;

1	delete from table_name where id=1;

3. 改:

update table_name set name='张舫' where id=6;

1	update table_name set name='张舫' where id=6;

4.查:

select * from table_name where id=1;

1	select * from table_name where id=1;

<span class="hljs-keyword">SELECT</span>
    d.dyName,
    w.storeNo,
    w.stackingNumber,
    w.propellantList,
    w.propellantListMd5,
    <span class="hljs-built_in">COUNT</span>( <span class="hljs-operator">*</span> ) <span class="hljs-keyword">AS</span> totalCount 
<span class="hljs-keyword">FROM</span>
    jobsTable j
    <span class="hljs-keyword">JOIN</span> dyInfoTable d <span class="hljs-keyword">ON</span> j.id <span class="hljs-operator">=</span> d.jobsId
    <span class="hljs-keyword">JOIN</span> WorkTable w <span class="hljs-keyword">ON</span> d.id <span class="hljs-operator">=</span> w.dyInfoId 
<span class="hljs-keyword">WHERE</span>
    j.state <span class="hljs-operator">=</span> <span class="hljs-number">1</span> 
    <span class="hljs-keyword">AND</span> d.dyName <span class="hljs-operator">=</span> <span class="hljs-string">'张舫'</span> 
    <span class="hljs-keyword">AND</span> (j.type <span class="hljs-operator">=</span> <span class="hljs-number">1</span> <span class="hljs-keyword">OR</span> j.type <span class="hljs-operator">=</span> <span class="hljs-number">2</span>)     #长见识了
<span class="hljs-keyword">GROUP</span> <span class="hljs-keyword">BY</span>
    w.propellantListMd5,
    w.storeNo,
    w.stackingNumber;

SELECT

d.dyName,

w.storeNo,

w.stackingNumber,

w.propellantList,

w.propellantListMd5,

COUNT( * ) AS totalCount

FROM

jobsTable j

JOIN dyInfoTable d ON j.id = d.jobsId

JOIN WorkTable w ON d.id = w.dyInfoId

WHERE

j.state = 1

AND d.dyName = '张舫'

AND (j.type = 1 OR j.type = 2) #长见识了

GROUP BY

w.propellantListMd5,

w.storeNo,

w.stackingNumber;

mysql数据的导入导出

导入数据:

       用户名     密码         数据库
mysql [-uroot] [-p***] [laravel-shop] < ./database/admin.sql             #中括号[]代表可选参数

1 2	用户名密码数据库 mysql [-uroot] [-p***] [laravel-shop] < ./database/admin.sql #中括号[]代表可选参数

导出数据:

           用户名    密码     数据库
mysqldump [-uroot] [-p***] [laravel-shop] > admin.sql                    #中括号[]代表可选参数

1 2	用户名密码数据库 mysqldump [-uroot] [-p***] [laravel-shop] > admin.sql #中括号[]代表可选参数

mysql 默认选择数据库的格式

utf8_general_ci

关于作者

张舫

好好学习天天向上