Snippets > MySQL > Change Column Position

Change Column Position

ALTER TABLE table_name MODIFY COLUMN column_last_name VARCHAR(40) AFTER column_first_name;

Change column position Convert values of a column to lowercase Count the number of rows in a table Display records Display records in a Bootstrap Table Display records with Bootstrap pagination

Display records with CSS styles Do not display a comma after the last record Escape all special characters in a string Highlight the search term in the search results Replace unicode characters by utf-8 characters Search field autocomplete with Bootstrap Typeahead

Search records by an option Search with pagination Select table rows that have the current day and month Split results into columns Strip HTML tags