Re: MySQL Server not running

Nothing, the server is definetively not running You get the bug script from me.. regards Daniel Datum: Fri, 12 Oct 2007 15:44:29 +0530 Von:Ananda Kumar [EMAIL PROTECTED] An: Daniel Bau [EMAIL PROTECTED] Betreff:Re: MySQL Server not running Kopie an:

Re: MySQL Server not running

When i do this, he say MySL package is not installed, but when i reinstall the same thing is happen, so thats what i told you he dont realy instal mysql and i dont know why Datum: Fri, 12 Oct 2007 04:40:28 -0600 Von:John Meyer [EMAIL PROTECTED] An:

Limiting the text size on text fields

Is there a way to restrict the length of text field in MySQL. For example, it is of 65K limit and could hold more than 2 characters. Is there a way to restrict that to 4000 characters at table/field level. Coz the max_allowed_packet constrainted the entire DB. Thanks Ganesh -- View this

Error 1064 on a basic UPDATE query

Hi List, We have a transactions table (~600k records). I'm trying a simple update query, it fails. I thought this could be due to a reserved word problem, but all names have been escaped. mysql UPDATE `tblTransaction` SET `TYPE` = 'Manual' WHERE (`ORDERID` = '694215576aac60f10c9eebe4a5a39d0f');

Re: Error 1064 on a basic UPDATE query

Hi, James Graham wrote: Hi List, We have a transactions table (~600k records). I'm trying a simple update query, it fails. I thought this could be due to a reserved word problem, but all names have been escaped. mysql UPDATE `tblTransaction` SET `TYPE` = 'Manual' WHERE (`ORDERID` =

Deadlocks with High Concurrency SELECT FOR UPDATE

Hello List, I have this table that has a single row in it: CREATE TABLE `quicktable` ( `x` int(11) NOT NULL auto_increment, `quick_id` int(11) NOT NULL default '0', PRIMARY KEY (`x`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 select * from quicktable; +---+--+ | x |