MySQL 5.0.51a-3ubuntu5.7 doesn't accept USING BTREE in CREATE TABLE. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual...

Jivanmukta

10-19-2010 08:21 AM
Jivanmukta

Is it possible in SQL to develop a subroutine in some way? I've got a Java function (formula) I'd like to implement into a Select query to compute a...

Charles

10-18-2010 10:22 AM
Charles

"Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 18 Oct...

me

10-18-2010 03:35 AM
me

Hi MY name is sonam, i am 20 i love to F*U*C*K only 50 $ per n8 At http://telecomdomain.Co.CC Due to high sex security risks,i have hidden, that...

namitha

10-16-2010 09:10 AM
namitha

I'm writing a Clarion program (Clarion6.3 9056) that connects to a MySQL database via an ODBC connection (MySQL Connector/ODBC driver). Everything...

Stuart345

10-15-2010 11:39 AM
MG

Hello everybody, I'm relatively new in database management and programming, and I have a simple question: I need to update a Date Field in multiple...

Francesco

10-15-2010 04:18 AM
Francesco

I have a large (9000 records) table 'map', with a key field 'id', and a data field 'p'. I have a small (30 records) table 'hexads', with a unique...

Nick Wedd

10-15-2010 02:30 AM
Luuk

Hello Group, Given these two tables: pathlist ========== id pathname 1 /folder/ 2 /folder/sub1/ 3 /folder/sub2/

lallous

10-14-2010 01:16 PM
Lennart Jonsson

Hi SELECT * FROM TABLE123 WHERE FULLNAME LIKE 'RED' The above will only check one variable FULLNAME. Is there anyway of searching across all...

John

10-14-2010 04:04 AM
Captain Paralytic

Chad Hanna wrote: know what it actually means..;-)

Erick T. Barkhuis

10-12-2010 07:48 AM
Jerry Stuckle

"Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 11 Oct...

me

10-11-2010 03:39 AM
me

On 10-10-10 14:07, JTP PR wrote: why not simply just post a link to this crap?: http://www.yellowfinbi.com/YFCommunityNews.i4?newsId=99710 this...

Luuk

10-10-2010 10:24 AM
Luuk

Hello, I recently read about InnoDB internals but I can't figure out some questions. 1. When InnoDB update small record (16KB page) all page with...

eteste

10-10-2010 09:43 AM
Axel Schwenke

i'm doing something research on master-master(standby) replication. so far we use manually method to exchange the standby master as master when occur...

sissi

10-10-2010 09:30 AM
Axel Schwenke

Hello again. When I run this connect.php get and error. The php file contains: <?php $dblink = mysql_connect("localhost","root","")or die("Kunne ikke...

Karl-Arne Gjersøyen

10-07-2010 12:46 AM
Erick T. Barkhuis

Howdy all, I noticed something strange today when trying to speed up some queries and can't figure out if it's a bug in MySQL or something I...

Blake

10-06-2010 10:55 AM
Peter H. Coffin

Is it possible to configure/select a column with some kind of max_size so it doesn't wrap the row?

alst74

10-06-2010 08:00 AM
Captain Paralytic

Hello. I need to completely remove MySQL 5.5.6 from My Mac. OS: Snow Leopard Processor: 2.4 HDD: 320GB I have follow the description...

Karl-Arne Gjersøyen

10-06-2010 06:15 AM
Willem Bogaerts

Hi, Can anyone recommend a really easy to use schema viewer for MySQL? I just need to generate a graphic map of selected tables. Tx ;-)

Heather Mills

10-05-2010 08:33 PM
Heather Mills

Hi guys, I have loads of SQL Server experience, but not a lot of mySql. I have created this proc: DROP PROCEDURE IF...

Cralis

10-05-2010 06:58 AM
Álvaro G. Vicario

Hi, I need help with a JOIN Query. My DB has two tables, Employees and Data. The table "Data" has duplicate rows. I know this is a terrible...

Joe Hesse

10-05-2010 04:53 AM
Captain Paralytic

Dear all, I have several tables with foreign key constraints. What I want to achieve is if a record is referred by any other tables, the record...

cell

10-04-2010 10:25 AM
Peter H. Coffin

I'm trying to figure out a query that matches up combinations. The tables should look like this: Starting tables: Table I Field 1 Field 2 ...

Charles

10-04-2010 05:02 AM
Captain Paralytic

"Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 04 Oct...

me

10-04-2010 03:34 AM
me

Let's say I have a table t with a column c which is an auto incrementing primary key. I can retrieve the rows in t in a random order with...

August Karlstrom

10-03-2010 01:25 PM
Peter H. Coffin

I want to write an update statement, but can't figure out the syntax. if the value of column 'form' is = 'K' I want to set it to 'ck' Yes, I read...

bill

10-03-2010 12:25 PM
Peter H. Coffin

If I create a table with 32 columns each declared as BOOL, will the data be stored as bits (32 bits = 4 bytes) or an individual bytes? Will each row...

Sgt Snorkel

10-03-2010 12:25 PM
Peter H. Coffin

Hi there, Is it possible to store a binary content of around 200 MBytes into MySQL ? Theorically, there is the BLOB data type (and variation such...

Hugo

10-01-2010 07:31 PM
Norman Peelman

Does anyone know know where I can find protocol information on how to connect to a MySQL database directly using UNIX sockets (without using...

Rob

10-01-2010 12:45 PM
Axel Schwenke

I'm working for an energy meter company. The energy meters reports consumption to a MySQL database. We are now in the works of developing virtual...

Johnny Beeper

10-01-2010 10:57 AM
Tony Mountifield

Hi, I am pleased to announce the initial release of ODB with native MySQL support. ODB is an open-source, compiler-based object-relational mapping...

Boris Kolpackov

10-01-2010 03:40 AM
Boris Kolpackov

Hello, I am looking for information about replication strategies on mySQL databases. I am particularly interested in "dynamic" replication, i.e how...

ByB

09-30-2010 02:31 AM
Axel Schwenke

Hello, I want to use a cursor in a function which has a select with a dynamic column name and returns the value of this relevant column depending...

Jens Riedel

09-30-2010 02:06 AM
Mau C

Thanks guys for your feedback and tips. First, let me say that i do have a table call media_format that contains the different format of a disc (cd,...

SM

09-29-2010 06:16 AM
Captain Paralytic

"Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 27 Sep...

me

09-27-2010 03:31 AM
me

We started seeing performance issues in our master database after its host server was accidentally rebooted. Although the OS was rebooted gracefully,...

ampersand

09-25-2010 05:20 AM
Axel Schwenke

Hi all, in order to manage the special character into descrition field (i.e.: "Description 1, sddsd'") the sql query returns an error about '...

softwareEngineer

09-24-2010 03:31 PM
Lennart Jonsson

I have problems making a query, maybe someone can help. What do I have: A standard select * from 'table_a' where .... query In this table there is a...

Electricdummy

09-24-2010 02:55 PM
Peter H. Coffin

Really not sure how to do this.. but I suspect a sub select is needed I have 2 tables, both have a column labeled ID , I need to delete the row in...

dewed

09-24-2010 03:43 AM
Captain Paralytic

Hello, please how is it possible to set the timeout, for when I try to write on a record that is already locked by another transaction? I did try...

enos76

09-23-2010 02:38 PM
enos76

I have a NAS installed MySQL with/from OptWare. It works in some way ok, but now and then it goes down, both MySQL and the NAS, no web, no SSH, no...

Hans Kjaergaard

09-23-2010 08:10 AM
Axel Schwenke

Yellowfin Business Intelligence have released a whitepaper detailing their technical approach to a SAAS integration and deployment. Download Link...

JTP PR

09-21-2010 06:35 AM
JTP PR

Dear Friends, I've received lately quite common (as I've researched) error, which occurs as following: Commands out of sync; you can't run this...

Przemek M. Zawada

09-19-2010 01:16 PM
Axel Schwenke

In the ndc column there were some imported rows from Excel with scientific notation. I am trying to find those rows using preg_match so I can...

jr

09-17-2010 06:51 PM
Jerry Stuckle

Hi folks. I've become a little stuck trying to work out how to JOIN two tables in what is maybe a rather unconventional way... For the following,...

Andrew C.

09-16-2010 11:43 AM
Lennart Jonsson

Dear Friends, I was wondering, whether it's possible to arrange query results in such order: Let us image I have two tables: Stages ( int...

pmz

09-15-2010 05:05 PM
Przemek M. Zawada

I have a table with about 8 million rows. I want to select a small random subset of them (about 1000). What I'm doing now is simply "select id from...

Roy Smith

09-15-2010 08:49 AM
Captain Paralytic

I'd like to get dumps of each mysql table into separate files. The manual indicates that the syntax for this is mysqldump db_name Which indicates...

steve lefevre

09-15-2010 08:44 AM
steve lefevre

Why doesn't this work? 7000 rows have the length less than 11 digits but none of them get left padded. The ndc column is int(11). tnx, update...

jr

09-15-2010 01:39 AM
Álvaro G. Vicario

I have two tables: client_account | CREATE TABLE `client_account` ( `id` int(15) NOT NULL auto_increment, `acc_id` char(15) NOT NULL, `live`...

David

09-14-2010 10:02 AM
Captain Paralytic