Home arrow MySQL arrow Page 4 - Transferring Data to MySQL Using SQLyog

Importing only selected rows or importing the resultset of a query - MySQL

Need any easy way to import data from your ODBC-compliant database into MySQL? Look no further than SQLyog's ODBC Import tool. Read all about it inside.

TABLE OF CONTENTS:
  1. Transferring Data to MySQL Using SQLyog
  2. What is SQLyog?
  3. Getting Started
  4. Importing only selected rows or importing the resultset of a query
  5. Conclusion
By: Insanely Great
Rating: starstarstarstarstar / 8
March 06, 2003

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

 

Choosing the option Use a query to specify the data totransfer in Figure D loads up the following dialog (Figure I)

Figure I

 

The next dialog box (Figure J) allows you to run therocess immediately or save the data as SQL scripts for later execution.

Figure J

 

The final dialog box (Figure K) displays the resultof the Import Process.

Figure K

 

If any error occurred while importing data then SQLyog will display youthe errorneous query and the error message (Figure L). For your convenience, iteven logs them in sqlyog.err. After checking out the error, you can eithercontinue with the Import Process or you can stop there.



 
 
>>> More MySQL Articles          >>> More By Insanely Great
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

MYSQL ARTICLES

- Oracle Unveils MySQL 5.6
- MySQL Vulnerabilities Threaten Databases
- MySQL Cloud Options Expand with Google Cloud...
- MySQL 5.6 Prepped to Handle Demanding Web Use
- ScaleBase Service Virtualizes MySQL Databases
- Oracle Unveils MySQL Conversion Tools
- Akiban Opens Database Software for MySQL Use...
- Oracle Fixes MySQL Bug
- MySQL Databases Vulnerable to Password Hack
- MySQL: Overview of the ALTER TABLE Statement
- MySQL: How to Use the GRANT Statement
- MySQL: Creating, Listing, and Removing Datab...
- MySQL: Create, Show, and Describe Database T...
- MySQL Data and Table Types
- McAfee Releases Audit Plugin for MySQL Users

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: