#mysql - Mon 2 Apr 2007 between 00:41 and 01:02

NY Lost Funds



chadmaynardis that last quote a "?
savagephpHow can I do something like this recursively through all the records in table2: update `table2` set `FieldDescription`=(select `FieldDescription` from table1 where `fieldname`=`table2`.`fieldname`)
nada'
savagephpI hope that makes enough sense
chadmaynardpost the entire query nada since i alerady know your pass
savagephpBasically, I have two identical tables except for one field. I want to copy just that one field into the other table based on a unique field.
nadachadmaynard: GRANT ALL PRIVILEGES ON database.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'password';
chadmaynardthats what i sent you.... :(
nadayup
I'm not a mysql-client guy.
and my SQL fu is limited to sql injection stuff.
chadmaynardshow me the query YOU entered
nadaThat's what I entered, except the password was something different
doolssavagephp: i would think that you can do this:
chadmaynardyea...
what ws it?
nadaI believe I got the same thing accomplished through webmin, chadmaynard
chadmaynardok
doolsinsert into temp_table select table1.field1,table1.field2,table2.missing_field FROM table1 INNER JOIN table2 USING(key_field);
actionchadmaynard pokes webmin
chadmaynardpokes webmin
doolssavagephp: ^^
nadalo
l
savagephphmm
I'll try that
trhaynesHello
I have a database of my music library and want to list the artists and how many songs I have by them
I have SELECT DISTINCT artist FROM songs; but I don't know how to count how many songs they each have ... can anyone help? Thanks.
Vanpriesthi, how can i insert a current date ?
is there a function in mysql to insert the curent date and time into the date field ?
LoRezfoo = now()
trhaynesVanpriest: NOW()
Vanpriestok thanks
trhaynesLoRez: Beat me to it ;)
LoRez: Know how to do what I want to do?
LoRezselect artist, count(1) from songs group by artist;
VanpriestNOW only insert date.. no time ?
trhaynesVanpriest: If the column is DATETIME or TIME, the time will be included
Try SELECT NOW(); in your terminal
Vanpriestoh ok

Page: 5 12 19 26 33 40 47 54 61 68 75 

IrcArchive

NY Lost Funds