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 | q
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` =
'694215576
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');
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 mess
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:
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: mysql@list