/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 vote268 views1 answer
Sql server manager close connection
SQL
0 vote271 views1 answer
Oracle show running job
SQL
0 vote286 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
0 vote382 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
1 vote327 views1 answer
Delete dublicate rows sql
SQL
0 vote300 views1 answer
Add week ending date sql server
SQL
8 votes283 views1 answer
Check mysql version phpmyadmin
SQL
2 votes263 views1 answer
Mariadb select multiple rows into one column
SQL
1 vote280 views1 answer
Sql server cast date dd/mm/yyyy
SQL
5 votes281 views1 answer
How to get all dates in a month in oracle
SQL

Share