-
Temp Tables in mySQL
Hi all.
Currently writing a purchasing website and have got a choice on the matter of how to create the shopping cart. Now normally, id use my own shopping cart, but the old dependable dog is tired, and want to update it, and I want to know the following information.....
Need to know how much memory TEMP tables take up in MySQL, a rough outlin in command son how to create them, what they can store and such forth.
Any links of quick lookups or tutorials would be good
Ta
Kai
-
Re: Temp Tables in mySQL
I've never used MySQL but I did find this, and according to that article, there is an example in the MySQL manual's tutorial section (Chapter 3).
-
Re: Temp Tables in mySQL
Hi.
Cheers hack, got this and have a few more questions.
1. Do you have to lock the temporary table upon creation and have to select data from an existing table also upon creation or can you simply insert data?
2. If in the event that it is needed, can you change a temp table to a myISAM table with a new name, primary key properties, indexes, Etc..?
3. How does using temporary tables affect databse response time upon multiple transactions?
Ta
Kai
-
Re: Temp Tables in mySQL
Threads that go BUMP in the forum!!!