select count(*) , lw , lfd , concat(dir_rel,’_‘,dsn) as ddid , dt_last_modif , format(size , 0 ) as size , ext from fs_171009_1805 group by ddid having (count(*) = 1) order by size desc, ddid , lw ;
SELECT DATE_FORMAT(„2017-06-15“, „%m %d %Y“); Format Description %a Abbreviated weekday name (Sun to Sat) %b Abbreviated month name (Jan to Dec) %c Numeric month name (0 to 12) %D Day of month, numeric, follwed by Weiterlesen
SET @x =0;SELECT (@x:=@x+1), a, b, c FROM tab; ———- Beispiel:drop table p_music_auf_LP_mit_id ; set @x =0;create table p_music_auf_LP_mit_idSELECT(@x:=@x +1) AS id, year, interpret_lastname, interpret_prename, albumFROM p_music_auf_LP;