i want select values in list ,then it automatically stored in database. how to do ?
if anybody know say to me....
sugikrish
0
Junior Poster in Training
Recommended Answers
Jump to PostMay be you want to know how to use select along with insert command in mysql. If you search net, you will get many examples on it.
If I am not right, please let us know what you do not want to see, to be considered as automatically stored …
All 2 Replies
sourcebits
6
Junior Poster
May be you want to know how to use select along with insert command in mysql. If you search net, you will get many examples on it.
If I am not right, please let us know what you do not want to see, to be considered as automatically stored in database.
qualitybrains
0
Newbie Poster
Maybe you are looking for a SQL query which will select values from one table and insert into another: Following is an example where account no and name from customers table is being fetched and inserted into supplier table.
INSERT INTO suppliers (supplier_id, supplier_name)
SELECT account_no, name FROM customers
WHERE city = 'NY'
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.