MySQL Database Forum

Hi I have a SQL query that counts values in a table and totals them up and works out a percentage, it involves a few counts, is there a better why to acheive what I want other than the way I have done it? The query is: SELECT q.`text` AS 'Question', (SELECT COUNT(*) FROM answer WHERE question_id = q.id AND answer = 'y')

I've got a problem with importing chinese characters into a mysql-table and have read several mailings but didn't find a solution. i have a utf-8 text file that contains chinese characters. the table where i want to import the data using "load data local infile" has collation utf8_unicode_ci. but after the import is done, the chinese...

I am using mysql with the InnoDB engine. I wrote a perl script that first selects something from a table, and then updates a second table based on the select from the first table. I need to make sure that there is no read or write to the tables while my script performs the insert and update. I looked at...

Hi all, I am building a project which will have 200T data in very short term. For the size of 200T data, what does the muliti-database-server system look like? I am hoping to have a set of machine working together, but don't know the architecture. any article talking about this? Or, is there any solution out there? Please help me out.thanks...

<script language="JavaScript"> <!-- Hide the script from old browsers -- function a(txt) { self.status = txt } function b() { self.status = "" }

Hi, I have a problem. I have written a SQL statement that has a nested select case statement on the 'where' clause to condition the results. -------------------------------------------------------- SELECT b.ISBN, b.Title, b.SmallImage, f.idForSale, count(f.idForSale) FROM books b, forsale f

Hello All, This is my first time using this list, but hopefully I got the right one for the question I need to ask :). I have a table which has about 4 million records. When I do a search (as I will explain below) it takes about 1.35 secs to get me back what I am looking for. Since I am doing multiple types of these searches, the total...

Here's my installation issue: I have two versions of an application (I'll refer to it as "ABC"). One version of the tool requires MySQL 4.1.x and the other requires MySQL 5.0.x, which is not an issue as I can install each of these on their own port; 3346 and 3356 respectively. The complex part of this problem is that ABC's executable is...

Just started investigating InnoDB after having used MyISAM tables in the 4.0.12 version, almost immediately ran into a locking issue with INSERTs, DELETEs, and transactions. Given the following table: CREATE TABLE test1 ( f1 varchar(32) default NULL ) and a steady stream of INSERTs from a command-line shell:

Suppose a table "address" contains the following records ------------------------------------------------------- | name | address | phone | ------------------------------------------------------- | mr x | 8th lane | 124364 | | mr x | 6th lane | 435783 | | mrs x | 6th lane | 435783 | | mr x | 8th lane | 124364 |...

Is it possible to change the format of a decimal field on mysql level? We would like to use an open source solution though all the currency fields have to change. Values like: 1,2567.34 should be in european format: 1.2567,34. To change the source we have to change all the properties of the num_format($value,2) into...

Hello, Is it possible to use the replace function with wildcard characters? For instance, I want to replace instances of thisString thisWildPhrase thisStringEnd with

Hello all, I'm building an Ajax table which fetches its contents from mySQL. The idea is that the table displays x results on each page, and when you click 'next page' it downloads the next x results and displays them. The table uses an arbitrary SQL string to fetch results, and I'm stuck on how to access just a small result set. Since...

Using version: 4.0.18-Max-log We're getting some fairly poor performance when doing an INSERT INTO temp_table ... SELECT (...). The SELECT is grabbing 2K row chunks from its table, so the problem is not that the query results are so monstrous that it's just taking that long to gather them all. The problem appears to be one of IO. When...

hi, i have some data in mysql in a column like this: 6.1.01 Financial Regulations 3.32.02 Academic Counseling what iam selecting is select by letter A, B, C...Z. so my first char in the column is always a integer, how can i select when the first few characters are always a integer, i want to get rid of the integers and run query on the...

hai.. i'm doing a program about searching. but, i have some probem when using 'between'. this is my program: SELECT eID, REPLACE(eTitle, '''', '''')as eTitle, REPLACE(eDescription, '''', '''')as eDescription, eSystemID, eDateStart, eDateEnd, eDurationSet, eDateCreated, eAuthorID, eTemplate, eStatus FROM vm_examdb.vm_examset WHERE eStatus =...

Hi, I want to drop a foreign key constraint on an INNODB table in MySQL 4, but i keep getting this error: mysql> ALTER TABLE ORDER_FORM_CARTRIDGES DROP FOREIGN KEY FK2_ORDER_FORM_CARTRIDGES; ERROR 1005: Can't create table './REFILLSTATION/#sql-6e1_11.frm' (errno: 150) Grateful for any advice, - Dave

I'm having the most bizarre problem with PHP/MySQL that I've ever faced and it's an urgent matter (of course) to try to fix it ASAP. We have one record inserted into a table with 75 columns, whereby half of the columns are not-null, but for some bizarre reason, the fields are null. The rest of the columns that are null are completely...

I took a lab exam today. However, though the exam is over I'm still thinking about one of the questions. I had a schema for a bookstore database defined like this: Book: +---------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra |...

I'm working with mysql without referential itegrity. Let me make some small example: tableA +-----------+---------------+ | id_1 | data_1 | +-----------+---------------+ | 1 | bla1 | | 2 | bla2 | | 3 | bla3 |

Hi everybody, I am a rookie at the forum stuff. Please don't bash me too badly. I have created an app a few years back to store some records in a DB. According our calculations we were never to exceed 500,000 records in the DB. Seems we were off by a decimal point or so. I set up a FreeBSD box with MySQL three years back and it has been...

Hi, I have a database where I have to find the highest point aggregator. I am new to mysql. Would you please let me know what query would be good for getting what I want? The sample is below. Thanks: Name | Points Jack 10

Hi, I cant declare a varible in mySQL 4 i've tried: declare @id as int declare @id int declare id int any ideas? thaks

I realize that this probably isn't a best practice, but I'm working with legacy code that has a query stored in one column of a table. Because the queries vary, the JSP page that selects a query and runs it cannot add any additional information (like a WHERE clause). I need to add a few more records to the the table, and would like the...

Hi everyone, Is there any easy way to duplicate a row in a table with auto increment column, that shouldn't of course be copied. I tried a query "NSERT INTO table SELECT * FROM table" but it caused an error due to the auto increment column. I succeeded with listing all required fields in the query, but it's not very efficient way to do it...