/SQL/Mysql varchar length

Mysql varchar length

Mysql varchar length

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

2

Varchar max length

TINYTEXT              255
TEXT/VARCHAR          65,535
MEDIUMTEXT    	      16,777,215
LONGTEXT              4,294967,295

2

Change varchar length mysql

ALTER TABLE emp MODIFY COLUMN name VARCHAR(100);

0

Source: stackoverflow.com

Similar codes

5 votes184 views3 answers
Oracle list columns in schema
SQL
0 vote166 views1 answer
Create table Statement Syntax in SQL Server
SQL
0 vote186 views1 answer
Get number of rows in every table mysql
SQL
0 vote185 views2 answers
How to set global time_zone in mysql
SQL
1 vote181 views1 answer
Login to database mysql terminal
SQL
0 vote183 views1 answer
Mysql sum with group by
SQL
0 vote196 views1 answer
Ajouter une clé etrangere mysql
SQL
0 vote184 views1 answer
How to find database collation in postgres
SQL
0 vote172 views1 answer
Linux upload database to mysql
SQL
0 vote181 views1 answer
Storing RGBA in mysql db
SQL

Share