I have a MySQL table with the following data (simplified): INSERT INTO `stores` (`storeId`, `name`, `country`) VALUES (1, 'Foo', 'us'), (2, 'Bar', 'jp'), (3, 'Baz', 'us'), (4, 'Foo2', 'se'), (5, 'Baz2', 'jp'), (6, 'Bar3', 'jp'); Now, I want to be able to get a paginated list of stores that begins with the customers country. For examp...
I have to rewrite my code so that it will be iffecient when it comes to memory and execution time.. what the script does is creat a mysql dump wherein the data are get into huge data table and insert into another database. The data that being process here is about 17 MB of table data and eating about 62 MB of Memory. any suggestion how...
Hello all, I've been working with a couple different contact management solutions, but my security paranoia prevents me from wanting to put any sensitive data in the cloud. While I'm not dealing with anything like credit transactions that have detailed security requirements, I am considering handling sensitive personal data that I woul...
Currently we are restoring MySQL connections in a $_SESSION in order to save round trip time to set up connection to MySQL, but the problem is that the number of connections exceed the limit quickly, so what's your guys' solution? Do you create a new connection each time,and close that connection after using,or like me,restore it? ...
Hi I am having fun trying to get a stored procedure to parse correctly in MySQL. My issue is with dates. I am trying to get the store procedure to create a start date that is the beginning of the current month e.g. 2009-07-01. Using this date I then use the DATA_ADD() function to add a month so that it reads 2009-08-01. However my pro...
**Table A** 1 2 3 4 5 6 **Table B** 2 3 5 How can I select for entry IDs that only exist in Table B? In this example, I'm looking for a query that returns 1, 4, and 6. ...
I need to extract the following fields into a new table, any ideas if I can do this exclusively with a query or if I need to use PHP as well. CURRENT TABLE STRUCTURE USERID USEREXPERINCE 1 a:4:{i:0;s:20:"business development";i:1;s:6:"design";i:2;s:9:"marketing";i:3;s:15:"press relations";} REQUIRED TABLE STRUCTURE USERID ...
I have a mysql table with data connected to dates. Each row has data and a date, like this: 2009-06-25 75 2009-07-01 100 2009-07-02 120 I have a mysql query that select all data between two dates. This is the query: "SELECT data FROM tbl WHERE date BETWEEN date1 AND date2" My problem is that I also need to get the rows betwee...
I'm sure this is straight-forward, but how do I write a query in mysql that joins two tables and then returns only those records from the first table that don't match. I want it to be something like: Select tid from table1 inner join table2 on table2.tid = table1.tid where table1.tid != table2.tid; but this doesn't seem to make alot ...
Is it possible to INCLUDE other mysql scripts in a composite script? Ideally I do not want to create a stored procedure for the included scripts... For larger projects I would like to maintain several smaller scripts hierarchically and then compose them as required... But for now, I'd be happy to just learn how to include other scripts.....
I'm trying to create a java program to cleanup and merge rows in my table. The table is large, about 500k rows and my current solution is running very slowly. The first thing I want to do is simply get an in-memory array of objects representing all the rows of my table. Here is what I'm doing: pick an increment of say 1000 rows at a ti...
I have some really funky code. As you can see from the code below I have a series of filters that I add to query. Now would it be easier to just have multiple queries, with it's own set of filters, then store the results in an array, or have this mess? Does anyone have a better solution to this mess? I need to be able to filter by keywo...
Problem: to read effectively MySQL's manual Error: mysql> create database plastronics -> ; ERROR 1007 (HY000): Can't create database 'plastronics'; database exists mysql> Question: How to check it quickly like in VIM: ":h 1007"? Introduction Material I was reading ...
Hi All, I want to use mysql server on two different ports on same machine. I made two separate cnf files for the same. when I am trying to connect to mysql server with second port which i have added I am unable to do so. I am working on Windows Vista. I tried to start mysqld from command line after specifying port. This is the sample f...
I have a time in EST timezone, it is done using the NOW() function on the mysql server. Because my server is located in EST, the time stored is in EST. When I retrieve it from my app on the iPhone, I need to display it in the correct time zone of the user. How do I do that? ...
Why is installing MySQL on Windows Vista such a bear? For someone who is not a professional database administrator, it seems like I am jumping through hoops. This page http://forums.mysql.com/read.php?11,200958,204223#REPLY pointed to this page http://www.sqlservercentral.com/blogs/brian_kelley/archive/2008/04/04/installing-5-0-51a-my...
Hello everybody, I'm trying to write a valid mysql statement that would allow me to update multiple columns in one record with values provided as python variables. My statement would look like this: db = MySQLdb.connect(host="localhost", user="user", passwd="password", db="dbname") cursor = db.cursor() sql_update = "UPDATE table_name ...
I am using native MySQL driver (http://code.google.com/p/erlang-mysql-driver/) with mochiweb. When I tried that MySQL driver in shell mode, all woked fine. But when I write some code with Mochiweb, it reported me the following error: =CRASH REPORT==== 4-Jul-2009::04:44:29 === crasher: initial call: mochiweb_socket_server:acceptor_...
Hi I have the following scenario. I am calling stored procedures to MySQL 5.x from my .NET 2 application. All stored procedures have parameters and they work fine with the exception of two which throw the following exception (only when deployed to production): "When calling stored procedure and 'Use Procedure bodies' is false, all param...
I am developing a video website (PHP - MYSQL), just like youtube, in which I want to provide the functionality of Next video and Previous video. Let's say I am currently on videoId: 234 so Next and Previous video links will point to videoId: 233 and 235 respecively. My table structure is as follows: videoId videoName videoURL ...