Share

MySQL: SQL Syntax Rules

  • If you want to run multiple queries at a time then command for selecting city and id from customers-
    SELECT city FROM customers;
    SELECT id FROM customers;
  • You run the any query by giving line breaks and white spaces, it wont affect the command/result-
    SHOW COLUMNS
    FROM customers



Notice:
  1. Whenever you run multiple queries each query must end with a semicolon, for one query semicolon is optional.
  2. SQL is not case sensitive. 
  3. White spaces and line brakes are ignored.
  4. Here city and id are columns, and customer is table.
                                       

0 comments:

Post a Comment