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


   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    Change Drop Primary Index Unique Fulltext
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(200) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No  3600    Change Drop Primary Index Unique Fulltext
   tinyint(3)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   tinyint(4)     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
catid_3 UNIQUE Edit Drop catid
id_2 UNIQUE Edit Drop id
alias_2 UNIQUE Edit Drop alias
published_3 UNIQUE Edit Drop published
numarticles_2 UNIQUE Edit Drop numarticles
cache_time_2 UNIQUE Edit Drop cache_time
checked_out_2 UNIQUE Edit Drop checked_out
checked_out_time_2 UNIQUE Edit Drop checked_out_time
ordering_2 UNIQUE Edit Drop ordering
rtl_2 UNIQUE Edit Drop rtl
checked_out_3 UNIQUE Edit Drop checked_out
catid_5 UNIQUE Edit Drop catid
cache_time_4 UNIQUE Edit Drop cache_time
alias_4 UNIQUE Edit Drop alias
ordering_4 UNIQUE Edit Drop ordering
rtl_4 UNIQUE Edit Drop rtl
checked_out_time_3 UNIQUE Edit Drop checked_out_time
published_5 UNIQUE Edit Drop published
id_4 UNIQUE Edit Drop id
numarticles_4 UNIQUE Edit Drop numarticles
numarticles_6 UNIQUE Edit Drop numarticles
filename_2 UNIQUE None  Edit Drop filename
filename_4 UNIQUE None  Edit Drop filename
published INDEX None  Edit Drop published
catid INDEX None  Edit Drop catid
catid_2 INDEX None  Edit Drop catid
id INDEX None  Edit Drop id
alias INDEX None  Edit Drop alias
filename INDEX None  Edit Drop filename
published_2 INDEX None  Edit Drop published
numarticles INDEX None  Edit Drop numarticles
cache_time INDEX None  Edit Drop cache_time
checked_out INDEX None  Edit Drop checked_out
checked_out_time INDEX None  Edit Drop checked_out_time
ordering INDEX None  Edit Drop ordering
rtl INDEX None  Edit Drop rtl
ordering_3 INDEX None  Edit Drop ordering
cache_time_3 INDEX None  Edit Drop cache_time
rtl_3 INDEX None  Edit Drop rtl
catid_4 INDEX None  Edit Drop catid
published_4 INDEX None  Edit Drop published
id_3 INDEX None  Edit Drop id
numarticles_3 INDEX None  Edit Drop numarticles
alias_5 INDEX None  Edit Drop alias
filename_5 INDEX None  Edit Drop filename
checked_out_time_4 INDEX None  Edit Drop checked_out_time
checked_out_4 INDEX None  Edit Drop checked_out
filename_7 INDEX None  Edit Drop filename
alias_7 INDEX None  Edit Drop alias
ordering_5 INDEX None  Edit Drop ordering
numarticles_5 INDEX None  Edit Drop numarticles
id_5 INDEX None  Edit Drop id
catid_6 INDEX None  Edit Drop catid
checked_out_time_5 INDEX None  Edit Drop checked_out_time
name FULLTEXT None  Edit Drop name
alias_3 FULLTEXT None  Edit Drop alias
link FULLTEXT None  Edit Drop link
filename_3 FULLTEXT None  Edit Drop filename
link_2 FULLTEXT None  Edit Drop link
name_2 FULLTEXT None  Edit Drop name
alias_6 FULLTEXT None  Edit Drop alias
filename_6 FULLTEXT None  Edit Drop filename
name_3 FULLTEXT None  Edit Drop name
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 utf8_general_ci
Rows 0
Next Autoindex 1
Creation Oct 30, 2017 at 04:29 PM
Last update Apr 07, 2018 at 05:56 PM
Last check Apr 08, 2018 at 09:50 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: