Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: bosdevUUSbosdevUUS
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0004 sec)
SQL-query: 
SELECT *
FROM `bosdevUUS`
ORDER BY `bd5` ASC
LIMIT 0 , 30
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]


   Field  Type Collation Attributes Null Default Extra Action
   int(5)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   date     No  0000-00-00    Change Drop Primary Index Unique Fulltext
   tinyint(2)     No    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(2)     No    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(2)     No    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(2)     No    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(2)     No    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
With selected: Check All  /  Uncheck All     With selected:  

Print viewPrint view    Propose table structurePropose table structureDocumentation
Add new fieldAdd new field: 


Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY Edit Drop id
id_2 UNIQUE Edit Drop id
username_2 UNIQUE Edit Drop username
email_2 UNIQUE Edit Drop email
bf3_2 UNIQUE Edit Drop bf3
id INDEX None  Edit Drop id
username INDEX None  Edit Drop username
password INDEX None  Edit Drop password
email INDEX None  Edit Drop email
status INDEX None  Edit Drop status
last_login INDEX None  Edit Drop last_login
bd1 INDEX None  Edit Drop bd1
bd2 INDEX None  Edit Drop bd2
bd3 INDEX None  Edit Drop bd3
bd4 INDEX None  Edit Drop bd4
bd5 INDEX None  Edit Drop bd5
bc1 INDEX None  Edit Drop bc1
bc2 INDEX None  Edit Drop bc2
bc3 INDEX None  Edit Drop bc3
bc4 INDEX None  Edit Drop bc4
bc5 INDEX None  Edit Drop bc5
bdir1 INDEX None  Edit Drop bdir1
bdir2 INDEX None  Edit Drop bdir2
bdir3 INDEX None  Edit Drop bdir3
bdir4 INDEX None  Edit Drop bdir4
bdir5 INDEX None  Edit Drop bdir5
bm1 INDEX None  Edit Drop bm1
bm2 INDEX None  Edit Drop bm2
bm3 INDEX None  Edit Drop bm3
bm4 INDEX None  Edit Drop bm4
bm5 INDEX None  Edit Drop bm5
bn1 INDEX None  Edit Drop bn1
bn2 INDEX None  Edit Drop bn2
bn3 INDEX None  Edit Drop bn3
bn4 INDEX None  Edit Drop bn4
bn5 INDEX None  Edit Drop bn5
bf1 INDEX None  Edit Drop bf1
bf2 INDEX None  Edit Drop bf2
bf3 INDEX None  Edit Drop bf3
username_3 FULLTEXT None  Edit Drop username
password_2 FULLTEXT None  Edit Drop password
email_3 FULLTEXT None  Edit Drop email
bd2_2 FULLTEXT None  Edit Drop bd2
bd3_2 FULLTEXT None  Edit Drop bd3
bd4_2 FULLTEXT None  Edit Drop bd4
bd5_2 FULLTEXT None  Edit Drop bd5
bc2_2 FULLTEXT None  Edit Drop bc2
bc3_2 FULLTEXT None  Edit Drop bc3
bc4_2 FULLTEXT None  Edit Drop bc4
bc5_2 FULLTEXT None  Edit Drop bc5
bdir2_2 FULLTEXT None  Edit Drop bdir2
bdir3_2 FULLTEXT None  Edit Drop bdir3
bdir4_2 FULLTEXT None  Edit Drop bdir4
bdir5_2 FULLTEXT None  Edit Drop bdir5
bm2_2 FULLTEXT None  Edit Drop bm2
bm3_2 FULLTEXT None  Edit Drop bm3
bm4_2 FULLTEXT None  Edit Drop bm4
bm5_2 FULLTEXT None  Edit Drop bm5
bn2_2 FULLTEXT None  Edit Drop bn2
bn3_2 FULLTEXT None  Edit Drop bn3
bn4_2 FULLTEXT None  Edit Drop bn4
bn5_2 FULLTEXT None  Edit Drop bn5
bf1_2 FULLTEXT None  Edit Drop bf1
bf2_2 FULLTEXT None  Edit Drop bf2
Create an index on  columns  
 
Space usage: 
Type Usage
Data 0 Bytes
Index 4,096 Bytes
Total 4,096 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 0
Next Autoindex 1
Creation Dec 20, 2020 at 04:18 AM
Last update Mar 28, 2024 at 04:16 AM
Last check Mar 29, 2024 at 01:40 AM

Run SQL query/queries on database puropartyDocumentation     Fields: 
Or Location of the textfile: 
 Location of the textfile: 
   (Max: 2,048KB)
  Compression:
                
Character set of the file: