Settlers Posted February 14, 2007 Report Share Posted February 14, 2007 (edited) Tip dota tabula: +------+-------+------+ | col1 | col2 | col3 | +------+-------+------+ | 3 | Three | NULL | | 1 | One | NULL | | 2 | Two | NULL | +------+-------+------+ a kaa lai es vareetu visu kolonu piem col3 paarlikt priekshaa col1? tip iznaakumam jaaiznaak: +------+-------+------+ | col3 | col1 | col2 | +------+-------+------+ | NULL | 3 | Three| | NULL | 1 | One | | NULL | 2 | Two | +------+-------+------+ kautko meegjinaaju ar sho: ALTER TABLE Tabula MOVE col3 [bEFORE col1] nekaa nesanaaca :D neesu prof MySQL komandaas. izskridiiiju 30 min googlee par MySql... bet nekaa iipashu neatradu izmantoju phpmyadmin MySQL Cerams kaads var palīdzēt man, paldies Edited February 14, 2007 by Settlers Link to comment Share on other sites More sharing options...
v3rb0 Posted February 14, 2007 Report Share Posted February 14, 2007 varbūt [] noņem lai gan, sieties klāt pie lauku secības nav tas labais tonis Link to comment Share on other sites More sharing options...
Val Posted February 14, 2007 Report Share Posted February 14, 2007 http://dev.mysql.com/doc/refman/5.0/en/cha...lumn-order.html Link to comment Share on other sites More sharing options...
Settlers Posted February 14, 2007 Author Report Share Posted February 14, 2007 http://dev.mysql.com/doc/refman/5.0/en/cha...lumn-order.html Paldies, ar šo variantu strādā Link to comment Share on other sites More sharing options...
Delfins Posted February 14, 2007 Report Share Posted February 14, 2007 priekškam tev mainīt kolonnu secību !!? doh... Link to comment Share on other sites More sharing options...
andrisp Posted February 14, 2007 Report Share Posted February 14, 2007 Patīkamāk strādāt tad ir, ja ir kautkāda organizācija tabulai. Link to comment Share on other sites More sharing options...
Recommended Posts