Database test - table contact 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
	name	varchar(30)		No			Change	Drop	Primary	Index	Unique	Fulltext
	phone_no	varchar(15)		No			Change	Drop	Primary	Index	Unique	Fulltext
	email	varchar(50)		No			Change	Drop	Primary	Index	Unique	Fulltext
	comments	text		No			Change	Drop	Primary	Index	Unique	Fulltext
	bikeid	int(11)		No	0		Change	Drop	Primary	Index	Unique	Fulltext
	year	year(4)		No	0000		Change	Drop	Primary	Index	Unique	Fulltext
	make	varchar(30)		No			Change	Drop	Primary	Index	Unique	Fulltext
	model	varchar(30)		No			Change	Drop	Primary	Index	Unique	Fulltext
	dateposted	date		No	0000-00-00		Change	Drop	Primary	Index	Unique	Fulltext
With selected: Or

Indexes : [Documentation]

Keyname	Type	Cardinality	Action		Field
PRIMARY	PRIMARY	0	Drop	Edit	id

Create an index on columns

Space usage :

Type	Usage
Data	0	Bytes
Index	1,024	Bytes
Total	1,024	Bytes

Row Statistic :

Statements	Value
Format	dynamic
Rows	0
Next Autoindex	1

Print view
Add new field :
Propose table structure [Documentation]
Run SQL query/queries on database test [Documentation] Fields:

SELECT * FROM `contact` WHERE 1
Show this query here again

Or Location of the textfile :
Insert data from a textfile into table