This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

MySql

MySql Interview Questions and Answers – Part 1

By | August 10th, 2013|Database, Interview Questions, MySql|

What's MySQL ? MySQL (pronounced "my ess cue el") is an open source relational database management system (RDBMS) that uses Structured Query Language (SQL), the most popular language for adding, accessing, and processing data in a database. Because it is open source, anyone can download MySQL and tailor it to their needs in accordance with [...]

MySQL – Interview Questions And Answers

By | May 26th, 2013|Database, MySql|

How do you start and stop MySQL on Windows? - net start MySQL, net stop MySQL How do you start MySQL on Linux? - /etc/init.d/mysql start Explain the difference between mysql and mysqli interfaces in PHP? - mysqli is the object-oriented version of mysql library functions. What’s the default port for MySQL Server? - 3306 [...]

What is the equivalent of Oracle's explain plan command in MySQL ?

By | August 26th, 2012|Database, DBA Issues, DBA Miscellaneous, MySql, Oracle DBA|

The Explain Plan command in Oracle generates information that details the execution plan that will be used on a particular query. It uses a pre-existing table (PLAN_TABLE) in the current schema to store information about the execution plan chosen by the optimizer. The plan table is populated using the explain plan command: [crayon-58da505bf12e3725576033/] [crayon-58da505bf12f9117001667/] [crayon-58da505bf1304648483647/] The only [...]

MySql Interview Questions & Answers – Part 2

By | May 29th, 2011|Database, MySql|

11). How to setup admin user for MYSQL ? Login as super user 'root' in mysql and execute the following commands. mysql> use mysql; mysql> create user 'test'@'%' identified by 'test'; mysql> grant all on *.* to 'test'@'%' with grant option; mysql> flush privileges; 12). What types of privileges are there in MySQL ? There [...]

MySql Interview Questions & Answers – Part 1

By | May 27th, 2011|Database, MySql|

1). What is the minimum hardware requirement for MySQL to be installed ? The following are the minimum hardware requirement for MySQL installation. Minimum Disk Space 80GB Minimum RAM 4G Server with Multiple CPU processor 2). How do I login in MySQL Database ? From Mysql DB server: mysql -u <username> <database> -p<password> Ex : [...]

MySql Tools & Utilities

By | May 12th, 2011|Database, MySql|

Following is the list of some tools which support MySql Tools to Monitor Queries and Transactions 1). mytop: tool for monitoring queries. It is a Perl program that runs in a terminal and displays information about all connections in a tabular layout, similar to the Unix top program's process display. Columns include the connection ID, [...]