dannybrazil Posted April 3, 2008 Share Posted April 3, 2008 hello i have a table with 4 cul' and i want to ADD another culomn after the 3rd before the 4th culomn ALTER TABLE 'name' ADD 'City' BEFORE '4th'; is it like that ? Link to comment https://forums.phpfreaks.com/topic/99389-sql-with-php/ Share on other sites More sharing options...
metrostars Posted April 3, 2008 Share Posted April 3, 2008 PHPMyAdmin threw out ALTER TABLE `table` ADD `colname` VARCHAR( 45 ) NOT NULL AFTER `fieldname` ; Link to comment https://forums.phpfreaks.com/topic/99389-sql-with-php/#findComment-508579 Share on other sites More sharing options...
cooldude832 Posted April 3, 2008 Share Posted April 3, 2008 hello i have a table with 4 cul' and i want to ADD another culomn after the 3rd before the 4th culomn ALTER TABLE 'name' ADD 'City' BEFORE '4th'; is it like that ? the order of fields in the table isn't terribly important its just having them in there in the proper type that is more important. Link to comment https://forums.phpfreaks.com/topic/99389-sql-with-php/#findComment-508587 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.