Skip to main content
Ctrl+K
PggPy - Home
  • dev-ops
  • mcq
  • python
  • Machine Learning
  • Backend Framework
    • UI framework
    • pl/SQL
    • Database
    • interview
    • Mix post
  • GitHub
  • LinkedIn
  • Facebook
  • pyc
  • dev-ops
  • mcq
  • python
  • Machine Learning
  • Backend Framework
  • UI framework
  • pl/SQL
  • Database
  • interview
  • Mix post
  • GitHub
  • LinkedIn
  • Facebook
  • pyc

Section Navigation

Database

  • postgreSQL
    • PostgreSQL USE on Linux Terminal
    • pgcron doc
  • mySQL
    • mySQL cheat-sheet 😸
  • NoSQL
    • For Elasticsearch, some Kibana useful commands are:
  • Database
  • mySQL

mySQL#

mySQL Library Doc in Bangla

  • mySQL cheat-sheet 😸
    • Login
    • USER
      • Show Users
      • Create User
      • Delete User
      • Exit
    • Grant
      • Grant All Priveleges On All Databases
      • Show Grants
      • Remove Grants
    • DataBase
      • Show Databases
      • Create Database
      • Delete Database
      • Select Database
    • Table
      • Create Table
      • Delete / Drop Table
      • Show Tables
    • Row
      • Insert Row / Record
      • Insert Multiple Rows
      • Select
      • Where Clause
      • Delete Row
      • Update Row
    • Column
      • Add New Column
      • Modify Column
      • Order By (Sort)
      • Concatenate Columns
    • Operations
      • Select Distinct Rows
      • Between (Select Range)
      • Like (Searching)
      • Not Like
      • IN
    • Index
      • Create & Remove Index
      • New Table With Foreign Key (Posts)
      • Add Data to Posts Table
    • Join
      • INNER JOIN
      • New Table With 2 Foriegn Keys
      • Add Data to Comments Table
      • Left Join
      • Join Multiple Tables
      • Aggregate Functions
      • Group By

previous

pgcron doc

next

mySQL cheat-sheet 😸

© Copyright 2024, Rakib Hasan.