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

Count item across multiple columns in same table

MySQL
I have a table that looks like below TableA ------------------------------------ id| ColumnA | ColumnB | ColumnC ----------------------------...
7 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 ...
7 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...
7 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...
7 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...
7 months ago