Search In
Hi Readers,
Many developers use third party SDK for saving records into the Database, Firebase provides us this functionality. To add records into Firebase, please follow these steps:
First of all, you need to create a reference to Firebase databas
To display all the databases in MySQL you need to execute the following command:
SHOW DATABASES;
Database configuration in cakePHP: Cake PHP configuration file is found in app/Config/database.php
Example of database configuration file in app/Config/database.php.default.
class DATABASE_CONFIG {
public $default = array(
'datasource'
To make a copy of a table in MySQL you need to execute the following statement:
use databasename;
Create table new_table_name
select * from existing_table_name
where conditions
For example:
We have database demo having table1. We required to crea
find_in_set() is a function which returns the position of a string within second string.
We mostly found a situation where we want to fetch records on the basis of particular string and that string are stored in comma separated values in database
Hello All,
Many time, We want to know that, What are all the tables who have referenced a column as a "foreign key" which is a "Primary Key" of other table.
Example:-- In a database I have one Company table which stores company information with Co
When we show a profile image we get image path from database and show that image as a profile image. But if image not found or image path is not correct then we see a broken image. So we add a conditions there to show a defualt image. But if we use o
DECODE is a function in Oracle and is used to provide if-then-else type of logic to SQL. It is not available in MySQL or SQL Server.
It is only used for the MySql server and in the Oracle server for the case like manipulation tha
Context is the current state of any object/application that represents several environment data. Context assist the present activity to communicate with the outer environments like the databases, class loaders, files to the environment. It is the han
I am trying to get data from a database using 3 Jcomboboxes and then put the data in a Jtable and i am getting a empID=(int)employees[selectedIndex-1][1];
public void updateTable()
  {
     int selectedIndex=employeeCmb.getSelectedIndex
