Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: MySQL query Help
I am trying to create a new table using values from another table. The query I have so far is getting values from an existing table and inserting them into the new table, but I am trying to find the syntax for inserting a value into a unique column in new table as well as using values from another table. Can anybody help me?
 
MySqlConnection conn = new MySqlConnection(connectionSQL);
conn.Open();
MySqlCommand cmd = new MySqlCommand("INSERT INTO TransactionsTemp(barcode, name, price) SELECT barcode, name, price FROM Product WHERE barcode='" + textBox1.Text + "'", conn);
cmd.ExecuteNonQuery();

conn.Close();
Posted 10-Apr-13 5:57am
Edited 10-Apr-13 6:56am
v3
Comments
joshrduncan2012 at 10-Apr-13 11:14am
   
Can you show us the code that you have already and pinpoint where the issue is?
Member 9611735 at 10-Apr-13 11:23am
   
Question has been updated with code

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

You can use 'ALTER table' as described in :
 
http://www.w3schools.com/sql/sql_alter.asp[^]
 

-------------------------------
 
Regards
H.Maadani
  Permalink  
Comments
Member 9611735 at 10-Apr-13 11:54am
   
the column already exists in table, I just want to extend query and insert value into column

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 200
1 PIEBALDconsult 150
2 BillWoodruff 148
3 Jochen Arndt 135
4 DamithSL 130
0 OriginalGriff 5,695
1 DamithSL 4,506
2 Maciej Los 4,007
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,190


Advertise | Privacy | Mobile
Web01 | 2.8.141216.1 | Last Updated 10 Apr 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100