Re: finding max values

Keith >i'm trying to find the max value of a certain field and return a field linked with the max value. The tables: >planets-- >population >government >sysID >systems-- >sysID >For examples sake lets say we are searching through three sysID's. For each sysID I want to look in planets and >calc

hello , Can I ask you a question about"MFC + ODBC + MYSQL"

hello , mysql .　　first,sorry for my poor english . I'm used CRecordSet to connected database of mysql(linux) . Read source data no error , but can't write data , has a "memory allocation error" error in used CRecordSet::Update() . into debug , this error ( CATCH_ALL(e) { lResult = AfxGetT

finding max values

g'day, i'm trying to find the max value of a certain field and return a field linked with the max value. The tables: planets-- population government sysID systems-- sysID For examples sake lets say we are searching through three sysID's. For each sysID I want to look in planets and calculate

REGEX in an Order By clause

How do I use a REGEX expression in the Order By clause? I have a column which contains data that looks like this, A002C A001 A1000C B100AA CAR A023 I use a query like this that sorts everything but the occasional last aphla character Select field From table Order BY Left(1,field ). Right(fi

understanding foreign keys

I am a new user trying to learn mysql (using InnoDB tables, mysql version 3.23.54) and to create a useful database for a project I am working on. In trying to understand how to use foreign keys effectively, I studied examples at http://sqlzoo.net - "A Gentle Introduction to SQL" I am trying to und

RE: Basic Setup Questions!!!!

Jeremy: Yes I tried the "GRANT ... " and few others. Finally it HIT me (after two weeks). I installed the MySQL master server on "data" server, which can't be accessed from the Class C IP addresses (see my setup below). I used "mysqlcc" GUI display and changed the server to "datal" and I started a

Re:

[EMAIL PROTECTED] wrote: Description: How-To-Repeat: Fix: Submitter-Id: Originator: root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity:

Aliases and bookmarks

There are some things I do in mysql often, is there some way to alias or otherwise bookmark a a sql statement for simple rapid use in the future? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com

re: Basic Setup Questions!!!!

Have you tried: GRANT privileges ON database.* TO 'jupiter'@'192.168.6.%' IDENTIFIED BY 'sunrise'; See: http://www.mysql.com/doc/en/GRANT.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Table is "Read Only"

Smartyone wrote: The database used to work, but then something must have broke, because now it is suddenly Read-Only (reports Read Only when I try to add a record using MySQLCC). Make sure the owner and group of the database files is set to mysql. -- MySQL General Mailing List For list archiv

Basic Setup Questions!!!!

Hello List: After two weeks of struggling, I need help!! My setup: T1 to Internet Backbone | Cisco 26XX 12.21.237.1

Re: How to minimize Master-Slave Traffic during replication <- Activating slave_compressed_protocol question

"Lutz Maibach" <[EMAIL PROTECTED]> wrote: > Hello Sasha, > > thanks for your advise, but I'm not shure whether I understand how to > find out if the master is offering (and using) the compressed protocol. > When I execute the strings-command, I get can see the string > "slave_compressed_protocol"

Re: Is there an update limit

"John Berman" <[EMAIL PROTECTED]> wrote: > Hi > > Using MYSql 4.x > > I'm trying to execute the following in MySQL Control Center > > INSERT INTO jgsurname_index ( type, surname ) > SELECT mc_JewishChronicle.type, mc_JewishChronicle.SURNAME > FROM mc_JewishChronicle; > > It works fine but only

Table is "Read Only"

I've seen this similar issue in other postings, but haven't found a way to correct it. I haven't found any help in the manuals, either, so please someone explain what this is about. MySQL v. 4.0.15 SuSE Linux 9.0 Database is very small: 6 tables, largest table around 5k. Ownership is mysql:root

mysql@lists.mysql.com

>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release:

Re: error in nested query?

Subselects are only available from 4.1 - that's why you have an error. Terry --Original Message- > Hi all > I have Mysql 3.23.45 on linux. > > while trying this command : > SELECT outbox_id > FROM outbox > WHERE send_time=(SELECT MAX(send_time) FROM outbox WHERE > subs_id=

error in nested query?

Hi all I have Mysql 3.23.45 on linux. while trying this command : SELECT outbox_id FROM outbox WHERE send_time=(SELECT MAX(send_time) FROM outbox WHERE subs_id="myid"); I encounter this error: ERROR 1064: You have an error in your SQL syntax near 'SELECT MAX(send_time) FROM outbox WHERE subs