|
Title: Easy Simple help Needed For MYSQL [i can pay 1$ in BTC ] Post by: Party24*7 on March 20, 2016, 04:07:04 PM I'm Totally Noob in This Web Programming ::)
so i'm using EPS [GUI MySql Manager] for Deleting some records from Database But in a column whenever i try to remove anything from DB i get this error "No Unique Key" https://i.imgur.com/k9tqvvY.png i Tried to add some keys or whatever in Indexes Tab but it give some othere error ! i just want to delete some data/Records from This Colum so anyone can help me ? i can pay 1$ Via BTC Title: Re: Easy Simple help Needed For MYSQL [i can pay 1$ in BTC ] Post by: bL4nkcode on March 20, 2016, 05:01:35 PM Well you must declare a primary key in every table and that key will be your identifier to
delete or update your data in every table you made. That's only i know dude. Hope it can help Title: Re: Easy Simple help Needed For MYSQL [i can pay 1$ in BTC ] Post by: Joel_Jantsen on March 20, 2016, 05:36:00 PM Yes,you must declare a primary key ,use one of the Joins,maybe in this case left outer joins.Its quite simple,I didn't go through the entire thing but let me know if you're not able to figure it out,I will write you a custom query.
|
