/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

0 vote183 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote170 views1 answer
Call rest api from postgresql
SQL
6 votes541 views3 answers
Sql select last id
SQL
0 vote166 views1 answer
Longtext sql
SQL
0 vote169 views1 answer
St_buffer mysql
SQL
0 vote216 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
2 votes198 views1 answer
Find column in all stored procedures sql server
SQL
9 votes184 views5 answers
Laravel to sql
SQL
10 votes167 views1 answer
Oracle object dependencies
SQL
0 vote195 views1 answer
Oracle current date minus 1 day
SQL

Share