Re: INSERT with auto increment

From: "David Stoltz" In mySQL, if I expressly give it a value, like "INSERT INTO TABLE1 VALUES(17,'stuff')" - it works fine. But if I remove the 17, it says I don't have a matching number of columns. Use NULL for the autoinsert column. I made it a rule to forbear all direct c

Re: INSERT with auto increment

You can choose between: INSERT INTO TABLE1 VALUES (null,'stuff') or INSERT INTO TABLE1 (stuffField) VALUES ('stuff') -- João Cândido de Souza Neto ""David Stoltz"" escreveu na mensagem news:487e7d0857fe094590bf2dc33fe3e1080a102...@shhs-mail.shh.org... Hi All, In MS SQL, if the table ha

Re: INSERT with auto increment

generally, it is: INSERT INTO TABLE1 (fieldname [ , fieldname]* ) VALUES (value[, value]*) If you don't list the columns, it assumes you are inserting all of them, so: INSERT INTO TABLE1 (mycolumn ) VALUES ('stuff') This will also work INSERT INTO TABLE1 VALUES (0, 'stuff') the auto-incremen

INSERT with auto increment

Hi All, In MS SQL, if the table has an identity field/primary key which is set to auto increment, you can leave the value out of an INSERT statement, and the next highest value will be automatically inserted... For instance, with a two column table I could do "INSERT INTO TABLE1 VALUES('stu

Re: Reserving threads for root user

On 6/30/2010 6:56 AM, Machiel Richards wrote: Good day all Sorry one more question. I have seen many questions about this on the web but no resolution yet. When MySQL runs out of threads, you are unable to stop / restart the database

Re: Determine connection origins

> Good day all > We are trying to find out where the current connections > on > our Mysql database originates from. > > We are receiving 4000+ connections at the moment where > this > was usually only about half this. > > Is there a way of determinin

Reserving threads for root user

Good day all Sorry one more question. I have seen many questions about this on the web but no resolution yet. When MySQL runs out of threads, you are unable to stop / restart the database. Is there a way to reserve thre

Re: MySQL Replication

2010/6/30 Tompkins Neil : > Hi > > Just one other question.  With regards the replication in MySQL 5.1 - does > it it replication the whole row of data or just the field in which the data > has been changed for the current record ? MySQL 5.1 supports two replication formats: row and statement-base

Re: MySQL Replication

Hi Just one other question. With regards the replication in MySQL 5.1 - does it it replication the whole row of data or just the field in which the data has been changed for the current record ? Thanks Neil 2010/6/24 Jaime Crespo Rincón > 2010/6/24 Tompkins Neil : > > Hi > > > > Regarding tw

Determine connection origins

Good day all We are trying to find out where the current connections on our Mysql database originates from. We are receiving 4000+ connections at the moment where this was usually only about half this. Is there a way of determining where

RE: Mysql error causing database to not accept threads

Hi Joerg Thank you very much for the response. I found an answer this morning (about 15 minutes ago) where the server's Thread cache was used up and the amount of max connections exceeded causing the same error. We have not yet been able to establish the source of the amo

Re: Mysql error causing database to not accept threads

Hi! Machiel Richards wrote: > [[...]] > > We received an error on a MySQL database this morning which > caused it to be unavailable for connections. > > Error: > > ERROR 1135 (0): Can't create a new thread (errno 11); if > you are not out of

Re: Updating from 4 to 5

Yeah, I'm agree with michael. For migration of DB from one major version to another, must use the below approach. by the using mysqlupgrade, might be we can loss some data. regards, Nilnandan Michael Dykman wrote: There are binary differences between v4.x and 5.x (5.1.x recommended).. The cl