Database
test
- table
vehicles
running on
localhost
Structure
Browse
SQL
Select
Insert
Export
Operations
Options
Empty
Drop
Field
Type
Attributes
Null
Default
Extra
Action
id
int(11)
No
auto_increment
Change
Drop
Primary
Index
Unique
Fulltext
title
varchar(250)
Yes
NULL
Change
Drop
Primary
Index
Unique
Fulltext
city
varchar(50)
Yes
NULL
Change
Drop
Primary
Index
Unique
Fulltext
state
varchar(20)
Yes
NULL
Change
Drop
Primary
Index
Unique
Fulltext
zip
varchar(20)
Yes
NULL
Change
Drop
Primary
Index
Unique
Fulltext
price
int(11)
Yes
NULL
Change
Drop
Primary
Index
Unique
Fulltext
fulldesc
text
No
Change
Drop
Primary
Index
Unique
Fulltext
type
varchar(20)
Yes
NULL
Change
Drop
Primary
Index
Unique
Fulltext
featured
char(1)
Yes
NULL
Change
Drop
Primary
Index
Unique
Fulltext
photo
char(1)
Yes
NULL
Change
Drop
Primary
Index
Unique
Fulltext
bold
char(1)
Yes
NULL
Change
Drop
Primary
Index
Unique
Fulltext
dateposted
date
Yes
NULL
Change
Drop
Primary
Index
Unique
Fulltext
agent
varchar(30)
Yes
NULL
Change
Drop
Primary
Index
Unique
Fulltext
notes
mediumtext
No
Change
Drop
Primary
Index
Unique
Fulltext
owner
int(11)
No
0
Change
Drop
Primary
Index
Unique
Fulltext
model
varchar(30)
No
Change
Drop
Primary
Index
Unique
Fulltext
make
varchar(30)
No
Change
Drop
Primary
Index
Unique
Fulltext
year
year(4)
No
0000
Change
Drop
Primary
Index
Unique
Fulltext
drivetrain
varchar(30)
No
Change
Drop
Primary
Index
Unique
Fulltext
transmission
varchar(30)
No
Change
Drop
Primary
Index
Unique
Fulltext
body
varchar(30)
No
Change
Drop
Primary
Index
Unique
Fulltext
doors
int(11)
No
0
Change
Drop
Primary
Index
Unique
Fulltext
features
text
No
Change
Drop
Primary
Index
Unique
Fulltext
stereo
varchar(30)
No
Change
Drop
Primary
Index
Unique
Fulltext
color
varchar(30)
No
Change
Drop
Primary
Index
Unique
Fulltext
miles
int(11)
No
0
Change
Drop
Primary
Index
Unique
Fulltext
opt1
char(1)
No
N
Change
Drop
Primary
Index
Unique
Fulltext
opt2
char(1)
No
N
Change
Drop
Primary
Index
Unique
Fulltext
opt3
char(1)
No
N
Change
Drop
Primary
Index
Unique
Fulltext
opt4
char(1)
No
N
Change
Drop
Primary
Index
Unique
Fulltext
opt5
char(1)
No
N
Change
Drop
Primary
Index
Unique
Fulltext
opt6
char(1)
No
N
Change
Drop
Primary
Index
Unique
Fulltext
opt7
char(1)
No
N
Change
Drop
Primary
Index
Unique
Fulltext
opt8
char(1)
No
N
Change
Drop
Primary
Index
Unique
Fulltext
opt9
char(1)
No
N
Change
Drop
Primary
Index
Unique
Fulltext
opt10
char(1)
No
N
Change
Drop
Primary
Index
Unique
Fulltext
hitcount
int(5)
No
0
Change
Drop
Primary
Index
Unique
Fulltext
With selected:
Or
Structure
Browse
SQL
Select
Insert
Export
Operations
Options
Empty
Drop
Indexes : [
Documentation
]
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
8
Drop
Edit
id
Create an index on
columns
Space usage :
Type
Usage
Data
1,508
Bytes
Index
2,048
Bytes
Total
3,556
Bytes
Row Statistic :
Statements
Value
Format
dynamic
Rows
8
Row length ø
188
Row size ø
444 Bytes
Next Autoindex
11
Print view
Add new field :
At End of Table
At Beginning of Table
After id
After title
After city
After state
After zip
After price
After fulldesc
After type
After featured
After photo
After bold
After dateposted
After agent
After notes
After owner
After model
After make
After year
After drivetrain
After transmission
After body
After doors
After features
After stereo
After color
After miles
After opt1
After opt2
After opt3
After opt4
After opt5
After opt6
After opt7
After opt8
After opt9
After opt10
After hitcount
Propose table structure
[
Documentation
]
Run SQL query/queries on database test [
Documentation
] Fields:
id
title
city
state
zip
price
fulldesc
type
featured
photo
bold
dateposted
agent
notes
owner
model
make
year
drivetrain
transmission
body
doors
features
stereo
color
miles
opt1
opt2
opt3
opt4
opt5
opt6
opt7
opt8
opt9
opt10
hitcount
SELECT * FROM `vehicles` WHERE 1
Show this query here again
Or
Location of the textfile :
Insert data from a textfile into table