Sql

Search

mysql change database charset and collation

ALTER DATABASE databasename CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Comment

PREVIOUS	NEXT

Code Example
Sql :: cast string to datetime mysql
Sql :: alter user password postgres
Sql :: mysql date minus 1 day
Sql :: mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
Sql :: liquibase alter column type / length
Sql :: get current date in pyspark sql
Sql :: update part of a string in mysql
Sql :: sql_mode=only_full_group_by
Sql :: sql query to make a existing column auto increment
Sql :: Mysql query add column with default string value
Sql :: convert_tz mysql
Sql :: how remove column in mysql
Sql :: get the list of all tables in sql server
Sql :: mysql remove last character
Sql :: t-sql remove all non-alphanumeric characters from a string
Sql :: get hour from date sql
Sql :: stop mysql ubuntu
Sql :: adding a default constraint to an existing column in sql
Sql :: mysql count words
Sql :: install mysqldump ubuntu
Sql :: how to give user privelege to create dblink in oracle
Sql :: alter user root mysql
Sql :: mysql dump mysql db cli
Sql :: mysql create database charset utf8mb4
Sql :: psql is not recognized
Sql :: monthname sql
Sql :: oracle export trigger ddl
Sql :: postgresql update to unique
Sql :: oracle character index
Sql :: oracle view ddl

Search

SQL

mysql change database charset and collation

ADD CONTENT