/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

1 vote226 views1 answer
Top 10 rows in mysql
SQL
1 vote174 views1 answer
List all triggers in SQL Server
SQL
0 vote175 views1 answer
Sql server select value large text
SQL
0 vote172 views1 answer
Sql select non unique
SQL
0 vote184 views1 answer
Make parameters nullable in sql server
SQL
2 votes209 views1 answer
Match in sql server
SQL
2 votes176 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
0 vote184 views1 answer
How to install Firebird
SQL
0 vote134 views2 answers
Avg() sql
SQL
3 votes185 views1 answer
Force using index plsql
SQL

Share