Database test - table agents 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
	agent	varchar(30)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	agentpass	varchar(10)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	agenturl	varchar(70)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	agentemail	varchar(70)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	notes	text		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	agentphone	varchar(30)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	agentcell	varchar(30)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	agentfax	varchar(30)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
With selected: Or

Indexes : [Documentation]

Keyname	Type	Cardinality	Action		Field
PRIMARY	PRIMARY	2	Drop	Edit	id

Create an index on columns

Space usage :

Type	Usage
Data	132	Bytes
Index	2,048	Bytes
Total	2,180	Bytes

Row Statistic :

Statements	Value
Format	dynamic
Rows	2
Row length ø	66
Row size ø	1,090 Bytes
Next Autoindex	3

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

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

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