创建一个表格,DDL语句:
CREATE TABLE `ab` (
`A` varchar(255) DEFAULT NULL,
`B` varchar(255) DEFAULT NULL,
`1.0` varchar(1024) DEFAULT NULL,
`Column2` varchar(1024) DEFAULT NULL,
`,` varchar(1024) DEFAULT NULL,
`Column3` varchar(1024) DEFAULT NULL,
`Column4` varchar(1024) DEFAULT NULL,
`Column5` varchar(1024) DEFAULT NULL,
`Column6` varchar(1024) DEFAULT NULL,
`Column7` varchar(1024) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gbk
创建几个数据:
INSERT INTO d1.t3 (源端设备名称,源端端口名称,带宽,时间,`流入流速(bps)`,`流出流速(bps)`,`流入利用率(%)`,`流出利用率(%)`) VALUES
('K1','2020-12-18 00:00:00.0','2926778904','708588608','29.3','7.09'),
('k2','Te4/27','10485760000','2020-12-18 00:05:00.0','2594198800','620771192','25.9','6.21');
有这么几个格式:(用DBeaver生成的)
标准的SQL语句:
INSERT INTO d1.t3 (源端设备名称,源端端口名称,带宽,时间,`流入流速(bps)`,`流出流速(bps)`,`流入利用率(%)`,`流出利用率(%)`) VALUES
('K1','2020-12-18 00:00:00.0','2926778904','708588608','29.3','7.09'),
('k2','Te4/27','10485760000','2020-12-18 00:05:00.0','2594198800','620771192','25.9','6.21')
可导入的CSV文本;
"源端设备名称","源端端口名称","带宽","时间","流入流速(bps)","流出流速(bps)","流入利用率(%)","流出利用率(%)"
k-A05,Te4/27,"10485760000","2020-12-18 00:00:00.0","2926778904","708588608","29.3","7.09"
k-A05,Te4/27,"10485760000","2020-12-18 00:05:00.0","2594198800","620771192","25.9","6.21"
dbunit:
<?xml version="1.0" encoding="UTF-8"?>
<dataset>
<T3 _="k-A05" _="Te4/27" _="10485760000" _="2020-12-18 00:00:00.0" _BPS_="2926778904" _BPS_="708588608" _="29.3" _="7.09"/>
<T3 _="k-A05" _="Te4/27" _="10485760000" _="2020-12-18 00:05:00.0" _BPS_="2594198800" _BPS_="620771192" _="25.9" _="6.21"/>
</dataset>
html语句
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8"/><style>
table {border: medium solid #6495ed;border-collapse: collapse;width: 100%;} th{font-family: monospace;border: thin solid #6495ed;padding: 5px;background-color: #D0E3FA;}td{font-family: sans-serif;border: thin solid #6495ed;padding: 5px;text-align: center;}.odd{background:#e8edff;}img{padding:5px; border:solid; border-color: #dddddd #aaaaaa #aaaaaa #dddddd; border-width: 1px 2px 2px 1px; background-color:white;}</style>
</head>
<body>
<table><tr><th colspan="8">t3</th></tr><tr><th>源端设备名称</th><th>源端端口名称</th><th>带宽</th><th>时间</th><th>流入流速(bps)</th><th>流出流速(bps)</th><th>流入利用率(%)</th><th>流出利用率(%)</th></tr><tr class="odd"><td>k-A05</td><td>Te4/27</td><td>10485760000</td><td>2020-12-18 00:00:00.0</td><td>2926778904</td><td>708588608</td><td>29.3</td><td>7.09</td></tr>
<tr><td>k-A05</td><td>Te4/27</td><td>10485760000</td><td>2020-12-18 00:05:00.0</td><td>2594198800</td><td>620771192</td><td>25.9</td><td>6.21</td></tr>
</table></body></html>
json:
{
"t3": [
{
"源端设备名称" : "k-A05",
"源端端口名称" : "Te4\/27",
"带宽" : "10485760000",
"时间" : "2020-12-18 00:00:00.0",
"流入流速(bps)" : "2926778904",
"流出流速(bps)" : "708588608",
"流入利用率(%)" : "29.3",
"流出利用率(%)" : "7.09"
},
{
"源端设备名称" : "k-A05",
"源端端口名称" : "Te4\/27",
"带宽" : "10485760000",
"时间" : "2020-12-18 00:05:00.0",
"流入流速(bps)" : "2594198800",
"流出流速(bps)" : "620771192",
"流入利用率(%)" : "25.9",
"流出利用率(%)" : "6.21"
}
]}
导入文本
|源端设备名称|源端端口名称|带宽 |时间 |流入流速(bps)|流出流速(bps)|流入利用率(%)|流出利用率(%)|
|------|------|---|-------------------|---------|---------|--------|--------|
|k-A05|Te4/27|10485760000|2020-12-18 00:00:00.0|2926778904|708588608|29.3 |7.09 |
|k-A05|Te4/27|10485760000|2020-12-18 00:05:00.0|2594198800|620771192|25.9 |6.21 |
xml:
<?xml version="1.0" ?>
<!DOCTYPE t3 [
<!ELEMENT t3 (DATA_RECORD*)>
<!ELEMENT DATA_RECORD (_?,_?,_?,_?,_bps_?,_bps_?,_?,_?)+>
<!ELEMENT _ (#PCDATA)>
<!ELEMENT _ (#PCDATA)>
<!ELEMENT _ (#PCDATA)>
<!ELEMENT _ (#PCDATA)>
<!ELEMENT _bps_ (#PCDATA)>
<!ELEMENT _bps_ (#PCDATA)>
<!ELEMENT _ (#PCDATA)>
<!ELEMENT _ (#PCDATA)>
]>
<t3>
<DATA_RECORD>
<_>k-A05</_>
<_>Te4/27</_>
<_>10485760000</_>
<_>2020-12-18 00:00:00.0</_>
<_bps_>2926778904</_bps_>
<_bps_>708588608</_bps_>
<_>29.3</_>
<_>7.09</_>
</DATA_RECORD>
<DATA_RECORD>
<_>k-A05</_>
<_>Te4/27</_>
<_>10485760000</_>
<_>2020-12-18 00:05:00.0</_>
<_bps_>2594198800</_bps_>
<_bps_>620771192</_bps_>
<_>25.9</_>
<_>6.21</_>
</DATA_RECORD>
</t3>
sorsecode
<?php
$t3 = array(
array(
"源端设备名称" => "k-A05",
"源端端口名称" => "Te4\/27",
"带宽" => "10485760000",
"时间" => "2020-12-18 00:00:00.0",
"流入流速(bps)" => "2926778904",
"流出流速(bps)" => "708588608",
"流入利用率(%)" => "29.3",
"流出利用率(%)" => "7.09"
),
array(
"源端设备名称" => "k-A05",
"源端端口名称" => "Te4\/27",
"带宽" => "10485760000",
"时间" => "2020-12-18 00:05:00.0",
"流入流速(bps)" => "2594198800",
"流出流速(bps)" => "620771192",
"流入利用率(%)" => "25.9",
"流出利用率(%)" => "6.21"
)
);
?>