The length of the sql query

[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 500M, 1G, etc? Or 
the query can be as long as it is.


Thanks a lot!


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysqldump all tables except 2 in a database

[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, I have 10 tables, I'd like to dump 8 of 
them at one time.

Thanks a lot!
Emi
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

[Emi Lu]

Hello all,
I have a questions about varchar columns change to CHAR columns 
automatically.

When I designed a table t1
create table t1(id varchar(3) not null) in MySQL. After that, we use 
desc t1 to see the description of table t1.

The result is the following:
===
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| id| char(3) | YES  | | NULL|   |
+---+-+--+-+-+---+
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.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]