472,127 Members | 1,713 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,127 software developers and data experts.

how to create a editable mysql file that contains table data

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.
Jan 10 '07 #1
3 1687
4,258 Expert 4TB
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:
Jan 10 '07 #2
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
Jan 10 '07 #3
4,258 Expert 4TB
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:
Jan 10 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Eric Wichterich | last post: by
10 posts views Thread by John Smith | last post: by
8 posts views Thread by ASP Yaboh | last post: by
1 post views Thread by Ike | last post: by
3 posts views Thread by Me Alone | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.