Database test - table agent 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
	username	varchar(20)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	password	varchar(150)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	mailadres	varchar(100)		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
	actnum	varchar(20)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	userlevel	tinyint(4)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	signupdate	varchar(16)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	lastlogin	varchar(16)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	lastloginfail	bigint(20)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	numloginfail	tinyint(4)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
With selected: Or

Indexes : [Documentation]

Keyname	Type	Cardinality	Action		Field
PRIMARY	PRIMARY	5	Drop	Edit	id

Create an index on columns

Space usage :

Type	Usage
Data	712	Bytes
Index	2,048	Bytes
Total	2,760	Bytes

Row Statistic :

Statements	Value
Format	dynamic
Rows	5
Row length ø	142
Row size ø	552 Bytes
Next Autoindex	7

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

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

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