The length of the sql query

2006-08-23 Thread Emi Lu
Hello, Just curious to know whether Mysql 3.23 has any length constraint about where part, such as Query = [ select col1, col2, ... coln from table 1, table2, where constraint1 + constraint2 +constraintN ] Is there any length arrange for the Query str such as

Why "VARCHAR" TO "CHAR" automatically when the length less than 4.

2004-08-16 Thread Emi Lu
+ I did not understand why the varchar(3) is changed to char(3) automatically. While if we define a varchar(4) it will not change to char(4) automatically. Could somebody help and explain that please? Thanks a lot! Emi Lu -- MySQL General Mailing List For list archives: http://lists

mysqldump all tables except 2 in a database

2004-08-31 Thread Emi Lu
Hello all, In mysql, do we have a way to "mysqldump" all tables except two in a database. I know we have the way only dump schema, only data, a specific table, both data structure and data. But could someone help me about dumping all tables in a structure except two. For example, in databse "D1