1 / 4

MySQL Query Writing Guide for CSE Students

Access, practice, and submit MySQL queries with step-by-step instructions for CSE class projects. Ensure your queries work smoothly.

zack
Download Presentation

MySQL Query Writing Guide for CSE Students

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. “Source” the file • Download tables.sql from the class website • Upload it into your cse account • “source” the file at the command line • mysql -h student-db -u [EUID] -p [EUID] < tables.sql • Example: mysql-h student-db -u jwp0101 -p jwp0101 < tables.sql • Your password is your EUID unless you change it • If you have having password problems, contact Matt Kernanmkernan@unt.edu

  2. Querying at the Command Line • Log in to your mysql account • mysql -h student-db -u [EUID] –p • Use your database • use [EUID]; • Practice writing queries • When you are satisfied with the query, copy it into file [lastname]_[firstname]_MySQL.sql

  3. [lastname]_[firstname]_MySQL.sql • Use comments for the English version • Number the queries • Place your SQL query underneath: -- 1. Find the table names of all existing tables created by you show tables; -- 2. Find the schema of the borrower table etc... • Save the file regularly

  4. Submitting the file • Source the file to ensure your queries work • Submit the file using the project command: project submit 4350s001 banking [filename]

More Related