the max length of one SQL statement

Hi guys,   Anybody knows that how many bytes the max length of on SQL statement can be in MySQL database? I know it's 64KB in Oracle.   Thanks. *^_^* ___ 好玩贺卡等你发，邮箱贺卡全新上线！ http://card.mail.cn.yahoo.com/

Re: the max length of one SQL statement

hi, According to the transfer limit, ... 16M? 2009/3/20 raid fifa raid_f...@yahoo.com.cn: Hi guys, Anybody knows that how many bytes the max length of on SQL statement can be in MySQL database? I know it's 64KB in Oracle. Thanks. *^_^*

Re: copy blob between tables may get in consistent data?

hi, I found this: http://bugs.mysql.com/bug.php?id=34300 in the bug system. As it descibed, there is chance which I get corrupted data when read BLOB. Now I wonder why I also get corrupted data when write BLOB into table... I tried this: step 1: read BLOB data from TABLE1 step 2:

Re: MySQL versus PostgreSQL for GPS Data

Jim Ginn wrote: Not sure why you you need the trucks location 'every second' ie: 31,536,000 rows per year per truck ? doing every 30 seconds seems more manageable at 1,051,200 rows per year per truck? Maybe better at 60 seconds? OpenGGD is also designed to deliver GPS data in real time; we have

RE: Performance Spamassin PostgreSQL vs MySQL

We had an awkward setup, which forced us to use PGSQL for SpamAssassin. Unfortunately the SA queries are not processed well by PGSQL. Back in January we switched SA processing to MySQL. Bingo! Instant improvement in overall performance, and no PGSQL maintenance required. This is not

Re: MySQL versus PostgreSQL for GPS Data

Juan: Still seems excessive but in that case, ignore inserts that have no change in lat / lon ... Jim Jim Ginn wrote: Not sure why you you need the trucks location 'every second' ie: 31,536,000 rows per year per truck ? doing every 30 seconds seems more manageable at 1,051,200 rows per year

MySQL General Discussion question

Sorting a varchar field alphabetically with correct numerical order help needed I have a varchar 50 field that contains product names, which are typically numerical, alphabetical and punctuation thrown in. I would like to have them returned in some sort of order that is roughly alphabetical,

Re: MySQL General Discussion question

Hi Rich, I believe that since they are definitely considered as strings they are sorted as such, how can you pretend that '#2 NOV' is considered as a number? If you cannot define a rule in the structure of the data it is impossible to sort, not only in sql, but in life! IF we take for granted

Re: MySQL General Discussion question

I'd use a cursor loop, and parse through the string extracting the numeric characters, convert the numeric characters to a Int to be used as a sequence number. Insert the sequence number and the string into a temp table, (or add seqnum to the current table) and select from X order by seqnum. I