Re: the max length of one SQL statement

hi, According to the transfer limit, ... 16M? 2009/3/20 raid fifa : > 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. > > *^_^* > > > _

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/

Auto increment without uniquness

I think ideally I would like to create an auto increment column that has no requirement for uniqueness. So if 6 was the last entry, and there are 10 of them, 7 would still be the next, is this possible? I am assuming it is not? I am working in a case where data is needing to be de-normalize

Re: why is this happening?

I am afraid you have two mysql instances up on the same host. ps -ef | grep mysql ? Claudio Jim Lyons wrote: I have a rather odd problem with a replication slave. The slave has been down for a number of hours. Of course, both io and sql threads are stopped - from SHOW SLAVE STATUS:

RE: why is this happening?

what does the master db show for processlist ? master_mysql>show processlist ? Martin __ Disclaimer and confidentiality note This message is confidential and may be privileged. If you are not the intended recipient, we kindly ask you to please inf

Re: why is this happening?

On 3/19/09, Jim Lyons wrote: > > I have a rather odd problem with a replication slave. > > The slave has been down for a number of hours. Of course, both io and sql > threads are stopped - from SHOW SLAVE STATUS: > > Slave_IO_Running: No > Slave_SQL_Running: No > > > However, t

why is this happening?

I have a rather odd problem with a replication slave. The slave has been down for a number of hours. Of course, both io and sql threads are stopped - from SHOW SLAVE STATUS: Slave_IO_Running: No Slave_SQL_Running: No However, the relay logs are still being written to. I w

Re: Multiple batch files

Thanks, much better.I appended '| mysql' to each line but I am not sure what you mean by 'then call it' I ran the batch file and tried using source batch.bat but no joy. What am I missing? Thanks again -- Dave 2009/3/19 Gary Smith > Dir /b > Sent via BlackBerry by AT&T > > -Original Messa

Re: Multiple batch files

Hi David, Why not use a FOR loop in a batch file? This post seems to be doing the same thing, using MS SQL Server: http://bytes.com/topic/windows/answers/647680-xp-batch-file-loop-help Andy David Scott wrote: Thanks for responding Gary I get: --- Volume in

Re: Multiple batch files

Thanks for responding Gary I get: --- Volume in drive D has no label. Volume Serial Number is C45F-3341 Directory of D:\data\03\09 03/19/2009 05:45 PM 389,305 sessions-20090309-00.sql 03/19/2009 05:45 PM 402,264 sessions-20090309-01. sql 0

Multiple batch files

HeyaI have folders of sql files which, when there were a few, I executed using "source d:\folder\file.sql"I now I have 100's, so is there a way to do "source d:\folder\*.sql" (which sadly does not work) ? How would you go about automating this? The DB is running on a windows box. Thanks for any

Re: Performance Spamassin PostgreSQL vs MySQL

At 02:53 PM 3/18/2009, you wrote: We are using the PostgreSQL currently to store the Bayes information. It seems to periodically spend a lot of time 'vacumming' which of course drives up disk load. The system admin has adjusted it so it only does this at low load. I'm curious if anyone has act

Open source Data warehouse

Hi Anybody know some open source data warehouse product like Bizgres?

Re: Separate customer databases vs all in one

You only confirm my first-blush opinion: keep separate databases. Regarding your second issue (joining across databases for reports), I would suggest that these operations are best done against an OLAP database not the numerous OLTP databases. That is, create an additional database whose sole purpo

Re: How to set db property so that table name queries are case-insensitive?

http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_lower_case_table_names I think you'll want to set it to 1 On Wed, Mar 18, 2009 at 22:15, David M. Karr wrote: > Ubuntu 8.10. > > I was experimenting with the Spring Petclinic sample application, configured > with MySQL.  

copy blob between tables may get in consistent data?

hi, I'm using mysql-5.1.22, innodb. For some reason, I need to add some columns to a table without locking it, so I do this: insert into TABLE2(col1, col2, ... ,colN) select col1, col2, ... colN from TABLE1 where ...(primary key traversal condition). which TABLE1 is under use, and TABLE2

Re: From MS Access to MySQL

> I have taken a Microsoft Access database and have basically copied the > structure of it and rebuilt it in MySQL, however, I have encountered > some problems with formatting of data. I need to ask what is the most > suitable field type to use to retain the content from Access field types > > The

RE: Please help me.

Hi You can make a backup of the original table and recreate the table and import. That will help you ASAP Muthukumar Selvarasu, Project Manager, Webmaster Ltd. -Original Message- From: Gary Smith [mailto:g...@primeexalia.com] Sent: Thursday, March 19, 2009 7:25 AM To: Valentin Ionescu;