Wednesday 13 August 2014

Make symbols with the help of Keyboard

Trademark SymbolAlt+0153
Copyright SymbolAlt+0169©
Registered Trademark SymbolAlt+0174®
Degree SymbolAlt+0176°
Plus or Minus SignAlt+0177±
Paragraph Mark SymbolAlt+0182
Fraction three-fourthsAlt+0190¾
Multiplication SignAlt+0215×
The Cent SignAlt+0162¢
Upside Down Exclamation PointAlt+0161¡
Upside Down Question markAlt+0191¿
Smily faceAlt+1
Black Smily faceAlt+2
SunAlt+15
Female SymbolAlt+12
Male SymbolAlt+11
SpadeAlt+6
ClubAlt+5
HeartAlt+3
DiamondAlt+4
Eighth NoteAlt+13
Beamed Eighth NoteAlt+14
Squareroot Check markAlt+251
Up ArrowAlt+24
Down ArrowAlt+25
Right ArrowAlt+26
Left ArrowAlt+27
Up/Down ArrowAlt+18
Left/Right ArrowAlt+29

Tuesday 12 August 2014

Datatable jQuery Plugin set order example

$(document).ready(function() {
    $('#example').dataTable( {
        "order": [[ 3, "desc" ]]
    } );
} );
Plugin files:
//code.jquery.com/jquery-1.11.1.min.js
//cdn.datatables.net/1.10.2/js/jquery.dataTables.min.js

Mysql get two column value in get single field

Table : user
--------------
| Id | Name  |
--------------
|  1 | Test  |
|  2 | Test1 |
|  3 | TEst2 |
|  4 | Test3 |
|  5 | Test4 |
|  6 | Test5 |
|  7 | Test6 |
--------------
Query :

selecr concat(id,":",name) as output from user

Output:
------------
| output   |
------------
|  1:Test  |
|  2:Test1 |
|  3:TEst2 |
|  4:Test3 |
|  5:Test4 |
|  6:Test5 |
|  7:Test6 |
------------