Database test - table tbl_files running on localhost

Structure

Browse

SQL

Select

Insert

Export

Operations

Options

Empty

Drop

	Field	Type	Attributes	Null	Default	Extra	Action
	id_files	int(11)		No		auto_increment	Change	Drop	Primary	Index	Unique	Fulltext
	description	tinytext		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	filename	varchar(50)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	thumbname	varchar(50)		No			Change	Drop	Primary	Index	Unique	Fulltext
	prop_num	int(11)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
	owner	int(11)		Yes	NULL		Change	Drop	Primary	Index	Unique	Fulltext
With selected: Or

Indexes : [Documentation]

Keyname	Type	Cardinality	Action		Field
PRIMARY	PRIMARY	5	Drop	Edit	id_files

Create an index on columns

Space usage :

Type	Usage
Data	520	Bytes
Index	2,048	Bytes
Overhead	116	Bytes
Effective	2,452	Bytes
Total	2,568	Bytes
[Optimize table]

Row Statistic :

Statements	Value
Format	dynamic
Rows	5
Row length ø	80
Row size ø	514 Bytes
Next Autoindex	18

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

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

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