How to Convert an Access Query to MySQL
SQL stands for Structured Query Language. This is a standardized language that is designed to work with any database application that understands SQL. For this reason, SQL statements that are created in one application should work in nearly any other application without any modifications. Microsoft Access can be used to create queries using their query-by-example (QBE) and then the resulting SQL language can be viewed and copied to any other location, including a web page accessing a mySql database.
Other People Are Reading
Instructions
-
-
1
Start Microsoft Access and open the database containing the query that is to be converted to mySql.
-
2
Open the selected query in Design View using the "Design View" button or right-click on the query and select "Design View."
-
-
3
Select "View" from the menu and select "SQL View."
-
4
Press and hold the "Ctrl" button on the keyboard and press "C" to copy the selected SQL statement to the Windows clipboard.
-
5
Open the mySql web page (or mySql query application), press and hold the "Ctrl" key on the keyboard and press the "V" key to place the Access query into the mySql application.
-
1
