Search results for query: *

I have been using MySQL in a Windows environment for about 6 months and have successfully written a couple of applications. Reading all and anything about MySQL I have been looking into the My.Ini entries, particularly those affecting InnoDB tables. Reading the site...

Thanks Mark and DonQuichote for your comments. As outlined in my last post I am always leaving one record in the table now. I have an aversion to storing thousands of useless records - historically due to minimum storage space 34 years ago when I started programming on old ICL mainframes, and...

Of course that should have been http://bugs.mysql.com/11946

After further research I found some interesting info at http://bugs/mysql.com/11946 which discusses Truncate and Delete of tables/records with autoincrement fields, and points out some documentation conflicts for various versions of MySQL. It still doesn't resolve the problem of why my...

The field is int(11)

I have setup a table with an autoincrement field solely to supply an application with consecutive numbers for new accounts. The application calls a GetNewAccountNo function, which basically deletes all records from the table then inserts a new record thus supplying the latest incremented number...

Sorry, tried to post a new item and it ended up as a reply to yours. Confusing interface???

I have setup a table with an autoincrement field solely to supply an application with consecutive numbers for new accounts. The application calls a GetNewAccountNo function, which basically deletes all records from the table then inserts a new record thus supplying the latest incremented number...

I need to access the USB drive attached to the PC currently logged into an application via Terminal Services. The API call GetDriveType() returns drives associated with the server running Terminal Services. The application was developed in Delphi 5 running under Windows XP Pro SP2. Any ideas...

Both my local PC and the server MySQL have full privileges granted Chris

Good thought, Andrew. The version on my local PC is 5.0.27-community-nt, and that on the server is 5.0.45-community-nt. Maybe the difference.

I quote from MySQL Cookbook : 'Another property of temporary tables is that they can be created with the same name as a permanent table. In this case, the temporary table "hides" the permanent table for the duration of its existence, which can be useful for making a copy of a table that you can...

Solved. The problem was naming the temporary table the same as the permanent table, as described in 'MySQL Cookbook' by Paul DuBois, chapter 4.3.

Important information I omitted : MySQL version is 5.0.45 and all tables are InnoDB

I’m converting an application from Paradox to MySQL (first time I’ve used this) and am replacing Paradox local tables with MySQL temporary tables – I understand each user will have a unique copy of the table. Basically I issue the following two commands : 'drop temporary table if exists...