Get the latest Laravel/PHP jobs, events and curated articles straight to your inbox, once a week
Source: medium.com
How to convert SQL from MS Access to be used in a web applicationCategory: PHP, MySQL
MS Access typically won’t be used in a real-world web application, but you can have it generate some of the SQL for you with it’s easy-to-use drag-and-drop interface. Even for non-web applications (using MS Access as the front-end) it’s not good for “big” databases.
You can use MS Access to generate some of the SQL for you, that you can then transform to be compatible with a different relational database.
Let’s assume we have two tables with these fields: Creating a query in MS Access to show the number of total hours played by user would look like this: You can view the SQL by changing the “View” at the top left to SQL View
If you create a Delete query in MS Access, it will provide SQL similar to this: Remove contents between DELETE and FROM (specifically, the “*”).
You can use MS Access to generate some of the SQL for you, that you can then transform to be compatible with a different relational database.
Let’s assume we have two tables with these fields: Creating a query in MS Access to show the number of total hours played by user would look like this: You can view the SQL by changing the “View” at the top left to SQL View
If you create a Delete query in MS Access, it will provide SQL similar to this: Remove contents between DELETE and FROM (specifically, the “*”).
Newsletter
ToastMail
Achieve superior email deliverability with ToastMail! Our AI-driven tool warms up inboxes, monitors reputation, and ensures emails reach their intended destination. Sign up today for a spam-free future.
Community Partners
Laravel/PHP Careers