Executing SQL Statements from a Text File The mysql client typically is used interactively, like this: shell> mysql db_name However, it is also possible to put your SQL statements in a file and then tell mysql to read its input from that file. To do so, create a text file text_file that contains the statements … Read more
MySQL : Dumping Data in SQL Format with mysqldump By default, mysqldump writes information as SQL statements to the standard output. You can save the output in a file: shell> mysqldump [arguments] > file_name To dump all databases, invoke mysqldump with the –all-databases option: shell> mysqldump –all-databases > dump.sql To dump only specific databases, name them on the command line … Read more
Friendship Day Messages A single candle can illuminate an entire room. A true friend lights up an entire lifetime. Thanks for the bright lights of ur friendship. A friend is sweet when it is new. And it is sweeter when it is true. But you know what? It is sweetest when it is u. A … Read more
Friendship Day Quotes “Your friend is the man who knows all about you, and still likes you.” -Elbert Hubard “True friendship is like sound health; the value of it is seldom known until it be lost.” -Charles Caleb Colton “Each friend represents a world in us, a world possibly not born until they arrive, and … Read more
FRIENDSHIP DAY5th August 2018, Sunday various countries like India, USA and others celebrate Friendship Day on the First Sunday of August each year. This wonderful occasion is slated to be on 5th August for 2018. Make the most of this day and have a gala time with your friends! Friendship Day Quotes and Messages Your friend is … Read more
Unable to connect to remote asterisk (does /var/run/asterisk/asterisk.ctl exist?) When first learning Asterisk some users will find they are unable to connect to the Asterisk service. You may see the below message after running some variation of asterisk -r Unable to connect to remote asterisk (does /var/run/asterisk/asterisk.ctl exist?) The asterisk.ctl file asterisk.ctl is a UNIX Domain … Read more
UGC NET Result 2018: CBSE @ Cbsenet.nic.in, Cbseresults.nic.in CBSE UGC NET July 2018 Result: Central Board of Secondary Education or CBSE is expected to release the UGC NET result 2018 this week. The Board has completed the process of raising objections to UGC NET answer keys released recently. It was earlier reported that the … Read more
Asterisk and Speech Recognition Before we dive into Asterisk, we need to select a speech engine. There are two main types of speech engines: Text-to-Speech (TTS) Automatic Speech Recognition (ASR). Generally speaking, your choices for TTS engines are more plentiful. There are more vendors in the TTS market and they cover more languages. ASR vendors and … Read more
Chess Game program in C language #include<stdio.h> #include<conio.h> #include<graphics.h> void blk(int,int); void display(); //enum bool{TRUE,FALSE}; /*void main() //MAIN FUNCTION { display(); getch(); } */ void display() //DISPLAY TO SHOW THE BOARD { int gd=DETECT,gm,i,j,l,m,b; char pattern[]={0xFF,0xFF,0xFF,0xFF,0xFF,0xFF,0xFF,0xFF}; int arrodd[32][2]={ {0,0},{100,0},{200,0},{300,0},{50,50},{150,50} ,{250,50},{350,50},{0,100},{100,100},{200,100},{300,100} ,{50,150},{150,150},{250,150},{350,150},{0,200},{100,200} ,{200,200},{300,200},{50,250},{150,250},{250,250},{350,250}, {0,300},{100,300},{200,300},{300,300},{50,350},{150,350}, {250,350},{350,350} }; int arrevn[33][2]={{50,0},{150,0},{250,0},{350,0},{0,50},{100,50},{200,50}, {300,50},{50,100},{150,100},{250,100},{350,100},{0,150}, {100,150},{200,150},{300,150},{50,200},{150,200},{250,200}, {350,200},{0,250},{100,250},{200,250},{300,250},{50,300}, {150,300},{250,300},{350,300},{0,350},{100,350},{200,350}, {300,350}}; clrscr(); initgraph(&gd,&gm,””); … Read more
RANGE Partitioning in MySQL What is Partitioning? Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables, but still get treated as a single table by the SQL layer. When partitioning, it’s a good idea to find a natural partition key. You want to ensure … Read more