Search In
As developers of any technology which uses MySQL as backend we always need to know some basic queries to work on. The list may vary as per the development need but a basic set still remains the same.
The very first query that comes into use is to
Hello Readers!
This blog is about how to use SQLite in Flex.
Before proceeding a brief introduction to SQLite.
SQLite is a relational database management system contained in a small C programming library,it is an embedded SQL database engine and a
Some Useful PostgreSQL Command in below example->
Backup database-
pg_dump -U geekstuff erp -f mydb.sql
Restore database-
psql -U erp -d erp_devel -f mydb.sql
Change owner of database-
ALTER DATABASE erp_v1 OWNER TO openerp;
Describing table
If you want to get the outstanding residual value in invoice currency in Odoo then follow the following code in your .py file.
# -*- coding: utf-8 -*-
import json
from lxml import etree
from datetime import datetime
from dateutil.relativedelta imp
SQL SELECT DATE
if you want to retrieve a date from database,use this staement. For eg. you want to find a particular date from a database, this statement is the answer.
1)For example: let's see the query to get all the records after '2013-12-12'
Whenever you create a new user in MySQL it wiil stored in the User table of mysql database. There are two ways to create users:
Create user statement:
CREATE USER username@hostname
IDENTIFIED BY 'password'
For example:
CREATE USER root@localh
What is addslashes() function ?
The addslashes() function basically used to returns a string with backslashes before characters that need to be quoted in database queries.
Mostly it is used for predefined characters, addslashes() function is very u
Hello Reader's! If you have stored the image in database as blob. Then you need a php code to retrieve them and a html page to show them. Lets see an example below how to show them
First create a php page getImage.php and code as written below:-
&l
The reason of computed fields is been used is because it defines a filed whose value is computed rather then simply being read from the database.
Below are the attributes that are specific to computed fields. To define such a field, simply provide a
Hello
This section will detail out some insight on how to set up the database system for PIM.
PIM Database Pre-Installation Checklist
During database installation:
Create a new schema
Create a user with full read/write access to
