Member Login

Freestyle Joomla Forums

SQL Manager

Member Login   Register

Please login or register to post on the forum

Forum Index    Board Index    Last Post   

Lakshya

Lakshya

17 July 2015, 22:44

Insert Rows (SQL Manager)

Hi,

I have a table in my joomla database and I want to insert more than one row at once in it how can I do that by writing a sql query?
Link showing problem 1
Joomla Version 3.0
Freestyle Version SQL Manager Pro(Latest)
Adam Clarke

Adam Clarke

20 July 2015, 09:17

Re: Insert Rows (SQL Manager)

Hello

you can do this with a query such as:

INSERT INTO Table ( Column1, Column2 ) VALUES ( Value1, Value2 ), ( Value1, Value2 )

Please let me know if you have any further questions

Thanks

Adam Clarke
Freestyle Joomla

Vote For Us!

Please vote for our software or write a review of one of our products on the Joomla! Extensions Directory