Member Avatar for sugikrish

i want select values in list ,then it automatically stored in database. how to do ?
if anybody know say to me....

  • 3 Contributors
  • 2 Replies
  • 67 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by qualitybrains
Member Avatar for sourcebits

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.

Member Avatar for qualitybrains

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'
Edited by qualitybrains because: n/a
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.