|Re: eclipse mysql open table [message #804535 is a reply to message #804327]
||Wed, 22 February 2012 18:45
| Dennis Christy
Registered: February 2012
I am using Windows7, MYSQL within Eclipse and JavaEE. I have created a database adpr within a project adspayr, folder name adspr, file name adspay. Within database adpr I have created 2 tables empmf and paychks. I created those tables using Eclipse/MYSQL in Project Explorer in the tab headed adspay.sql. I highlighted the code, right clicked on the selected code and clicked "execute selected text". This worked fine and created the table empmf. I can see this table in the pane to the right of the Project Explorer pane, the empmf tab is next to the adspay.sql tab. If I click on the empmf tab, it will bring up a spreadsheet-like format into which I can key the data for the empmf table. This all works fine. However I cannot find a way to get the same spreadsheet-like view into which I can key the data for the paychks table. I know the table is being created, because I can go to a command line for MYSQL and see the file. I can of course key the data using the MYSQL command line, however I am having trouble creating a script to update the file with new data records. I have thought of a workaround in which I will key the updates in Eclipse using the same coding techniques I used to create the table and its schema, and then use MYSQL command line to view the updated table. I thought of this workaround after I had posted my question on the forum. I still think it more convenient to do the updating and viewing in Eclipse rather that using both Eclipse and the command line approach. |
There were of course other intermediate steps I used as per tutorials/manuals/books I viewed, however I cannot remember all the steps they had me go through. I do know about Data Source Explorer and it is visible in the pane below the pane to the right of the project explorer pane.
Thank you in advance for any guidance you can give me on this.
[Updated on: Wed, 22 February 2012 18:54]
Report message to a moderator
Powered by FUDForum
. Page generated in 0.02346 seconds