/SQL/Change varchar length mysql

Change varchar length mysql

Mysql varchar length

SELECT length('abcd') FROM DUAL;		-- Oracle
SELECT length('abcd');					-- MySql
SELECT len('abcd');						-- SQL Server

2

Change varchar length mysql

ALTER TABLE emp MODIFY COLUMN name VARCHAR(100);

0

Source: stackoverflow.com

Similar codes

2 votes227 views1 answer
Oracle cpu per session
SQL
0 vote237 views1 answer
Contraint default SQL
SQL
-1 vote267 views1 answer
How to Activate the database
SQL
0 vote237 views1 answer
Sql #region
SQL
0 vote228 views1 answer
Sql server remove enter from string
SQL
2 votes231 views1 answer
Sql server find table name
SQL
1 vote256 views1 answer
Oracle sql pad left zeros
SQL
0 vote260 views1 answer
Oracle insert single quote in string
SQL
0 vote227 views1 answer
Get server date mysql
SQL
0 vote228 views7 answers
10 random questions use python and SQL
SQL

Share