Three Questions :
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 RD 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]
Re: Three Questions :
RTFL. THIS HAS BEEN ASKED AND ANSWERED TWICE BEFORE. If you have problems with the answers, address the answers. Stop re-posting!!! 1. http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html 2. The physical sequencing of the records on disk is out of the administrator's control. 3. http://dev.mysql.com/doc/mysql/en/Date_and_time_type_overview.html http://dev.mysql.com/doc/mysql/en/Using_DATE.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine litlpooh [EMAIL PROTECTED] wrote on 11/24/2004 09:44:22 AM: 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 RD 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]
Fwd: Three Questions
-- Forwarded message -- From: litlpooh [EMAIL PROTECTED] Date: Fri, 12 Nov 2004 16:46:02 +0900 Subject: Three Questions To: [EMAIL PROTECTED] 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 RD Center DBA TEAM / DBA Tel : 02-6003-5607 Fax : 02-6003-5402 Mobile : 010-5505-1837 e-mail : [EMAIL PROTECTED] Daum messenger : stickyboy -- . Daum Communication DBA Team, (02)6003-5607 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fwd: Three Questions
You've asked these before, and received answers. If you didn't find the answers sufficient, you should reply to them with follow up questions, rather than reposting your original email. Michael litlpooh wrote: -- Forwarded message -- From: litlpooh [EMAIL PROTECTED] Date: Fri, 12 Nov 2004 16:46:02 +0900 Subject: Three Questions To: [EMAIL PROTECTED] 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 RD 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]
Three Questions
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 RD 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]
Re: Three Questions
litlpooh [EMAIL PROTECTED] wrote on 12/11/2004 07:46:02: 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? This is a documented feature of MySQL: http://dev.mysql.com/doc/mysql/en/CHAR.html It will thereforer probably never be changed. Why to you say that it cannot b of varchar type? I think that the opinion of the MySQL team is that there is no performance impact and no functional difference with the change. 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. I have not heard of any plans for this. Since you can specify that results are ORDERED in ascending or descending order, what does it matter to you what order the index is held in? If MySQL can search an ascending index backwards, the effect is the same as a descending index. 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? No table type that I am aware of. The manual doeaz not contain msec, millisec or millisecond, so I don't think there is any such type. When I have to store such types, I use absolute milliseconds stored in BIGINTs. Alec Cawley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Three Questions
1. All char's are automatically changed to varchar whenever there is any field that is not fixed length. This is not a bug or a problem, it's smart design. Fixed length records are great for performance since the database knows the offset of the next record. Once a record is not fixed length, the database needs to search through the data to find the end of the record. So changing all char to varchar will make the record smaller (and the database) and speed up searching since the records and database is smaller. 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 RD 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]