User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 363,494 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,383 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting

MySql insert

Join Date: Apr 2008
Posts: 11
Reputation: nickyspace is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 0
nickyspace's Avatar
nickyspace nickyspace is offline Offline
Newbie Poster

Re: MySql insert

  #2  
May 9th, 2008
hi
Jino

what exactly you want to insert
insert data through forms or from one table to another table.

regards
nickyspace

Originally Posted by jino View Post
Hi all,

I want to insert multiple records into a table using one query.
And my query is

INSERT INTO table2(id,message)
SELECT id FROM table1 WHERE condn,'hello'

but it displays an error....

Can you help me?
Thanx in advance....

jino
Reply With Quote  
All times are GMT -4. The time now is 3:35 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC