|chadmaynard||is that last quote a "?|
|savagephp||How 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`)|
|savagephp||I hope that makes enough sense|
|chadmaynard||post the entire query nada since i alerady know your pass|
|savagephp||Basically, 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.|
|nada||chadmaynard: GRANT ALL PRIVILEGES ON database.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'password';|
|chadmaynard||thats what i sent you.... :(|
I'm not a mysql-client guy.
and my SQL fu is limited to sql injection stuff.
|chadmaynard||show me the query YOU entered|
|nada||That's what I entered, except the password was something different|
|dools||savagephp: i would think that you can do this:|
what ws it?
|nada||I believe I got the same thing accomplished through webmin, chadmaynard|
|dools||insert into temp_table select table1.field1,table1.field2,table2.missing_field FROM table1 INNER JOIN table2 USING(key_field);|
|action||chadmaynard pokes webmin|
I'll try that
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.
|Vanpriest||hi, how can i insert a current date ?|
is there a function in mysql to insert the curent date and time into the date field ?
|LoRez||foo = now()|
|trhaynes||LoRez: Beat me to it ;)|
LoRez: Know how to do what I want to do?
|LoRez||select artist, count(1) from songs group by artist;|
|Vanpriest||NOW only insert date.. no time ?|
|trhaynes||Vanpriest: If the column is DATETIME or TIME, the time will be included|
Try SELECT NOW(); in your terminal