Yes I do, for example, I want the database to set the timestamp each time I insert a new record.
I could solve it with this tutorial: Launching a phpMyAdmin Docker container
Yes I do, for example, I want the database to set the timestamp each time I insert a new record.
I could solve it with this tutorial: Launching a phpMyAdmin Docker container
I would focus on Wapplerâs Database Manager and then edit directly the migration files created by the DB manager whenever you are blocked by the UI.
Here you have a migration file where I create a user table with timestamps.. @george maybe you could think of a way to integrate (drop)timestamps into the UI.
Also it may be easier to use a desktop app to tweak some things directly in the database.
Check tableplus. It has a great interface and a free tier. Phpmyadmin in docker seems overkill for adding default values
Thanks!
Good avise, but Iâm not a good sql writter, so this option itâs going to be harder for me.
Great! Some time ago I bought Navicat, though itâs not a bad solution, trying to set the timestamp function is harder than using phpmyadmin. Hope this interface is better.
Let us know how it goes. Anyway I found an error in your command. Just after the --link argument you are trying to connect to the network âmpc_docker_local_db_1:dbâ which is the database from my example and not the name of your database.
Yeap, I didnât read it correctly and realized while reading the other topic
If youâre still using Navicat, setting up timestamp columns is straighforward:
⌠though I usually copy/paste these and a few other columns between tables.
Yes, on my Navicat that option isnât available (donât know why)
After modifying the table on phpmyadmin I checked how it shows on Navicat
In my opinion, it should be more intuitive Navicat.
Thanks for your advises! Good post
Sorry - itâs not available on mine either. I assumed it appeared as an option automatically, but I must have typed it in originally and forgotten.