Jpg file insertion

Hi, I want to store jpg files to BLOB field of a table. That table has other fields which are integer and char types. So i tried inserting image using LOAD DATA INTO .. statement . It got stored , but when i retrieve it back , i'm not able to see the image file.I hope it didn't get sto

is mysql compatible with C++???

Hi, is mysql compatible with c++ in linux? I cant seem to get it working any sample c++ script would do. thanks in advance. dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: access denied

What's user are you logged with when you're trying these commands? It looks like you specified no user when launching the mysql console. Try with user root if you have access to it. You don't have enough rights to perform your commands without a user specified. Lian Sebe, M.Sc. Freelance Analyst-P

Re: Faster reindexing

Yep... im using fulltext indexes That is, multiple indexing would be the best. Nut now i add more memory and do some fine-tuning on my.cnf, perhaps the result won't be the same. "Me fail English? That's unpossible" ###___Archon___### - Original Message - From: <[EMAIL PROTECTED]> To: <[

RE: Inserting HTML page to TEXT fails... syntax error?! (Python MySQLdb)

> -Original Message- > From: Paul DuBois [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 17, 2003 9:38 PM > To: Nick Arnett; [EMAIL PROTECTED] Well, Paul, just knowing you were on the job inspired me and I finally realized the dumb thing I'd done. The list I'm iterating, urls, comes from

Re: Faster reindexing

umm say i reindex after a reimport i usually drop all the indexes first , then add indexes again one by one , seems to be quicker for me especially for fulltext indexes , doing it at once tends to be slower, must crunch the cpu a bit dont know > On Wed, Jul 09, 2003 at 11:51:01PM -0500, Paul DuBoi

Re: Inserting HTML page to TEXT fails... syntax error?! (Python MySQLdb)

At 20:49 -0700 7/17/03, Nick Arnett wrote: My hair... I am ready to tear it out. I've been working with Python and the MySQLdb module for a long time, thought I couldn't get snagged by anything, but today I just can't seem to persuade the blasted thing to let me stick an HTML document (a string) i

Re: utf8 support

At 23:03 +0200 7/17/03, Yves Goergen wrote: > >2. What about fulltext search on UTF8 strings? Unavailable. Eh? Why should this be a special DB feature at all? Correct me if I'm wrong (I didn't have very much contect with fulltexts yet), but can't I just give mysql an UTF8 string to search in an

Re: Faster reindexing

On Wed, Jul 09, 2003 at 11:51:01PM -0500, Paul DuBois wrote: > At 14:14 +0700 7/9/03, Dominicus Donny wrote: > >Sorry, my mistake. It's "reindexing" then. > >Once i should add 2 key indexes on a huge table. > >But instead of alter the table in 1 single query, > >I build each index 1 by 1. > > Gene

Inserting HTML page to TEXT fails... syntax error?! (Python MySQLdb)

My hair... I am ready to tear it out. I've been working with Python and the MySQLdb module for a long time, thought I couldn't get snagged by anything, but today I just can't seem to persuade the blasted thing to let me stick an HTML document (a string) into a TEXT column. I'm getting SQL syntax

access denied

mysql> CREATE DATABASE csttrainrep -> ; ERROR 1044: Access denied for user: '@localhost' to database 'csttrainrep' mysql> GRANT ALL ON csttrainrep. TO helen -> ; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right

MySQL binaries on a K6-2?

Hi all. Another question... I'm trying to diagnose a problem I'm having with MyISAM tables, and it was recommended that I use the binaries instead of compile MySQL myself. I noticed the binaries have 'i686' in their name. Does this mean they are optimised for an i686, or will only work on an i6

Re: mysqld starts and ends

check /usr/local/var/servername.err /.log or whereever your data files are.. perhaps it can't bind to an ip address or something like that.. the logfile might help.. On Thu, 17 Jul 2003, Helen wrote: > when I enter: > cd /usr/local/mysql > sudo chown -R mysql data/ > sudo echo > sudo ./b

mysqlimport question

Hi all I have some data in Excel ( I didn't put it there - a customer did ). I'm setting up an import routine for it, with an Access front-end. I don't like the way Access imports Excel files, though, and I'm thinking about getting the user who will import it to first open the spreadsheet and sa

mysqld starts and ends

when I enter: cd /usr/local/mysql sudo chown -R mysql data/ sudo echo sudo ./bin/mysqld_safe & mysqld starts and ends. I am using a Mac with OSX 10.2.4 and have installed 4.0.4 Any assistance would be greatly appreciated! Helen

Re: Changing ENUM Values

Hi Aaron, that would need to be accomplished in 3 several steps I believe. 1) Add the prurple option with an ALTER command 2) REPLACE Blue with purple 3) ALTER the enum type again (remove blue option) While I dont understand the meaning/background on this it might be a good idea to keep the va

Changing ENUM Values

So I've got fairly big sized table (20,000 records) which has an ENUM row. I need to change the name of one of the ENUM options. For example, if the ENUM value was 'blue' before, it needs to be 'purple' now. What's the best way to do this? Thanks, -Aaron --- Aaron Blew Jackson Cou

* HELP * MySQL Connection Issue - Access Denied!!

.I just sent this out to the win32 distribution list but no one has replied.can someone on this list please help? The issue should be trivial for experienced MySQL users, I'm just a novice, thanks! Anyone - I've been racking my brain for the majority of the day and scouring through the MySQL

Re: Java API to mySQL

> Hello > > I want to know if there is java API to mySQL like its available for C > and C++. > > Bye > Kalika > > SMS using the Yahoo! Messenger;Download latest version. Look for Connector/J on the MySql site. William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061

Re: too many connection error driving me nutz, need advice

On Thu, 17 Jul 2003, Eben Goodman wrote: > This comment confuses me: > I have seem some sites code that actually open multiple connections to the > same database.. I have worked on some larger sites that 30+ past and current developers worked on.. Some good, some terrible.. The code typically

Show Status data

I'm developing a net-snmp module that executes a 'show status' command on a MySQL server and advertises the values. My choices seem to be super concrete: one server, one set of results, the variables don't change, ever... moderatly concrete: multiple possible servers, one set of results each, t

Re: too many connection error driving me nutz, need advice

This comment confuses me: I have seem some sites code that actually open multiple connections to the same database.. If I am using php's mysql_connect() function, then every time a query is run this function gets run. Wouldn't this mean that for every query a new "connection" is opened to the s

Re: utf8 support

On 17 Jul 2003 at 23:03, Yves Goergen wrote: > > >2. What about fulltext search on UTF8 strings? > > > > Unavailable. > > Eh? Why should this be a special DB feature at all? > Correct me if I'm wrong (I didn't have very much contect with > fulltexts yet), but can't I just give mysql an UTF8 stri

Re: utf8 support

> >2. What about fulltext search on UTF8 strings? > > Unavailable. Eh? Why should this be a special DB feature at all? Correct me if I'm wrong (I didn't have very much contect with fulltexts yet), but can't I just give mysql an UTF8 string to search in an UTF8 column (/data)? Shouldn't this wor

Re: too many connection error driving me nutz, need advice

DOh! i mean script_append part ;) .. basically it's a garbage collector.. On Thu, 17 Jul 2003 [EMAIL PROTECTED] wrote: > > Suggestion.. make a small script called closeall.php .. basically it has > some code to force closed the mysql connection opened (be sure to run a > close for all opene

Join using temporary, filesort

I asked this a couple days ago, but never got an answer, so I'll try to include some more detail: MySQL 4.0.12 on linux 2.4.18... I'm doing a join on 2 tables and trying to optimize it but I always end up with "Using temporary; Using filesort" and the query takes way too long... What can I do to

Re: too many connection error driving me nutz, need advice

Suggestion.. make a small script called closeall.php .. basically it has some code to force closed the mysql connection opened (be sure to run a close for all openened handles) I have seem some sites code that actually open multiple connections to the same database.. Add this file into php.ini u

Security question: Possible to hide table structure? I couldn't find...

Hello,   Think that we have a database named DATABASE1, and table named TABLE1, and fields named FIELD1, FIELD1,FIELD2,FIELD3,FIELD4   You want to give a specific permission to a user named USER1   For ex, you give only SELECT permission to USER1 for FIELD1 and FIELD4 in TABLE1 and DATABASE1.

too many connection error driving me nutz, need advice

I run a site that gets a fair amount of traffic throughout the day. For days at a time the site runs smoothly, and then, at seemingly random intervals I get the mysql error "Too many connections". The only solution for this is to stop the mysql service and restart it. I changed the max_conne

Re: Sun Cobalt Web Server RTX

For my Cobalt server, I just d/l th mysql build from the Cobalt website (which is now @ sun.com) . And it worx just fine. Saqib Ali - http://www.xml-dev.com On Thu, 17 Jul 2003, Clint S. Jones wrote: > What type of MySql can I install on a cobalt web server??? Please help... not > sur

Re: Getting table comments

At 14:29 -0500 7/17/03, Jackson Miller wrote: I have a short and simple question that I can't find an answer to. Is there a way to return table comments with a query? SHOW CREATE TABLE t; SHOW TABLE STATUS LIKE 't'; Thanks, -Jackson -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA

Re: utf8 support

At 17:25 +0300 7/13/03, Sagi Bashari wrote: Hello, I would like to know the status of the UTF8 support in MySQL 4.1. I tried to create a table using utf8 charset, and inserting hebrew text into it. it seems like it still treats this text as binary - for example the length() function returns 8 o

Getting table comments

I have a short and simple question that I can't find an answer to. Is there a way to return table comments with a query? Thanks, -Jackson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: encryption/authentication

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John Jolet wrote: > I need to find out if it's possible to do two things with mysql. > The first is external authentication, preferably with kerberos5, but PAM will work as well. No. > Second, encrypting the data stream. Specifically with jdbc conn

Re: Java API to mySQL

Welcome to the word of JDBC ... mysql calls it connector/j @ http://www.mysql.com/products/connector-j/index.html On Thu, 17 Jul 2003, [iso-8859-1] kalika patil wrote: > Hello > > I want to know if there is java API to mySQL like its available for C and C++. > > Bye > Kalika > > SMS using the Y

Re: Sun Cobalt Web Server RTX

If you have a compiler.. probably any version you want... I'm pretty sure I've compiled mysql on an older qube in the past (took forever).. Cobalt may have binary distribution packages available for download.. I'd check their site first.. may save you some time... On Thu, 17 Jul 2003, Clint S

Sun Cobalt Web Server RTX

What type of MySql can I install on a cobalt web server??? Please help... not sure... Clint S. Jones Computer Teks, Inc. President 1520 East Sunrise Blvd. Suite: 202 Fort Lauderdale, FL 33304 (954) 465-5516 (954) 767-6150 fax [EMAIL PROTECTED] www.webingenuity.net

Java API to mySQL

Hello I want to know if there is java API to mySQL like its available for C and C++. Bye Kalika SMS using the Yahoo! Messenger;Download latest version.

Re: JOIN with php

- Original Message - From: "Viorel Dragomir" <[EMAIL PROTECTED]> To: "Patricio Gigoux" <[EMAIL PROTECTED]>; "mysql groups" <[EMAIL PROTECTED]> Sent: Thursday, July 17, 2003 9:25 AM Subject: Re: JOIN with php > Can u apply the standard list of rows to your query. > Like: > > $result = pg_

Re: Working with the text datatype in MySQL

Lekeas GK wrote: Hi All, I am managing a small database and some of the tables need to be strings of an average length of about 2,000 characters. I decided to use the text datatype to store this information knowing that the upper limit is about 65,000 characters. However, the system crashes whe

Re: mysql.sock

Hello all, after Installing mysql I started the mysql daemon.. The I tried to log in to my mysql database and got the message could not find mysql.sock in /tmp. In the mysql-configuration file /etc/my.cnf (in my redhat system 8.0) I changed the place for the socket file from "socket=/var/lib/mys

How to enter iso-8859-2 characters through command line client?

Hi, We're trying enter polish language into mysql. My understanding is that polish language uses iso-8859-2 character set. I am cutting and pasting polish text from a web browser (Konqueror) into the mysql command line client running in a terminal window (konsole). MySQL server is version 4.

Working with the text datatype in MySQL

Hi All, I am managing a small database and some of the tables need to be strings of an average length of about 2,000 characters. I decided to use the text datatype to store this information knowing that the upper limit is about 65,000 characters. However, the system crashes when the user tries t

Re: Difference of MySQL Standard and Max Version

In the last episode (Jul 16), Jeremy Zawodny said: > On Mon, Jul 07, 2003 at 10:57:52AM -0500, Dan Nelson wrote: > > In the last episode (Jul 07), Nils Valentin said: > > > Thank you for the superfast reply. I actually was looking for > > > other information. I understood the actual feature differe

Warning: thr_alarm queue is full errors and panic with invalid backtrace

>Description: I'm running mysql in a 3 server configuration, with 2 servers being slaves to the first. I'm running vpopmail, which means a connection every incoming mail and every check. I woke up this morning to a mysql that wasn't answering connections, and that had left this in the log: 030716

Re: join query result difference between 3.23.49 and 4.0.13

hello victoria, thanks for your response. however, the real goal of my question still remains unanswered: given my sample data, how would i find the balance on an invoice with one sql statement. sure, i could query for the amount paid, then in a separate query subtract the result from the in

Re: Select via Perl

Ashwin Kutty wrote: I am trying to read a file and see if the contents of it exists in the DB or not and am trying to do it via a Select. I try to do a select * into outfile /tmp/result.txt from table where field like "%$var%"; but it always goes through the first two lines of the input file and

Warning: thr_alarm queue is full errors and panic with invalid backtrace

>Description: I'm running mysql in a 3 server configuration, with 2 servers being slaves to the first. I'm running vpopmail, which means a connection every incoming mail and every check. I woke up this morning to a mysql that wasn't answering connections, and that had left this in the log: 0307

RE: i need help, innodb blocks insertion into table for a while

hi i solved the problem by executing the commit after the select. best regards benny

Re: Another mysql config help...

"Ola Ogunneye" <[EMAIL PROTECTED]> wrote: > > Let me start out by saying that I am still a newbie. I just freshly > installed mysql version 4.0.13. > > The following are the steps that I took. > > Unzipped the binary file in a windows directory. > Ran setup > > Edited my-small.cnf and changed

complex query qusetion

Hi, I'm looking at some search engine where we can have up to 14-15 categories and each categories have about 5-10 option (checkbox) my question is if we have a complex query like this would it be better to split some categories in tables i.e we have 21 different categories should we have 7 tabl

Select via Perl

I am trying to read a file and see if the contents of it exists in the DB or not and am trying to do it via a Select. I try to do a select * into outfile /tmp/result.txt from table where field like "%$var%"; but it always goes through the first two lines of the input file and then says the file al

Help!!!

Hi I am trying to extract two lots of information from one table but in such a way as to maintain the relationship between the two entities. I.E.: Table A ID NAME WORK HOME ^ 1 Jon A null 2 TracyA n

Re: Is MySQL cluster capable?

Broadl;y speakng, no. See http://www.mysql.com/doc/en/Multiple_servers.html . There are single writer/multiple reader configurations that can be achieved using replication - see the replication section of the manual. Alec -- Can two mysql processes (ru

mysql.sock again

Hello all, after Installing mysql I started the mysql daemon.. Then I tried to log in to my mysql database and got the message could not find mysql.sock in /tmp. In the mysql-configuration file /etc/my.cnf (in my redhat system 8.0) I changed the place for the socket file from "socket=/var/lib/my

Re: Is MySQL cluster capable?

Im thinking of using OpenMOSIX for that kind of clustering (load balancing and shared filesystem/storage). But it doesn't support application that uses shared memory. That's including Oracle, MySQL, etc... But the shared storage feature gonna be useful for our hundred gigs of images :) "Me fail En

Re: JOIN with php

sorry [my unfortunate mistake] disregard the pg_ [stuff] and consider mysql_ instead [mysql_query($query)] - Original Message - From: "Viorel Dragomir" <[EMAIL PROTECTED]> To: "Patricio Gigoux" <[EMAIL PROTECTED]>; "mysql groups" <[EMAIL PROTECTED]> Sent: Thursday, July 17, 2003 4:25 PM

Re: JOIN with php

Can u apply the standard list of rows to your query. Like: $result = pg_exec($db, $query); while($row = pg_fetch_row($result)) print_r($row); - Original Message - From: "Patricio Gigoux" <[EMAIL PROTECTED]> To: "mysql groups" <[EMAIL PROTECTED]> Sent: Thursday, July 17, 2003 4:19 PM

JOIN with php

Hello: I am making a php script, and I have the next problem: SELECT * FROM alo LEFT JOIN alo_resp ON alo.id=alo_resp.id result is: iddescpriceiddesc 1gg81dd 9 3df53 ff but if I do the same in mysql

Is MySQL cluster capable?

Can two mysql processes (running in different machines) access and work with the same database files in a shared storage scenario? Would there be any problem? Thanks :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

finding user details inside UDF

hi! i heared that its possible to get user details inside the UDf by adding the mysql_priv.h header file. But where will this file be available. i am using MySql 3.23.52 on linux8.0 when i try to compile it says :"mysql_priv" file not found. If i can include this file, i can get the thread c

Another mysql config help...

Hello all, Let me start out by saying that I am still a newbie. I just freshly installed mysql version 4.0.13. The following are the steps that I took. Unzipped the binary file in a windows directory. Ran setup Edited my-small.cnf and changed it to my.cnf saved it in the root of my C-drive..

server doesn't take all options out of my.cnf

My problem is, that all variables except "wait_timeout" are initialized from the my.cnf file, only "wait_timeout" is always set to the standard value... Has anyone the same problem? Does somebody know how to resolve it? Moritz

OT: Signing off for a while

I will be gone from the list until further notice. Unfortunately, the volume of email and volume of work do not coincide well. Should anyone need to contact me, please do so directly. Thanks a lot, and sorry for the OT. Edward Dudlik Becoming Digital www.becomingdigital.com -- MySQL Genera

Re: Delete all but (n) most recent records?

Hi, I've got the same kind of problem, though I need to keep the top 150 rows after a order has been done. DELETE FROM table WHERE date='2003-07-08' ORDER BY count DESC LIMIT 150,-1; Though it doesn't seem to like the -1, but this works ... SELECT * FROM table WHERE date='2003-07-08' ORDER BY c

Re: Question again : mysql.sock

"Oliver Etzel - GoodnGo.COM \(R\)" <[EMAIL PROTECTED]> wrote: > >> If you change path to the socket file for the server, you must > change it to the clients, too. > How can I change the path to the socket file for the mysql clients??? > Are there any config-files or shall I have to put a ln -s - l

Re: mysql connection error

"zafar rizvi" <[EMAIL PROTECTED]> wrote: > hi > I am running one centralized mysql server, its runnig fine and conneded with > localhost and his own ip very fine. > But when i want to connect him from remote system or other lan system > it give me errror like that. > > [EMAIL PROTECTED] root]# mys

RE: mysql setup compared to oracle

Hmmm... right. You can compare the server to the instance. And the user to the DB (in the scheme, not at authentication) Thanx for the pointer! /rudy -Original Message- From: Jim Smith [mailto:[EMAIL PROTECTED] Sent: donderdag 17 juli 2003 11:06 To: Rudy Metzger; 'Harald Falkenberg';

RE: join query result difference between 3.23.49 and 4.0.13

I also fell into this NULL trap. Make sure to read the change log concerning NULL values! They are still buggy (imho) and with every change I have the feeling that new bugs/features are introduced. Example: Select sum(1) from foo where 1 = 3; This statement actually returns a row with NULL. Whic

RE: mysql setup compared to oracle

> 1. No, especially not MyISAM. In MyISAM, a database (you can compare > that to instance) is just a directory on disk. Every table in this DB > (instance) again is file (well actually 3 files, one for data, one for > metadata, one for index information). Actually the server is equivalent to an

RE: mysql connection error

Also make sure that the port is not firewalled. Cheers /rudy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: donderdag 17 juli 2003 9:56 To: zafar rizvi Cc: [EMAIL PROTECTED] Subject: Re: mysql connection error Keep in mind you need 2 things to happen: A) th

RE: mysql setup compared to oracle

I'm fairly new to mysql myself, but I'll have a go. The mysql manual is at http://www.mysql.com/doc/. I've only dipped into it, but it seems to be pretty good. > Questions: > > 1. is mysql simular organized as oracle: instance/users/tables, > so that I have to connect to chossen instance a

Re: MySQL Config

"Tomer Zverling" <[EMAIL PROTECTED]> wrote: > Hi, > > I have installed MySQL on Windows98se twice under different paths, and then > deleted the second installation. When i run MySQL as usual using the line > "C:\Program Files\nusphere\mysql\bin\mysqld-opt.exe" , i get the following > error msg: >

Re: subselect question... shouldn't this work?

Ben Margolin <[EMAIL PROTECTED]> wrote: > > I am new to subselects, and what I really want is to do them in an update, > but the following shows a simpler select, that also doesn't seem to work as I > think it should. Advice? Do I just misunderstand how subselects are actually > executed? > > (Th

RE: mysql setup compared to oracle

1. No, especially not MyISAM. In MyISAM, a database (you can compare that to instance) is just a directory on disk. Every table in this DB (instance) again is file (well actually 3 files, one for data, one for metadata, one for index information). InnoDB looks a bit similar, as it also uses the co

i need help, innodb blocks insertion into table for a while

hi dear mysql list members i have setup a mysql database 4.013 with innodb enabled. when i set the transaction isolation level to serializable. after executing a specific query is the insertion into a table blocked for about 20 seconds. the table is defined as follows CREATE TABLE `slide`

Re: Question again : mysql.sock

Hello Egor, hello all, > If you change path to the socket file for the server, you must change it to the clients, too. How can I change the path to the socket file for the mysql clients??? Are there any config-files or shall I have to put a ln -s - link??? Oliver > >"Oliver Etzel - GoodnGo.COM

RE: Best practice column type for storing decimal currency amounts?

Hmmm The trainer on our "Managing MySQL" told us that they are stored as FLOATS/DOUBLES. But I could have wrong recollection of it, maybe he meant they are stored as strings and only CALCULATION is done with DOUBLES. I this case, I would trust the manual :) But still, it is no true monetary

Re: Question again : mysql.sock

"Oliver Etzel - GoodnGo.COM \(R\)" <[EMAIL PROTECTED]> wrote: > > after Installing mysql I started the mysql daemon.. The I tried to log > in to my mysql database and got the message could not find mysql.sock > in /tmp. > > In the mysql-configuration file /etc/my.cnf (in my redhat system 8.0) >

Re: Deleted index file (.MYI)

Hi! On Jul 16, Oswaldo Castro wrote: > Hi Everybody > > I have acidentally deleted an index file (.MYI) from a table. Is there > another way, besides its backup, to recover this table ? > > Thanks for any help Yes. Backup your MYD file (just in case) and try REPAIR ... USE_FRM or create dummy

Re: join query result difference between 3.23.49 and 4.0.13

Doug Reese <[EMAIL PROTECTED]> wrote: > > i have what seems to me a very common operation i'm performing. i need to > find the balance on an invoice. i was not having any problems until the > production server was upgraded to mysql v4.0.13-standard for > pc-linux. there must be a better way

Re: mysql connection error

Keep in mind you need 2 things to happen: A) the mysql server has to be bound/listening on the ip/interface you need it to be. This is typically configured in my.cnf configuration file. B) you need to ensure the mysql privlidges will allow access from other hostnames/ip addresses. If mysql isn

Re: mysql connection error

hi No its not listening and giving same error ERROR 2013: Lost connection to MySQL server during query how can i allow a ip to connect mysql database from other system. plz explain me little (i have not yet idea to use mysql fully) Thanks ZafAr - Original Message - From: <[EMAIL PROTECTE

Re: Unable to perform Inner Join

Hello Henry, Wednesday, July 16, 2003, 5:35:49 PM, you wrote: I've noticed 2 errors. First: You describe table with name: PUBLISHER but useing in SQL table PUBISHER - missing a letter "L" Second: As I'm understanding you want to make join table PUBLISHER with table TITLES. But see what you wrote

get a certain element in a GROUP BY

Hi, I am trying to control which element gets picked when I do a group by, but I can't figure out how to do it. First some example data: CREATE TABLE t ( id int not null primary key auto_increment, group_id int not null, level int not null); INSERT INTO t VALUES (1,1,2); INSERT INTO t VALUES (