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,...
11 months 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...
11 months 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 ...
11 months 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...
11 months 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...
11 months 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 | +-------+ ...
11 months ago

how to select max of mixed string/int column?

MySQL
Lets say that I have a table which contains a column for invoice number, the data type is VARCHAR with mixed string/int values like: invoice_number *...
11 months ago

Disable autocommit in SQL Developer when using MySQL

MySQL
I'd like to connect to a MySQL server with Oracle SQL Developer, but with autocommit disabled. By default, all MySQL connections have autocommit enabl...
11 months ago

Migration of MYSQL database without losing records

MySQL
I'm migrating a MYSQL DB from one host to another so I run the following command to backup the DB from the old hosting: mysqldump -u **** -p **** | g...
11 months ago

Count of joined items per group in MySql

MySQL
I need to get a set of results showing the number of items accumulated for each 'esta' group. I'm grouping the results by establishment. Establishm...
11 months ago

Update and Delete query for merging records

MySQL
I have a table with following records id | fname | lname | skills 22 | Jane | Doe | php,mysql 43 | Jane | Doe | java,oracle,php 45 | Jane | Doe...
11 months ago

Like % with many values in sql

MySQL
How to write the like% query with too many values in sql ? For example ,please see the table structure Id Tid name 1 1 test 2 3 ram 3 10 fe...
11 months ago

PHP MYSQLi Displaying all tables in a database

MySQL
How do I display out all the information in a database (All tables and records) using PHP? I read displaying tables as HTML table but how do I do it f...
11 months ago

Count how many rows you have in your db with PHP

MySQL
Hellow, I want to count how many rows i have in a table. I got a table (workstations) in my mysql database (phpmyadmin). I want to print it out, so ...
11 months ago

MySQL SELECT on Arabic Word returns 0 results on PHP but does on SQLBuddy/phpMyAdmin

MySQL
Problem I am getting 0 results when searching for an Arabic word in a MySQL database using the SELECT query with PHP. However, the same exact query...
11 months ago

Count item across multiple columns in same table

MySQL
I have a table that looks like below TableA ------------------------------------ id| ColumnA | ColumnB | ColumnC ----------------------------...
11 months ago

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 ...
11 months 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...
11 months 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...
11 months 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...
11 months ago