New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Tool for quickly creating sql
Hello all.
Long time no speak.
I was wondering, if their exists an online tool that would allow me to make databases like php my admin but with out needing to be connected to the server? And I can just coppy the sql it generates after making all the necessary tables.
When I say online, I mean one using html as the gui in this case.
Thanked by 1inthecloudblog
Comments
https://www.npmjs.com/search?q=mysql
Tafak are you showing for this poor man?
Hm, try this: https://dev.mysql.com/downloads/workbench/ but it's not "like HTML". Standalone app.
You can try this: https://www.dbdesigner.net/designer?landing_guest=true
Or more here: https://www.google.com/search?q=mysql+create+table+online+tool
There's mysql workbench for downloadables and several free tools for webapps. Just search them.
MySQL Front Sir, an old tool for over 10 years but still works well.
@kbap thanks for your answer. It one the gold metal. The first link was not accessible with my screen reader (in particular, the adding fields part). Thanks for rest of you also, you get the silver (participation prize). I did the second or third thing on that google search but unfortunately I can only make one at a time.
mysql workbench, navicat..
for lazy people like me : .hbm2ddl.auto
oh, i miss the silver award!
anyway, my first emoticon on LET
For desktop I use this https://www.activedbsoft.com and online phpmyadmin is best
HeidiSQL
If you are comfortable with PhpMyAdmin you can use it with XAMP (or install it manually) and just run it localhost, create your database, dump it and run it on the server.
personally I use DataGrip, but for non-students it costs money. The best free alternative I know of (that has also been mentioned here) is Mysql Workbench, but you'll still need to run a localhost database for it to work. It can't just "create a database" for you, I think. You can use XAMP or terminal for this as well.
Edit: PhpMyAdmin, like all tools mentioned in this thread, can also connect to remote databases. So you can do all your work in the localhost databse, then just switch over to the remote in the same interface from localhost and run the commands you need.