CodeCraft – Learn SQL

Xampp Installation

Learn how to install xampp.

CMD command

Start xampp server with cmd command.

Create database

Create database in xampp server.

Show databases

Show created databases.

Use database

Use created database.

Create table university

Create a new table in database.

Desc university

Show structure of the university table.

Create table student

Create another new table in database.

Desc student

Show structure of the student table.

Insert into university

Enter data into university table.

Insert into students

Enter data into student table.

Select all from university

Show data in all columns and rows from university table.

Select all from student

Shows all the columns and rows from the student table.

Select name from student

Displays only the name column from the student table.

Select name as "Undergraduates" from students

Displays the name column, but the output heading is renamed to Undergraduates.

Select indexno, name from students

Shows only the index number and name columns from the students table.

Select indexno, name as "Undergraduates" from students

Shows the index number and the name column, but names are displayed under the heading Undergraduates.

Select indexno, name as "Undergraduates" from students Order By indexno Desc

Displays index number and name (as Undergraduates) sorted by index number in descending order (largest to smallest).

Select indexno, name as "Undergraduates" from students Order By name Desc

Displays index number and name (as Undergraduates) sorted by name in descending alphabetical order (Z → A).

Select distinct name from students

Shows only unique names from the students table (removes duplicates). .

ALTER table university

Used to modify the structure of the university table (e.g., add, delete, or change columns). .

Desc university

Shows the structure (columns, types, keys) of the university table.

Select all from university

Displays all data from the university table.

Update university

Used to change/update data in the university table.

Select all from university

Displays all data from the university table.

Select payment from university where name like 'university of technology'

Shows the payment column for the university named “university of technology”.

Learn SQL Easily

Latest Tutorials

Xampp Installation

CMD command

Create database

Show databases

Use database

Create table university

Desc university

Create table student

Desc student

Insert into university

Insert into students

Select all from university

Select all from student

Select name from student

Select name as "Undergraduates" from students

Select indexno, name from students

Select indexno, name as "Undergraduates" from students

Select indexno, name as "Undergraduates" from students Order By indexno Desc

Select indexno, name as "Undergraduates" from students Order By name Desc

Select distinct name from students

ALTER table university

Desc university

Select all from university

Update university

Select all from university

Select payment from university where name like 'university of technology'

Select payment all 1000 as "Income" from university where name like 'university of technology'

Select count (IndexNo) from student where uniid like 'UOO1'

Learn SQL Easily

Latest Tutorials

Xampp Installation

CMD command

Create database

Show databases

Use database

Create table university

Desc university

Create table student

Desc student

Insert into university

Insert into students

Select all from university

Select all from student

Select name from student

Select name as "Undergraduates" from students

Select indexno, name from students

Select indexno, name as "Undergraduates" from students

Select indexno, name as "Undergraduates" from students Order By indexno Desc

Select indexno, name as "Undergraduates" from students Order By name Desc

Select distinct name from students

ALTER table university

Desc university

Select all from university

Update university

Select all from university

Select payment from university where name like 'university of technology'

Select payment all 1000 as "Income" from university where name like 'university of technology'

Select count (IndexNo) from student where uniid like 'UOO1'

Related Articles