Laurent D.A.M. MENTEN wrote:
> mebe a écrit :
>> i am in need of some advice about how to consistently add data into
>> two
>> MySQL tables. The database looks like this:
>>
>> CREATE TABLE Items (
>> itemId INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
>> itemName VARCHAR(255) DEFAULT NULL,
>> FULLTEXT (itemName)
>>
>> CREATE TABLE ViewCount (
>> itemId INT UNSIGNED PRIMARY KEY,
>> viewCnt INT UNSIGNED DEFAULT 0)
>> TYPE = InnoDB
>>
>> Both tables are connected through the column 'itemId'.
>> How would a SQL statement look that:
>> 1. Inserts a new row into table 'Items'
>> 2. Query Items.itemId, (note that itemName is not unique)
>> 3. Inserts a new row into table 'ViewCount' using
>> ViewCount.itemId = Items.itemId
>> 4. Does the whole operation in a thread save way.
>>
>> The main problems I've encountered are how can i query the newly
>> inserted Items.itemId if all other columns are not unique? And how do
>> i make the two inserts plus the one select atomic/thread save?
>> I appreciate any help,
>
> AFAIK mysql does not sup****t transactions... maybe you can switch to
> postgresql?
MySQL sup****t transactions on InnoDB tables but not for MyISAM
tables.
It seems from the above that it is InnoDB tables.
Arne
|
