|
Is there already any software that will allow me to select a table or row from existing DB, edit that table, add new rows, or clone existing ones, then insert the new rows back into the DB?
Read: i want to ADD this data, do not want to update/replace ...
Started by Patrick on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
You can clone rows.
By editing and selecting "insert as new row" (may have to blank out the primary key if you have oneThere's PHPMyAdmin , which will let you to pretty much anything to a database.
|
|
I dumped the data from a database using the MySQL Admin Migration toolkit. One of the tables has over 5 million rows. When I try to load the generated data file I get out of memory issues. Is there a way to force commit after X number of rows. The script...
Started by shikarishambu on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
For extra for "auto-commit every X rows....
Take an editor to it; every few hundred lines, insert a line that says COMMIT, and then start a new INSERT...VALUES statement.
This big INSERT INTO statement is essentially a script.
|
|
Hi everyone, I'm executing simple insert query like below: INSERT INTO tbl_destination ... SELECT ... FROM [SomeOtherLinkedServer].tbl_source
It results in 3'000'000 rows inserted to the destination table although the SELECT returns the 9'000'000 rows...
Started by indigo on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Where field1.
Select * from ....
Where rowid between 0 and 1 Insert into...
Select * from ....
Three times already :)
Have you considered partitioning the results and batching the insert?
Insert into...
|
Ask your Facebook Friends
|
I am trying to track what users are searching for on my site (from a simple search form on the front page) with PHP and MySQL.
At the end of all my queries I am using this query:
INSERT INTO `DiggerActivity_Searches` ( `SearchTerms`, `SearchType`, `NumResults...
Started by johnnietheblack on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Id suggest a PK like search ID or something similar
Read more about this at Unique key - Wikipedia
You might want to check first whether your script executes the query three times or the script is invoked three times... .
Your table is missing a primary key.
|
|
I am inserting records through a query similar to this one:
insert into tbl_xyz select field1 from tbl_abc
Now I would like to retreive the newly generated IDENTITY Values of the inserted records. How do I do this with minimum amount of locking and maximum...
Started by Manu on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
SELECT * FROM Inserted
Temp Table:
insert field1, unique_col....
This conaints all of the inserted rows.
Trigger:
--Use the Inserted table.
insert your rows, and then get your max key again and do a range.
|
|
Hello all,
How is it possible that this function below inserts two rows in my database?
//called like save_session_db($_SESSION['user_id']); function save_session_db($session){ include('includes/db-connect.php'); $connectionInfo = array( 'Database' =&...
Started by Abs on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Although, that seems like something you would probably know about. .
An additional row, for example.
|
|
I have the following problem: I need to insert N rows after row X. The set of rows i need to insert is passed to my function as chunk of HTML consisting of TR elements. I also have access to the TR after which i need to insert.
This is slightly different...
Started by mkoryak on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
Straight can insert a new row....
There is an error with IE using innerHTML to insert the rows, so that won't work.
//if not, determine row_after_row_x for(i in n_rows){ if(lastRow.
//determine if lastRow...
|
|
How do I insert for example 100 000 rows into MySQL table with a single query?
Started by TheMagician on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
You can do a batch insert with the INSERT statement, but....
You will need a loop.
You do have an option, kind of comboBox that lets you choose the number of rows you wanna insert on your data format
You can't as far as I know.
|
|
How do I get the number of rows affected by a BULK INSERT on SQL Server (2008 if that matters)?
Started by Mathias on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
As a result of your BULK INSERT, as this may affect your result..
|
|
In Sql Server 2005, is there any way, using the official GUI or a third party tool, to select rows in a table and then generate a insert script for the selected rows?
Started by James McMahon on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at serverfault):
I do not know of tool that lets you do this using a nice GUI, but I do know of a nice stored procedure that you can use to generate inserts....
SQuirreL SQL can do this:
Highlight a SELECT statement, then invoke Session/Scripts/Create data script from SQL .
|
