Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

Working with triggers in mySql Database

A trigger is SQL code which runs just before or just after an INSERT, UPDATE or DELETE event occurs on a particular database table. Creating a Trigger: Consider we have two tables: CREATE TABLE `blog` ( `id` mediumint(8) unsigned...

How to set default value of column with datatype varchar to empty string

We usually face this kind of issue when we are doing programing with respect to a column with varchar data-type. If we don't add any value to a particular column it takes it as NULL. Thus forcing the developer to check for NULL every-time other t...

Using Putty and SSH Tunnel to connect to MySQL on remote server from SQLYog

To connect to a remote MYSQL server using SQLYog you can create SSH tunnel using putty following the steps. Connect to the remote server using putty. . Right Click on putty window and select the change settings option. ...

Set up remote access to MySQL database on Ubuntu

Without database any application is almost redundant. So this post might help you to setup access to MySQL database on Ubuntu. Firstly you need to open up the MySQL server config file present at /etc/mysql/my.conf and search for the lin...

Find MYSQL server version information

To find the version information of MYSQL server from command line log into MYSQL server using command mysql -h hostname -uusername -p You would be prompted for the password for the user on the server type the same and press Enter key. ...

How to Work with a Stored Procedure

How to Work with a Stored Procedure DELIMITER // CREATE PROCEDURE `p2` () LANGUAGE SQL DETERMINISTIC SQL SECURITY DEFINER COMMENT 'A procedure' BEGIN SELECT 'Hello World !'; END// The four characteristics of a procedure are:...

Importing a MYSQL database dump from command line

While importing databases dump that are of large sizes in GB you may find issues with PHPmyadmin and some other clients also. To import the database you can use the command. mysql -uusername -p databasename < sqldump.sql where userna...

Known bug of Temporary Table in MYSQL

Known Bug We cannot use temporary table twice in same query. http://dev.mysql.com/doc/refman/5.0/en/temporary-table-problems.html However if you have not required above condition then Temporary table is best to use rather than creating rea...

Delete duplicate row in table

You can delete the duplicate row without using the temporary table. You can use the self join concept. Suppose we have person table contain 3 columns named id, name, and city. INSERT INTO person(id,name,city) VALUES (1,'a', 'aa'), (2,'b','b...

Use of Find in set() function in mysql

In some cases, we use find_in_set() instead of in() in mysql. Following is an example, where we should use find_in_set() instead of in() :- Suppose we have a table 'flashdata':- fid productId 1 75,73 2 72...
1 3 next
Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: