mysql

Installing MySQL so file

Hi, Probably an easy question, but I'm trying to install sys_exec into MySQL. It contains an so file, along with a few other things. Where do I place the .so file? I'm running Debian + MySQL5 I've tried /var/lib/mysql/, /usr/share/mysql and /usr/local/mysql/lib/mysql which according to MySQL Docs is the location for libs/plugin direct...

magento - Image type and information need to be specified for each store view

Hi, I have a working Magento 1.4.1.0 installation that is due to go live next week, all was well until yesterday when I noticed the following message when uploading images to a product 'Image type and information need to be specified for each store view'. The image uploads fine and is visible on my server, the preview works when I hover...

Mysql -change DB,tables to utf8

In /etc/my.cnf the following has been added character-set-server=utf8 collation-server=utf8_general_ci But for the database and tables created before adding the above how to convert the database and tables to utf8 with collation settings ...

One parent row, multiple child rows in another table. How to get them all in one row?

I volunteer for a local non-profit that gives out toys and food during the holiday season. One way that I am helping them is by putting their gift/food requests online. This way instead of manually entering 1,000 or so names manually into Excel over the course of 15 hours they can simply click on a link and have the whole thing exported ...

Splitting mysql database per client

I am working on a database that is relatively small. It has a total of 67 tables, with a little over a million records. It is about 254 MB. The application that works with it has been running for about 5 years and the amount of usage has doubled each year. This year we are projected to triple which will just almost double the database in...

Symfony using Doctrine and MySQL

For schema.yml to work with relations, do you have to InnoDB? Here is my schema: BuybackStatus: connection: doctrine tableName: buyback_statuses columns: id: type: integer(4) fixed: false unsigned: true primary: true autoincrement: true label: type: string() fixed: false unsi...

MySQL problem with statement

SELECT a.id,i.* FROM ads a INNER JOIN images i ON i.ad_id=a.id GROUP BY a.id LIMIT 10 Can't figure out, how to pick images with flag "main" inside images table. For one a.id can be up to 3 photos inside images table, one of those 3 photos can have a field main=1. I need to pick photos by priority where flag mai...

How does MySQL behave in JOIN cases where ORDER BY and LIMIT are specified and only a small number of rows need actually be JOINed?

Suppose I have the following tables: CREATE TABLE Game ( GameID INT UNSIGNED NOT NULL, GameType TINYINT UNSIGNED NOT NULL, PRIMARY KEY (GameID), INDEX Index_GameType (GameType, GameID) ) ENGINE=INNODB CREATE TABLE HighScore ( Game INT UNSIGNED NOT NULL, Score SMALLINT UNSIGNED, PRIMARY KEY (Game), INDEX ...

change mysql default character set to UTF8 in my.cnf?

currently we are using following commands in PHP to set the character set to UTF8 in our application. Since this is a bit of overhead, we'd like to set this as the default setting in mysql. Can we do this in /etc/my.cnf or in another location? SET NAMES 'utf8' SET CHARACTER SET utf8 I've looked for a default charset in /etc/my.cnf b...

where to keep temporary data?

Hi Guys, I'm doing a system with Codeigniter , this is my first system with CI, and i'm also novice to PHP too. I'm doing this for a hospital, in this i have the following problem junior doctor first check the 1st visit patients and then if he can't handle them he refer them to the senior doctor from registration room some patients ...

The specified type member 'DateTime' is not supported in LINQ to Entities

I am using the latest development version of the connector - 6.3.3 beta to connect to a mysql database via the Entity Framework 4 in VS2010. I have the following Linq statement which uses a TIMESTAMP column - createdDate - in the query. Here is the code: int timeThreshold = 5; DateTimeOffset cutoffTime = DateTime.Now.A...

MySQL: How to sort by column in ascending order, and show NULL at the end instead of the beginning?

I know how to sort a result set: SELECT * FROM `People` ORDER BY `LastName` ASC However, the results that have an empty LastName show at the beginning. How do I sort in ascending order, and show the NULL results at the end instead of the beginning? ...

mysql order by field( with a twist)

I have a product table with a product name, two product attributes fields, and a price field. The problem is that I can't change the way the database is structured. Each attribute fields are equivalent and either can be used. basically : NAME | ATTRIBUTE_1 | ATTRIBUTE_2 | PRICE Tshirt | red | small | 25 Tshirt...

Update 20 rows in mysql with x=x+1 values?

Hi there In mysql I have a table with like 20 rows (example). I want to write sort order (it is in array that carried picID's) to the SORT column from 1 to x (x is the number of items in this example x=20). My array starts with: [10,15,1...] I can do: UPDATE table SET sort=1 WHERE picID=10 UPDATE table SET sort=2 WHERE picID=15 UPDAT...

SQL Query in Informatica Cloud

I am trying to integrate a MySQL database with Salesforce but am having trouble with part of the query logic. I enter this query: SELECT occupation_name FROM skillsmatch_skillsprofile GROUP BY time_updated ORDER BY time_updated DESC LIMIT 0,5 But get this error: <> missing operator... SELECT>>>> <<< Any idea where I might be going w...

How to optimize this query?

Hello i have two tables: **prices** id id_stock price date **stocks** id stock_name active now i have to set stocks.active=0 for each stocks that has the MAX(prices.date) > 15 days (of a date i have to pass) This is my query, but it's very very slow!!! update stocks set stocks.active=0 where stocks.id IN ( SELECT prices.id_stock ...

Proper way to build MVC for my application

I am scraping data from I want to scrape three search engines. In My queries_controller I will have a function search that calls $this->Query->find('$query'). My Model will hand this onto my own Database whose read() funcion will call three functions, searchGoogle($query), searchYahoo($query) and searchBing($query). The return values wil...

Need help with a MYSQL query grouping

Table schema is set up something like this: userID Points timestamp 1 40 3 20 1 10 4 15 3 5 Need to be able to present a report that shows the following: Total Points Allocated for the Day (0 if none allocated), (nice to have) To what userID's the points were allocated to ...

MySQL: Sum values in subqueries

I have information on school athletics, with tables for school, season, cashflow, and cashflow_group. I'm trying to query for all schools with cashflow in one or more given cashflow_groups within a user-specified range. I need to query multiple different categories in the same query. I'm having trouble. My query is below. The reason I d...

Using LIKE to search for a name

I have a table which contains contact information. This table has 1 column relevant to names. It looks like this: Sort Name: Doe, John Clinton, Bill Dooby Doo, Scooby Sadly, there are no first name / last name columns, and they can't be added. If a user enters the search term "john doe", is there any way I can get mysql to return the ...