Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql modify default value

ALTER TABLE tbl_name ALTER column_name SET DEFAULT new_value;
Comment

mysql change default collation

//Server side, so every new table will be utf8 unicode

SET character_set_server = 'utf8';
SET collation_server = 'utf8_unicode_ci';
Comment

PREVIOUS NEXT
Code Example
Sql :: oracle apex warning message 
Sql :: how to drop function in sql 
Sql :: sql check duplicate value in column 
Sql :: sql server alter table add column tinyint 
Sql :: varchar vs nvarchar sql 
Sql :: myswql show full processlist 
Sql :: sql drop procedure 
Sql :: sql remove decimal places 
Sql :: SQL Error 1040 : Too many connections 
Sql :: add colum date in sql 
Sql :: how to select distinct in mysql 
Sql :: Check database restore status sql script 
Sql :: SQL ORDER BY DESC (Descending Order) 
Sql :: update one column from another column in same table 
Sql :: oracle drop sequence 
Sql :: mysql grant all on all databases 
Sql :: postgresql remove new line from string 
Sql :: mysql stored procedure vs function 
Sql :: mysql delete entire row on condition 
Sql :: declare varchar sql server 
Sql :: SQL Modify Column in a Table -PostgreSQL 
Sql :: orcale index size 
Sql :: increment integer in table sql 
Sql :: 11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 
Sql :: sqlserver add column 
Sql :: createdb with postgresql on ubuntu 
Sql :: complete date is 1 year or not sql server 
Sql :: creating table in sql 
Sql :: How to insert data in mysql ? 
Sql :: SQL COUNT() with WHERE 
ADD CONTENT
Topic
Content
Source link
Name
1+5 =