SQL Statement |
Syntax |
AND / OR
|
SELECT column_name(s)FROM table_nameWHERE conditionAND|OR condition
|
ALTER TABLE |
ALTER TABLE table_nameADD column_name datatype
or
ALTER TABLE table_name
DROP COLUMN column_name |
AS (alias) |
SELECT column_name AS column_aliasFROM table_nameorSELECT column_nameFROM table_name AS table_alias |
BETWEEN |
SELECT column_name(s)FROM table_nameWHERE column_nameBETWEEN value1 AND value2 |
CREATE DATABASE |
CREATE DATABASE database_name |
CREATE TABLE |
CREATE TABLE table_name(column_name1 data_type,column_name2 data_type,column_name2 data_type,…
)
Read the rest of this entry » |
Like this:
Like Loading...
Tags: Agile, Ask_the_tester.Automation.Awards.Best_Practices.Black, auto mechanic, automation tools, begin, black box test, Box, Career, Cartoon, Case, Certification, Check browser compatibility, Check spelling, climate, Cloud, commu, communication, communications problem., communications skills, Conference, Crews, Development, dicuss of the day, Documents of software testing, Editorial, End_to_End_Error_Handling, enterprise-it, gaming, graphical user interface, graphical user interface gui, intimation, istqb, istqb help, it-security, launch, loop space, missing page titles, query, reference, scm software, select, software, software configuration management, software testing, software-development, software-testing softwar, software-testing software-development, SQL, SQL Quick Reference, technology, testing, testing methodology, todays-topic topics, topics of the day, unused memory