I have a query that involves joining 4 tables. Each of the tables has many columns but my query involves a small subset of the columns from each of...

Joe Hesse

03-23-2011 02:32 AM
John Nagle

Hi, this may sound ridiculuos but i want to know how can i insert a polygon into database, if i only know the radius of the polygon. Like i have a...

shashi kanth

03-23-2011 02:25 AM
John Nagle

I have a database for an annual festival with an awards contest. For each year, there are a number of entries. So I have a table for FestivalYears,...

Steven Lefevre

03-21-2011 07:27 AM
Captain Paralytic

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

me

03-21-2011 03:27 AM
me

I'm developing a project about little soccer league. I need to store teams, team's players, matches info (which are two teams involved in the match),...

Mariano C.

03-19-2011 05:09 PM
Luuk

I have a series of mysql stored procedures that query thousands of records over 60 tables. these are quite slow and user has to wait 10 or 15minutes...

terry433iid@yahoo.com

03-17-2011 03:44 AM
Álvaro G. Vicario

I have a column that is my primary key... it has PK and NN checked off in MySQL Workbench table editor... However software is able to write a record...

SpreadTooThin

03-16-2011 10:14 AM
SpreadTooThin

Hi, I am pleased to announce the release of ODB 1.2.0. ODB is an open-source object-relational mapping (ORM) system for C++. It allows you to...

Boris Kolpackov

03-16-2011 10:05 AM
Boris Kolpackov

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

me

03-14-2011 03:27 AM
me

Hello *, I'm trying to use mk-table-checksum in a situation where a slave does not have all the databases from the master: Master has: DB1, DB2,...

DBA-Dont_Bother_Asking

03-10-2011 05:12 AM
DBA-Dont_Bother_Asking

I'm not sure how to even ask about this, nor how to phrase this for Google, but here it goes. I have a table, category, eg: CREATE TABLE...

Adrienne Boswell

03-08-2011 05:20 PM
Adrienne Boswell

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

me

03-07-2011 04:29 AM
me

Hi there, i don't know if i'm in right Ng, but i'd ask you something bout access database query. I have got a db with a table so ID ITALY...

Giovanni Militano

03-07-2011 03:31 AM
Álvaro G. Vicario

Hello, Using MySQL, i'm selecting a list of songs in spanish that i would like to sort. Here's a demo of the list of names that is returned by the...

SM

03-06-2011 02:53 PM
Jerry Stuckle

Hi, I want to use mysqldump to back up by database. If I have to restore the database to another MySQL server I would like all the grants and...

Joe Hesse

03-06-2011 01:42 AM
Gordon Burditt

I have a table that I want to copy selected fields into another table. The footprint of the tables is different. Here is the INSERT I am trying to...

bruce

03-05-2011 10:28 AM
Peter H. Coffin

VTD-XML 2.10 is now released in Java, C#, C and C++. It can be downloaded...

dontcare

03-04-2011 11:42 PM
dontcare

What does the 'like' expression look like for a zero length string? select * from x where something Like %%

SpreadTooThin

03-03-2011 10:25 PM
Doug Miller

Hi guys I have a table where rows are inserted each time someone visits any page on a site. Something like: table site_visits: creation_date...

pac Man

03-03-2011 09:14 AM
Kees Nuyt

How come this one works SELECT DISTINCT a.d FROM a,b WHERE a.c NOT IN (SELECT b.c FROM b) but this one doesn't SELECT DISTINCT a.d,a.c FROM a LEFT...

jrough

03-02-2011 06:06 PM
Lennart Jonsson

I've got a table where 2 of the columns are dates, Date1 and Date2. One of the columns (Date1) can be null (0000-00-00). I want to query the db so...

Chris W

03-02-2011 03:23 PM
Luuk

International Business Intelligence (BI) software vendor, Yellowfin, has confirmed its place as a leader in Mobile BI, blitzing Howard Dresner’s...

mehrapeak@yahoo.com.au

03-02-2011 08:30 AM
Peter H. Coffin

Table products (id, price, description). Some values: 1, 25.00, jacket 2, 110.00, jacket 3, 32.00, pants 4, 5.00, hat I would like to extract the...

MacMax

03-01-2011 08:04 PM
onedbguru

Nagesh S K wrote: Mr Nagesh. I have already done something similar, which may be of use. The very first step you must take is not to create...

The Natural Philosopher

03-01-2011 07:38 AM
Doug Miller

Hello, I had an incorrect script, which attempted to INSERT a row with the incorrect number of values. I got back a "bad insert" error. I've...

Bint

03-01-2011 05:21 AM
Brian Cryer

Is there a limit to the number of columns a table can have ?

richard

02-28-2011 04:53 PM
Beauregard T. Shagnasty

I've get this error during a SP call on a ISP shared MySQL server. perror 24 says that OS error code 24: Too many open files Ok... It's almost...

Mau C

02-28-2011 03:27 PM
Peter H. Coffin

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

me

02-28-2011 04:34 AM
me

Table a Row1: id=1, text=row1 Table b Row1: id=1, otherfield=2, text=row2 Row2: id=1, otherfield=1, text=row3 Here is the SQL: SELECT a.text,...

keytostars

02-27-2011 12:29 PM
Tony Mountifield

International Business Intelligence (BI) software vendor, Yellowfin, has confirmed its place as a leader in Mobile BI, blitzing Howard Dresner’s...

JTP PR

02-27-2011 06:24 AM
JTP PR

Hi, How to count rows WHERE category="x" AND date BETWEEN (first d of month) AND (last d of month) for every day? For category='x' in march...

L

02-26-2011 05:32 PM
L

I have an sql statement that needs to be executed of a list of parameters. say for example I have a table of Clients SELECT LastName, Nationality...

SpreadTooThin

02-25-2011 07:32 PM
Norman Peelman

The .err file contains these messages: 100605 14:27:02 Plugin 'FEDERATED' is disabled. C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld:...

Joe

02-25-2011 02:30 PM
Mauricio

Hi, MySQL NB here. Got a MySQL on linux. When connecting from the local machine (mysql -u<user> -p<password>) I can log in. When trying from my Win...

Ran Shenhar

02-25-2011 02:28 PM
Mauricio

Hi, Is it possible for a single text column to support multiple character sets (i.e. chinese, japanese, greek...). I'm creating a language flashcard...

bizt

02-25-2011 10:11 AM
Peter H. Coffin

Hi, i have inserted a polygon with points into a mysql database. Now how can i retrieve back the points associated with this polygon? (hopefully in...

shashi kanth

02-25-2011 09:49 AM
Lennart Jonsson

I was just prototyping a select on a single table, when I noticed that the order of what came out, was rather weird. There is an autoincrement on...

The Natural Philosopher

02-25-2011 07:57 AM
The Natural Philosopher

I Need to call one procedure inside other procedure: MainProcedure begin ... call AnotherProcedure(); end

Felipe Aron

02-23-2011 03:27 PM
Lennart Jonsson

Hi guys! What are you using for connection pooling, for read/write queries separation in your applications? MySQL Proxy? SQL Relay? Some other stuff?

vadim

02-22-2011 05:37 PM
Axel Schwenke

I'm running a test Cluster (5.1.47-ndb-7.1.8-cluster) with two SQL nodes and two NDB nodes. The MGM daemons run on the SQL nodes. The machines are...

Theodore Hope

02-21-2011 02:08 PM
Theodore Hope

I'm trying to match certain Unicode code points in a select query but all my attempts and lots of searching on the net failed. (Actually, I want...

Kai Schaetzl

02-21-2011 08:31 AM
Kai Schaetzl

Ok so I scrapped the version I had installed and downloaded straight from the true source. Downloaded 5.5 and went through one install procedure. Got...

richard

02-21-2011 08:09 AM
Jerry Stuckle

I can't find a site that will help me even get started with the bare basics. One site did show how to enter services.msc and setup things on...

richard

02-21-2011 05:47 AM
Álvaro G. Vicario

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

me

02-21-2011 04:37 AM
me

Hi, I'm using MySQL 5.1.42. I'm trying to create a function, but running into some syntax errors taht I can't figure out. The function is CREATE...

Dave

02-20-2011 04:24 PM
Lennart Jonsson

Hello, I want to update the nb_mail column with this query but the select query returns empty results in same case while i need 0 value. An idea...

Julien Arlandis

02-20-2011 04:10 PM
Lennart Jonsson

Finally got the basic mysql installation solved and is up and running. Now I'm trying to figure out how to work in the workbench, which makes life a...

richard

02-20-2011 02:52 AM
Erick T. Barkhuis

I'm hoping that Axel can answer this one for me. I have a need to add row numbers to the result set of a query, to give ranking within a particular...

Captain Paralytic

02-19-2011 07:43 PM
The Natural Philosopher

Hi, I have a table Faculty where the SQL "SELECT * FROM Faculty;" works fine. I would like to have the table "Faculty" be retrieved from a...

Joe Hesse

02-18-2011 11:42 AM
Axel Schwenke

I have problem joing tables. one table is user table the other one is user role table and one user can have multiple roles I want to find out if...

cake-learner

02-18-2011 07:19 AM
Lennart Jonsson