Search In
Avg ( ) function is used to return the average of numeric column . If in a table there is null value then it ignored that value .
Syntax :
select avg ( column_name ) from table_name where clause ; // where clause is optional
Example :
Table name
Can't log in? Forgot Password? Many users and many passwords?
All these questions are very common in daily operations of your OpenERP. If you are admin then you have all the access to change or recover passwords for other users as well.
This is ver
Case Sensitive SQL query
A select query does not performs case-sensitive query which means if the user name is pravesh, Pravesh, PRAVESH then it will select all users using simple select. Below example of normal mysql select query -
SELECT * FROM
There are chances that you want to check for the indexes that you created on the tables in past because there can be a large number of indexes on numerous of tables depending on the size of the database
If you want to see the indexes for a particula
Hello friends,
I am here for share the solution of a MySQL problem.
If you want to change the data type of a column from varchar or any other one to date, you should need to use following query-
UPDATE `tbl` SET `date1` = STR_TO_DATE(`date1`, '%d-%
Recently I updated my Firefox from version 30 to 39 . But after updating my Firefox to version 39 test case written for a project which make use of selenium starts failing.
The reason being selenium is unable to obtain stable connection while the sam
By using REGEXP function of mysql.Below is the example via a MySQL Query
select empId,empName from tbl_employee where empName REGEXP “[1-4]$”;
This will select the data of all employees whose name ends with either 1 or 2 or 3 or 4
Below mentioned command is used to find a particular text in all stored procedures
SELECT OBJECT_NAME(id)
FROM syscomments
WHERE [text] LIKE '%EmailOnTRX%'
AND OBJECTPROPERTY(id, 'IsProcedure') = 1
GROUP BY OBJECT_NAME(id)
To restore database in PostgreSQL in ubuntu follow these step in terminal
1- sudo su - postgres
2- psql
3- psql -d abc1 < /home/sachin/pqr.sql
abc1 = is dbname from where I am restoring backup
pqr = backup file which will restore data
I came across a requirement where i had to find the current domain address of the app as i had to send an email to users with a public page url. I knew the virtual address of page but it would not work as in order to open a page from my website using
