Arduino Programming Cheat Sheet

HTML Cheat Sheet

GitHub Cheat Sheet

Python Cheat Sheet

MySQL Cheat Sheet

SQL JOINS Cheat Sheet

GIT Cheat Sheet

Java Programming Cheat Sheets

1 of  28

2 of  28

3 of 28

4 of 28

5 of 28

6 of 28

7 of 28

8 of 28

9 of 28

10 of 28

11 of 28

12 of 28

13 of 28

14 of 28

15 of 28

16 of 28

17 of 28

18 of 28

19 of 28

20 of 28

21 of 28

22 of 28

23 of 28

24 of 28

25 of 28

26 of 28

27 of 28

28 of 28

Common SQL commands and syntax

Select Statement

SELECT 'column_name' FROM 'table_name'

Distinct

SELECT DISTINCT 'column_name' 

FROM 'table_name'

Where

SELECT 'column_name' 

FROM 'table_name'

WHERE 'condition'

In

SELECT 'column_name'

FROM 'table_name'

WHERE 'condition'

Between

SELECT 'column_name'

FROM 'table_name'

WHERE 'column_name' BETWEEN 'value1'

AND 'value2'

Like

SELECT 'column_name'

FROM 'table_name'

WHERE 'column_name' LIKE {PATTERN}

Order By

SELECT 'column_name'

FROM 'table_name'

[WHERE 'condition']

ORDER BY 'column_name' [ASC, DESC]

Count

SELECT COUNT ('column_name')

FROM '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 (arithmetic function condition)

Create Table Statement

CREATE TABLE 'table_name'

('column1' 'data_type_for_column_1',

'column2' 'data_type_for_column_2', ...)

Drop Table Statement

DROP TABLE 'table_name'

Truncate Table Statement

TRUNCATE TABLE 'table_name'

Insert Into Statement

INSERT INTO 'table_name' ('column1', 

'column2', ...)

VALUES('value1', 'value2', ...)

Insert Into Select Statement

INSERT INTO 'table1' ('column1','column2',...)

SELECT 'column3', 'column4', ...

FROM 'table2'

Update Statement

UPDATE 'table_name'

SET 'column1' = [new value]

WHERE {condition}

Delete From Statement

DELETE FROM 'table_name'

WHERE {condition}

Special Characters

Alt + 0153..... ™... trademark symbol
Alt + 0169.... ©.... copyright symbol
Alt + 0174..... ®....registeredtrademark symbol
Alt + 0176 ...°......degre­e symbol
Alt + 0177 ...±....plus-or­-minus sign
Alt + 0182 ...¶.....paragraph mark
Alt + 0190 ...¾....fractio­n, three-fourths
Alt + 0215 ....×.....multi­plication sign
Alt + 0162...¢....thecent sign
Alt + 0161.....¡......upside down exclamation point
Alt + 0191.....¿.....­upside down question mark
Alt + 1...........smiley face
Alt + 2 ......☻.....bla­ck smiley face
Alt + 15.....☼.....su­n
Alt + 12......♀.....female sign
Alt + 11.....♂......m­ale sign
Alt + 6............s­pade
Alt + 5.............­Club
Alt + 3............. ­Heart
Alt + 4.............­Diamond
Alt + 13......♪.....e­ighth note
Alt + 14......♫......­beamed eighth note
Alt + 8721.... ∑.... N-ary summation (auto sum)
Alt + 251.....√.....s­quare root check mark
Alt + 8236.....∞.....­infinity
Alt + 24.......↑.....­up arrow
Alt + 25......↓......­down arrow
Alt + 26.....→.....ri­ght arrow
Alt + 27......←.....l­eft arrow
Alt + 18.....↕......u­p/down arrow
Alt + 29......↔... left right arrow

How to fix Starting emulator for AVD 'androidname' PANIC: Could not open: androidname on MAC OSX

On MAC OSX you may encounter this error when you programming in android using Android SDK on Eclipse Kepler. This happens when you logged in to your root account and by trying to run a specific android avd and nothing happens.

Starting emulator for AVD 'androidname'
PANIC: Could not open: androidname

C++ Code Snippets

Dear students, last year while I'm studying C++, there are lots of snippets I've working on. And I'd like to share it with you only for educational purposes. You may download my C++ sample projects from the links below. Enjoy!

Odd and Even Numbers

void main(){
   int num = 0;
   cout << "Please input any number:";
   cin >> num;
   
   if(num/2 * 2!=num){
      cout<< endl <<endl;
      cout<< "You entered an Odd Number" <<endl <<endl;
   }else{
      cout<< endl <<endl;
      cout<< "You entered an Even Number" <<endl <<endl;
   }

   if(num<0){
      cout << "You entered a Negative Number" <<endl <<endl;
   }else{
      cout << "You entered a Positive Number" <<endl <<endl;
   }

   if(num%3==0){
      cout << "The number is divisible by 3" <<endl <<endl;
   }else if(num%4==0){
      cout << "The number is divisible by 4" <<endl <<endl;
   }else if(num%5==0){
      cout << "The number is divisible by 5" <<endl <<endl;
   }
}

Meralco Bill

Discount

Ordering

How many 100 are there in your given

Other snippets:

Leap Year

Gas Station

Fixed floating point

Assembly Language - Projects

Display Ascii Heart Image

Download Code Here

Assembly Language - Hello World

Assembly Language... This is a low level programming language which has a direct interaction with the processor. It aims to make you executable files, .com applications, and libraries. It is use to program a robot. You must know how to convert binaries(10101) to decimal(0123456789),