Featured
-
How Regression Testing Detects Integral Errors In Business Processes
Humans are forever changing and evolving and so to
by kristina.rigina -
Get Display Banner Advertising Opportunity on FindNerd Platform
“Do you have a product or service that nee
by manoj.rawat -
Android O Released with Top 7 New Features for App Developers
Android was founded by Andy Rubin, Rich Miner, Nic
by sudhanshu.tripathi -
Top 5 Features That Make Laravel the Best PHP Framework for Development
Laravel is a free open source Web Framework of PHP
by abhishek.tiwari.458 -
Objective C or Swift - Which Technology to Learn for iOS Development?
Swift programming language is completely based on
by siddharth.sindhi
Tags
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...
