mebe a écrit :
> Hi Folks,
>
> 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,
> Thanks in advance!
AFAIK mysql does not sup****t transactions... maybe you can switch to
postgresql?
|
