Bitcoin Forum
June 14, 2024, 05:04:47 AM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Warning: One or more bitcointalk.org users have reported that they strongly believe that the creator of this topic is a scammer. (Login to see the detailed trust ratings.) While the bitcointalk.org administration does not verify such claims, you should proceed with extreme caution.
Pages: [1]
  Print  
Author Topic: Easy Simple help Needed For MYSQL [i can pay 1$ in BTC ]  (Read 247 times)
Party24*7 (OP)
Sr. Member
****
Offline Offline

Activity: 402
Merit: 250

Get Amazon Best Deals @ https://goo.gl/JE38kC


View Profile
March 20, 2016, 04:07:04 PM
 #1

I'm Totally Noob in This Web Programming  Roll Eyes
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"

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
bL4nkcode
Copper Member
Legendary
*
Offline Offline

Activity: 2142
Merit: 1305


Limited in number. Limitless in potential.


View Profile
March 20, 2016, 05:01:35 PM
 #2

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
Joel_Jantsen
Legendary
*
Offline Offline

Activity: 1918
Merit: 1310

Get your game girl


View Profile
March 20, 2016, 05:36:00 PM
 #3

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.
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!