WordPress database error: [Duplicate entry '13955' for key 1]
INSERT INTO wp_bas_visitors (visit_ip, referer, osystem, useragent, lasthere) VALUES (644300605, 1, 191, 629, '2009-01-06 11:37:44');

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND referer = referer_id AND osystem = os_id AND useragent = ua_]
SELECT * FROM wp_bas_visitors, wp_bas_refer, wp_bas_ua, wp_bas_os WHERE visit_id = AND referer = referer_id AND osystem = os_id AND useragent = ua_id

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' '2009-01-06 11:37:44', 0, 82)' at line 1]
INSERT INTO wp_bas_log (visit, stamp, outbound, page) VALUES (, '2009-01-06 11:37:44', 0, 82);

CMJ Office Blog » Excel Database Function Codes

CMJ Office Blog


Excel Database Function Codes

Posted in Virtual Assistant by CMJ Office on the March 19th, 2008

I’ve listed some database function codes for Excel. If you are working on a database within Excel, this tool can be quite useful. You can find more function codes at Microsoft.com.

Happy databasing!

Colleen M. Johnson, CMJ Office

Database Functions


Function 

Description 

DAVERAGE

Returns the average of selected database entries 

DCOUNT

Counts the cells that contain numbers in a database

DCOUNTA

Counts nonblank cells in a database 

DGET

Extracts from a database a single record that matches the specified criteria 

DMAX

Returns the maximum value from selected database entries

DMIN

Returns the minimum value from selected database entries 

DPRODUCT

Multiplies the values in a particular field of records that match the criteria in a database 

DSTDEV

Estimates the standard deviation based on a sample of selected database entries

DSTDEVP

Calculates the standard deviation based on the entire population of selected database entries

DSUM

Adds the numbers in the field column of records in the database that match the criteria 

DVAR

Estimates variance based on a sample from selected database entries 

Leave a Reply