RE: Handling Arrays

Sorry, I forgot that would help, I am using PHP 4, pulling from a mySQL database, I am trying to delete a record in an array before it gets written back into the table, should I be asking this in a PHP forum instead? I should have thought of that.

Handling Arrays

I have a quick question about arrays. I know that this is probably pretty easy for most of you out there, so here it goes. If you remove $array[2], would $array[3] then automatically become the new $array[2]? Thanks in advance for your help.

Re: how to code an 'IS - A' relationship ?

Morten, I'd like to help you with actual code, but I can't, because the version of MySQL I use doesn't implement foreign key constraints. In my own code (written in the C API), I plan on checking these constraints myself. But I can't implement them in the tables themselves. Best, Steve Fromm

InnoDB and lots of UPDATES

I have a question about InnoDB and how it would handle updates on the order of about 3,000-5,000 a second. The UPDATEs update a single record on a primary key. In MySQL, it does a table lock thus serializing the updates. There are a few selects, though on a couple of orders of magnitude less often.

SuperSmack on x86_64 / gcc 3.2.2

Anyone ever get super-smack to compile on this system? I get tons of warnings/errors that look like syntax errors almost. Not sure what I am doing wrong. I get a list of errors/warnings like this: c++ -DHAVE_CONFIG_H -I. -I. -I.. -I/mysql/include -g -O2 -c client.cc In file included from clie

Re: keeping a fulltext index in memory

On Tue, Sep 02, 2003 at 11:45:21AM -0700, Mark wrote: > Hi, > > I'm having problems with a fulltext indexed table where it takes a > long time return from a query where many rows match. I noticed that > when I run a query like > select count(*) from table where keywords like '%x%'; > > it takes

Re: InnoDB slow?

I just want to note the final figures after adjusting the log file size, setting innodb_flush_method=O_DSYNC and innodb_flush_log_at_trx_commit=0 the time was down to 2 minutes 52 seconds (from 10 minutes 37 seconds when I first attempted to use InnoDB) compared to 2 minutes 34 seconds with MyI

Re: Query not returning 0 count records....

Hi Mike, If you use a LEFT JOIN, I think you'll get the results you want. Something like SELECT afs.stat_date, afs.hits, COUNT(v.clientcode) AS signups FROM affiliate_stats AS afs LEFT JOIN vtconlineusers AS v ON (v.creation_date=afs.stat_date AND v.dealercode=afs.affiliate_id) WHERE affiliate_id

Re: Select from one table where ID not in another table - Solved

Finally worked it out, here's the query I'm using SELECT table2.TransactionID,table1.* FROM Table1 table1 LEFT OUTER JOIN Table2 table2 ON table2.TransactionID = table1.Transa ctionID WHERE table1.ReconciliationID = '8' HAVING table2.TransactionID IS NULL; Regards Marty - Original Message

Query not returning 0 count records....

In the following query: select afs.stat_date,afs.hits,count(v.clientcode) as signups from affiliate_stats as afs,vtconlineusers as v where affiliate_id='a280' and afs.stat_date between '2003-01-01' and '2003-09-31' and v.creation_date = afs.stat_date and v.dealercode=afs.affiliate_id group by afs.

[Stats] MySQL List Stats: August, 2003

List Archives: MySQL List Stats August, 2003 Note: Up/Down % as compared with July, 2003 Posts: 2148 (Down 16%) Authors: 608 (Down 1

Re: Select from one table where ID not in another table

SELECT tr.* FROM Table1 tr LEFT JOIN Table2 recTran ON tr.ReconciliationID=recTran.ReconciliationID WHERE (tr.ReconciliationID = '8' AND tr.TransactionID <> recTran.TransactionID) || recTran.ReconciledTransactionID IS NULL; Should work, I'm always not sure about the joins and which table should go

Round Robin Replication, Add a server; Renumber

I currently have three mysql machines replication from A-B-C-A type fashion. I need to replace A. I am thinking that I could add D and have it pull from C. Then once A is removed restart D as A. Is this a good way to do this or is there a better way that I should do this? Thanks! Lewis -- MySQL

Problem with my bin-logs in replication

Occasionally I will notice that one of my slaves is not in sync. It will be reading fine from the master's bin-log, but it gets hung up in the relay log and stops. It seems there is corrupt data in the relay log. When I use the mysqlbinlog utility, I get tons of "mysqlbinlog: Error writing file

runnaway mysql children processes

Hey everyone, I'd appreciate it if anyone on this list might be able to help us out with a problem we've been having with mysql lately. We are using mysql as a backend for a content management system on our site. We've been using it for awhile, and it has been working fine. However, we recently

Re: Select from one table where ID not in another table

I'm not sure if I've described the exact results I want very well, but thanks to everyone for your help so far, hope you can bear with me a little longer. Below are the table Descriptions Table1:- +---+---+--+-+-+ + | Field

Re: ERROR 1115: Unknown character set: 'latin1_de'

Simon wrote: > So, you'd want: > CREATE TABLE foo ( blah ... ) CHARACTER SET latin1 COLLATE > latin1_german1_ci; You can enforce a different character set by configuration, but how to setup for a non-swedish(!) collation ?? HansH -- MySQL General Mailing List For list archives: http://lists.my

Here is a free MySQL Quick Reference Card you can download

I found a terrific MySQL language reference card that you can print off and stick in your pocket. You can download it from http://www.digilife.be/quickreferences/QRC/MySQL-4.02a.pdf Have fun folding! :) Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To uns

RE: mysqlimport command question

>To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] >Subject: RE: mysqlimport command question > > >Darryl, > >Provide a copy of the table's details either with a describe >table output or >the table's definition and a sample of the input file's top 5-rows. > >Regards, >Adam OK, here is the table structur

Re: Select from one table where ID not in another table

Hi Marty, Yes, a query like this: SELECT t1.* FROM table1 t1 LEFT JOIN table2 t2 ON (t2.id=t1.id) WHERE t2.id IS NULL This assumes that table2.id is defined as NOT NULL. See also: http://www.mysql.com/doc/en/JOIN.html Hope that helps. Matt - Original Message - From: "Martin Moss" <[

Re: Select from one table where ID not in another table

select t1.* from table1 t1 LEFT JOIN table2 t2 on t1.id=t2.id WHERE t2.id IS NULL you can print out table2 values if you want, but they will all be NULL.. provided that table2.id and table1.id are the matches you are trying to find. Kelley Martin Moss wrote: > All, > > Am wondering if it's p

Re: Select from one table where ID not in another table

Sorry I missed out the difficult bit, query sould read:- SELECT table1.*,table2.id from Table1 AS table1,Table2 AS table2 WHERE table1.otherkeyid = '7236523' AND table2.otherkeyid = '7236523' AND table1.id DOESN'T EXIST IN table2.id; If there are NO entries in table2 for otherkeyid I still want

Re: Select from one table where ID not in another table

Sorry I missed out the difficult bit, query sould read:- SELECT table1.*,table2.id from Table1 AS table1,Table2 AS table2 WHERE table1.otherkeyid = '7236523' AND table2.otherkeyid = '7236523' AND table1.id DOESN'T EXIST IN table2.id; If there are NO entries in table2 for otherkeyid I still want

Re: Many Read and Writes...

Hi, If the index file is just 1k (the same size as an EMPTY table!), it sounds like you don't have any indexes. The 8.6MB table is probably at least a few thousand rows, right? Well, if all your queries are scanning the whole table, that would cause a few Table_locks_waited! :-) In order to help

RE: Select from one table where ID not in another table

Use LEFT JOIN SELECT t1.*, t2.id FROM table1 as t1 LEFT JOIN table2 as t2 ON t1.id=t2.id WHERE t2 IS NULL; <-- something like that --> -->-Original Message- -->From: Martin Moss [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, September 02, 2003 1:50 PM -->To: [EMAIL PROTECTED] -->Subject:

Select from one table where ID not in another table

All, Am wondering if it's possible to do a query that does something like this:- SELECT table1.*,table2.id from Table1 AS table1,Table2 AS table2 WHERE table1.id DOESN'T EXIST IN table2.id; Regards Marty --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://ww

Select from one table where ID not in another table

All, Am wondering if it's possible to do a query that does something like this:- SELECT table1.*,table2.id from Table1 AS table1,Table2 AS table2 WHERE table1.id DOESN'T EXIST IN table2.id; Regards Marty --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.

RE: mysqlimport command question

Darryl, Provide a copy of the table's details either with a describe table output or the table's definition and a sample of the input file's top 5-rows. Regards, Adam -Original Message- From: Darryl Hoar [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 4:31 PM To: [EMAIL PROTE

Re: InnoDB slow?

Hi! - Original Message - From: "Paul Gallier" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Tuesday, September 02, 2003 9:55 PM Subject: Re: InnoDB slow? > --060404050304080006000506 > Content-Type: text/plain; charset=us-ascii; format=flowed > Content-Transf

mysql replication question(s)

Hi All, I'm having a few issues getting things up and running in regards to replication. I believe I have everything setup correctly the slave is roughly in the same spot as the master as far as the logs are concerned. However, when I make changes in the master db I don't see them show up in the

mysqlimport command question

greetings, I have created a text file in windows (from a database) that has the format empnum name fname lname ext email listit bm bd hd bm, bd are integers and hd is date. I have tried to import using the follow command #mysqlimport -u root -pmypass -d --local iweb emp2.txt it imports the 97 r

mysql replication question(s)

Hi All, I'm having a few issues getting things up and running in regards to replication. I believe I have everything setup correctly the slave is roughly in the same spot as the master as far as the logs are concerned. However, when I make changes in the master db I don't see them show up in the

Re: Auto Increment ID of Inserted Row

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dan Greene wrote: > (newbie to MySQL) > > I've been banging my head against the wall on this one for a bit now, and I understand that last_insert_id() is per-connection based, but most webapps are connection pooled (simple) or clustered (harder). Wha

Re: Fwd: different between index and key when create table

> > From: Vivian Wang <[EMAIL PROTECTED]> > Date: 2003/09/02 Tue PM 02:16:26 CDT > To: [EMAIL PROTECTED] > Subject: Fwd: different between index and key when create table > > mysql: > > > >Can anyone tell me what is different between index and key when creating > >table? > >like this situation:

Re: Many Read and Writes...

Ahhh! Ok, yeah the index file was 1.0k and the data file was 8.6M. -James On Tue, 2003-09-02 at 12:17, Jeremy Zawodny wrote: > On Tue, Sep 02, 2003 at 11:23:57AM -0700, James Kelty wrote: > > Whoa, ok. Sorry. I didn't read the questions about the data and index > > files. I'm, uh, not exactly su

Re: Many Read and Writes...

On Tue, Sep 02, 2003 at 11:23:57AM -0700, James Kelty wrote: > Whoa, ok. Sorry. I didn't read the questions about the data and index > files. I'm, uh, not exactly sure how to tell that, can you give me a > hint there as well? *look sheepishly around*... Sure. First you need to figure out where My

Fwd: different between index and key when create table

mysql: Can anyone tell me what is different between index and key when creating table? like this situation: create table info ( fname char(9), lname char (15), address char(30), index(lname)); or create table info ( fname char(9), lname char(15), address char(30), key(lname)); Thanks.

different between index and key when create table

Can anyone tell me what is different between index and key when creating table? like this situation: create table info ( fname char(9), lname char (15), address char(30), index(lname)); or create table info ( fname char(9), lname char(15), address char(30), key(lname)); Thanks.

Re: InnoDB slow?

I've not a clue - digging around somewhere on the Internet. I didn't see the info in the manual regarding fsync being used as default for Linux, but now I also notice that my manual says version 4.0.5 Mikhail Entaltsev wrote: Paul, Where did you find information about 'littlesync' and 'n

keeping a fulltext index in memory

Hi, I'm having problems with a fulltext indexed table where it takes a long time return from a query where many rows match. I noticed that when I run a query like select count(*) from table where keywords like '%x%'; it takes a long time but after that all fulltext queries are much faster, I'm not

Re: Many Read and Writes...

Whoa, ok. Sorry. I didn't read the questions about the data and index files. I'm, uh, not exactly sure how to tell that, can you give me a hint there as well? *look sheepishly around*... -James On Tue, 2003-09-02 at 11:06, Jeremy Zawodny wrote: > On Tue, Sep 02, 2003 at 10:58:03AM -0700, James K

Re: Many Read and Writes...

On Tue, Sep 02, 2003 at 10:58:03AM -0700, James Kelty wrote: > Well, there isn't a my.cnf file, so other that setting the > max_connections with the -O option, it's whatever is default for > 3.23.56. Since you didn't answer the other questions, I'm going to do some guessing here... I'll guess tha

Re: mysqlbug

On Tuesday, September 02, 2003 7:20 PM CET, Gronquist, Jim M wrote: > Yves, > > Thanks so much! Yes, I was able to create the data directory and get > farther along. Now, when I try and start > > cd ~ > /etc/rc.d/rc3.d/S90mysql start > starting mysql daemon with db from > /usr/local/mysql/var > 0

Re: Many Read and Writes...

Well, there isn't a my.cnf file, so other that setting the max_connections with the -O option, it's whatever is default for 3.23.56. -James On Tue, 2003-09-02 at 10:50, Jeremy Zawodny wrote: > On Tue, Sep 02, 2003 at 10:37:34AM -0700, James Kelty wrote: > > So, we have a webmail application that

Re: Many Read and Writes...

On Tue, Sep 02, 2003 at 10:37:34AM -0700, James Kelty wrote: > So, we have a webmail application that uses a mysql server for holding > it's session information. Obviously this causes many > reads,updates,inserts, and deletes to happen. Here are my lock > statistics. > > | Table_locks_immediate

Many Read and Writes...

So, we have a webmail application that uses a mysql server for holding it's session information. Obviously this causes many reads,updates,inserts, and deletes to happen. Here are my lock statistics. | Table_locks_immediate| 73099 | | Table_locks_waited | 32187 | This ratio see

Re: mysqlbug

On Tuesday, September 02, 2003 5:01 PM CET, Gronquist, Jim M wrote: > shell> groupadd mysql > shell> useradd -g mysql mysql > shell> cd /usr/local > shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf - > shell> ln -s full-path-to-mysql-VERSION-OS mysql > shell> cd mysql > shell> scripts/mys

RE: Large query techniques

I may be missing something, but why not just do: SELECT CustomerName, ApplicationName, Status, COUNT(1) AS Count FROM LogMessage GROUP BY Status, CustomerName, ApplicationName with rollup; which should return all the data you need in 1 query, which has got to run faster than 4 seperate queri

Re: ERROR 1115: Unknown character set: 'latin1_de'

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 02 September 2003 5:40 pm, Morten Gulbrandsen wrote: > mysql> create table mytbl( c1 char(10) character set latin1_de); > ERROR 1115: Unknown character set: 'latin1_de' IIRC latin1_de is not a character set in Mysql 4.1.. The character s

Large query techniques

Assuming that I had a database containing a single table used to record an audit trail of messages originated from customers and their applications like so: CREATE TABLE `LogMessage` ( `MessageID` int(11) NOT NULL auto_increment, `CustomerName` varchar(100) default '', `ApplicationName` var

Assembly file not found while trying to connect ASP.NET to MySQL

i copy the Bytefx.data i.72 i nto my project folder, but when i run the project, an error occur : "File or assembly name System, or one of its dependencies, was not found. ". As usual, i copy the file into my project folder, then i add a reference. After that i imports ByteFX.Data.MySQLCLIENT

Importing data into MySQL

I have data that is in a progress database. I need to get a copy of the data into my mysql database. What would be the best approach ? I can dump the data in any specific format, so. Never tried ODBC with Progress (8.2C12), so don't know if that can/will work. thanks, Darryl -- MySQL Ge

ERROR 1115: Unknown character set: 'latin1_de'

mysql> create table mytbl( c1 char(10) character set latin1_de); ERROR 1115: Unknown character set: 'latin1_de' mysql> create table mytbl( c1 char(10) character set utf8); ERROR 1115: Unknown character set: 'utf8' mysql> create table mytbl( c1 char(10) character set sjis); ERROR 1115: Unk

Fw: No valid command found

Does anyone know what prompt the message below to be sent by the list? I have now been getting a few of these and cannot figure out why. Thanks for any input Uma From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 02, 2003 11:39 AM Subject: No valid command

Re: Crystal Decisions Report Application Server Problem

Sounds like a problem authenticating the host the queries are coming from. Try using the grant command with like john@"%", which allows any host to connect. (replace john with the username you want.) As a historical note, we tried using Crystal RAS with Lotus Notes and concluded it was too slow a

mysqlbug

shell> groupadd mysql shell> useradd -g mysql mysql shell> cd /usr/local shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell> ln -s full-path-to-mysql-VERSION-OS mysql shell> cd mysql shell> scripts/mysql_install_db shell> chown -R root . shell> chown -R mysql data I'm getting

WARNING! Virus Win32/Sobig.F@mm detected

Your EMail with subject 'Thank you!', sent to the recipient(s) [EMAIL PROTECTED] contains a virus or other harmful content. The message has NOT been delivered to the recipients. Please contact the postmaster (mailto:[EMAIL PROTECTED]) to resolve this issue. /var/ex...006LT-00-tmp/document_9446

RE: Abt Mysqldump

For grant statemnets grant all ON mysql.* to 'albert' is the correct syntax back ticks (`) are for around column names single quotes (') are for around strings/varchars/chars... M -Original Message- From: Albert [mailto:[EMAIL PROTECTED] Sent: 02 September 2003 14:04 To: [EMAIL PROTEC

Re: Re-establishing nuked log file

On Tue, Sep 02, 2003 at 07:59:07AM -0700, Bruce Ferrell wrote: > flush logs from the mysql command line works And so it does. Thank you. I misunderstood what the Manual said about this command, though I should have tried it first anyway. Jesse Sheidlower -- MySQL General Mailing List For list a

Re: Show database problem

OK I think I got it, in Win32 it has to be done from the mysql client screen and not from the command prompt. Either that or use another GUI client as the front end for MySQL I guess and I have had some suggestions on that one. I will try doing so. Thanks for the help Albert - Original Mes

Re: Re-establishing nuked log file

flush logs from the mysql command line works Jesse Sheidlower wrote: I recently restarted my MySQL server (4.0.10 in this case) with the general query log enabled, to help out with some debugging and optimization issues. After looking at a batch of these, I then deleted the log file directly, wit

RE: Re-establishing nuked log file

I don't know the answer to your question, but as a side note, I've always found cat'ing /dev/null into a file to be safer if the file may be in use cat /dev/null > foo.log > -Original Message- > From: Jesse Sheidlower [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 02, 2003 10:27

Crystal Decisions Report Application Server Problem

I'm writing to get some help on the following problem: We're running MySql (1.4.1 version) with MyODBC (version 3.51.06) and the Report Application Server 9 (RAS) from Crystal Decisions. We're having a problem getting the Report Application Server to connect to the MySql database via MyODBC. We

Re-establishing nuked log file

I recently restarted my MySQL server (4.0.10 in this case) with the general query log enabled, to help out with some debugging and optimization issues. After looking at a batch of these, I then deleted the log file directly, with "rm foo.log", assuming that it would be re-generated as soon as the

Re: Show database problem

On Tue, 2 Sep 2003 08:45:42 -0400 "Albert" <[EMAIL PROTECTED]> wrote: > When I enter : > > mysql\bin>SHOW GRANTS FOR uma; > > I get a response that show is not a command etc.. > > This is on Win32 version 4.x > > The same happens when I try it from mysql> > and also after I run mysqld > > An

Re: Show database problem

Stefan, Indeed, and my mistake (semantics). I meant what you explained. It is clear to me that the order in the table remains in the manner the data were entered, and that cannot be changed, unless a record is deleted and then re-entered, which would place it elsewhere (at the end). This does n

Re: ERROR 1115: Unknown character set: 'ucs2'

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 02 September 2003 1:36 pm, Morten Gulbrandsen wrote: > mysql> SET @s = CONVERT('ABC' USING ucs2); > ERROR 1115: Unknown character set: 'ucs2' > mysql> It works for me. I think you need to be using mysql 4.1.1alpha from BK. see: http://www.m

Re: Show database problem

This is the error I get and yes uma is a user and listed in my.ini file actually C:\mysql\bin>SHOW GRANTS FOR uma; 'SHOW' is not recognized as an internal or external command, operable program or batch file. C:\mysql\bin> Albert - Original Message - From: "Fortuno, Adam" <[EMAIL PROTE

Re: Show database problem

* Albert > When I enter : > > mysql\bin>SHOW GRANTS FOR uma; > > I get a response that show is not a command etc.. > > This is on Win32 version 4.x > > The same happens when I try it from mysql> > and also after I run mysqld > > Any ideas what is wrong here? When you say you "try it from mysql>" d

Re: Auto Increment ID of Inserted Row

(newbie to MySQL) I've been banging my head against the wall on this one for a bit now, and I understand that last_insert_id() is per-connection based, but most webapps are connection pooled (simple) or clustered (harder). What are my options to get the id of the inserted row in a webapp? As a

RE: Show database problem

Albert, This may sound minuscule. You're certain that 'uma' is a user account and not a database or table? Normally, you use "SHOW GRANTS FOR ". See example: mysql> SHOW GRANTS FOR test_usr; +--+ | Grants for [EMAIL PROTECTED] +

Sorting and use of tables

Stefan, Indeed, and my mistake (semantics). I meant what you explained. It is clear to me that the order in the table remains in the manner the data were entered, and that cannot be changed, unless a record is deleted and then re-entered, which would place it elsewhere (at the end). This does not

Re: Abt Mysqldump

Matthew (UK), I have two questions regarding this: 1. are you using the tick that is under the ~ sign on US keyboards, or the ' which is under the " quotes on US keyboards? I tried both and get an error executing the following query in mysql client gui screen GRANT ALL mysql.* TO USER 'albert'

Backup procedure

All, I'm looking for opinions/suggestions on a backup procedure I plan on implementing. All databases (DBXX) will be MySQL ver 4.0 All our applications work with DB01. DB01 replicates to DB02. Once a day I will Stop the slave on DB02, lock the tables, flush the logs and perform a mysqldump of

upgrading

We are currently running production on ver 3.23. We have two db servers that are in need of hardware upgrade. DB1 replicates to DB2. I plan on taking DB2 offline, upgrading RAM and Processors, installing latest RH OS and MySQL 4.0. Then replace DB1 with the upgraded DB2 making it the new DB1

How much user LOAD can Mysql bear???

Hi All! How much user LOAD can Mysql bear before die. Regards, Tariq -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Show database problem

When I enter : mysql\bin>SHOW GRANTS FOR uma; I get a response that show is not a command etc.. This is on Win32 version 4.x The same happens when I try it from mysql> and also after I run mysqld Any ideas what is wrong here? Thanks Albert - Original Message - From: "Joris Beckers

Re: Abt Mysqldump

try to export the database once again , using the command mysqldump database-name > file.sql . then try importing the same using mysql database-name < file.sql .(delete all the backups before trying this) by the way , are you trying to export/import between diff versions of mysql / or between diff

ERROR 1115: Unknown character set: 'ucs2'

Dear programmers, is this correct ? mysql> select version(); +---+ | version() | +---+ | 4.1.0-alpha-max-debug | +---+ 1 row in set (0.00 sec) mysql> SET @s = CONVERT('ABC' USING ucs2); ERROR 1115: Unknown character set: 'uc

Re: insert ... select .. order by, problem

Roger, Thanks for the additional clarification Albert Atlanta - Original Message - From: "Roger Baklund" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Albert" <[EMAIL PROTECTED]> Sent: Tuesday, September 02, 2003 8:00 AM Subject: Re: insert ... select .. order by, problem > * Alb

Re: insert ... select .. order by, problem

Stefan, Indeed, and my mistake (semantics). I meant what you explained. It is clear to me that the order in the table remains in the manner the data were entered, and that cannot be changed, unless a record is deleted and then re-entered, which would place it elsewhere (at the end). This does not

RE: Abt Mysqldump

Hi The only problem I get with mysqldump is that if I have used a reserved word as a column name, then the create starement fails. (eg CREATE TABLE fred ( KEY int(10) not null default '0' ); will fail (but as produced by mysqldump) However, if you edit the file and put ` character

Re: CPU Usage and MySQL...

On Sun, Aug 31, 2003 at 07:14:12AM -0400, Albert wrote: > Can this tool be used on Windows and if so what version do I need to DL and > does it need anything else besides the software (e.g. Perl - which I see > listed for the nix versions. When I last had a Windows box at work, mytop worked with A

Re: Need help with oracledump (contributed program)

On Tue, Sep 02, 2003 at 12:25:35PM +0100, Jim Smith wrote: > A TNSNAMES file isn't going to help unless you have the Oracle > client software installed. If you had the software, you would > already have a tnsnames file. > Thanks all for your help. I've found a free java-based application (JOracle

Re: CPU Usage and MySQL...

On Sun, Aug 31, 2003 at 12:02:20AM -0400, K Old wrote: > > I ran across this tool the other day and it is awesome. Basically it is > like the top utility for *nix, but it's for mysql. It basically gives > you a live look into the database and what queries it's processing, etc > in real time. Gl

Re: crash after 15 minutes

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 2 Sep 2003, Roman Hochuli wrote: > i migrated a server of ours (from 3.23) to mysql-4.0.14 (solaris > 8/sparc/64bit). i took the precompiled binary of the website. so far so > good. > > my problem now is the mysql-server crashed with signal 11

Re: Abt Mysqldump

use mysql database-name < backupfilename I think , the backup file name should have .sql extension , like backup.sql "Hoeven, Maarten van der" wrote: > What are the errors? > > For example, is the error like unable to create the tables, because the > tables still exist? See the dumpfile if tables

Re: insert ... select .. order by, problem

* Albert > Stefan, I'm Roger, but I reply anyway. :) > Do you imply that tables cannot be sorted desc or asc based on one of the > columns e.g. a last name? or am I misunderstanding you. In relational database theory the order of rows within the table is undefined, i.e. it is up to the server, a

Re: insert ... select .. order by, problem

Hi Albert, you are not misunderstanding me :-) Tables can indeed not be sorted, it's output which gets sorted. The difference is not academic, but important: It's not the table which gets an order, but the output. Take a command like: insert into x ... select from y ... order by z. Here the outp

RE: Abt Mysqldump

What are the errors? For example, is the error like unable to create the tables, because the tables still exist? See the dumpfile if tables are created (by default). If so, delete the tables first, and redump back the dumpfile. -Original Message- From: Uma Shankari T. [mailto:[EMAIL PROT

Re: Abt Mysqldump

On Tue, 2 Sep 2003 17:02:37 +0530 (IST) "Uma Shankari T." <[EMAIL PROTECTED]> wrote: > but while redumping back to mysql it is giving some errors in the > textfile..is there any possibility to redump the contents without any > error.. what exactly does it say ? --- WBR, Antony Dovgal aka tony2

Abt Mysqldump

Hello, I have dumped the database contents as one txt file by using this command mysqldump databasename -uusername -ppasswd > textfilename. but while redumping back to mysql it is giving some errors in the textfile..is there any possibility to redump the contents without any error.. R

RE: Need help with oracledump (contributed program)

A TNSNAMES file isn't going to help unless you have the Oracle client software installed. If you had the software, you would already have a tnsnames file. > -Original Message- > From: Doug Poland [mailto:[EMAIL PROTECTED] > Sent: 02 September 2003 02:58 > To: Martin Gainty > Cc: [EMAIL PRO

Re: insert ... select .. order by, problem

Stefan, Do you imply that tables cannot be sorted desc or asc based on one of the columns e.g. a last name? or am I misunderstanding you. Albert Atlanta (anyone else in Atlanta?) - Original Message - From: "Stefan Kuhn" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, Septem

Strange behavior -- user variables in 4.0.14b

I get the following strange behavior with a user variable. @T has the value 0 to start; after adding 1 to @T a few times, it ends up with a clearly incorrect value. I'd expect it to have a value of 280 after the second select. -- SELECT @T -- +--+ | @T | +--+ |

Re: RAID or not?

--On Friday, August 22, 2003 8:37 PM -0600 Jim McAtee <[EMAIL PROTECTED]> wrote: I don't quite understand the need to read data before any write. Why wouldn't it just calculate the parity of whatever is being written and just write it to disk? Wouldn't there be slack space, as with any disk s

RE: RAID or not?

--On Friday, August 22, 2003 1:21 PM -0400 "Lefevre, Steven" <[EMAIL PROTECTED]> wrote: "that is not true. mirroring gives you double the read speed and half the write speed. RAID5 gives you less than half the write speed." - OK, I see how it can give you double the read speed, bu

Virus Found in message "Wicked screensaver"

Symantec AntiVirus found a virus in an attachment you ([EMAIL PROTECTED] <[EMAIL PROTECTED]>) sent to Jay Blanchard. To ensure the recipient(s) are able to use the files you sent, perform a virus scan on your computer, clean any infected files, then resend this attachment. Attachment: details

Re: Using multiple character sets (Russian & English)

Egor, Thank you for the response. You are the perfect person to answer my questions regarding Russian character sets. :) I two follow-up questions: 1. Will this work even though I am using two different character sets? I just want to be clear on what I am describing: one column of my table wi

Re: insert ... select .. order by, problem

Hi, I think you can't do this. There is no order in the table, so there is no point in using order by with insert. You always have to do this when retrieving the records (the order you get with select without order by is accidential). HTH Stefan Am Tuesday 02 September 2003 11:49 schrieb Alejan

  1   2   >