Search
 
SCRIPT & CODE EXAMPLE
 

SQL

How do I modify a MySQL column to allow NULL?

ALTER TABLE mytable MODIFY mycolumn VARCHAR(255);
Comment

mysql update column to be nullable

ALTER TABLE `products` CHANGE `category_id` `category_id` BIGINT(20) UNSIGNED NULL;
Comment

PREVIOUS NEXT
Code Example
Sql :: sql mm/dd/yyyy format 
Sql :: enable constraint in sql 
Sql :: count column of tables psql 
Sql :: savepoint in sql 
Sql :: How to drop a foreign key constraint in mysql ? 
Sql :: ms sql create user 
Sql :: insert current date in mysql 
Sql :: sql declare table variable 
Sql :: postgresql set auto increment value 
Sql :: get record which is available in one table but not in another mysql 
Sql :: select last row in sql 
Sql :: update query with between in mysql 
Sql :: create a sqlite database c# 
Sql :: sql percentage 
Sql :: check postgresql version in rails console 
Sql :: mysql alter add foreign key 
Sql :: show all event schedular on mysql 
Sql :: oracle get running queries 
Sql :: excel export from sql using python 
Sql :: varchar vs nvarchar sql 
Sql :: use float in sql server string 
Sql :: how to insert multiple rows in sql 
Sql :: docker create postgresql database 
Sql :: output table plsql 
Sql :: update with inner join sql server 
Sql :: postgresql remove new line from string 
Sql :: between from sql 
Sql :: reset auto increment mysql 
Sql :: mysqlclient error 
Sql :: default number in sql 
ADD CONTENT
Topic
Content
Source link
Name
8+7 =