[Aa12]

I just started learning mysql

http://i.imgur.com/Gfs0rYX.png

How do I delete line? For example line with id 23?

And why I have edit and delete options in this table : http://i.imgur.com/ec3R2eS.png but dont have them in my first table(first picture). Im pretty sure I created both tables the same way

[iKarim]

You don't need buttons to delete or edit data from MySQL.
Just use the queries: Delete, Update and Insert Into.
Example:

PHP код:

DELETE * FROM `table` WHERE `id` = 23; 


PHP код:

UPDATE `table` SET `IntCol` = 0 , `StrCol` = 'Test'; 


[Vince]

You only have the edit options if the table has a primary key. If the table does not have a primary key then a row cannot be uniquely identified and those options won't work.

[Aa12]

Quote:

Originally Posted by Vince You only have the edit options if the table has a primary key. If the table does not have a primary key then a row cannot be uniquely identified and those options won't work.

Thank you