Database
dumartinc
- Table
dsf_account_info
running on
dumartcom.fatcowmysql.com
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0030 sec)
SQL-query : [
Edit
] [
Explain SQL
] [
Create PHP Code
]
SELECT
*
FROM
`dsf_account_info`
LIMIT
0
,
30
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Field
Type
Charset
Attributes
Null
Default
Extra
Action
id
int(11)
Yes
NULL
auto_increment
dsf_username
varchar(32)
Yes
NULL
dsf_password
varchar(32)
Yes
NULL
company_name_en
varchar(128)
Yes
NULL
company_name_cn
varchar(128)
Yes
NULL
company_id
varchar(11)
Yes
NULL
company_code
varchar(32)
Yes
NULL
customer_service_code
varchar(32)
Yes
NULL
customer_service_id
int(11)
Yes
NULL
customer_service_name
varchar(32)
Yes
NULL
maintainer_code
varchar(32)
Yes
NULL
maintainer_id
int(11)
Yes
NULL
maintainer_name
varchar(32)
Yes
NULL
dsf_wsdl_url
varchar(256)
Yes
NULL
calculate_wsdl_url
varchar(256)
Yes
NULL
packet_codes
varchar(256)
Yes
NULL
status
int(11)
Yes
NULL
created
timestamp
Yes
NULL
modified
timestamp
Yes
NULL
Check All
/
Uncheck All
With selected:
Indexes : [
Documentation
]
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
0
id
Create an index on
columns
Space usage :
Type
Usage
Data
0
Bytes
Index
1,024
Bytes
Total
1,024
Bytes
Row Statistic :
Statements
Value
Format
dynamic
Charset
Rows
0
Next Autoindex
1
Creation
May 08, 2013 at 05:13 AM
Last update
May 08, 2013 at 05:13 AM
Print view
Add new field :
At End of Table
At Beginning of Table
After id
After dsf_username
After dsf_password
After company_name_en
After company_name_cn
After company_id
After company_code
After customer_service_code
After customer_service_id
After customer_service_name
After maintainer_code
After maintainer_id
After maintainer_name
After dsf_wsdl_url
After calculate_wsdl_url
After packet_codes
After status
After created
After modified
Propose table structure
[
Documentation
]
Run SQL query/queries on database dumartinc [
Documentation
]
SELECT * FROM `dsf_account_info` WHERE 1
Fields:
id
dsf_username
dsf_password
company_name_en
company_name_cn
company_id
company_code
customer_service_code
customer_service_id
customer_service_name
maintainer_code
maintainer_id
maintainer_name
dsf_wsdl_url
calculate_wsdl_url
packet_codes
status
created
modified
Show this query here again
Or
Location of the textfile :
Compression:
Autodetect
None
"gzipped"
"bzipped"
Insert data from a textfile into table