в 13:46, 26 мая 2010

2010-05-26T13:46:00Z

Admin: 1 версия

2010-05-26T10:16:32Z

1 версия

Новая страница

==Define and use varchar==



<source lang="sql">
/*
mysql> Drop table Product;
mysql> CREATE TABLE Product
-> (
-> ID SMALLINT NOT NULL PRIMARY KEY,
-> Color VARCHAR(15) NOT NULL
-> );
Query OK, 0 rows affected (0.07 sec)
mysql> INSERT INTO Product VALUES (101, "Red"),
-> (102, "red"),
-> (103, "RED"),
-> (104, "REd"),
-> (105, "reD"),
-> (106, "Blue"),
-> (107, "blue"),
-> (108, "BLUE"),
-> (109, "BLue"),
-> (110, "blUE");
Query OK, 10 rows affected (0.01 sec)
Records: 10 Duplicates: 0 Warnings: 0
mysql> select * from Product;
+-----+-------+
| ID | Color |
+-----+-------+
| 101 | Red |
| 102 | red |
| 103 | RED |
| 104 | REd |
| 105 | reD |
| 106 | Blue |
| 107 | blue |
| 108 | BLUE |
| 109 | BLue |
| 110 | blUE |
+-----+-------+
10 rows in set (0.00 sec)

*/
Drop table Product;
CREATE TABLE Product
(
ID SMALLINT NOT NULL PRIMARY KEY,
Color VARCHAR(15) NOT NULL
);

INSERT INTO Product VALUES (101, "Red"),
(102, "red"),
(103, "RED"),
(104, "REd"),
(105, "reD"),
(106, "Blue"),
(107, "blue"),
(108, "BLUE"),
(109, "BLue"),
(110, "blUE");
select * from Product;

</source>

← Предыдущая	Версия 13:46, 26 мая 2010
(нет различий)

SQL/MySQL/Data Type/Varchar - История изменений

в 13:46, 26 мая 2010

Admin: 1 версия