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
   

MYSQL ARTICLES

- Xeround Releases Free Version of MySQL Cloud...
- Oracle Announces New MySQL Specialization
- Constant Contact Chooses SkySQL for MySQL Su...
- Revoke Statement in MySQL
- The Grant Statement in MySQL
- SuccessBricks Announces ClearDB Availability...
- Building a PHP ORM: Deploying a Blog
- TROSYS Launches Free MySQL Manager and Admin...
- Building an ORM in PHP: Domain Modeling
- Building an ORM in PHP
- MySQL Leads Open Source Market, Gets Cluster...
- Oracle Announces Milestone Release for MySQL
- How to Stop SQL Injection Attacks
- New Defragmentation Solution for SQL Server
- Comparison of MyISAM and InnoDB MySQL Databa...


© 2003-2012 by Developer Shed. All rights reserved. DS Cluster 6 - Follow our Sitemap

Dev Shed Tutorial Topics: