Search In
UserEntities objUserEntities= new UserEntities();/*Create object of user entity
/* Add records into the database */
public void AddUser(User objUser)
{
objUserEntities.AddToUsers(objUser); /*Linq has its own function to insert th
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
