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 > 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] >