more insert like one transaction(MySQL)

chipev

Hi,
i need a help
i`m a biginer in PHP/mySQL
Please,tell me ,how can i make more than one INSERT... in mySQL from PHP, like one transaction.I want to do this to prenvent error in database if connetction is crash between two INSERTs
If you can write to me litle example 🙂

Thanks
Asen
P.S.
Sorry for my english 🙂)

Anon

As far as i know, it s not possible with mysql

use postgresql 🙂

Anon

There is no concept of a transaction in MySQL, except for the most recent release. Look for BDB tables in MySQL, or if you can, switch to PostgreSQL, which is a much more feature-full database and has full support for transactions.

[deleted]

Polite correction:

MySQL does not support transactions by default,
but it can use transactions if you include the Berkely DB libraries.

Plus, MySQL does let you do several inserts at once:

INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name [(col_name,...)]
VALUES (expression,...),(...),...

🙂

Anon

You can simulate "weak" transactions. For many cases is it sufficient to ensure your
data integrity.

1) A lot of INSERT is probably safe, because you can insert houndreds or thousands of rows per second. A connection loss in this interval is very improbably.

2) Make a flag into your rows with a unique id for this "transaction". F.e. transid = getmypid(); in PHP.

Insert (transid,....) into your_table;
...
...

If your Insert-sequence is successful, you can continue your program. Otherwise you have to delete these rows with this transid.

MySQL runs atomic operations.
After this you can switch these inserts free with only one UPDATE-statement. UPDATE your_table set OK= 1 where transid=$transid