Search In
I am facing issue with my android app.
If a user installs my app through apk file. After installation a window appears with two buttons open and done which is part of android os.
When user taps on open, it opens my launcher activity. Whi
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
In MySQL, aliases are used to give temporarily name to a table or a column. When we write a query we use Aliases to make column name more readable.
Alias Syntax for Columns
SELECT column_name AS alias_name
FROM table_name;
Alias Syntax for Tables
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
There might be some scenario in your code, where some of the tasks should be performed in the background without affecting the current task. Some time we have scenario, where we needed to fire the function, which consists of some function call, where
This article demonstrate how we can export records from MySQL Table to a CSV file. fputcsv() is a buit in function of PHP which takes an array and a file pointer as parameters which convert the array data into CSV format and writes it to the file.
CREATING VIEWS:
Views are virtual tables which are created from other tables .It is beneficial for those situation when we want to show limited columns to users. It can be created from one or more tables.
Syntax:
CREATE VIEW viewname AS SELECT col
What is CSRF in rails?
CSRF means Cross-Site Request Forgery. It is an attack where an attacker will submit a form on our behalf to a different website , causing damage to the website or revealing the sensitive information from the website
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
In this article we will see how to pass an array of parameters to a stored procedure using xml. For illustration purpose we will be passing the
below list of id's :
<ids>
<id>1</id>
<id>2</id>
<id>3&l
