MySQL Update First Row In Table

Question

I have a table with single column.

EmailTable

NotifyEmail
[email protected]

No id no nothing just single row single column. So how do I update this row with new value?

I tried:

UPDATE NotifyEmail
FROM EmailTable
SET [email protected]

It's not working.

edit, my table do not have ID. It's just a single column.

Please don't ask a question for something like this that is readily available via a google or the appropriate manual section. — philipxy
– philipxy, Commented Feb 15, 2018 at 2:30
@philipxy where in google can you solve my problem? If i have found in google or manual, i would'nt be asking in here. Pls refrain from commenting if you can't help. — GeneCode
– GeneCode, Commented Feb 26, 2018 at 2:19
See How to Ask & What types of questions should I avoid asking? & the downvote arrow mouseover text. Also https://www.google.ca/search?q=So+how+do+I+update+this+row+with+new+value+mysql+stackoverflow.com. And How do comments work? — philipxy
– philipxy, Commented Feb 26, 2018 at 2:57
@philipxy the answer at "Change One Cell's Data in mysql " does not answer my question since my table is only one column without any ID. Pls read carefully my question before suggesting unrelated answers. Thank you. — GeneCode
– GeneCode, Commented Mar 2, 2018 at 4:01

Alessio Cantarella · Accepted Answer · 2018-02-15 00:29:59Z

3

The MySQL UPDATE statement has the following syntax:

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

so, in your case, you should write the following query:

UPDATE EmailTable
SET NotifyEmail = '[email protected]'
WHERE NotifyEmail = '[email protected]';

answered Feb 15, 2018 at 0:29

5,2413 gold badges31 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1