how to create a editable mysql file that contains table data

[ravikiranveluguleti]

hi, this is ravikiran

i am working on a project(using java & mysql) that requires creation of a editable mysql file that contains all the data present in a particular table ,(like .mdb file that MS-Access will create for every table).Is mysql having a facility to create such file.If so how???

help me

thanx in advance.

[ronverdonk]

You can use phpMyAdmin, phpMyEdit or alike free products to edit MySQL rows. If you don't want to use the available tools for this, you can use one of the numerous so-called GRID packages that are available on the web, or you'd have to develop the entire editor yourself.

Ronald :cool:

[ravikiranveluguleti]

hi ronald,

i dont think that u got my requirement right.I am not looking for a editor for mysql rows.

What i need is creating a editable mysql file that should be saved to the hard disk when a user clicks on a button in my front-end. That file must contain all the records in a particular table.(As if MS-Access creates a .mdb file for every table, that contains all the data of a particular table)

help me

thanx in advance

[ronverdonk]

Ok, I got it.
No, since the MySQL data is not stored in a 'normal' editable format, you cannot directly edit/save the MySQL tables/rows.
All you can do is create SQL statements or XML structures from the tables, present that to the user in an editor-like format and then insert that data back into the db. But you'll have to write such code yourself or use any of the available classes/packages for this.

Ronald :cool: