Search In
Triggers in SQL of a table can be find by writing a SQL query and passing table name as its parameter for the query
We will just pass the table name for that and it will provide all the triggers made for that table.
Ex: select so.name, text
fro
We can insert data from one table to another in MySQL. For this we use the INSERT INTO SELECT statement that selects the data from on table and inserts that data into another table.
INSERT INTO SELECT Syntax
We can select and insert all the columns
At the time of development of a module or functionality we always curious that the code we wrote will work perfectly or not until and unless we run that in a browser. so rails provide us a way where we can test the functions via a console. By running
how to implement thumbnail for image in rails.
step 1:-
go to uploader inside views where you have written image uploader code for uploading image. uncomment this section
#Create different versions of your uploaded files:
version :thumb
This error generally comes when we want to delete child table row. To solve this problem we have to disable the
foreign key checks.
SET FOREIGN_KEY_CHECKS=0;
Now you can fire your query.
DELETE FROM TABLE WHERE ID = 'Somthing';
You can enable forei
Hi All,
Some times we need to know the all running/sleeping process in database. We can use the below code:--
SELECT 'These processes are using database' AS Note
,[Database]=DB_NAME(dbid), spid, last_batch,
status, hostname, loginame
FROM sys.syspr
Sometime we need to create zip of the folder which contains several subfolders, but all folders are not necessary to include in zip. For such cases we will run following command -
zip -r archiveName.zip folderName -x folderName/subfolder/**\*
Wh
The function that returns a value based on a condition is MYSQL IF function. Hence MYSQL IF function is one of the control flow functions.
The syntax of the MySQL IF function is as follows:
IF(expr,if_true_expr,if_false_expr)
For example, If we h
How To Load a Image Form a url
You can use this class in your application to load image . It can be use by calling its
DisplayImage(String url, int loader, ImageView imageView) function.This function there are three parameters
first is String para
Do you want to start your Affiliate Business?
Every year hundreds of newbies start affiliate marketing business to earn passive income.
It’s far easy to make money by selling others products through blogs and/or website promot
