Search In
If we have added wrong collation name of the database and its columns the we can get some problem with other languages and special character.
All other languages and characters will appear as ?????
So we can alter collation of database and table even
Hello Readers !
We can simply upload upload CSV data into database by two simple ways.
Step 1 – Data Base Connection
<?php
$db = mysq_connect("Database", "username", "password") or die("Could not connect.");
if(!$db)
die("no db");
if(!m
Storing and reading record from database using Sqlite Helper class.
We have taken Name, Age and City as input from user and saving them on click of Save button and reading on click of Fetch Data button from database.
MainActivity.java
public clas
Deleting record from database using Sqlite Helper class.
We have taken Name, Age and City as input from user and saving them on click of Save button and deleting on click of Delete button from database.
MainActivity.java
public class MainActivity
Storing record in database using Sqlite Helper class.
We have taken Name, Age and City as input from user and saving them on click of Save button in database.
MainActivity.java
public class MainActivity extends Activity {
CreateDatabase db;
If you want to make Database Association on Selected Pages In Cakephp follow the below steps,
Below code can set association where it require and you can also reduce unnecessary queries firing to database.
Make function in your model and set your
In PHP, To perform any data task in MySQL database , first we have to connect MySql database to local server
This can be done as :
<?php
$servername = "localhost";
$username = "username";
$password = "password";
// Create connection
$conn = new
Hello my friends, I try to use realm
But by adding this line of code
npm install --save realm
This error was
I even tried to add it manually, but again, what's the problem?
Do you know databases like realm that I can repl
Sometimes we need to change default Character set of Schema. We can do this easily by using ALTER command.
Command:
ALTER SCHEMA database-name DEFAULT CHARACTER SET utf8 ;
Example:
ALTER SCHEMA `jeeyoh` DEFAULT CHARACTER SET utf8 ;
by running
Selectivity
Selectivity is used for the definition of the number of unique values in the table.
It shows how many unique values are there in the table.
Selectivity=Cardinality/number of record *100%
If the selectivity is high than only the databa
