test

 

 
alim  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

gender

char(1)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

status

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

fat

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

meat

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

fish

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

fruits

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

vegetables

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

chocolate

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

tea

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

coffee

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

heigth

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

weight

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

age

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Indexes

Back

 
mytable  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

id

mediumint(8) unsigned

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

gruppe

mediumint(9)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

wert

mediumint(9)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

mytable

0

PRIMARY

1

id

A

100

(NULL)

(NULL)

 

BTREE

 

 

Back