user @ host:〜# mysql -V -mysql Ver 14.14 Distrib 5.7.25-28,用于debian-linux-gnu(x86_64),使用在debian-9,9下运行的7.0
user @ host:〜# uname -a -Linux 4.9.0-8-amd64#1 SMP Debian 4.9.144-3.1(2019-02-19)x86_64 GNU / Linux
用户@主机:〜# perl -MDBI -e 'print $DBI::VERSION ."\n";' -1.636
user @ host:〜# perl -v这是为x86_64-linux-gnu-thread-multi构建的perl 5,版本24,版本1(v5.24.1)
mysql> SHOW CREATE TABLE tbl1;
tbl1 | 创建表`tbl1`(
`id` bigint(20)NOT NULL AUTO_INCREMENT,
main_id bigint(20)NOT NULL DEFAULT'0',
`debet` varchar(255)NOT NULL DEFAULT``,
`kurs` double(20,4)NOT NULL默认'0.0000',
sum sum double(20,2)NOT NULL默认值'0.00',
is_sync` int(11)NOT NULL默认为'0',
主键(`id`),
KEY`main_id`(`main_id`)
)ENGINE = InnoDB AUTO_INCREMENT = 70013000018275 DEFAULT CHARSET = utf8
mysql> SELECT * FROM tbl1 WHERE id=70003020040132;