So no, there are no plans to fix this and I think most databases work this way.
2. An index is an index, regardless of order. MySQL can search from the "bottom" up or "top" down. There used to be problems in earlier versions where MySQL couldn't use an index for sorting in reverse order of the index, but this is no longer the case. There are lots of parameters that MySQL will accept and either ignore or "convert" to supported parameters. This is for compatibility with other databases, which is great for dumping and importing to and from other database products.
So, no plans on changing the index in the case as far as I know. There are plans to add support for other ignored parameters.
3. Your question is kind of odd, Dates don't have hours, minutes or seconds, much less milliseconds. You should use DATETIME or TIMESTAMP if you want to track detailed time information. No, neither of those support millisecond detail. But if you want to track time in millisecond detail, you should probably use FLOAT, where milliseconds would be the decimal value.
On Nov 12, 2004, at 2:46 AM, litlpooh wrote:
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]
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
