Database test - table friendmail 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
	fromname	varchar(50)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	fromemail	varchar(55)		No			Change	Drop	Primary	Index	Unique	Fulltext
	toemail	varchar(75)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	toname	varchar(50)		No			Change	Drop	Primary	Index	Unique	Fulltext
	message	text		Yes	NULL		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	1	Drop	Edit	id

Create an index on columns

Space usage :

Type	Usage
Data	720	Bytes
Index	2,048	Bytes
Overhead	488	Bytes
Effective	2,280	Bytes
Total	2,768	Bytes
[Optimize table]

Row Statistic :

Statements	Value
Format	dynamic
Rows	1
Row length ø	232
Row size ø	2,768 Bytes
Next Autoindex	4

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

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

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