Menu
  • HOME
  • TAGS

Create Mysql Trigger before Insert [SOLVED]

mysql,triggers,adminer

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 |...

Can I add a column to an existing table without typing typing SQL commands in Adminer?

mysql,adminer

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.

How to export database with Adminer?

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...