You forgot the escape the table name 4013834123456 with backticks. Also you have and end too much. delimiter | CREATE TRIGGER handle100kRows BEFORE INSERT ON `4013834123456` FOR EACH ROW BEGIN IF (SELECT COUNT(*) FROM `4013834123456`) = "100000" THEN DELETE FROM `4013834123456` ORDER BY id LIMIT 1; END IF; END |...
Off course it is possible, just little hidden, took me some tie to find it. Click to the table, then "alter table" and then the plus (+) icon next to the column you want to add the new column after.
php,mysql,database,export,adminer
Per your comment on or original question: I want to export the database and import it in phpMyAdmin in my local environment to test and modify my client's website. You want to recreate the database and data in a new environment and you are exporting SQL. Therefore, you will want...