8 lines
254 B
SQL
8 lines
254 B
SQL
ALTER TABLE qt_projects
|
|
ADD COLUMN tracker_url VARCHAR(500) NULL AFTER name;
|
|
|
|
UPDATE qt_projects
|
|
SET tracker_url = CONCAT('https://tracker.yandex.ru/', TRIM(name))
|
|
WHERE (tracker_url IS NULL OR tracker_url = '')
|
|
AND TRIM(COALESCE(name, '')) <> '';
|