Database
test
- table
signup
running on
localhost
Structure
Browse
SQL
Select
Insert
Export
Operations
Options
Empty
Drop
Field
Type
Attributes
Null
Default
Extra
Action
id
int(11)
No
0
Change
Drop
Primary
Index
Unique
Fulltext
username
varchar(20)
Yes
NULL
Change
Drop
Primary
Index
Unique
Fulltext
password
varchar(20)
Yes
NULL
Change
Drop
Primary
Index
Unique
Fulltext
mailadres
varchar(100)
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
]
No index defined!
Create an index on
columns
Space usage :
Type
Usage
Data
124
Bytes
Index
1,024
Bytes
Total
1,148
Bytes
Row Statistic :
Statements
Value
Format
dynamic
Rows
2
Row length ø
62
Row size ø
574 Bytes
Print view
Add new field :
At End of Table
At Beginning of Table
After id
After username
After password
After mailadres
After actnum
After userlevel
After signupdate
After lastlogin
After lastloginfail
After numloginfail
Propose table structure
[
Documentation
]
Run SQL query/queries on database test [
Documentation
] Fields:
id
username
password
mailadres
actnum
userlevel
signupdate
lastlogin
lastloginfail
numloginfail
SELECT * FROM `signup` WHERE 1
Show this query here again
Or
Location of the textfile :
Insert data from a textfile into table