Izzatilla Rakhmatullaev
Last answered:

25 Oct 2023

 Posted on:

12 Oct 2023
0

Resolved: Cannot change column with default

in SQL / DEFAULT Constraint

3 answers ( 1 marked as helpful)
Tanika
Posted on:

12 Oct 2023
0

The column has datatype of INT and hence default has to be of that datatype.


Your query is trying to add 'X' (which is a character) as default to the INT column

Helpful answer
Izzatilla Rakhmatullaev
Posted on:

12 Oct 2023
0

thank you!

Tsvetelin Tsonkov
Instructor
Posted on:

25 Oct 2023
0

Hi Izzatilla!
Thanks for reaching out.


As Tanika explained the column has a datatype of INT and hence default has to be of that datatype.


Hope this helps.
Best,
Tsvetelin

Submit an answer

related questions

Sivarajan Sivakumar
0
18
Cannot insert 999903 into the dept_emp table?
Christopher Watts
1
12
Error Code: 1364. Field 'customer_id' doesn't have a default value
Sizar Aziz
0
6
Resolved: Quotation marks for INT column
Bwende Boazi Gaston
0
6
Resolved: default constraint part 1
Messaoud Makhlouf
0
6
Error Code: 1054. Unknown column 'gender' in 'field list'
Lizeth Alexandra Estevez Joya
0
6
Error Code: 1136. Column count doesn't match value count at row
AINA BINTI AZAZI
0
6
Unknown gender column in the field
Izzatilla Rakhmatullaev
0
4
Resolved: Cannot add auto increment
Japhet Paz
1
4
Resolved: ALTER COLUMN VS. CHANGE COLUMN
Rasoul Heydari
0
4
Resolved: Rollback clause does not retrieve the last change
Md Abdur Rakib
3
4
Differences between CHANGE COLUMN, ALTER COLUMN, and MODIFY
Ahmed Hesham
0
2
0 55 00:22:30 ALTER TABLE customers ADD COLUMN gender ENUM('M', 'F') AFTER last_name Error Code: 10