SQL-QuickReference

Statement -> Syntax
AND / OR -> SELECT column_name(s) FROM table_name WHERE condition ANDOR condition
ALTER TABLE(add column) -> ALTER TABLE table_name ADD columnname datatype
ALTER TABLE(drop column) -> ALTER TABLE table_name DROP COLUMN column_name
AS(alias/colum) -> SELECT column_name AS column_alias FROM table_name
AS(alias/table) -> SELECT column_name FROM table_name AS table_alias
BETWEEN -> SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2
CREATE INDEX -> CREATE INDEX index_name ON table_name (column_name)
CREATE TABLE -> CREATE TABLE table_name ( column_name1 data_type, column_name2 data_type, .......)
CREATE UNIQUE INDEX -> CREATE UNIQUE INDEX index_name ON table_name (column_name)
CREATE VIEW -> CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition
DELETE FROM -> DELETE FROM table_name DELETE FROM table_name WHERE condition(Deletes entire table)
DROP DATABASE -> DROP DATABASE database_name
DROP INDEX -> DROP INDEX table_name.index_name
DROP TABLE -> DROP TABLE table_name
GROUP BY -> SELECT column_name1,SUM(column_name2) FROM table_name GROUP BY column_name1
HAVING -> SELECT column_name1,SUM(column_name2) FROM table_name GROUP BY column_name1 HAVING SUM(column_name2) condition value
IN -> SELECT column_name(s) FROM table_name WHERE column_name IN (value1,value2,..)
INSERT INTO -> INSERT INTO table_name VALUES (value1, value2, ....) INSERT INTO table_name (column_name1, column_name2,...) VALUES (value1, value2,....)
LIKE -> SELECT column_name(s) FROM table_name WHERE column_name LIKE pattern
ORDER BY -> SELECT column_name(s) FROM table_namex ORDER BY column_name [ASCDESC]
SELECT -> SELECT column_name(s) FROM table_name
SELECT * -> SELECT * FROM table_name
SELECT DISTINCT -> SELECT DISTINCT column_name(s) FROM table_name
SELECT INTO -> SELECT * INTO new_table_name FROM original_table_name (creates backup copies of tables) ORSELECT INTO -> SELECT column_name(s) INTO new_table_name FROM original_table_name
TRUNCATE TABLE -> TRUNCATE TABLE table_name (deletes only the data inside the table)
UPDATE -> UPDATE table_name SET column_name=new_value [, column_name=new_value] WHERE column_name=some_value
WHERE -> SELECT column_name(s) FROM table_name WHERE condition

Comments

Post a Comment

Popular posts from this blog

AWK - quick reference

AWK awk is an extremely versatile pattern matching and processing language. Although "awk scripts" can be written simply on the command line, more sophisticated use involves script files. Where the shell language is geared to running various utilities, the awk language is geared to extracting information from files according to rules and patterns. As a programming language (which looks much like C in some respects), awk has the usual selection, loop, and condition constructs, and has variables. Awk variables are not referenced with a leading $ as in the shell, except for the variables representing fields in the input line: $1, $2, ... . See below. As with the shell, comments come after the # character. To invoke an awk script is similar to the first method for shell scripts (an awk script cannot be made executable, however, an executable shell script with a here-document for awk could be used): awk -f script-file input-files If is missing, awk looks for input from stdin. Th
Read more

GDB - A quick reference

GDB - A quick reference gdb program-name gdb program-name core-file gdb program-name process-id - GDB gets attached to the running process with its id equal to given process-id; Note that the running process pauses. Now some variable value can be set and process can be detached. (gdb prompt) attach process-id - Attaches GDB to given process ID (gdb prompt) detach - detaches the process attached. gdb -q -q stands for quite; No copyright printed b(break) main - Put a breakpoint at the beginning of the program b(break) - Put a breakpoint at the next line ( current line makes no sense) b(break) N - Put a breakpoint at line N b(break) filename:N - Put a breakpoint at line N in file filename b(break) class::func - To put a break point in C++ function b(break) +N - Put a breakpoint N lines down from the current line b(break) -N - Put a breakpoint N lines up from the current line b(break) fn - Put a breakpoint at the beginning of function "fn" b(break) if (exprsn) - Any for
Read more

Linux Kernel Hacking!!

Linux Kernel Hacking!! In this first of a two-part series, learn about system and environment requirements, the best ways to acquire Linux™ source code, how to configure and boot your new kernel, and how to use the printk function to print messages during bootup. Before you start Learn what these tutorials can teach you, and what you need to run the examples in them. About this series The capability of being modified is perhaps one of Linux's greatest strengths, and anyone who has dabbled with the source code has at least stood at the gates of the kingdom, if not opened them up and walked inside. These two tutorials are intended to get you started. They are for anyone who knows a little bit of programming and who wants to contribute to the development of Linux, who feels that something is missing in the kernel and wants to fix that, or who just wants to find out how a real operating system works. About this tutorial This tutorial takes a basic approach to
Read more