I have three questions about mysql. 1. mysql> CREATE TABLE board ( -> boardid char(6) binary NOT NULL, -> title varchar(128) binary NOT NULL, -> ) ENGINE=MYISAM; Query OK, 0 rows affected, 0 warning (0.00 sec)
mysql> desc board; +----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+-------+ | boardid | varchar(6) | | PRI | | | | title | varchar(128) | | | | | +----------+--------------+------+-----+---------+-------+ 2 rows in set (0.00 sec) "char" type column cannot be with "varchar" type column. is there any plan to fix it..? if there is not.. when do you think it will be fixed? 2. my second and last question is index descending.. in the mysql document, "An index_col_name specification can end with ASC or DESC. These keywords are allowed for future extensions for specifying ascending or descending index value storage. Currently they are parsed but ignored; index values are always stored in ascending order" when do you think it will be possible? what I want from you is just roughly plan. 3. I want to get 'DATE' typed data which including millisecond format. What can I use for this? Which function can be made it possible? --- Pok Myung Ho R&D Center DBA TEAM / DBA Tel : 02-6003-5607 Fax : 02-6003-5402 Mobile : 010-5505-1837 e-mail : [EMAIL PROTECTED] Daum messenger : stickyboy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]