I am Learning SQL(mysql) in 2025.
#learning#sql#sqlserver#database
Tahir Rafique

Tahir Rafique @tahir_rafique

About: I write for myself

Joined:
Feb 20, 2025

I am Learning SQL(mysql) in 2025.

Publish Date: Apr 24
4 2
  1. Database & DBMS
  2. Type of DB, SQL & non-sql / (RDBMS vs NRDBMS)
  3. SQL
  4. Tables, Columns(schema), Rows(individual data)
  5. MY First Query

SQL is not Case-Senstive
semi-colon important at every line-end

CREATE DATABASE college;
DROPE DATABASE college;

create table students(
// column_name datatype constraint
id int primary key,
name varchar(50),
age int not null,
);
Enter fullscreen mode Exit fullscreen mode

Comments 2 total

  • david duymelinck
    david duymelinckApr 25, 2025

    I want to point out some errors:

    • the sqlserver tag is short for Microsoft sql server.
    • DROPE DATABASE college; should be DROP (probably a typo)

    An improvement I would make is age int DEFAULT 0. All languages are using more typing for variables, so it is better to return a default result that matches the type. Null is seen as a lazy solution nowadays.

  • Nevo David
    Nevo DavidApr 25, 2025

    yeah learning sql can get kinda messy with all the weird details, tbh sometimes i still forget little syntax stuff - you ever catch yourself mixing up commands or does it all just click after some practice

Add comment