Free Tool for Validating 2 Databases
I want a free tool for verification all table data between 2 mysql databases ? is there any free tool available on Linux ...
mysql
problem applying a WHERE condition on an aliased response
This has been driving me nuts. I hope it's not been asked before but I could not find the answer so I will try to explain the situation as best as I can. my objective is to get data of products and their colour versions based upon a set of criteria like brand, category, price and so forth. the basic query works fine in that it returns ...
Given a latitude and longitude, find users interested in that position
Given a table, +-----+---------+---------+---------+---------+---------+ | user| min_lat | max_lat | min_lng | max_lng | +-----+---------+---------+---------+---------+---------+ | a | 46 | 407 | 6 | 367 | | b | 226 | 227 | 186 | 188 | And a Point(x, y) Find users where the point is within the m...
MySQLInstance Configuration
Hi guys, i am using this line to configure MySQL 5.1 MySQLInstanceConfig.exe -i -q -lmysql_config.log ServerType=SERVER DatabaseType=MIXED ConnectionUsage=DSS Port=3306 AddBinToPath=yes ConnectionCount=10 SkipNetworking=no StrictMode=no RootPassword=password it configures the server and the service is started fine, but the Stric...
Can't connect to MySQL for .NET application deployed in Wine using Ubuntu
Below is the link http://stackoverflow.com/questions/1518946/how-to-insert-delete-select-update-values-in-datagridview-in-c-using-mysql which has the code to connect to a MySQL datbase from a Windows application. It works fine in Windows XP. So I have created a setup file and installed in Ubuntu using Wine. The issue is with the data ...
MySQL error 150 during CREATE TABLE
Hi all, I have one table with name tbl_groupmaster created with SQL as shown below: create table tbl_groupmaster ( tgm_groupid int(10) unsigned NOT NULL auto_increment, tgm_groupname varchar(50), tgm_groupdescription varchar(50), PRIMARY KEY (tgm_groupid) ) and I am creating one more table with name tbl_groupmanager, using a f...
Splitting 20 million record database
I have a US company database which is 20 millions records. Firstly they is no budget for a massive RAM database server. So I think I am going to have to split the db into parts, 4 parts grouped by State. My question is how is the best way to handle this with PHP, I am thinking get the users query find the State and then point to the r...
Searching for availability with MySQL (and PHP) ?
I have two MySQL (MyIsAm) tables that represent letting units and bookings: LettingUnits (ID, Name, etc...) LettingUnitBookings (ID, F_LU_ID, Start, End) Where F_LU_ID is a foreign key to the unit. What is the best way to search for units that are available during a certain time frame? The search is passed a Start, End and Duration....
MySQL EXPLAIN: "Using index" vs. "Using index condition"
The MySQL 5.4 documentation, on Optimizing Queries with EXPLAIN, says this about these Extra remarks: Using index The column information is retrieved from the table using only information in the index tree without having to do an additional seek to read the actual row. This strategy can be used when the query us...
How to select a users specific info from a MySQL database?
I was wondering how can I have my users pick their favorite food from a category of foods in my MySQL database. Will I need two different tables? If so what will my second table look like? Here is my MySQL food table structure. id | parent_id | food | url ...
MySQL :: Connector/Net euro sign
My MySQL database can store the euro symbol just fine (as I have tested with a native MySQL client (HeidiSQL)). But with the MySQL .NET connector my ASP.NET application is using I can't insert nor read it back from the database: I only get a ? character back. What could be the possible cause? ...
advantage of BTREE?
I crate indexes without the "USING BTREE" clause. Is thre any advantage of using BTREE index? CREATE INDEX `SomeName` USING BTREE ON `tbl_Name`(`column_name`); ...
Problem having lots of databases?
We have built a hosted web application, that is developed in a way that each customer is connected to an individual database. This application is a web plattform/publishing system, and has been working very well so far with this design. We also have a main database. Now we are about to make some changes in our pricing model, which would...
Priming read for PHP Query
I am new to PHP and working on my own CMS for a project. Mostly to just give myself a project to learn the language. The CMS is working but I am just tracking down some bugs in it. So here it goes... I am trying to list all of my published articles for each section. It does this correctly but I am having an issue in the code statemen...
How to order pages in CMS?
I wrote a simple CMS for one of my clients which does specifically what he needs (without the bloat of mainstream content management systems he would never use). The CMS enables him to create and manage two types of content: pages and news (short messages that show in the sidebar). The pages are displayed in the navigation menu of the ...
PHP and MySQL Learning material
Hi, I though this would probably be the best place to ask. I am looking to get started on PHP and MySQL. I am familiar with programming, but have never needed to learn these until now and am asking if anyone can recommended some free learning material on these. Thanks for your time. Edit. Sorry for the edit I should have also point o...
Warning when calling mysqli_error()
I'm trying to join three tables from a database in-order to display a users selected categories but I get the following error. Warning: mysqli_error() expects exactly 1 parameter, 0 given in I think I'm doing something wrong when I query my database. Here is the code below. // Query member data from the database and ready it for dis...
Overhead of a Round-trip to MySql?
So I've been building django applications for a while now, and drinking the cool-aid and all: only using the ORM and never writing custom SQL. The main page of the site (the primary interface where users will spend 80% - 90% of their time) was getting slow once you have a large amount of user specific content (ie photos, friends, other ...
Object Oriented and Procedural Mysqli Help?
I asked a question earlier and a user stated that it looks like i'm oddly mixing the OO and procedural style usage of mysqli and that I should stick to either one or the other. Can some one show me exactly what is wrong with my code and how my code should look like in OO and procedural form. I'm kind of curious now since the code I have...
Looking for an SQL statement which groups by type
Hi all, first, I was pretty lost giving this question a correct title. I'm working on a system which allows me to find specific networking devices. A network device (called "system" in my example) has a number of ports, where each port can have a specific configuration. An example would be: Return all devices which have at least 2 por...