How to use MySQL gui to edit data?

Asked By 60 points N/A Posted on -
qa-featured

Hello friends,

How to use MySQL GUI to edit data? Is it possible for me to directly edit some data in the MySQL database?

I have to make some changes to the graphical user interface of my Java bookstore system. I am open to those suggestions and advice.

Thanks and Regards,

Mellisa Wright.

SHARE
Best Answer by jasonf kknisely
Best Answer
Best Answer
Answered By 0 points N/A #174563

How to use MySQL gui to edit data?

qa-featured

Hi,

Yes you can edit the data in my SQL by update query. For example you are having a class db and a student table. You want to update the name of the student from AAA to BBB in the student name field having id 1.

Update students set student name=’BBB’ where id=1;

The update command will update the name of the student.

Regards,

Answered By 0 points N/A #174564

How to use MySQL gui to edit data?

qa-featured

Hello Mellisa Wright,

You can use MySQL GUI tool to edit data with the following links I provided you:

  1. You can watch a video tutorial on YouTube .

  1. Or you can watch a step by step tutorial MySQL GUI tools .
  2. For directly edit data in your MySQL database you can use the live editing techshifts on the link provided below:

http://dev.mysql.com/doc/workbench/en/wb-sql-editor-live-editing-tabsheets.html

Hope for your best.

Related Questions