Problem with renaming a field in sql table

Question

So i have this table:

  SELECT * FROM table LIMIT 10; 


    +----+----------------+------------+----------+----------------+--------+--------+
    | sex_id | First name | year of beginning  | year of ending  | country |    |  |
    +----+----------------+------------+----------+----------------+--------+--------+
    |  56| mimic |       1987 |     NULL | United Kingdom | Group  | NULL   |
    | 3 | charales glass     |       1941 |     NULL | United States  | Person | Male   |
    | 33| Grass |                1983 |     2000 | United Kingdom | Group  | NULL   |
    | 67| Mother       |       1989 |     2000 | United States  | Group  | NULL   |
    | 69| wind of lollie  |       1950 |     NULL | United States  | Person | Male   |
    +----+----------------+------------+----------+----------------+--------+--------+

‎‎‎‎‎‎‎ ‎‎‎‎‎‎‎‎‎‎ ‎‎‎ ‎‎‎

I t‎‎‎‎hen make the ‎‎‎table smaller to show what i want to rename which is the end year, and i want to change it to NULL.

‎‎‎‎‎ERROR 1366 (HY000): Incorrect integer value 'NULL' for column 'end_year' at row 155

Please do not vandalize your posts. By posting on the Stack Exchange network, you've granted a non-revocable right for SE to distribute that content (under the CC BY-SA 4.0 license). By SE policy, any vandalism will be reverted. — tripleee
– tripleee, Commented Dec 10, 2021 at 14:01

Samraj Edwin Samuel · Accepted Answer · 2021-12-13 13:42:21Z

2

Please remove quotes from 'NULL' in your update statement.

UPDATE table_name SET row_name=NULL WHERE name='Specific name';

edited Dec 13, 2021 at 13:42

user17625561

answered Dec 8, 2021 at 14:42

Samraj Edwin Samuel

974 bronze badges

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

Comments

Donald Duck is with Ukraine · Accepted Answer · 2021-12-12 13:41:44Z

0

NULL not equal varchar2,so you should try end_year=NULL

edited Dec 12, 2021 at 13:41

Donald Duck is with Ukraine

9,00223 gold badges82 silver badges106 bronze badges

answered Dec 8, 2021 at 14:52

RP.S

8377 silver badges13 bronze badges

Collectives™ on Stack Overflow

Problem with renaming a field in sql table

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related