Search In
These statement consist of queries that retrieve data from tables in database and statements that change the data in the database
Statement under this category are:
SELECT
INSERT
UPDATE
DELETE
LOCK TABLE etc.
Insert command
It is used to add
Hello Readers!
Here is a simple line of code to generate an excel file of data fetched from database. Users benefits with the compact and secure form of saving data.
Firstly create a helper file in view/Helper folder and paste the following
In this tutorial we will see how we can use pluck and select in rails active record queries.
Select is used to fetch records with specific attributes. It returns ActiveRecord::Relation object.
Project.select(:id)
Project Load (41.5m
Hi readers,
If you want to write your MySQL table data to excel sheet. Then by using Apache's POI libraries and MySQL connector you can actually do this. Have a look on the below simple example. It May give you an idea how to proceed.
In t
If you are heading up your own business, you will have a need for IT services, and unless you happen to be a web designer, or similar, you will have little choice but to outsource this section of the business. There are many specialist companies that
Cloud computing is helping startups equalize the playing field with larger corporations, because they have the same resources available. Cloud computing also gives startups the ability to have flexible storage to scale up or down depending on their n
Opening files
fopen() function is used to open the file. It require two arguement first the name and the other the mode.
the different mode are
r- open for read only
r+- open file for read and writing
w- open file for writing
w+- open file for
Ruby on Rails Interactor
Before interactor we use to write complex business logic in some class in the ActiveRecord /models directory and that class can have too many responsibilities so while testing we could stuck between tediously slow test-suit
Validating an empty field on submit through JavaScript
As we know in almost all the web applications we have forms which contain text boxes and text fields to input some data and submit it. Sometimes knowingly or unknowingly users can submit the for
What exactly are the environment variables? Environment variables are a set of key value pairs on which our project configuration depend and which might change according to the environment in which code it running i.e development/production/stagging
