PHP mysql BULK Insert data insertion not fully
I use mysqli, a breath need to insert 52 records, occasionally will miss a few did not insert success, now this table 3.4M, if the table is emptied, this will not happen?
------Solution--------------------
Only 53 will leak??? What kind of code ah, stick it out to see
Another: Why not PDO?
------Solution--------------------
Not a problem with the code, this database you can think of as access. So the situation of losing data is not difficult to understand.
If you want to use a small database, then I suggest you look at MongoDB, this thing good prospects, and very small.
------Solution--------------------
MySQL and access are not a level database okay?
Why is losing data easy to understand? MySQL lost data, in 53 of these circumstances difficult to understand!
By the way, MongoDB is not a small database, it is NoSQL, and MySQL is not the same thing. For example, Foursquare uses it to process hundreds of G of customer geographic information.
--Curiosity, how the medal was taken.
References:
not a problem with the code, this database you can think of as access. So the situation of losing data is not difficult to understand.
If you want to use a small database, then I suggest you look at MongoDB, this thing good prospects, and very small.
------Solution--------------------
MongoDB is really not a small database .... It's a horrible thing to be big.
The other 52 leaks are too exaggerated.
It is recommended to use transaction processing to see
If it's missing, it's a code problem.
------Solution--------------------
Satay
Reference:
MongoDB is really not a small database .... It's a horrible thing to be big.
The other 52 leaks are too exaggerated.
It is recommended to use transaction processing to see
If it's missing, it's a code problem.
