Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query for Inserting multiple empty rows 3

Status
Not open for further replies.
Sort by date Sort by votes
are there any fields which woul be popultated at the ned of the query (id in an auto_increment for example?) ***************************************
Party on, dudes!
[cannon]
 
Upvote 0 Downvote
Well it would be sad to try and enter several blank lines and have no proof that it actually worked, also if its an ID you have a base to start adding from.

In all honesty I think a php while() loop is going to be the easiest(read quickest as well), but I'll happily wait for someone to prove me wrong ;) ***************************************
Party on, dudes!
[cannon]
 
Upvote 0 Downvote
well, try this sql statement

INSERT INTO <table_name> (<autoincrement_column_name>) VALUES (''), (''), ('')

this should insert three empty rows
 
Upvote 0 Downvote
I think Homer once said....
Doh!
(_8(0)

Nice one Piti, star for j00 :) ***************************************
Party on, dudes!
[cannon]
 
Upvote 0 Downvote
Well, the query given by Piti will also force me to use a PHP loop in the case I want to give the user the choice of how many rows he wants to insert before applying the query.

I thought there was a simple query with a numeric value for the number of rows to be added. Thus, a single PHP variable in the query could have done the trick, you see.

Anyway, thanks for the help. My Work...
...and More...
 
Upvote 0 Downvote
Sledia so try this
u will need a table with enough rows - it doesn't matter what kind of table, it just needs enough rows

INSERT INTO <target_table_name> (<column in target table>) SELECT NULL FROM <&quot;source&quot;_table_name> LIMIT N

where N is the number of rows u want to enter
 
Upvote 0 Downvote
Hello again Piti,

I already thought about this way but the problem is that it brings more hassle than using a PHP loop.
I'm lazy you know.. :)

Also, in order to create the table that has plenty of rows in the first place, I will have to write a PHP loop!

Anyway, here is a star for the effort.


My Work...
...and More...
 
Upvote 0 Downvote
well, just limit the number of possible inserted rows to the max in one of your table, or create one table just for this purpose, u will not be forced to create it everytime user wants to insert rows

btw i don't understand the purpose of this insert - why should a user want to insert empty rows in a table -allocating space? ;-)
 
Upvote 0 Downvote
I'm creating a browser based interface whose purpose is to look like an Excel interface a little bit and to allow people to edit every table/database on their remote/local mysql server very quickly.
I don't like phpmyadmin.

It's finished, but I wanted to shorten the code as much as possible.
I'm planning to design a Flash version of it for a nicer interface once I know how to do.

My Work...
...and More...
 
Upvote 0 Downvote
And to stop you from using a while loop .... :)

$x_rows=30; // however many you want here
$new_rows=substr(str_repeat(&quot;(''),&quot;, $x_rows),0,-1); // repeat the (''), as many times as required and strip the trailing ,

$sql=&quot;INSERT INTO table_name (autoincrement_column_name) VALUES $new_rows&quot;; ***************************************
Party on, dudes!
[cannon]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lupidol
  • Locked
  • Question
mysql cannot add rows with &quot;UNION&quot; 1
Replies
5
Views
398
Chris Miller
Chris Miller
AbidingDude
  • Locked
  • Question
One Constraint for Multiple Columns 1
Replies
2
Views
299
AbidingDude
AbidingDude
EdLentz
  • Locked
  • Question
How do I use a keyword in a query??
Replies
6
Views
502
EdLentz
EdLentz
EdLentz
  • Locked
  • Question
Looking for suggestions on how to do this
Replies
4
Views
362
Chris Miller
Chris Miller
waubain
  • Locked
  • Question
Show rows results on same row when Group BY fields 1
Replies
6
Views
363
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top