How to use MySQL gui to edit data?

Asked By Mellisa Wright 60 points N/A Posted on - 11/19/2012

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.

• Status: Open
• Question Views: 1179
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by jasonf kknisely

Go To Solution

Best Answer

Best Answer

Answered By jasonf kknisely 0 points N/A #174563

How to use MySQL gui to edit data?

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,

About jasonf kknisely

Questions
1

Answers
51

Best Answers
12

• Vote Up 0 Vote Down

• Posted on - 11/19/2012
• Question Category: MySQL Server

Answered By Dent Owensby 0 points N/A #174564

How to use MySQL gui to edit data?

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.

About Dent Owensby

Questions
2

Answers
19

Best Answers
10

• Vote Up 0 Vote Down

• Posted on - 04/23/2013
• Question Category: MySQL Server