Jump to content
MakeWebGames

Recommended Posts

Posted

I am trying to delete a row from my database. I have tried SO many things to delete this row from my users table, but I keep getting this error: Error

SQL query:

 

DELETE FROM users WHERE Field = 'bankcrystal2'

 

MySQL said: Documentation

#1054 - Unknown column 'Field' in 'where clause'

Do I need to add ' to users, like 'users'

I am using http://www.w3schools.com/sql/sql_delete.asp to help, but I can't seem to get it to delete...any help you can give me? I am trying to do things myself to learn, but I just can't seem to delete it... :(

Posted

Re: SQL Queries

Uh...no, not really.

In my users table, I have userid, etc, then bankcrystal2. But I have a crystalbank2 which I use, but I don't use bankcrystal2. And I want to delete that field from the users table.

Would the query be:

ALTER TABLE `users` DROP INDEX `bankcrystal2`
Posted

Re: SQL Queries

Humph...bugger:

 

SQL query:

ALTER TABLE `users` DROP INDEX `bankcrystal2`

MySQL said: Documentation
#1091 - Can't DROP 'bankcrystal2'; check that column/key exists 

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...