• Welcome to RadioDJ - Free Radio Automation Software Forum. Please log in or sign up.

Little Bit OF SQL Help PLS!

Started by DJ Garybaldy, March 20, 2022, 02:42:13 PM

DJ Garybaldy

I had a script years ago that my late husband wrote to get of of specific information in columns in MySQL tables.

The columns I want to empty are the specifically years and album titles.

Can someone point me in the right direction of a query that just gets rid of that information while leaving the rest of the data alone.

Thanks In advance, I really don't know where the file with the query went
Worlds Biggest Fan of RadioDJ

Install MariaDB https://djgarybaldy.blogspot.com/2020/08/installing-maria-db.html

Install RadioDJ: https://djgarybaldy.blogspot.com/2020/08/how-to-install-radiodj-free-radio.html

Into Internet radio for 25 years 1999-2024

RadioDJ 2045 MariaDB 11.2 Windows 11

stevewa

UPDATE songs
SET YEAR="", ALBUM=""

DJ Garybaldy

Ta! Its done now my database is a lot more tidy now
Worlds Biggest Fan of RadioDJ

Install MariaDB https://djgarybaldy.blogspot.com/2020/08/installing-maria-db.html

Install RadioDJ: https://djgarybaldy.blogspot.com/2020/08/how-to-install-radiodj-free-radio.html

Into Internet radio for 25 years 1999-2024

RadioDJ 2045 MariaDB 11.2 Windows 11