I’ve created a couple new tables and can see them in the sql manager of the control panel. I would like to easily be able to edit the data and was wondering if there is a plugin or module for EE that let’s you edit your table data?
Thanks
Ryan
This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
March 12, 2009 11:45pm
Subscribe [5]#1 / Mar 12, 2009 11:45pm
I’ve created a couple new tables and can see them in the sql manager of the control panel. I would like to easily be able to edit the data and was wondering if there is a plugin or module for EE that let’s you edit your table data?
Thanks
Ryan
#2 / Mar 13, 2009 6:06am
The only built-in method would be to use the :
Admin->Utilities->SQL Manager
utility that comes with ExpressionEngine. I don’t know of any plugins as such that do this. That being said though using phpMyAdmin or any database query applications will get the same result for you but probably with a little easier operation too.
Hope that helps a bit.
Best wishes,
Mark
#3 / Mar 13, 2009 1:53pm
On the Windows desktop, HeidiSQL is awesome. However, your host must allow remote MySQL access.
#4 / Mar 13, 2009 1:54pm
And for Mac Sequel Pro is fantastic 😉
#5 / Mar 13, 2009 3:09pm
I’ve created a couple new tables and can see them in the sql manager of the control panel.
If you’re creating new tables and populating with data you should become familiar with phpMyAdmin (which can be installed in your EE site, and is often available with server hosts) and the other DB management tools.
#6 / Mar 13, 2009 4:57pm
on win SQLyog is really nice…$99.00 and I think that there is a free version.
query builder is a huge time saver for me.
Also consider this free tool.