Search In
take in Rails:Rails has so many methods that provide the facility to fetching the records from database, so that you don't need to write raw sql. One of them is take.
By using take we can fetch a record (or N number of records if specified as a param
CTE
CTE stands for Common Table expressions. It was introduced with SQL Server 2005. It is a temporary result set and typically it may be a result of complex sub-query.CTE improves readability and ease in maintenance of complex queries and sub-que
Hello Readers! this is a small blog on Mysql injection, hope you like it.
Mysql Injection:
MySQL injection is a code injection technique, used to attack data-driven applications, in which harmful SQL statements are inserted into an entry fi
MySQL Stored Procedure
Stored Procedure
1)Stored Procedure are a set of declarative SQL statements which when created are compiled and stored in database.The main reason for their creation is that they are reusable. Stored procedure work different
Step 1: Create a Database
First create a database named ‘email_exists’ you can change if you want, and create a table named ‘users’ and fields.
CREATE TABLE `users` (
`first_name` varchar(50) NOT NULL,
`last_name` varchar(50) NOT N
We can connect our C# application to data in a SQL Server database by using following ways:
1. First Method
Firstly, we need a connection string to connect to database.This connection string contain the information about the server to which we are
A view is a virtual table which is stored in database with an associated name .Using views query we can select specific data from a large table . Suppose there is large database of any college , so i want to view the records of any one branch from th
Transaction is very useful in large rich applications such as eCommerce, Real Estate etc etc. It is mostly used in Customer Relationship Management (CRM), Enterprise Resource Plan (ERP).
What is Transaction?
When we need to execute more than one que
Hello Readers.! Here is a small blog on how to upload multiple images in database using cakephp.File uploading, nowadays is a very basic and common functionality. Here in this blog we will be uploading an image which will be stored on the ser
Hellow Readers ,
Today in my blog I am going to explain about Quick searching in MySQL using FULL-TEXT INDEXING. Many times we made a big mistake during searching from MySQL, we use the wildcard and like operator "LIKE %helpful website%" w
