Ekim 2015

MySQL Select For Update örneğim

Ek alan eklenip, tek tek uğraşmak istemeyince.

SELECT team_name FROM tuval_team FOR UPDATE;
UPDATE tuval_team SET team_name_sort = team_name;

varolan bir datadan insert üretirken

INSERT INTO tuval_lig_rel (lig_id, team_id)
SELECT 6, team_id FROM tuval_team WHERE team_lig = 6;