/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 votes200 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
2 votes192 views1 answer
Date_format for time sql
SQL
1 vote187 views1 answer
Oracle db create new schema
SQL
3 votes240 views2 answers
How to View column names of a table in SQL
SQL
0 vote186 views1 answer
Insert or update cassandra
SQL
0 vote220 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote201 views1 answer
Install package for sqlserver in asp.net core
SQL
0 vote195 views1 answer
Db format in quotation
SQL
0 vote259 views1 answer
Postgresql print variable
SQL
3 votes200 views3 answers
Stop mysql service ubuntu
SQL

Share