mysql data types code example

Example 1: change data type in mysql

ALTER TABLE table_name

CHANGE COLUMN column_name column_name datatype;

Example 2: python data types

#use syntax: variable = value
#string
string = 'ASCII text'
#integer
integer = 1234567890
#float
floatnum = 123.456
#list(called arrays in other languages)
numlist = [1,2,3,4,5]
#dictionary(called objects in other languages)
dictionary = {'key','value'}

Example 3: mysql url data type

< MySQL 5.0.3 use TEXT
or
>= MySQL 5.0.3 use VARCHAR(2083)

Tags:

Java Example

Related