char,varchar,text,blob
戻る
<![CDATA[
DROP TABLE IF EXISTS test_char;
CREATE TABLE test_char
(
id INT AUTO_INCREMENT,
partsid char(200),
PRIMARY KEY (id)
);
INSERT INTO test_char (partsid) VALUES("38");
SELECT * FROM test_char;
---------------------
C:\database\sql>mysql cookbook < test_char.sql -u cbuser -p
Enter password: ******
id partsid
1 38
-----------------------------------------------
==> partsid char(400),
C:\database\sql>mysql cookbook < test_char.sql -u cbuser -p
Enter password: ******
ERROR 1074 (42000) at line 2: Column length too big for column 'partsid' (max =
255); use BLOB or TEXT instead
-----------------------------------------------
DROP TABLE IF EXISTS test_char;
CREATE TABLE test_char
(
id INT AUTO_INCREMENT,
partsid varchar(400),
PRIMARY KEY (id)
);
INSERT INTO test_char (partsid) VALUES("2=3=4==16=23=");
SELECT * FROM test_char;
-----------------------------------------------
DROP TABLE IF EXISTS test_char;
CREATE TABLE test_char
(
id INT AUTO_INCREMENT,
partsid varchar(400),
PRIMARY KEY (id)
);
INSERT INTO test_char (partsid)
VALUES("123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890");
SELECT * FROM test_char;
C:\database\sql>mysql cookbook < test_char.sql -u cbuser -p
Enter password: ******
ERROR 1406 (22001) at line 9: Data too long for column 'partsid' at row 1
-----------------------------------------------
DROP TABLE IF EXISTS test_char;
CREATE TABLE test_char
(
id INT AUTO_INCREMENT,
partsid text,
PRIMARY KEY (id)
);
INSERT INTO test_char (partsid)
VALUES("123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890");
SELECT * FROM test_char;
C:\database\sql>mysql cookbook < test_char.sql -u cbuser -p
Enter password: ******
id partsid
1 123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890
--------------------------------------------------
DROP TABLE IF EXISTS test_char;
CREATE TABLE test_char
(
id INT AUTO_INCREMENT,
partsid blob,
PRIMARY KEY (id)
);
INSERT INTO test_char (partsid)
VALUES("123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890");
SELECT * FROM test_char;
C:\database\sql>mysql cookbook < test_char.sql -u cbuser -p
Enter password: ******
id partsid
1 123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890123456789012345678901234567890123456789012345678901234567890123456789012
34567890
]]>
戻る
海林市|
吉首市|
广汉市|
东乌|
二手房|
陆丰市|
页游|
新建县|
灵台县|
揭阳市|
环江|
内黄县|
江城|
漠河县|
泉州市|
百色市|
白水县|
察哈|
长丰县|
台东县|
鄢陵县|
南郑县|
阜城县|
天津市|
九江县|
罗甸县|
郓城县|
江门市|
恭城|
娱乐|
陵水|
屏东市|
惠安县|
富阳市|
淄博市|
桃园县|
罗定市|
肥城市|
达州市|
高安市|
乐昌市|