Hi, I have several hosts from which i want to do the same query. So imagine, i have on each server the database db and a table test like : mysql> desc test; +-------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+------------------+------+-----+---------+-------+ ...
Hi, Does anyone know how to bring in all of a mysql tables' results, only show the first X, (say 10), and then hide the rest using jquery? Basically, as I've already got the jquery, I just need to know how to show only the first X results in one div, then the rest in a seperate div. My aim is to only show the first 10 results, but prov...
Does having separate file for each table improve InnoDB performance in MySQL. Are there any such performance tuning tips for MySQL ...
I'm a bit new to OOP, but i've been playing with it for about a month now. Usually, i create a class called Mysql which has a __construct function that connects to a database directly. And after that i have lots of different functions that gets or inserts data into different tables. On the bus home today, i began thinking and i came up ...
Okay I do apologise that I'm out of my depth here. I'm not the kind of person to rely on places like this and any help towards improving my PHP & MySQL knowledge is greatly appreciated! I have this query which is called to collect information about users who are registered on our wordpress site. $verified = $wpdb->get_results("SELECT w...
Hi folks, one question about NDBCLUSTER. I inherited the writing of a web site basing on NDBCLUSTER 5.1 solution (LAMP platform). Unfortunately, who designed the former solution didn't realize that this database engine has strong limits. One, the maximum number of fields a table can have is 128. The former programmer conceived tables ...
When I try to call user defined functions using remote connection it gives me error. The thing is query without any functions runs fine for remote connection. So how can I call functions remotely. Query : select jobcardid,sonno,sonnumber,getSalesOrderCountByStatus('completed',1)as finished,getSalesOrderCountByStatus('pending',sonnumbe...
Hello. At first - Im sql newbie, sorry for this (mbe typicall) question. I Have two table: table of organisations... id_org org_name 1 Organiz1 2 Organiz2 and table of organization staff. id_staff staff_name id_org 1 John 1 2 Jack 1 3 Sally 1 4 Peter ...
Hi guys, i think its an regular problem, answered several times, but I just don't know how to ask the question right =( in MySQL: i have 2 tables with some kind of strings inside, now i want: 1. the data that occur in both tables 2. the data from a that is not in table b same in R: i have 2 R data.frame s and i want: 1. the data that...
Hi, I'm testing a method with quite huge sql query. I has about 15 joins, one subquery with 2 joins, so it is complex. But each running takes different time. Once it is 4 second, sometimes 80, or even 200 seconds. It is standard unit test, with preparing data with FactoryGirl, and data is always the same. Is there any mysql profilers, m...
I have a Ruby on Rails application that has two active environments, Stage and Production. Our development team has been using Stage, but we would like to move our data onto the production server for various reasons. However, there are conflicting ID's in the new database, so it's not as simple as pulling the data from one location and...
i have two question about msyql performance with my db using MyISAM engine : 1) what is smart way to solve the problem that when INSERT or UPDATE some rows in one table, many SELECT queries be hang on. 2) Is this easy to change from MyISAM to InnoDB with database is current running? 3) Why myISAM is still be default option of mySQL w...
SELECT * FROM `objects` WHERE (date_field BETWEEN '2010-09-29 10:15:55' AND '2010-01-30 14:15:55') returns nothing. I should have more than enough data to for the query to work though... what am I doing wrong? ...
I have a MySQL database that I'm using with Django. One of my tables has around 60 columns. I'm wondering whether to split it into 5-6 smaller tables. This would make logical sense, since the columns split nicely into 5-6 logical groups. The downside would be that some of the Django pages would then require 5-6 row queries instead of 1....
The Problem We have a large web application that stores and displays sensitive HIPAA-related data. We're currently researching ways to improve HIPAA compliance and reduce the risk of having a violation. Currently, there are several features and reports that do not correctly restrict client information based on the permissions of the pe...
Alright, another interesting problem over at Route 50. We wanted to implement a true forum lightbulb system where posts that are unread by a user (after the user's account is created) show as unread until that status is cleared or until the user reads them. We figured the best and easiest way to do this would be to implement a table of...
I have WampServer 2.0 that is installed on Windows on my laptop. I'm running on it an application that I wrote. The application is working with MySQL database. I would like to make backups of this database periodically. How this can be done ? How could I define cron on Windows ? ...
I have ended up with messed up character encodings in one of our mysql columns. Typically I have √© instead of é √∂ instead of ö √≠ instead of í and so on... Fairly certain that someone here would know what happened and how to fix. UPDATE: Based on bobince's answer and since I had this data in a file I did the following #!/use...
i have a table that has a cell containing a timestamp when the entry was created, than i have a cell containing the number of days that row should expire, something like this my_tb: id | elem1 | timestamp | maxdays | active 1 | jondoe | 2010-09-28 | 60 | 1 1 | foo | 2010-09-18 | 30 | ...
Hello, I'm writing an application on top of CodeIgniter to better organize my ebook collection. I'm nearly done, but I realize my 'browse' page is running far too many queries - two per book - to get their information. Obviously not at all ideal, especially since I have about 1000 books to put into this system. I currently have one mo...