5 lines
154 B
MySQL
5 lines
154 B
MySQL
|
ALTER TABLE bands ADD COLUMN lat NUMERIC(15,10);
|
||
|
|
ALTER TABLE bands ADD COLUMN lng NUMERIC(15,10);
|
||
|
|
|
||
|
|
UPDATE bands SET country = 'US' WHERE country = 'USA';
|