University:
American Baptist College
Course:
CSCI 1534 | Data Analysis and Visualization
Academic year:

2023
Views:

431

Pages:

1
Author:

Muthia M.

Trouble Shooting Misspelling Commands Misspelling commands in SQL can lead to errors in your queries and potentially produce unexpected results. SQL is a programming language used for managing and manipulating relational databases, and it requires precise syntax and keywords to function correctly. Examples : 1. Misspelled: SELCT * FROM customers; 2. Misspelled: UPDAET products SET price = 20.99 WHERE product_id = 5; 3. Misspelled: INERST INTO orders (order_id, customer_id, total_amount) VALUES (1, 101, 50.00); 4. Misspelled: CRETE TABLE suppliers (supplier_id INT, supplier_name VARCHAR(50)); 5. Misspelled: DROUP TABLE orders; Forgetting Brackets and Quotes Forgetting brackets and quotes in SQL commands can lead to syntax errors or unexpected behavior. Examples : 1. Missed Quotes: INSERT INTO customers (customer_id, customer_name, email) VALUES (1, John Doe, john@example.com); 2. Missing Brackets and Quotes: UPDATE orders SET order_status = 'Shipped WHERE order_id = 101; 3. Missing Brackets and Quotes with Multiple Conditions: SELECT * FROM employees WHERE department = 'HR AND salary > 50000; 4. Missing Quotes in WHERE Clause with Text Data: SELECT * FROM products WHERE product_name = SELECT product_name, price FROM products WHERE category IN (SELECT category_name FROM categories WHERE active = true;