MYSQL - Group by and Order By

MySQL
I have a table as such: ID Field1 Field2 Field3 1 Apple Fruit Cheap 2 Apple Fruit Eatable 3 Apple Food ...
1 year ago

Query to Get Counts of Ids under 2 different Conditions with Case When Statement

MySQL
So I Have a Table Structure like the one below. Here are the Conditions: I call 'Tag' as the IDs with none of Condition(x) as NULL. I call 'UnTag...
1 year ago

Which MySQL datatype to use for an IP address?

MySQL
Possible Duplicate: How to store an IP in mySQL I want to get the IP address from $_SERVER['REMOTE_ADDR'] and some other $_SERVER variables...
1 year ago

trending tag in a week like twitter wont work

MySQL
I am trying to make a hit list like twitter trending hashtags in one week. The following code working for just 1 DAY but i want to change it 1 WEEK ho...
1 year ago

url value not changing through loop

MySQL
I am trying to display the comments by the user from the database and +1 could be given to their comment. this is the view. <br>Comments:&l...
1 year ago

Wordpress error establishing a database connection - Memory Issue

MySQL
I have been running this wordpress site for a long time with no issues, however have recently been getting the error "Error establishing a database co...
1 year ago

Selecting MAX number from MySQL table not working - PHP

MySQL
I have a table like below (a piece); | Sl | NUMBER | Name | ---------------------- | 7 | 00007 | Name | ---------------------- | 8 | 00008 | Name...
1 year ago

Date Counting PHP

MySQL
I'm building a task list. I have two tables in my DB. Template and Tasks The templates are structured like so id, task_name, function, text, days_to_...
1 year ago

[My]SQL Query Syntax which requires foreach processing

MySQL
I have an SQL query task which I can do OK in C# or linqpad but would prefer it is in SQL so standard reporting tools can do it. End DB is a bugzill...
1 year ago

#1036 - Table is read only in phpMyAdmin

MySQL
i'm using a database host with phpMyAdmin. This host isn't mine. I execute this code in the phpMyAdmin of this host: INSERT INTO `fronton`(`id`, `Na...
1 year ago

Every derived table has its own alias

MySQL
i have the following query: select userid, name, checktime, campaign, CASE WHEN Hoursworked - 9 > 0 THEN Hoursworked - 9 ELSE 0 END Overtime from...
1 year ago

I want to Query in MYSql with some conditions

MySQL
Here is question with conditions: In a somewhat related situation to the above, management wants to know which technicians are certified in one trade ...
1 year ago

MySQL query to get that row which has the last day of first month of date field

MySQL
In my database I have a field named DateLastSaved: Suppose the values are: 1. 2016-05-12 08:07:00, 2. 2016-05-22 09:06:00, 3. 2016-05-22 09:06:00, 4...
1 year ago

Get total points of user in MySQL Table with PHP

MySQL
Table Hello! I have a MySQL table with the columns "user" and "warningpoints" for each warning as you can see in the table above. How can I get the u...
1 year ago

Non-GPL ADO.NET provider for MySQL?

MySQL
Is there any NON-GPL ADO.NET provider for MySQL ? There is the official one from here http://dev.mysql.com/downloads/connector/net but unfortunately,...
1 year ago

How to insert shopping cart orders of each user into one column in DB (not row)?

MySQL
I have shopping cart in my wordpress website and once user clicked "Place order" button, I want to insert corresponding user's cart items into DB, but...
1 year ago

phpMyAdmin access denied

MySQL
I am using wamp server, and my phpMyAdmin page returned the following error. Wamp server version:2.2 MySQL version:5.5.24 #1045 - Access ...
1 year ago

MySQL Multiple row update failure

MySQL
Am attempting to update multiple records in a table all at once when a user clicks on the submit button of the form. My code only updates the first ro...
1 year ago

Mysql, update query

MySQL
I have table like this: table1 first_id second_id value 1 0 10 2 0 60 <- can be bad value, need...
1 year ago

How to replace 'Empty set' in a mysql query?

MySQL
I have a mysql query: SELECT zip AS z FROM zip WHERE zip = 90210; When the row matching 90210 is found, it returns: +-------+ | z | +-------+ ...
1 year ago