Linked Questions

Pleas see it: (oid, iid, name, type) VALUES (5, X3, john, boxer) I want to insert oid. It is from a different table $oid=mysql_fetch_array['oid']; where iid name and type is same. Can i insert thes ...

I have a value like this $id='11'; $value1= 'tb1,tb2,tb3,tb4'; $value2= 'th1,th2,th3,th4'; and all I want to do is insert it into MySql (via PHP) like this: +---------+-------------+---------...

I am working on a student management project on pdo php mysql. I need to insert multiple rows like student payable amount available to specific group of students. Or send a billing to a group of ...

I have a PHP script and I'm inserting values into a MySQL table. This was working fine when dealing with a few thousand lines of data but as I increase the data only a part of the data is inserted ...

I am trying to insert data in a table using this type of dynamic form: userfood_order.php <form name="frmUser" method="post" action="mainfiles/user_order.php"> <?php $result = ...

I'm running a website aimed for medical students, I have a profile and points for every student in my database, So when they participate in an activity I must add X amount of points for all the ...

I have a script where I want to insert all rows in a single statement, but I don't know how to do that. Here's the code I have so far. This only inserts one row. How can I insert multiple rows? <...

I'm looking for a good way to perform multi-row inserts into an Oracle 9 database. The following works in MySQL but doesn't seem to be supported in Oracle. INSERT INTO TMP_DIM_EXCH_RT (EXCH_WH_KEY, ...

I'm trying to create a bunch of records in my MySQL database. This is a one time creation so I am not trying to create a stored procedure. Here is my code: BEGIN SET i = 2376921001; WHILE (i <= ...

I have to insert anywhere between 50 - 500 contact's information into the database. I have 4 arraylists that contain image, name, number, bool variable respectively. Each row in the data is made up ...

I have read in the Using The INSERT INTO ... SET Syntax In MySQL blog, that you can use the following SET syntax to insert records. Example: INSERT INTO mytable SET col1= 'val1', col6= 'val6', col10='...

I need to run this query 100 times to input data into my MySQL database. ID auto increments. Not concerned about incrementing the table Name column. Just need to fill the database. What is the best ...

I know this has been asked so many times but I can't seem to figure the issue out. Im running the following code, but it just returns the fail. When I run the output of $query1 --> INSERT INTO ...

I have a CSV input file with aprox. 4 million records. The insert is running since +2hours and still has not finished. The Database is still empty. Any suggestions on how to to actually insert the ...

I am trying to insert multiple rows in mysql database using node js.The idea is that I have four arrays which has 20 values each. My goal is to dynamically insert all the values in my database using ...