Re: Three Questions :

2004-11-24 Thread SGreen
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

Re: Three Questions

2004-11-12 Thread Brent Baisley
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, t

Re: Three Questions

2004-11-12 Thread Alec . Cawley
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) >