Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: networkgirlsnetworkgirls

   Field  Type Collation Attributes Null Default Extra Action
   int(10)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) 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 107  Edit Drop id
id UNIQUE 107  Edit Drop id
id_3 UNIQUE 107  Edit Drop id
id_4 UNIQUE 107  Edit Drop id
id_7 UNIQUE 107  Edit Drop id
id_9 UNIQUE 107  Edit Drop id
id_2 INDEX None  Edit Drop id
fname INDEX None  Edit Drop fname
lname INDEX None  Edit Drop lname
address INDEX None  Edit Drop address
city INDEX None  Edit Drop city
state INDEX None  Edit Drop state
zip INDEX None  Edit Drop zip
phone INDEX None  Edit Drop phone
bilingual INDEX None  Edit Drop bilingual
pic INDEX None  Edit Drop pic
fname_3 INDEX None  Edit Drop fname
pic_3 INDEX None  Edit Drop pic
state_4 INDEX None  Edit Drop state
lname_4 INDEX None  Edit Drop lname
id_5 INDEX None  Edit Drop id
address_3 INDEX None  Edit Drop address
phone_4 INDEX None  Edit Drop phone
city_4 INDEX None  Edit Drop city
bilingual_3 INDEX None  Edit Drop bilingual
zip_3 INDEX None  Edit Drop zip
pic_5 INDEX None  Edit Drop pic
phone_5 INDEX None  Edit Drop phone
state_5 INDEX None  Edit Drop state
address_6 INDEX None  Edit Drop address
zip_5 INDEX None  Edit Drop zip
fname_6 INDEX None  Edit Drop fname
lname_6 INDEX None  Edit Drop lname
id_6 INDEX None  Edit Drop id
bilingual_5 INDEX None  Edit Drop bilingual
city_6 INDEX None  Edit Drop city
id_8 INDEX None  Edit Drop id
fname_2 FULLTEXT None  Edit Drop fname
lname_2 FULLTEXT None  Edit Drop lname
address_2 FULLTEXT None  Edit Drop address
city_2 FULLTEXT None  Edit Drop city
state_2 FULLTEXT None  Edit Drop state
zip_2 FULLTEXT None  Edit Drop zip
phone_2 FULLTEXT None  Edit Drop phone
bilingual_2 FULLTEXT None  Edit Drop bilingual
pic_2 FULLTEXT None  Edit Drop pic
state_3 FULLTEXT None  Edit Drop state
lname_3 FULLTEXT None  Edit Drop lname
city_3 FULLTEXT None  Edit Drop city
phone_3 FULLTEXT None  Edit Drop phone
address_4 FULLTEXT None  Edit Drop address
fname_4 FULLTEXT None  Edit Drop fname
zip_4 FULLTEXT None  Edit Drop zip
pic_4 FULLTEXT None  Edit Drop pic
bilingual_4 FULLTEXT None  Edit Drop bilingual
address_5 FULLTEXT None  Edit Drop address
city_5 FULLTEXT None  Edit Drop city
state_6 FULLTEXT None  Edit Drop state
fname_5 FULLTEXT None  Edit Drop fname
lname_5 FULLTEXT None  Edit Drop lname
zip_6 FULLTEXT None  Edit Drop zip
phone_6 FULLTEXT None  Edit Drop phone
pic_6 FULLTEXT None  Edit Drop pic
bilingual_6 FULLTEXT None  Edit Drop bilingual
Create an index on  columns  
 
Space usage: 
Type Usage
Data 8,552 Bytes
Index 3,072 Bytes
Total 11,624 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 107
Row length ø 79
Row size  ø 109 Bytes
Next Autoindex 108
Creation Dec 11, 2017 at 10:35 AM
Last update Apr 03, 2018 at 06:08 PM
Last check Apr 03, 2018 at 06:08 PM

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: