公司mysql脚本

最新推荐文章于 2023-01-28 09:00:00 发布
最新推荐文章于 2023-01-28 09:00:00 发布
阅读量307 收藏 1
点赞数 1
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_37565521/article/details/87803287
版权

invoiceStartTime 企业最早开票时间

SELECT
min(t2.date)
FROM (
SELECT
invoice_info_tmp.billing_date AS date,
invoice_info_tmp.state,
invoice_info_tmp.amount_tax,
@rownum := @rownum + 1,
if(@pInvoiceCode = invoice_info_tmp.invoice_code AND
@pInvoiceNumber = invoice_info_tmp.invoice_number,
@rank := @rank + 1, @rank := 1) AS rank,
@pInvoiceCode := invoice_info_tmp.invoice_code,
@pInvoiceNumber := invoice_info_tmp.invoice_number
FROM (
SELECT
t1.invoice_code,
t1.invoice_number,
t1.billing_date,
t1.state,
t1.amount_tax
FROM inoutput t1
WHERE t1.corp_id = ‘BW0020180606320’ AND t1.bz=1
ORDER BY t1.invoice_code, t1.invoice_number ASC, state DESC
) invoice_info_tmp, (SELECT
@rownum := 0,
@pInvoiceCode := NULL,
@pInvoiceNumber := NULL,
@rank := 0) temp
) t2
WHERE t2.rank = 1 AND t2.state !=2;

#maxInvoiceMonthNuml12M过去12个月最大连续开票月份数(有点问题)

SELECT
left(t2.billing_date,7)
FROM
(
SELECT
invoice_info_tmp.billing_date,
invoice_info_tmp.amount_tax,
invoice_info_tmp.state,
@rownum := @rownum + 1,
if(@pInvoiceCode = invoice_info_tmp.invoice_code AND
@pInvoiceNumber = invoice_info_tmp.invoice_number,
@rank := @rank + 1, @rank := 1) AS rank,
@pInvoiceCode := invoice_info_tmp.invoice_code,
@pInvoiceNumber := invoice_info_tmp.invoice_number
FROM (
SELECT
t1.invoice_code,
t1.invoice_number,
t1.billing_date,
t1.amount_tax,
t1.state
FROM inoutput t1
WHERE t1.corp_id = ‘BW0020180606307’ AND t1.bz = 1
and t1.billing_date BETWEEN ‘2018-02-01’ AND ‘2019-01-31’
ORDER BY t1.invoice_code, t1.invoice_number ASC, state DESC
) invoice_info_tmp, (SELECT
@rownum := 0,
@pInvoiceCode := NULL,
@pInvoiceNumber := NULL,
@rank := 0) temp
) t2
WHERE t2.rank = 1 AND t2.state !=2
GROUP BY left(t2.billing_date,7);

invoiceAmtL12M 过去12个月开票金额总数

SELECT
sum(t2.amount_tax)

AS validAmountTax

FROM (
SELECT
invoice_info_tmp.billing_date,
invoice_info_tmp.amount_tax,
invoice_info_tmp.state,
@rownum := @rownum + 1,
if(@pInvoiceCode = invoice_info_tmp.invoice_code AND
@pInvoiceNumber = invoice_info_tmp.invoice_number,
@rank := @rank + 1, @rank := 1) AS rank,
@pInvoiceCode := invoice_info_tmp.invoice_code,
@pInvoiceNumber := invoice_info_tmp.invoice_number
FROM (
SELECT
t1.invoice_code,
t1.invoice_number,
t1.billing_date,
t1.amount_tax,
t1.state
FROM inoutput t1
WHERE t1.corp_id = ‘BW0020180606320’ AND t1.bz = 1
ORDER BY t1.invoice_code, t1.invoice_number ASC, state DESC
) invoice_info_tmp, (SELECT
@rownum := 0,
@pInvoiceCode := NULL,
@pInvoiceNumber := NULL,
@rank := 0) temp
) t2
WHERE t2.rank = 1 AND t2.state !=2
and t2.billing_date BETWEEN ‘2018-02-1’ AND ‘2019-01-31’;

#invoiceAmtL24M 过去24个月开票金额总数
SELECT
sum(t2.amount_tax) AS validAmountTax
FROM (
SELECT
invoice_info_tmp.billing_date,
invoice_info_tmp.amount_tax,
invoice_info_tmp.state,
@rownum := @rownum + 1,
if(@pInvoiceCode = invoice_info_tmp.invoice_code AND
@pInvoiceNumber = invoice_info_tmp.invoice_number,
@rank := @rank + 1, @rank := 1) AS rank,
@pInvoiceCode := invoice_info_tmp.invoice_code,
@pInvoiceNumber := invoice_info_tmp.invoice_number
FROM (
SELECT
t1.invoice_code,
t1.invoice_number,
t1.billing_date,
t1.amount_tax,
t1.state
FROM inoutput t1
WHERE t1.corp_id = ‘BW0020180606320’ AND t1.bz = 1
ORDER BY t1.invoice_code, t1.invoice_number ASC, state DESC
) invoice_info_tmp, (SELECT
@rownum := 0,
@pInvoiceCode := NULL,
@pInvoiceNumber := NULL,
@rank := 0) temp
) t2
WHERE t2.rank = 1 AND t2.state !=2
and t2.billing_date BETWEEN ‘2017-02-1’ AND ‘2019-01-31’;
#and t2.billing_date BETWEEN date_format(DATE_SUB(now(),INTERVAL 12 MONTH),’%Y%m’) AND ‘2019-01-31’;

invoiceAmtL6M 过去6个月开票金额总数

SELECT
sum(t2.amount_tax) AS validAmountTax
FROM (
SELECT
invoice_info_tmp.billing_date,
invoice_info_tmp.amount_tax,
invoice_info_tmp.state,
@rownum := @rownum + 1,
if(@pInvoiceCode = invoice_info_tmp.invoice_code AND
@pInvoiceNumber = invoice_info_tmp.invoice_number,
@rank := @rank + 1, @rank := 1) AS rank,
@pInvoiceCode := invoice_info_tmp.invoice_code,
@pInvoiceNumber := invoice_info_tmp.invoice_number
FROM (
SELECT
t1.invoice_code,
t1.invoice_number,
t1.billing_date,
t1.amount_tax,
t1.state
FROM inoutput t1
WHERE t1.corp_id = ‘BW0020180606320’ AND t1.bz = 1
ORDER BY t1.invoice_code, t1.invoice_number ASC, state DESC
) invoice_info_tmp, (SELECT
@rownum := 0,
@pInvoiceCode := NULL,
@pInvoiceNumber := NULL,
@rank := 0) temp
) t2
WHERE t2.rank = 1 AND t2.state !=2
and t2.billing_date BETWEEN ‘2018-08-01’ AND ‘2019-01-31’;

invoiceAmtL3M 过去3个月开票金额总数

SELECT
sum(t2.amount_tax) AS amount3months
FROM (
SELECT
invoice_info_tmp.billing_date,
invoice_info_tmp.amount_tax,
invoice_info_tmp.state,
@rownum := @rownum + 1,
if(@pInvoiceCode = invoice_info_tmp.invoice_code AND
@pInvoiceNumber = invoice_info_tmp.invoice_number,
@rank := @rank + 1, @rank := 1) AS rank,
@pInvoiceCode := invoice_info_tmp.invoice_code,
@pInvoiceNumber := invoice_info_tmp.invoice_number
FROM (
SELECT
t1.invoice_code,
t1.invoice_number,
t1.billing_date,
t1.amount_tax,
t1.state
FROM inoutput t1
WHERE t1.corp_id = ‘BW0020180606320’ AND t1.bz = 1
ORDER BY t1.invoice_code, t1.invoice_number ASC, state DESC
) invoice_info_tmp, (SELECT
@rownum := 0,
@pInvoiceCode := NULL,
@pInvoiceNumber := NULL,
@rank := 0) temp
) t2
WHERE t2.rank = 1 AND t2.state !=2
and t2.billing_date BETWEEN ‘2018-11-01’ AND ‘2019-01-31’;
– # l3MPercent 过去3个月/g过去第4,5,6个月的金额比较
SELECT format((t3.validAmountTax20196/t4.validAmountTax20186),2) from
(SELECT
sum(t2.amount_tax)AS validAmountTax20196
FROM (
SELECT
invoice_info_tmp.billing_date,
invoice_info_tmp.amount_tax,
invoice_info_tmp.state,
@rownum := @rownum + 1,
if(@pInvoiceCode = invoice_info_tmp.invoice_code AND
@pInvoiceNumber = invoice_info_tmp.invoice_number,
@rank := @rank + 1, @rank := 1) AS rank,
@pInvoiceCode := invoice_info_tmp.invoice_code,
@pInvoiceNumber := invoice_info_tmp.invoice_number
FROM (
SELECT
t1.invoice_code,
t1.invoice_number,
t1.billing_date,
t1.amount_tax,
t1.state
FROM inoutput t1
WHERE t1.corp_id = ‘BW0020180606320’
and bz=1 and (t1.billing_date BETWEEN ‘2018-11-01’ AND ‘2019-01-31’)
ORDER BY t1.invoice_code, t1.invoice_number ASC, state DESC
) invoice_info_tmp, (SELECT
@rownum := 0,
@pInvoiceCode := NULL,
@pInvoiceNumber := NULL,
@rank := 0) temp
) t2
WHERE t2.rank = 1 AND t2.state !=2)t3,
(SELECT
sum(t2.amount_tax) AS validAmountTax20186
FROM (
SELECT
invoice_info_tmp.billing_date,
invoice_info_tmp.amount_tax,
invoice_info_tmp.state,
@rownum := @rownum + 1,
if(@pInvoiceCode = invoice_info_tmp.invoice_code AND
@pInvoiceNumber = invoice_info_tmp.invoice_number,
@rank := @rank + 1, @rank := 1) AS rank,
@pInvoiceCode := invoice_info_tmp.invoice_code,
@pInvoiceNumber := invoice_info_tmp.invoice_number
FROM (
SELECT
t1.invoice_code,
t1.invoice_number,
t1.billing_date,
t1.amount_tax,
t1.state
FROM inoutput t1
WHERE t1.corp_id = ‘BW0020180606320’ and bz=1 and (t1.billing_date BETWEEN ‘2018-07-31’ AND ‘2018-10-31’)
ORDER BY t1.invoice_code, t1.invoice_number ASC, state DESC
) invoice_info_tmp, (SELECT
@rownum := 0,
@pInvoiceCode := NULL,
@pInvoiceNumber := NULL,
@rank := 0) temp
) t2
WHERE t2.rank = 1 AND t2.state !=2)t4;

#l6mPercent – #过去6个月/g过去第7,8,9,10,11,12个月的金额比较
SELECT format((t3.validAmountTax20196/t4.validAmountTax20186),2) from
(SELECT
sum(t2.amount_tax)AS validAmountTax20196
FROM (
SELECT
invoice_info_tmp.billing_date,
invoice_info_tmp.amount_tax,
invoice_info_tmp.state,
@rownum := @rownum + 1,
if(@pInvoiceCode = invoice_info_tmp.invoice_code AND
@pInvoiceNumber = invoice_info_tmp.invoice_number,
@rank := @rank + 1, @rank := 1) AS rank,
@pInvoiceCode := invoice_info_tmp.invoice_code,
@pInvoiceNumber := invoice_info_tmp.invoice_number
FROM (
SELECT
t1.invoice_code,
t1.invoice_number,
t1.billing_date,
t1.amount_tax,
t1.state
FROM inoutput t1
WHERE t1.corp_id = ‘BW0020180606320’
and bz=1 and (t1.billing_date BETWEEN ‘2018-8-01’ AND ‘2019-01-31’)
ORDER BY t1.invoice_code, t1.invoice_number ASC, state DESC
) invoice_info_tmp, (SELECT
@rownum := 0,
@pInvoiceCode := NULL,
@pInvoiceNumber := NULL,
@rank := 0) temp
) t2
WHERE t2.rank = 1 AND t2.state !=2)t3,
(SELECT
sum(t2.amount_tax) AS validAmountTax20186
FROM (
SELECT
invoice_info_tmp.billing_date,
invoice_info_tmp.amount_tax,
invoice_info_tmp.state,
@rownum := @rownum + 1,
if(@pInvoiceCode = invoice_info_tmp.invoice_code AND
@pInvoiceNumber = invoice_info_tmp.invoice_number,
@rank := @rank + 1, @rank := 1) AS rank,
@pInvoiceCode := invoice_info_tmp.invoice_code,
@pInvoiceNumber := invoice_info_tmp.invoice_number
FROM (
SELECT
t1.invoice_code,
t1.invoice_number,
t1.billing_date,
t1.amount_tax,
t1.state
FROM inoutput t1
WHERE t1.corp_id = ‘BW0020180606320’ and bz=1 and (t1.billing_date BETWEEN ‘2018-01-31’ AND ‘2018-7-31’)
ORDER BY t1.invoice_code, t1.invoice_number ASC, state DESC
) invoice_info_tmp, (SELECT
@rownum := 0,
@pInvoiceCode := NULL,
@pInvoiceNumber := NULL,
@rank := 0) temp
) t2
WHERE t2.rank = 1 AND t2.state !=2)t4;

L3mCom 过去3个月和去年同期三个月的开票金额进行比较

SELECT format((t3.validAmountTax20196/t4.validAmountTax20186),2) from
(SELECT
sum(t2.amount_tax)AS validAmountTax20196
FROM (
SELECT
invoice_info_tmp.billing_date,
invoice_info_tmp.amount_tax,
invoice_info_tmp.state,
@rownum := @rownum + 1,
if(@pInvoiceCode = invoice_info_tmp.invoice_code AND
@pInvoiceNumber = invoice_info_tmp.invoice_number,
@rank := @rank + 1, @rank := 1) AS rank,
@pInvoiceCode := invoice_info_tmp.invoice_code,
@pInvoiceNumber := invoice_info_tmp.invoice_number
FROM (
SELECT
t1.invoice_code,
t1.invoice_number,
t1.billing_date,
t1.amount_tax,
t1.state
FROM inoutput t1
WHERE t1.corp_id = ‘BW0020180606320’
and bz=1 and (t1.billing_date BETWEEN ‘2018-11-01’ AND ‘2019-01-31’)
ORDER BY t1.invoice_code, t1.invoice_number ASC, state DESC
) invoice_info_tmp, (SELECT
@rownum := 0,
@pInvoiceCode := NULL,
@pInvoiceNumber := NULL,
@rank := 0) temp
) t2
WHERE t2.rank = 1 AND t2.state !=2)t3,
(SELECT
sum(t2.amount_tax) AS validAmountTax20186
FROM (
SELECT
invoice_info_tmp.billing_date,
invoice_info_tmp.amount_tax,
invoice_info_tmp.state,
@rownum := @rownum + 1,
if(@pInvoiceCode = invoice_info_tmp.invoice_code AND
@pInvoiceNumber = invoice_info_tmp.invoice_number,
@rank := @rank + 1, @rank := 1) AS rank,
@pInvoiceCode := invoice_info_tmp.invoice_code,
@pInvoiceNumber := invoice_info_tmp.invoice_number
FROM (
SELECT
t1.invoice_code,
t1.invoice_number,
t1.billing_date,
t1.amount_tax,
t1.state
FROM inoutput t1
WHERE t1.corp_id = ‘BW0020180606320’ and bz=1 and (t1.billing_date BETWEEN ‘2017-10-31’ AND ‘2018-01-31’)
ORDER BY t1.invoice_code, t1.invoice_number ASC, state DESC
) invoice_info_tmp, (SELECT
@rownum := 0,
@pInvoiceCode := NULL,
@pInvoiceNumber := NULL,
@rank := 0) temp
) t2
WHERE t2.rank = 1 AND t2.state !=2)t4;

#L6MPercent 过去6个月和去年同期6月的开票金额进行比较
SELECT format((t3.validAmountTax20196/t4.validAmountTax20186),2) from
(SELECT
sum(t2.amount_tax)AS validAmountTax20196
FROM (
SELECT
invoice_info_tmp.billing_date,
invoice_info_tmp.amount_tax,
invoice_info_tmp.state,
@rownum := @rownum + 1,
if(@pInvoiceCode = invoice_info_tmp.invoice_code AND
@pInvoiceNumber = invoice_info_tmp.invoice_number,
@rank := @rank + 1, @rank := 1) AS rank,
@pInvoiceCode := invoice_info_tmp.invoice_code,
@pInvoiceNumber := invoice_info_tmp.invoice_number
FROM (
SELECT
t1.invoice_code,
t1.invoice_number,
t1.billing_date,
t1.amount_tax,
t1.state
FROM inoutput t1
WHERE t1.corp_id = ‘BW0020180606320’
and bz=1 and (t1.billing_date BETWEEN ‘2018-08-01’ AND ‘2019-01-31’)
ORDER BY t1.invoice_code, t1.invoice_number ASC, state DESC
) invoice_info_tmp, (SELECT
@rownum := 0,
@pInvoiceCode := NULL,
@pInvoiceNumber := NULL,
@rank := 0) temp
) t2
WHERE t2.rank = 1 AND t2.state !=2)t3,
(SELECT
sum(t2.amount_tax) AS validAmountTax20186
FROM (
SELECT
invoice_info_tmp.billing_date,
invoice_info_tmp.amount_tax,
invoice_info_tmp.state,
@rownum := @rownum + 1,
if(@pInvoiceCode = invoice_info_tmp.invoice_code AND
@pInvoiceNumber = invoice_info_tmp.invoice_number,
@rank := @rank + 1, @rank := 1) AS rank,
@pInvoiceCode := invoice_info_tmp.invoice_code,
@pInvoiceNumber := invoice_info_tmp.invoice_number
FROM (
SELECT
t1.invoice_code,
t1.invoice_number,
t1.billing_date,
t1.amount_tax,
t1.state
FROM inoutput t1
WHERE t1.corp_id = ‘BW0020180606320’ and bz=1 and (t1.billing_date BETWEEN ‘2017-07-31’ AND ‘2018-01-31’)
ORDER BY t1.invoice_code, t1.invoice_number ASC, state DESC
) invoice_info_tmp, (SELECT
@rownum := 0,
@pInvoiceCode := NULL,
@pInvoiceNumber := NULL,
@rank := 0) temp
) t2
WHERE t2.rank = 1 AND t2.state !=2)t4;

averageAmount12M 过去12个月平均开票金额

SELECT
sum(t2.amount_tax)/12 as avgAmt
FROM (
SELECT
invoice_info_tmp.billing_date,
invoice_info_tmp.amount_tax,
invoice_info_tmp.state,
@rownum := @rownum + 1,
if(@pInvoiceCode = invoice_info_tmp.invoice_code AND
@pInvoiceNumber = invoice_info_tmp.invoice_number,
@rank := @rank + 1, @rank := 1) AS rank,
@pInvoiceCode := invoice_info_tmp.invoice_code,
@pInvoiceNumber := invoice_info_tmp.invoice_number
FROM (
SELECT
t1.invoice_code,
t1.invoice_number,
t1.billing_date,
t1.amount_tax,
t1.state
FROM inoutput t1
WHERE t1.corp_id = ‘BW0020180606320’ AND t1.bz = 1
ORDER BY t1.invoice_code, t1.invoice_number ASC, state DESC
) invoice_info_tmp, (SELECT
@rownum := 0,
@pInvoiceCode := NULL,
@pInvoiceNumber := NULL,
@rank := 0) temp
) t2
WHERE t2.rank = 1 AND t2.state !=2
and t2.billing_date BETWEEN ‘2018-02-1’ AND ‘2019-01-31’;

#averageAmount24M 过去24个月平均开票金额
SELECT
sum(t2.amount_tax)/24 as avgAmt
FROM (
SELECT
invoice_info_tmp.billing_date,
invoice_info_tmp.amount_tax,
invoice_info_tmp.state,
@rownum := @rownum + 1,
if(@pInvoiceCode = invoice_info_tmp.invoice_code AND
@pInvoiceNumber = invoice_info_tmp.invoice_number,
@rank := @rank + 1, @rank := 1) AS rank,
@pInvoiceCode := invoice_info_tmp.invoice_code,
@pInvoiceNumber := invoice_info_tmp.invoice_number
FROM (
SELECT
t1.invoice_code,
t1.invoice_number,
t1.billing_date,
t1.amount_tax,
t1.state
FROM inoutput t1
WHERE t1.corp_id = ‘BW0020180606320’ AND t1.bz = 1
ORDER BY t1.invoice_code, t1.invoice_number ASC, state DESC
) invoice_info_tmp, (SELECT
@rownum := 0,
@pInvoiceCode := NULL,
@pInvoiceNumber := NULL,
@rank := 0) temp
) t2
WHERE t2.rank = 1 AND t2.state !=2
and t2.billing_date BETWEEN ‘2017-02-01’ AND ‘2019-01-31’;

#standardDeviation12M 过去12个月的开票金额，标准差的计算
SELECT
STD(t2.amount_tax) AS validAmountTax
FROM (
SELECT
invoice_info_tmp.billing_date,
invoice_info_tmp.amount_tax,
invoice_info_tmp.state,
@rownum := @rownum + 1,
if(@pInvoiceCode = invoice_info_tmp.invoice_code AND
@pInvoiceNumber = invoice_info_tmp.invoice_number,
@rank := @rank + 1, @rank := 1) AS rank,
@pInvoiceCode := invoice_info_tmp.invoice_code,
@pInvoiceNumber := invoice_info_tmp.invoice_number
FROM (
SELECT
t1.invoice_code,
t1.invoice_number,
t1.billing_date,
t1.amount_tax,
t1.state
FROM inoutput t1
WHERE t1.corp_id = ‘BW0020180606320’ AND t1.bz = 1
ORDER BY t1.invoice_code, t1.invoice_number ASC, state DESC
) invoice_info_tmp, (SELECT
@rownum := 0,
@pInvoiceCode := NULL,
@pInvoiceNumber := NULL,
@rank := 0) temp
) t2
WHERE t2.rank = 1 AND t2.state !=2
and t2.billing_date BETWEEN ‘2018-02-01’ AND ‘2019-01-31’;

standardDeviation24M 过去24个月的开票金额标志差

SELECT
STD(t2.amount_tax) AS validAmountTax
FROM (
SELECT
invoice_info_tmp.billing_date,
invoice_info_tmp.amount_tax,
invoice_info_tmp.state,
@rownum := @rownum + 1,
if(@pInvoiceCode = invoice_info_tmp.invoice_code AND
@pInvoiceNumber = invoice_info_tmp.invoice_number,
@rank := @rank + 1, @rank := 1) AS rank,
@pInvoiceCode := invoice_info_tmp.invoice_code,
@pInvoiceNumber := invoice_info_tmp.invoice_number
FROM (
SELECT
t1.invoice_code,
t1.invoice_number,
t1.billing_date,
t1.amount_tax,
t1.state
FROM inoutput t1
WHERE t1.corp_id = ‘BW0020180606320’ AND t1.bz = 1
ORDER BY t1.invoice_code, t1.invoice_number ASC, state DESC
) invoice_info_tmp, (SELECT
@rownum := 0,
@pInvoiceCode := NULL,
@pInvoiceNumber := NULL,
@rank := 0) temp
) t2
WHERE t2.rank = 1 AND t2.state !=2
and t2.billing_date BETWEEN ‘2017-02-01’ AND ‘2019-01-31’;

等风等雨
关注
SQL server 脚本自动转换成适合MySQL脚本的方法
zhangxiaoyu71的博客
04-11 1378
刚实习两个星期，目前接触到的东西，比较迷茫，在此将自己实习过程学到的东西，简单做个总结，希望有路过的大佬，也可以指点指点。（其实这就是俺的一些笔记，应该叫做菜鸟实习第一天）此方法是将SQL server的列名、表数据分别查出来。再赋值给不同的参数。最后将数据拼接成适应MySQL的sql语句。这样一段完成的，将Mysql脚本转换成SQL server脚本的方法就写好了。这个代码也是公司员工教的，我自己呢，也是半懂半不懂。还得继续努力啊友友们。
MySQL全备脚本
12-24
MySQL全备脚本，可以直接使用。放心使用。稍稍更改一下脚本就可以了
mysql脚本
hzmaozhetao的博客
09-08 422
附件是mysql脚本
mysql脚本集
warrah 南极狼
11-07 957
1 占位符 使用_作为占位符 -- --------------------- 甲生寅月 ----------------------- select count(*) from bazi_info where full_bazi like '__ _寅 甲_ __'; 2 同时包含两个及多个字符 -- 甲生寅月，申子辰备 select count(*) from bazi_info where full_bazi like '__ _寅 甲_ __' and full_bazi REGEXP '(?=.
mysql员工脚本_mySQL常用脚本汇总
weixin_35867894的博客
01-19 186
@mysql的常用脚本有哪些呢？我们来做个总结建表语句sql语句最后指定主键DROP TABLE IF EXISTS `user_info1`;CREATE TABLE `user_info1` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`name` varchar(20) COLLATE utf8_bin DEFAULT NULL CO...
全国省市区编号MySql脚本
07-16
全国省市区编号MySQL脚本是数据库管理中一个重要的资源，主要用来存储中国各个省份、城市和区县的行政编码信息。这些脚本通常用于构建地理信息系统（GIS）、电子商务平台、物流系统或者任何需要处理中国地理位置信息...
案例使用脚本数据MYSQL公司架构
02-01
案例使用脚本数据
全国快递物流查询 阿里云 物流公司 mysql数据 与 json数据
06-14
在物流查询系统中，MySQL用于存储大量的物流公司信息，包括公司的名称、编码、联系方式以及覆盖的运输网络等。此外，每个包裹的详细信息，如运单号、发货人、收货人、发货时间、预计到达时间、当前状态等，也会被...
mysql数据备份脚本
04-21
`mysql数据备份脚本` 提供了一种自动化的方式来确保数据库的定期备份，即使面临意外的数据丢失，也能通过备份轻松恢复。这里我们将深入探讨 MySQL 数据备份的重要性、备份方法以及如何创建一个 `bat` 脚本来实现自动...
mysql 脚本命令大全_Mysql常用命令脚本
weixin_39861823的博客
02-04 462
Mysql常用命令脚本第一招、mysql服务的启动和停止net stop mysqlnet start mysql第二招、登陆mysql语法是 mysql -h主机 -u用户名 -p秘密例子是 mysql -hlocalhost -uroot -p123456要确定mysql安装时候勾选了可以远程链接。如果登陆本地计算机，-h可以省略，键入命令mysql -uroot -p， 回车后提示你输入密码...
mysql使用脚本_MySQL自用脚本（不定期更新）
weixin_28716973的博客
01-20 268
查询指定SQL的trace信息mysql -uUSER -pPWD -hHOST -e "\use ins_tc_prd; \set session optimizer_trace='enabled=on'; \set optimizer_trace_max_mem_size= 1638400; \explain SQL; \select * from information_schema.opt...
mysql 命令写脚本_mysql命令行脚本
weixin_29695125的博客
01-27 402
1 --数据库的操作23 --链接数据库4 mysql -uroot -p5 mysql -uroot -p密码67 --退出数据库8 exit/q/ctrl+d910 --sql语句最后需要有分号；结尾11 --显示数据库版本12 selectversion();1314 --显示时间15 selectnow()；1...
Mysql常用脚本
weixin_42329561的博客
10-17 537
Mysql常用脚本
MySQL 常用脚本
yyaannnnnnnn的博客
01-28 1519
1mysqldump -u 用户名 -p –default-character-set=latin1 数据库名 > 导出的文件名(数据库默认编码是latin1) 2 3mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql 2.导出一个表 1mysqldump -u 用户名 -p 数据库名 表名> 导出的文件名 2 3mysqldump -u wcnc -p smgp_apps_wcnc users> wcnc_users.sql
MySQL 常用命令手册
zhaomengxia123的博客
05-11 145
MySQL 常用命令手册，赶紧收藏吧！ 常用功能命令 1.导出整个数据库 mysqldump-u用户名-p–default-character-set=latin1数据库名>导出的文件名(数据库默认编码是latin1) mysqldump-uwcnc-psmgp_apps_wcnc>wcnc.sql 2.导出一个表 mysqldump-u用户名-p数据库名表名>导出的文件名 mysqldump-uwcnc...
mysql 数据脚本 下载
最新发布
11-19
想要下载MySQL数据脚本，首先需要确保你有访问数据库的权限。如果是在公司内部操作，可以联系数据库管理员获取相应权限；如果是个人使用，需要确保你有相应数据库的访问权限。 一般来说，下载MySQL数据脚本有两种方式：一种是通过MySQL命令行工具进行数据导出，一种是通过MySQL可视化工具进行数据导出。 通过MySQL命令行工具进行数据导出，可以使用以下命令： ``` mysqldump -u 用户名 -p 数据库名 > 导出文件名.sql ``` 其中，用户名是你在MySQL数据库中的用户名，数据库名是你要导出的数据库名称，导出文件名是你希望导出的文件名称。执行完这个命令后，会提示你输入数据库密码，输入密码后数据脚本就会生成并保存在指定的文件中。 通过MySQL可视化工具进行数据导出，可以打开工具，连接到相应的数据库，选择要导出的数据库，选择导出的格式（一般是SQL格式），然后点击导出按钮，选择保存文件的路径和文件名，就可以完成数据脚本的下载。 无论使用哪种方式下载MySQL数据脚本，都需要确保在操作之前已经对数据进行了备份，以免因为操作失误导致数据丢失。希望以上方法对你有所帮助。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值