Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: bos_adsbos_ads
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0003 sec)
SQL-query: 
SELECT *
FROM `bos_ads`
PROCEDURE ANALYSE ( )
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]


   Field  Type Collation Attributes Null Default Extra Action
   int(10)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   int(5)     No    Change Drop Primary Index Unique Fulltext
   int(5)     No    Change Drop Primary Index Unique Fulltext
   varchar(10) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(10) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(3)     No    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   text 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
   int(10)     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  0.00    Change Drop Primary Index Unique Fulltext
   tinyint(4)     No    Change Drop Primary Index Unique Fulltext
   int(4)     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
   int(11)     No    Change Drop Primary Index Unique Fulltext
   int(4)     No    Change Drop Primary Index Unique Fulltext
   int(3)     No    Change Drop Primary Index Unique Fulltext
   float(6,2)     No  0.00    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 ad_id
ad_id_2 UNIQUE Edit Drop ad_id
ad_status_2 UNIQUE Edit Drop ad_status
ad_user_id_2 UNIQUE Edit Drop ad_user_id
ad_category_2 UNIQUE Edit Drop ad_category
ad_date_begin_2 UNIQUE Edit Drop ad_date_begin
ad_date_end_2 UNIQUE Edit Drop ad_date_end
ad_type_2 UNIQUE Edit Drop ad_type
ad_title_2 UNIQUE Edit Drop ad_title
ad_image1_2 UNIQUE Edit Drop ad_image1
ad_image2_2 UNIQUE Edit Drop ad_image2
ad_image3_2 UNIQUE Edit Drop ad_image3
ad_image4_2 UNIQUE Edit Drop ad_image4
ad_image5_2 UNIQUE Edit Drop ad_image5
ad_options_2 UNIQUE Edit Drop ad_options
ad_optional_1_2 UNIQUE Edit Drop ad_optional_1
ad_optional_2_2 UNIQUE Edit Drop ad_optional_2
ad_optional_3_2 UNIQUE Edit Drop ad_optional_3
ad_optional_4_2 UNIQUE Edit Drop ad_optional_4
ad_optional_5_2 UNIQUE Edit Drop ad_optional_5
ad_type_optional1_2 UNIQUE Edit Drop ad_type_optional1
ad_type_optional2_2 UNIQUE Edit Drop ad_type_optional2
ad_type_optional3_2 UNIQUE Edit Drop ad_type_optional3
ad_type_optional4_2 UNIQUE Edit Drop ad_type_optional4
ad_id INDEX None  Edit Drop ad_id
ad_status INDEX None  Edit Drop ad_status
ad_user_id INDEX None  Edit Drop ad_user_id
ad_category INDEX None  Edit Drop ad_category
ad_date_begin INDEX None  Edit Drop ad_date_begin
ad_date_end INDEX None  Edit Drop ad_date_end
ad_type INDEX None  Edit Drop ad_type
ad_title INDEX None  Edit Drop ad_title
ad_image1 INDEX None  Edit Drop ad_image1
ad_image2 INDEX None  Edit Drop ad_image2
ad_image3 INDEX None  Edit Drop ad_image3
ad_image4 INDEX None  Edit Drop ad_image4
ad_image5 INDEX None  Edit Drop ad_image5
ad_options INDEX None  Edit Drop ad_options
ad_optional_1 INDEX None  Edit Drop ad_optional_1
ad_optional_2 INDEX None  Edit Drop ad_optional_2
ad_optional_3 INDEX None  Edit Drop ad_optional_3
ad_optional_4 INDEX None  Edit Drop ad_optional_4
ad_optional_5 INDEX None  Edit Drop ad_optional_5
ad_type_optional1 INDEX None  Edit Drop ad_type_optional1
ad_type_optional2 INDEX None  Edit Drop ad_type_optional2
ad_type_optional3 INDEX None  Edit Drop ad_type_optional3
ad_type_optional4 INDEX None  Edit Drop ad_type_optional4
ad_date_begin_3 FULLTEXT None  Edit Drop ad_date_begin
ad_date_end_3 FULLTEXT None  Edit Drop ad_date_end
ad_title_3 FULLTEXT None  Edit Drop ad_title
ad_description FULLTEXT None  Edit Drop ad_description
ad_image1_3 FULLTEXT None  Edit Drop ad_image1
ad_image2_3 FULLTEXT None  Edit Drop ad_image2
ad_image3_3 FULLTEXT None  Edit Drop ad_image3
ad_image4_3 FULLTEXT None  Edit Drop ad_image4
ad_image5_3 FULLTEXT None  Edit Drop ad_image5
ad_optional_1_3 FULLTEXT None  Edit Drop ad_optional_1
ad_optional_2_3 FULLTEXT None  Edit Drop ad_optional_2
ad_optional_3_3 FULLTEXT None  Edit Drop ad_optional_3
ad_optional_4_3 FULLTEXT None  Edit Drop ad_optional_4
ad_optional_5_3 FULLTEXT None  Edit Drop ad_optional_5
ad_type_optional1_3 FULLTEXT None  Edit Drop ad_type_optional1
ad_type_optional2_3 FULLTEXT None  Edit Drop ad_type_optional2
ad_type_optional3_3 FULLTEXT None  Edit Drop ad_type_optional3
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 264
Creation Oct 07, 2017 at 09:13 PM
Last update Apr 03, 2018 at 04:17 AM
Last check Apr 03, 2018 at 04:17 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: