Blog (1)
About Us
Contact Us
Make a Donation

Tutorials (104)
- Tutorials Submenu
  Total Tutorials: 104
  HTML Tutorials (40)
  
  CSS Tutorials (45)
  
  CSS Flexbox (12)
  
  JavaScript Tutorials (6)
  
  jQuery Tutorials (13)
  
  PHP Tutorials (0)
  
  SQL Tutorials (0)
  
  WordPress Tutorials (0)
Reference (1746)
- Reference Submenu
  Total Reference Pages: 1746
  HTML Reference (244)
  
  HTML Tags (107)
  
  HTML Attributes (46)
  
  HTML Events (76)
  
  HTML Resources (15)
  
  CSS Reference (309)
  
  CSS Selectors (55)
  
  CSS Properties (220)
  
  CSS Functions (17)
  
  CSS Resources (17)
  
  JavaScript Reference (555)
  
  JavaScript Selectors (7)
  
  JavaScript Operators (12)
  
  JavaScript Statements (17)
  
  JavaScript Methods (284)
  
  JavaScript Properties (162)
  
  JavaScript RegExp (45)
  
  JavaScript Resources (28)
  
  jQuery Reference (220)
  
  jQuery Selectors (54)
  
  jQuery Methods (140)
  
  jQuery Ajax Methods (16)
  
  jQuery Properties (17)
  
  jQuery Resources (9)
  
  PHP Reference (128)
  
  PHP Keywords (0)
  
  PHP Functions (127)
  
  PHP Constants (0)
  
  PHP Resources (1)
  
  SQL Reference (290)
  
  SQL Keywords (59)
  
  MySQL Functions (138)
  
  SQL Server Functions (83)
  
  SQL Resources (10)
  
  WordPress Reference (0)
Snippets (59)
- Snippets Submenu
  Total Code Snippets: 59
  HTML Snippets (3)
  
  CSS Snippets (11)
  
  JavaScript Snippets (5)
  
  jQuery Snippets (8)
  
  PHP Snippets (0)
  
  SQL Snippets (3)
  
  WordPress Snippets (29)

SQL Snippets

Blog (1)
About Us
Contact Us
Make a Donation

Tutorials (104)
- Tutorials Submenu
  Total Tutorials: 104
  HTML Tutorials (40)
  
  CSS Tutorials (45)
  
  CSS Flexbox (12)
  
  JavaScript Tutorials (6)
  
  jQuery Tutorials (13)
  
  PHP Tutorials (0)
  
  SQL Tutorials (0)
  
  WordPress Tutorials (0)
Reference (1746)
- Reference Submenu
  Total Reference Pages: 1746
  HTML Reference (244)
  
  HTML Tags (107)
  
  HTML Attributes (46)
  
  HTML Events (76)
  
  HTML Resources (15)
  
  CSS Reference (309)
  
  CSS Selectors (55)
  
  CSS Properties (220)
  
  CSS Functions (17)
  
  CSS Resources (17)
  
  JavaScript Reference (555)
  
  JavaScript Selectors (7)
  
  JavaScript Operators (12)
  
  JavaScript Statements (17)
  
  JavaScript Methods (284)
  
  JavaScript Properties (162)
  
  JavaScript RegExp (45)
  
  JavaScript Resources (28)
  
  jQuery Reference (220)
  
  jQuery Selectors (54)
  
  jQuery Methods (140)
  
  jQuery Ajax Methods (16)
  
  jQuery Properties (17)
  
  jQuery Resources (9)
  
  PHP Reference (128)
  
  PHP Keywords (0)
  
  PHP Functions (127)
  
  PHP Constants (0)
  
  PHP Resources (1)
  
  SQL Reference (290)
  
  SQL Keywords (59)
  
  MySQL Functions (138)
  
  SQL Server Functions (83)
  
  SQL Resources (10)
  
  WordPress Reference (0)
Snippets (59)
- Snippets Submenu
  Total Code Snippets: 59
  HTML Snippets (3)
  
  CSS Snippets (11)
  
  JavaScript Snippets (5)
  
  jQuery Snippets (8)
  
  PHP Snippets (0)
  
  SQL Snippets (3)
  
  WordPress Snippets (29)

SQL Snippets

Home
Snippets
SQL Snippets

or View All Tags

SQL – Select, Order, and Limit Specified Entries from a Table

June 14, 2023

A typical SELECT statement will include WHERE, ORDER BY, and LIMIT keywords to retrieve only the rows that apply.

SQL – Show all Databases on the Server

June 14, 2023

This shows all databases on the server, and is handy when looking for a specific database in the system or if you’re acclimating yourself to a new system.

SQL – Show all Tables in the Current Database

June 14, 2023

This will display a list of all the tables in the current database.

HTML

HTML Tutorials (40)
HTML Tags (107)
HTML Attributes (46)
HTML Events (76)
HTML Resources (15)
HTML Snippets (3)

HTML Tutorials (40)
HTML Tags (107)
HTML Attributes (46)
HTML Events (76)
HTML Resources (15)
HTML Snippets (3)

CSS

CSS Tutorials (45)
CSS Flexbox (12)
CSS Selectors (55)
CSS Properties (220)
CSS Functions (17)
CSS Resources (17)
CSS Snippets (11)

CSS Tutorials (45)
CSS Flexbox (12)
CSS Selectors (55)
CSS Properties (220)
CSS Functions (17)
CSS Resources (17)
CSS Snippets (11)

JavaScript

JS Tutorials (6)
JS Selectors (7)
JS Operators (12)
JS Statements (17)
JS Methods (284)
JS Properties (162)
JS RegExp (45)
HTML Events (76)
JS Resources (28)
JS Snippets (5)

JS Tutorials (6)
JS Selectors (7)
JS Operators (12)
JS Statements (17)
JS Methods (284)
JS Properties (162)
JS RegExp (45)
HTML Events (76)
JS Resources (28)
JS Snippets (5)

jQuery

jQuery Tutorials (13)
jQuery Selectors (54)
jQuery Methods (140)
jQuery Ajax Methods (16)
jQuery Properties (17)
jQuery Resources (9)
jQuery Snippets (8)

jQuery Tutorials (13)
jQuery Selectors (54)
jQuery Methods (140)
jQuery Ajax Methods (16)
jQuery Properties (17)
jQuery Resources (9)
jQuery Snippets (8)

PHP

PHP Tutorials (0)
PHP Keywords (0)
PHP Functions (127)
PHP Constants (0)
PHP Resources (1)
PHP Snippets (0)

PHP Tutorials (0)
PHP Keywords (0)
PHP Functions (127)
PHP Constants (0)
PHP Resources (1)
PHP Snippets (0)

SQL

SQL Tutorials (0)
SQL Keywords (59)
MySQL Functions (138)
SQL Server Functions (83)
SQL Resources (10)
SQL Snippets (3)

SQL Tutorials (0)
SQL Keywords (59)
MySQL Functions (138)
SQL Server Functions (83)
SQL Resources (10)
SQL Snippets (3)

WordPress

WP Snippets (29)

WP Snippets (29)

HTML

HTML Tutorials (40)
HTML Tags (107)
HTML Attributes (46)
HTML Events (76)
HTML Resources (15)
HTML Snippets (3)

HTML Tutorials (40)
HTML Tags (107)
HTML Attributes (46)
HTML Events (76)
HTML Resources (15)
HTML Snippets (3)

CSS

CSS Tutorials (45)
CSS Flexbox (12)
CSS Selectors (55)
CSS Properties (220)
CSS Functions (17)
CSS Resources (17)
CSS Snippets (11)

CSS Tutorials (45)
CSS Flexbox (12)
CSS Selectors (55)
CSS Properties (220)
CSS Functions (17)
CSS Resources (17)
CSS Snippets (11)

JavaScript

JS Tutorials (6)
JS Selectors (7)
JS Operators (12)
JS Statements (17)
JS Methods (284)
JS Properties (162)
JS RegExp (45)
HTML Events (76)
JS Resources (28)
JS Snippets (5)

JS Tutorials (6)
JS Selectors (7)
JS Operators (12)
JS Statements (17)
JS Methods (284)
JS Properties (162)
JS RegExp (45)
HTML Events (76)
JS Resources (28)
JS Snippets (5)

jQuery

jQuery Tutorials (13)
jQuery Selectors (54)
jQuery Methods (140)
jQuery Ajax Methods (16)
jQuery Properties (17)
jQuery Resources (9)
jQuery Snippets (8)

jQuery Tutorials (13)
jQuery Selectors (54)
jQuery Methods (140)
jQuery Ajax Methods (16)
jQuery Properties (17)
jQuery Resources (9)
jQuery Snippets (8)

PHP

PHP Tutorials (0)
PHP Keywords (0)
PHP Functions (127)
PHP Constants (0)
PHP Resources (1)
PHP Snippets (0)

PHP Tutorials (0)
PHP Keywords (0)
PHP Functions (127)
PHP Constants (0)
PHP Resources (1)
PHP Snippets (0)

SQL

SQL Tutorials (0)
SQL Keywords (59)
MySQL Functions (138)
SQL Server Functions (83)
SQL Resources (10)
SQL Snippets (3)

SQL Tutorials (0)
SQL Keywords (59)
MySQL Functions (138)
SQL Server Functions (83)
SQL Resources (10)
SQL Snippets (3)

WordPress

WP Snippets (29)

WP Snippets (29)

Why 1SMARTchicken?

This site was built and is maintained to benefit my autistic son.
See More →

My Son's Name is Johnny

He was diagnosed as autistic quite late, at age four...

His story

Buy Me a Coffee

Thanks for your support!

Books

All are affiliate links. Thank you for your support!

HTML and CSS: Design and Build Websites
Get Coding!: Learn HTML, CSS & JavaScript & Build a Website, App & Game
HTML and CSS QuickStart Guide

1SMARTchicken

333 Washington Blvd.
Suite 126
Marina del Rey, CA 90292
United States

About Us
Contact Us
Privacy Policy
Cookie Policy
Terms & Conditions

About Us
Contact Us
Privacy Policy
Cookie Policy
Terms & Conditions

1SMARTchicken

333 Washington Blvd.
Suite 126
Marina del Rey, CA 90292
United States

About Us
Contact Us
Privacy Policy
Cookie Policy
Terms & Conditions

About Us
Contact Us
Privacy Policy
Cookie Policy
Terms & Conditions

1SMARTchicken

333 Washington Blvd.
Suite 126
Marina del Rey, CA 90292
United States

Blog (1)
About Us
Contact Us
Affiliates
Merchandise
Donations
Privacy Policy
Cookie Policy
Terms & Conditions

Blog (1)
About Us
Contact Us
Affiliates
Merchandise
Donations
Privacy Policy
Cookie Policy
Terms & Conditions

Blog (1)

Blog (1)

HTML Tutorials (40)
CSS Tutorials (45)
JavaScript Tutorials (6)
jQuery Tutorials (13)
PHP Tutorials (0)
SQL Tutorials (0)
WordPress Tutorials (0)

HTML Tutorials (40)
CSS Tutorials (45)
JavaScript Tutorials (6)
jQuery Tutorials (13)
PHP Tutorials (0)
SQL Tutorials (0)
WordPress Tutorials (0)

HTML Reference (244)
CSS Reference (309)
JavaScript Reference (555)
jQuery Reference (220)
PHP Reference (128)
SQL Reference (290)
WordPress Reference (0)

HTML Reference (244)
CSS Reference (309)
JavaScript Reference (555)
jQuery Reference (220)
PHP Reference (128)
SQL Reference (290)
WordPress Reference (0)

HTML Snippets (3)
CSS Snippets (11)
JavaScript Snippets (5)
jQuery Snippets (8)
PHP Snippets (0)
SQL Snippets (3)
WordPress Snippets (29)

HTML Snippets (3)
CSS Snippets (11)
JavaScript Snippets (5)
jQuery Snippets (8)
PHP Snippets (0)
SQL Snippets (3)
WordPress Snippets (29)

SQL Snippets

SQL Snippets

SQL Snippets

SQL Snippets

SQL Snippets

SQL Snippets

SQL Snippets

SQL Snippets

SQL – Select, Order, and Limit Specified Entries from a Table

SQL – Show all Databases on the Server

SQL – Show all Tables in the Current Database

Why 1SMARTchicken?

My Son's Name is Johnny

Books

1SMARTchicken

Newsletter

1SMARTchicken

Newsletter

1SMARTchicken

Newsletter