i create table from script:
create table if not exists msg00m1 (
id int primary key auto_increment,
hid int not null,
dsg char(10) not null,
nt char(7) not null,
gn char(2) not null,
wot char(12) not null,
k char(19) not null,
k2 varchar(20) not null,
wwt char(2) not null,
drt char(10) not null,
cr char(13) not null,
cr2 varchar(14) not null,
wat char(15) not null,
wat2 varchar(16) not null,
w char(3) not null
);
and command desc msg00m1 shows:
mysql> desc msg00m1;
+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| hid | int(11) | | | 0 | |
| dsg | varchar(10) | | | | |
| nt | varchar(7) | | | | |
| gn | char(2) | | | | |
| wot | varchar(12) | | | | |
| k | varchar(19) | | | | |
| k2 | varchar(20) | | | | |
| wwt | char(2) | | | | |
| drt | varchar(10) | | | | |
| cr | varchar(13) | | | | |
| cr2 | varchar(14) | | | | |
| wat | varchar(15) | | | | |
| wat2 | varchar(16) | | | | |
| w | char(3) | | | | |
+-------+-------------+------+-----+---------+----------------+
15 rows in set (0.00 sec)
some columns (dsg, nt, wot, k, drt, cr, wat) declared as char in script are
varchar in database...
whats is going on?
mysql ver 3.23.41
Roman
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
