Re: insert new records from other tables
Richard, it's possible, your syntax is pretty close.
Try this:
INSERT INTO info_stamp
(fav_colour, hobby, stamp_date, firstname,
last_name, sexe, age, username, email, insc_date)
SELECT $fav_colour, $hobby, $time, a.firstname, a.last_name, a.sexe,
a.age, a.username, b.email, b.inscription_date
FROM mem_info a
JOIN mem_login b ON a.username = b.username
WHERE a.username = $username;
I removed the reference to the 'key' column, fyi.
More info here: http://dev.mysql.com/doc/refman/5.0/en/insert-select.html
Hope this helps!
-Dan
On Feb 17, 2008 9:09 PM, Richard [EMAIL PROTECTED] wrote:
Hello,
I need to insert one entry(one line) containing 10 values, some from a
form(ok) but some from two other tables, what is the best way to do this ?
Say for example I need to enter this information :
first_name - last_name - age - sexe - username - email - favorite_colour
- hobby - inscription_date - timestamp
I already have a table containing : firstname - last_name - sexe - age -
username
And another one containing: username - email - inscription_date
And I get from the member : favorite_colour - hobby
Out of these three sources I would like to insert into one table
containing all of these details.
I need this to make a print of one moment So I would be able to pull out
an entry saying : At this date the information was the following :
first_name - last_name - age - sexe : height - username - email -
favorite_colour - hobby - inscription_date - timestamp
Can I do something like this :
INSERT INTO info_stamp (key , fav_colour, hobby, stamp_date, firstname,
last_name, sexe, age, username, email, insc_date )VALUES ('',
$fav_colour, $hobby, $time, (SELECT a.firstname, a.last_name, a.sexe,
a.age, a.username, b.email, b.inscription_date FROM mem_info a JOIN
mem_login b ON a.username = b.username WHERE a.username = $username));
I guess this query would not actually work, what would be the corect way
to do this ?
Thanks in advance :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
insert new records from other tables
Hello,
I need to insert one entry(one line) containing 10 values, some from a
form(ok) but some from two other tables, what is the best way to do this ?
Say for example I need to enter this information :
first_name - last_name - age - sexe - username - email - favorite_colour
- hobby - inscription_date - timestamp
I already have a table containing : firstname - last_name - sexe - age -
username
And another one containing: username - email - inscription_date
And I get from the member : favorite_colour - hobby
Out of these three sources I would like to insert into one table
containing all of these details.
I need this to make a print of one moment So I would be able to pull out
an entry saying : At this date the information was the following :
first_name - last_name - age - sexe : height - username - email -
favorite_colour - hobby - inscription_date - timestamp
Can I do something like this :
INSERT INTO info_stamp (key , fav_colour, hobby, stamp_date, firstname,
last_name, sexe, age, username, email, insc_date )VALUES ('',
$fav_colour, $hobby, $time, (SELECT a.firstname, a.last_name, a.sexe,
a.age, a.username, b.email, b.inscription_date FROM mem_info a JOIN
mem_login b ON a.username = b.username WHERE a.username = $username));
I guess this query would not actually work, what would be the corect way
to do this ?
Thanks in advance :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: insert new records from other tables [ solved, thankyou :) ]
Thanks it works great ! :)
Dan Buettner wrote :
Richard, it's possible, your syntax is pretty close.
Try this:
INSERT INTO info_stamp
(fav_colour, hobby, stamp_date, firstname,
last_name, sexe, age, username, email, insc_date)
SELECT $fav_colour, $hobby, $time, a.firstname, a.last_name, a.sexe,
a.age, a.username, b.email, b.inscription_date
FROM mem_info a
JOIN mem_login b ON a.username = b.username
WHERE a.username = $username;
I removed the reference to the 'key' column, fyi.
More info here: http://dev.mysql.com/doc/refman/5.0/en/insert-select.html
Hope this helps!
-Dan
On Feb 17, 2008 9:09 PM, Richard [EMAIL PROTECTED] wrote:
Hello,
I need to insert one entry(one line) containing 10 values, some from a
form(ok) but some from two other tables, what is the best way to do this ?
Say for example I need to enter this information :
first_name - last_name - age - sexe - username - email - favorite_colour
- hobby - inscription_date - timestamp
I already have a table containing : firstname - last_name - sexe - age -
username
And another one containing: username - email - inscription_date
And I get from the member : favorite_colour - hobby
Out of these three sources I would like to insert into one table
containing all of these details.
I need this to make a print of one moment So I would be able to pull out
an entry saying : At this date the information was the following :
first_name - last_name - age - sexe : height - username - email -
favorite_colour - hobby - inscription_date - timestamp
Can I do something like this :
INSERT INTO info_stamp (key , fav_colour, hobby, stamp_date, firstname,
last_name, sexe, age, username, email, insc_date )VALUES ('',
$fav_colour, $hobby, $time, (SELECT a.firstname, a.last_name, a.sexe,
a.age, a.username, b.email, b.inscription_date FROM mem_info a JOIN
mem_login b ON a.username = b.username WHERE a.username = $username));
I guess this query would not actually work, what would be the corect way
to do this ?
Thanks in advance :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
