On Mon, 24 Jan 2005 12:34:38 +0200, "Gleb Paharenko" <[EMAIL PROTECTED]> said: > Hello. > > Not enough information to make a conclusion. Please, send us information > about MySQL and operating system versions. Output of "show create table" > statement on your tables. Could you make a reproducable test case?
Yeah, I just reproduced it at home and at work on different PC's. It happens on windows XP or 2K. And, There is some very weird actvity were a particular table will not update from PHP but will from the command line. And yeah it's a new DB name which then has the tables and structue added to it via a mysqldump dump file...the new DB adopts the auto increment starting value of the 1st DB whose structure I dumped in to the 2ndn (but no data is dumped). They have same table/field names but slightly different DB names...wish I had more time to say more. But the updating mysteriousness is causing hair ripping... > > "leegold" <[EMAIL PROTECTED]> wrote: > > I have two different databases they both have an auto-increment PK field > > and while they are different databases with different names, they do > > have tables with the same names. What I find is that the auto-crement > > integer number remembers what it is across these databases. So if I > > insert in the 1st DB and the number is 24, then I insert in the 2nd DB > > the number will be 25. I would of thought that the number would be > > "fresh" and independent between the DBs. Could you explain? > > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > <___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
