Information worth remembering

User Tools

Site Tools


sql:sql_basics

SQL Basics

Basic commands:

  • CREATE dataBaseName ←- this will create the database with name dataBaseName
  • USE dataBaseName ←- this will ensure all following SQL commnands are applied to dataBaseName
  • SELECT * FROM tableName WHERE cond ←– this will list all records of tableName where cond is the filter
sql/sql_basics.txt · Last modified: 2017/10/04 08:00 by admin