zgkhoo Posted October 17, 2007 Share Posted October 17, 2007 how to use mysql query browser to delete the record ? eg..i wanna delete certain recordset at "mystaff" table Link to comment Share on other sites More sharing options...
Barand Posted October 17, 2007 Share Posted October 17, 2007 Drag the tablename from right side into a resultset window Click "Edit" at the bottom Right click the row to be delete selecting "Delete Row" from the popup menu. Link to comment Share on other sites More sharing options...
zgkhoo Posted October 18, 2007 Author Share Posted October 18, 2007 the delete row is disable ...in the menu..why? ??? Link to comment Share on other sites More sharing options...
Barand Posted October 18, 2007 Share Posted October 18, 2007 Looks the table isn't editable. Probably bcause there is no primary key to uniquely identify records. Link to comment Share on other sites More sharing options...
zgkhoo Posted October 18, 2007 Author Share Posted October 18, 2007 $sql = "CREATE TABLE transaction ( TransactionID varchar(6), PurchaseNo integer(4), TransactionDate Date, UserID varchar(10), Category varchar(10), BetMode varchar(9), Amount integer(10), DrawDate Date, DrawNumber varchar(25), DrawStatus varchar(6), PRIMARY KEY (PurchaseNo) )"; still cant delete... Link to comment Share on other sites More sharing options...
zgkhoo Posted October 18, 2007 Author Share Posted October 18, 2007 *bump* Link to comment Share on other sites More sharing options...
teng84 Posted October 19, 2007 Share Posted October 19, 2007 if you cant use it then query it manually Link to comment Share on other sites More sharing options...
zgkhoo Posted October 19, 2007 Author Share Posted October 19, 2007 query delete? waste time i need make my job simple n faster.. right click-->delete Link to comment Share on other sites More sharing options...
Barand Posted October 19, 2007 Share Posted October 19, 2007 For some reason the "Edit" button at the bottom is disabled. The only other reason I can think of is your user permissions setting Link to comment Share on other sites More sharing options...
Barand Posted October 20, 2007 Share Posted October 20, 2007 As you have opened another thread on this topic I'll close this one. Don't open a third. Link to comment Share on other sites More sharing options...
Recommended Posts