Re: Tuning MySQL Server Parameter

> I wish to tune our MySQL Server Parameter to increase > the speed of Join. I was trying to do a simple join > with two tables. One is big (~2,500,000 records); the > other one is small. The current join seems to take > forever to finish even on the indexed attribute. > > I am trying to learn from

RE: relational is relational is relational, but ...

On Tue, 3 Dec 2002, Jon Frisby wrote: > However, from a DB design standpoint, it is generally considered > MASSIVELY unwise for your PRIMARY KEY value to have any > "business-meaning". If it has no "business-meaning", it never needs to > change. Ever. Really, the issue is that you don't want a

Re: alter table syntax

Sorry, I tried that before. *** This is my show create table syntax mysql> show create table town_db ; +-+- --

Re: alter table syntax

ALTER TABLE town_db1 DROP PRIMARY KEY; ALTER TABLE town_db1 ADD PRIMARY KEY(town, subcity ); On 12/5/02 10:31 PM, "kayamboo" <[EMAIL PROTECTED]> wrote: > sql, mysql, query > > Hello folks > > This is my table structure with MySql 4.0.3-beta-max-nt with InnoDB > > +-+--+

alter table syntax

sql, mysql, query (B (BHello folks (B (BThis is my table structure with MySql 4.0.3-beta-max-nt with InnoDB (B (B+-+--+--+-+-+---+ (B| Field | Type | Null | Key | Default | Extra | (B+-+--+--+-+---

Re: QUICK: What is the optimal way to store opening times ?

On Fri, Dec 06, 2002 at 03:26:03AM +0100, Alliax wrote: > Thank you for this and for the previous answer about create temporary table, You're welcome. > your RestTimes is a nice way to do it, but it multiplies the number of rows > of the table. Does this matter? It should take up the same (or l

Re: QUICK: What is the optimal way to store opening times ?

On Thu, Dec 05, 2002 at 11:42:28PM -0500, Michael She wrote: > Although normalization is good practice, it can complicate queries. It is almost always good practice. If done right, it need not even complicate the queries much (see my response to this thread earlier). For what its worth, I've alw

Re: QUICK: What is the optimal way to store opening times ?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael She wrote: Yes, in some cases. It's called Normalization. Although normalization is good practice, it can complicate queries. Have you thought about storing just M/T/W/etc and then storing the Opening, Closing times as a comma delimited st

What are basic db files MySQL creates?

Question: When I create a new db using MySQL... What files does MySQL create? I'm asking because a MySQL sample db was created on the machine I am using and they don't seem to be where I think they should be... and I want to search for them... (I looked in root/var/lib/mysql/ and didn't see the

How to tell MySQL where to store db files ??

1 - When I create a new db using MySQL... Can I tell MySQL where (what path & directory) to store the new db files? And... 2 - To back up the db... can I just copy the files in that directory to a backup device like a CD or floppy? Thanks, Will ---

RE: QUICK: What is the optimal way to store opening times ?

Yes, in some cases. It's called Normalization. Although normalization is good practice, it can complicate queries. Have you thought about storing just M/T/W/etc and then storing the Opening, Closing times as a comma delimited string? Maybe like Monday: 11AM,1PM,5PM,1AM Tuesday 10AM,1PM,6PM,12

RE: Limit and Order by

On Thu, 2002-12-05 at 19:39, Michelle de Beer wrote: > > you mean mySQL does the search on 100 first entries > > and then order the > > results, instead of getting the results and > > returning only the first 100 ? > > If yes I too would like to know what's the right way > > to do it in SQL then ?

Re: Limit and Order by

What version of MySQL are you using? The order by and limit clauses should work the way you want them to, not the way you are describing -- i.e. it should order first and then return the top 100 rows. I use this kind of sql statement all the time in the reports I write. I'm not sure if any older ve

re: Delete from sub select

On Wed, 4 Dec 2002 17:38:00 +0200, Victoria Reznichenko wrote: >Kittiphum, >Wednesday, December 04, 2002, 1:49:08 PM, you wrote: > >K> This query can find the record in Table1 that not found in Table2 > >K> SELECT Table1.ID FROM Table1 LEFT JOIN Table2 Using(ID) >K> WHERE Table2.ID IS NULL > >K> an

Re: QUICK: What is the optimal way to store opening times ?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Alliax wrote: Thank you for this and for the previous answer about create temporary table, your RestTimes is a nice way to do it, but it multiplies the number of rows of the table. So you say it's better to have more rows than have less row, when doi

Mysql_real_connect shared memory problem

I have a problem sharing mysql structs between processes. I am using shared memory to accomplish this. When my program starts, I create a shm segment. Let's say I simply fill it with one MYSQL struct. // parent process setting up shm for it's children int shmid = shmget(2181973, sizeof(MYSQL),

RE: QUICK: What is the optimal way to store opening times ?

Thank you for this and for the previous answer about create temporary table, your RestTimes is a nice way to do it, but it multiplies the number of rows of the table. So you say it's better to have more rows than have less row, when doing simple select query? I'll do it your way then, except if so

Re: abnormally high load under 4.04

Hi, Try also to download 4.0.5a (not 4.0.5), this version could solve your load problem (due to a problem with the glibc used during the build) Regards, Jocelyn - Original Message - From: "Josh Marcus" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 06, 2002 2:16 AM

abnormally high load under 4.04

Recently, I upgraded some moderately taxed mysql servers from 3.23.49a to 4.0.4 (all installed via redhat rpms downloaded from mysql.com). The motivation for the upgrade was actually that replication seems a little flaky under 3.23.49a. For example, we've had unexplained corrupt binlog issues. (

Re: QUICK: What is the optimal way to store opening times ?

On Fri, Dec 06, 2002 at 01:35:04AM +0100, Alliax wrote: > Since there is no common denominator for opening times, I thought of having > another table with 28 (!!) fields. I'm doubtful this is optimal. As opposed to something like: RestTimes ( id ..., restaurantid ..., weekday tinyint unsigned, o

Can someone explain this?

Dec 3rd, 2002 mysql> select sum(trial_signups) from campaign_t where datestamp='20021203'\g ++ | sum(trial_signups) | ++ | 64 | ++ Dec 4th, 2002 mysql> select sum(trial_signups) from campaign_t where datestamp='20021204

Re: Re: Limit and Order by

On Thu, Dec 05, 2002 at 02:00:43PM -0800, Michelle de Beer wrote: > Select * from mytable ORDER by total desc limit 0, 100 See my other most recent reply; you can do it in two queries: CREATE TEMPORARY TABLE Top100 SELECT * ... limit 0,100; SELECT * FROM Top100 ORDER BY ...; The temporary table

Re: Limit and Order by

At 2:00 PM -0800 12/5/02, Michelle de Beer wrote: How can I limit the result after the "order by" has been executed? This stops efter 100 rows and the result is not as I intended... Select * from mytable ORDER by total desc limit 0, 100 Must this be done in PHP? Perhaps you could tell us wha

Order By or Group By Help Please

Ok, I will try this one again. I need some help on a select if it is possible. Take for Example the following data. -- | RUSH | FileNumber | PTime | PDate | -- | 1 | 1-1023-001 | 08:00 | 12/04 | | 1 | 1--001 | 06

RE: Limit and Order by

> you mean mySQL does the search on 100 first entries > and then order the > results, instead of getting the results and > returning only the first 100 ? > If yes I too would like to know what's the right way > to do it in SQL then ? That is correct. This is what I have: One table with 1000 recor

Limit and Order by

I am not sure I understand your question, I thought the line you showed would give proper results (100 total-ordered lines) but maybe : So there is a similar thread running now, Re: SQL Select Idea [ORDER BY] by Michael, he says creating a temporary table is the way to go : "create temporary tabl

QUICK: What is the optimal way to store opening times ?

Hello, I have a table of restaurants, I want to store opening times so I can display in real time if the restaurant is open or not. What is the optimal way to store the times ? Since there is no common denominator for opening times, I thought of having another table with 28 (!!) fields. I'm doubtf

RE: Limit and order by

MYSQL On Thu, 2002-12-05 at 17:00, Michelle de Beer wrote: > How can I limit the result after the "order by" has > been executed? This stops efter 100 rows and the > result is not as I intended... > > Select * from mytable ORDER by total desc limit 0, 100 > > Must this be done in PHP? > > Thanks

joing 2 columns to 1 table

if i have the following mySQL tables create table list ( id int, name char(20) ); insert into list values(1, 'bob'); insert into list values(2, 'joe'); create table list2 ( id1 int, id2 int ); insert into list2 values(1,2); insert into list2 values(2,1); what query will return the following resu

Re: mysql NULl value in perl problem

Hi David: I am assuming you are using DBI. I am not quite sure what you are asking, but here is some code that might help: while ($hashref = $sth->fetchrow_hashref) #while there are records in the query ... { DO SOME STUFF } The above code is a pretty traditonal way to deal with a statement h

Re: mysql NULl value in perl problem

Isn't NULL value in MySQL stored as '\N'? If so, you can check that in your perl script. Qunfeng --- David Wu <[EMAIL PROTECTED]> wrote: > Hi guys, > > Running into a frustrating problem. When I have a > empty table in mysql > database, i tried run a select statement in my perl > script and

Re: mysql NULl value in perl problem

At 14:59 -0800 12/5/02, David Wu wrote: Hi guys, Running into a frustrating problem. When I have a empty table in mysql database, i tried run a select statement in my perl script and supposing get a NULl return value. Is the NULL returned from mysql is described as string in perl or as undef i

Tuning MySQL Server Parameter

Hi, I wish to tune our MySQL Server Parameter to increase the speed of Join. I was trying to do a simple join with two tables. One is big (~2,500,000 records); the other one is small. The current join seems to take forever to finish even on the indexed attribute. I am trying to learn from http:

Re: Questions Compressed Tables & Indexs

On Thu, Dec 05, 2002 at 04:03:41PM -0600, Dan Nelson wrote: > Protocol compression is separate from Table compression. To enable > protocol compression, set the CLIENT_COMPRESS flag when connecting to > the server, or add the "compress" keyword to the [client] block of your > my.cnf file. How ab

Re: Error Message Documents - where to find it?

Dear Jason, > Where can i find documents with the description of mysql error code returned > by the mysql daemon? try the PERROR utility shipped along with the MySQL daemon (in the bin directory), like: PERROR 1064 HTH! -- Stefan Hinz <[EMAIL PROTECTED]> CEO / Geschäftsleitung iConnect Gmb

Re: Questions Compressed Tables & Indexs

On Thu, 05 Dec 2002 15:36:37 -0500, Michael She wrote: >As for indicies is it better to create a single index per column, or an >index for a set of columns. For example, if I go: SELECT * FROM SOMETABLE >WHERE A = X and B = Y. Is it better to create a X AND Y index, or two >separate indicies?

Re: SQL Select Idea [ORDER BY]

On Thu, Dec 05, 2002 at 08:54:29PM -0200, Felipe Moreno - MAILING LISTS wrote: > > Well, could you explain the behave of ORDER BY DATE,COD? Just try it (it will order by date, then cod). What I think you want is (as I originally said, but briefly): create temporary table top10 select * from ..

mysql NULl value in perl problem

Hi guys, Running into a frustrating problem. When I have a empty table in mysql database, i tried run a select statement in my perl script and supposing get a NULl return value. Is the NULL returned from mysql is described as string in perl or as undef in perl?.. As there is no the word NULL i

RES: SQL Select Idea [ORDER BY]

Well, could you explain the behave of ORDER BY DATE,COD? I will show you bellow what I want, graphically: >1) What I have: > >Table: processo_arquivos > >_ >|Cod| Date | >- >|1 | 12/10 | >- >|2

Re: Serwer Hardware p4 or pIII ?

Does anybody have any benchmarks of MySQL running on otherwise equivalent machines but with different CPUs? It would be interesting to compare Athlon vs Pentium III vs Pentium IV vs Pentium IV Xeon at various speeds. And yes, while a Pentium IV is generally slower than a Pentium III at the same

Re: import size

On Thu, 5 Dec 2002 10:16:16 -0700, Sarah Killcoyne wrote: >I've found that using the "local infile import" query on files that are >several mb in size takes up to a min per mb I've posted a couple times recently on a Delphi project I wrote to upload data from a client's Access database (

RE: mysql breaking through a firewall

Opening TCP port 3306 for inbound requests on your firewall should be adequate. Mike Grabski -Original Message- From: Grant Cooper [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:05 PM To: [EMAIL PROTECTED] Subject: mysql breaking through a firewall I am trying to break t

Re: Questions Compressed Tables & Indexs

In the last episode (Dec 05), Michael She said: > I'm planning to run a remote DB across the internet for a web > application and I would like to minimize retrival times and > bandwidth. > > I have a couple of questions about MyISAM compressed Tables: > > 1. Is it slower to retrieve from a compre

RE: Aggregating function which returns more than one row

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Felix LUNGU Sent: Thursday, December 05, 2002 12:27 AM To: Victor Pendleton; [EMAIL PROTECTED] Subject: Re: Aggregating function which returns more than one row The idea is simple: I want to implement some

Limit and Order by

How can I limit the result after the "order by" has been executed? This stops efter 100 rows and the result is not as I intended... Select * from mytable ORDER by total desc limit 0, 100 Must this be done in PHP? Thanks for all replys to my topics, btw. Any thoughts? // Michelle sql, query ___

Re: mysqldump error

I have mysql 3.23.49a installed. I have noted that some directories under /usr/local/mysql was wrong owner. I change it and try again. The problem is reduced to only one database, because with another with same size of tables (180.000 registers) there is no problem. A tip: when I make a backup

Re: Error Message Documents - where to find it?

The manual: http://www.mysql.com/doc/en/perror.html It'll return the error string. At 02:59 PM 12/5/2002 -0500, Jason Hall you wrote: Where can i find documents with the description of mysql error code returned by the mysql daemon? -

RE: Error Message Documents - where to find it?

http://www.mysql.com/doc/en/perror.html >perror [errornum] i.e. > perror 13 Error code 13: Permission denied -Original Message- From: Jason Hall [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 11:59 AM To: '[EMAIL PROTECTED]' Subject: Error Message Documents - where to fin

Re: [OT] LEGAL information about MySQL.

On Thu, 2002-12-05 at 03:23, Pae Choi wrote: > Look! > > I already unsubscribed this. Do you understand what that mean? > I have no interest to dealing with MySQL and have no time for > this. > > You must understand that this thread was started from someone > who were interested to sell his/her p

Re: mysqldump error

Dear Carlos, > ERROR 2013 at line 1: Lost connection to MySQL server during query > I think is problem with the binary, but I don't know why.. an idea may be > install a recent new version from mysql. Which version do you have? Regards, -- Stefan Hinz <[EMAIL PROTECTED]> CEO / Geschäftsleitu

updating a field more than once

Hi, I wrote a simple CGI application using mysql. What it does is really simple : connect to mysql database ... do something ... update a field ... do something again ... close mysql The update is like TOTAL = TOTAL + AMOUNT. If let say, 1000 users accessing my CGI in the same ti

Re: mi_test_all error help

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 5 Dec 2002, shawn xu wrote: > I am using BSDI 4.3, and downloaded MySql source code > 3.23.53. > > After untarring it, it passed ./configure > --prefix=/usr/local/mysql. But when I run make, > finally it says > > make: don't know how to make m

Re: Questions Compressed Tables & Indexs

Hi all, I'm planning to run a remote DB across the internet for a web application and I would like to minimize retrival times and bandwidth. I have a couple of questions about MyISAM compressed Tables: 1. Is it slower to retrieve from a compressed table, or actually faster since data is packed?

RE: MySQL

Ud. necesita arrancar el servicio de mysql del directorio de instalación. Por ejemplo, si el programa en el directorio /usr/local/mysql/bin/safe_mysqld, entonces desde el directorio /usr/local/mysql, use ./bin/safe_mysqld --user=mysql & -Original Message- From: Vicente Valero [mailto:[EM

RE: MySQL Server

Parece que el user mysql no tiene permiso para escribir en el directorio donde le has puesto que ponga el soket. Asegurate de que el directorio data el dueño sea mysql. Espero que te ayude JFernando ** sql ** -Original Message- From: Vicente Valero [mailto:[EMAIL PROTECTED]] Sent: Decem

Error Message Documents - where to find it?

Where can i find documents with the description of mysql error code returned by the mysql daemon? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list arc

Re: LEGAL information about MySQL.

On Thu, Dec 05, 2002 at 03:14:14AM +0100, David Axmark wrote: > > Maybe MySQL.com is concern about own profit so does other > > commercial vendors. They all use public-domain code in some > > degree. I know this thread has been trollish at times, and many have probably kill-filed it, but I'd like

question about inner and left join

Hello to all I have the following sql: select phones.*, ops.plid, ops.box, ops.mac, concat(phones.prefix1,phones.suffix1) as complete_phone from phones inner join ops on phones.suffix1 = ops.phone I do wa

EXCEPT, NOT IN, JOIN

hi MySQL 3.23.52 could not make my way throuh the JOIN statement. i would like to accomplish something like what EXCEPT does in other databases, with a full SQL-statement after the EXCEPT. xxxIDref is a foreign key. first i have a table with users ID Name 1 John Doe 2 Jane Doe 3 Me Myself th

issues with RedHat and mySQL.rpm run levels?

I notice that I see mysql failing to stop on reboot of my machine, however I believe it's because it already was stopped at an earlier runlevel: [root@daevid rc3.d]# locate mysql | grep "/etc/rc.d/" /etc/rc.d/init.d/mysqld /etc/rc.d/init.d/mysql /etc/rc.d/rc0.d/K90mysql /etc/rc.d/rc0.d/K12mysqld /

re: Re: Security issues with LOAD DATA

This also does not enable me to upload a data file. My resulting SQL cardrdc> statement reads: cardrdc> LOAD DATA LOCAL '/tmp/phpgPhl51' INTO TABLE test FIELDS TERMINATED BY ',' cardrdc> ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' cardrdc> I have also tried: cardrdc> LOAD DATA LOC

mysql@lists.mysql.com

I am using BSDI 4.3, and downloaded MySql source code 3.23.53. After untarring it, it passed ./configure --prefix=/usr/local/mysql. But when I run make, finally it says make: don't know how to make mi_test_all. Stop *** Error code 1 Your help will be appreciated Shawn Xu MySQL, MYSQL, mysql

Can't connect error 10061 - nothing but Mascon works remotely.

I'm having a strange problem connecting via remote to mySQL. This is an internal LAN, so there should be no firewall issues. I'm running RedHat 8.0, but I've installed the latest mySQL rpms which I thought were statically linked to avoid the earlier problem of this same nature. The peculiar thing i

mysql breaking through a firewall

I am trying to break through my admins firewall on 1531. But my admin was thinking it needs more than one port like Microsoft MySQL. Are there special requirements for port assignments? If this doesn't work I have to use M. MySQL. :( Thanks in advance. G. Cooper

Bad system call received during mysql_install_db

>Description: Bad system call received during mysql_install_db >How-To-Repeat: I have tried installing the binary mysql-max-3.23.53a-dec-osf5.1-alphaev6 as well as compiling from the source code mysql-3.23.53-dec-osf5.1-alphaev6. Perhaps I used the wrong code??? Pl

Problems with MySQL lists internet line

Hi We are having some problems with high load on our Internet line in the MySQL office in Uppsala. And we might need to temporary ( about 12-24 hours) turn off the MySQL mailing lists. If our current workaround will work we can stay up. We should get a upgrade of our Internet line equipment tomo

multiple hosts w/ GRANT

I'm wondering if it's possible to specify multiple hosts for a user when setting up permissions, but without using wildcards. For example.. if I have these two GRANT statements: GRANT SELECT on database.* to [EMAIL PROTECTED] identified by 'passwd'; GRANT SELECT on database.* to [EMAIL PROTECTE

Re: mysqldump error

thanks for your answer. Now the problem is worst. When I do a sql request with mysql client and the number of register is a litte big, for example 50, the error appears again: mysql --debug -e"select * from table" > /tmp/lista.log ERROR 2013 at line 1: Lost connection to MySQL server during query

Re: ÓòÃû×¢²á£¬ÐéÄâÖ÷»ú³ö×â

Try use "commit" before use this statement... 5/12/2002 14:29:17, lpkvb <[EMAIL PROTECTED]> wrote: > >Ç×°®µÄÅóÓÑ£º >ÄúºÃ£¡ >ÕâÊÇÀ´×ÔÏÃÃÅÊÐӯͨԶº½µç×ӿƼ¼ÓÐÏÞ¹«Ë¾µÄÎʺ¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£ÎÒÃÇÕæ³ÏµÄÏ£ >ÍûÄúÄܳÉΪÎÒÃÇÔÚ¹óµØÇøµÄÖØÒª»ï°é¡£ÎÒÃÇÊÇÒ»¼ÒÖÂÁ¦ÓÚ»¥ÁªÍøÐÅÏ¢·þÎñ¡¢µç×ÓÉÌÎñ·þ >ÎñºÍÆó

EXCEPT, NOT IN

hi MySQL 3.23.52 could not make my way throuh the JOIN statement. i would like to accomplish something like what EXCEPT does in other databases, with a full SQL-statement after the EXCEPT. xxxIDref is a foreign key. first i have a table with users ID Name 1 John Doe 2 Jane Doe 3 Me Myself th

Re: SQL Select Idea [ORDER BY]

On Thu, Dec 05, 2002 at 09:41:24AM -0200, Felipe Moreno - MAILING LISTS wrote: >The ten last dates appear as a default result of a Archives page. When I > enter for the first time in the page, it give me the last ten Files that was > uploaded. In the same page, I can ORDER BY the ten last dates

Re: Install PHP with MySQL

yes... it seems that you do not have mysql in the PHP module. you can use --with-mysql in the php configure, but you should use --with-mysql=/your/mysql/directory PHP has included code for the default mysql build. try to use your own libs and headers. HTH brian sql, query, mysql On Th

Lost connection to MySQL server during query.

Oops. I should have been paying more attention to the lost connection thread. What does the "Lost connection to MySQL server during query" error message mean and where can I find more information about it? I just installed the DBTools on a XP box. When I try to connect to by Linux box, it gives m

make: don't know how to make mi_test_all. Stop

I am forwarding Shawn's real question to the list, since I haven't got a clue :) > -Original Message- > From: shawn xu [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 05, 2002 12:42 PM > To: Luc Foisy > Subject: RE: I can not post to this list after I have joined > > > Hi, Luc Fo

Re: Table copy problem

Dear Oláh, > "SELECT * INTO [temptablename] FROM [sourcetablename] WHERE id is null" In MySQL, you simply do: CREATE TABLE temptable SELECT * FROM sourcetable LIMIT 0 That's even simpler, 100% reliable and FAST! :) HTH! -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH

Re: mysqldump error

Dear Carlos, > Got error: 2013: Lost connection to MySQL server > during query > when retrieving data from server In your my.cnf / my.ini configuration file, set the value for the communication buffer high (maximum is 16 MB): [mysqldump] set-variable = max_allowed_packet=16M Restart the server,

MySQL Server

Hola de nuevo, he mirado el log de mysqld, y pone lo siguiente: bind on unix socket : permission denied Donde reside el problema? Gracias ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http

import size

I'm attempting to import 36 files of varying size from about 500kb to 80mb. I've found that using the "local infile import" query on files that are several mb in size takes up to a min per mb and much longer if it get's over 100mb. The system we're using has 500mb RAM and a 1600mHz processor. Is

Re: InnoDB shared lock with JOINs

Evgeny, - Original Message - From: "Evgeny Chuykov" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Thursday, December 05, 2002 12:28 PM Subject: InnoDB shared lock with JOINs > Hallo. > > I have this query: > SELECT table1.id > FROM table1 > LEFT JOIN tabl

RE: WoW!!!! SQL is something!

Colin, According to the docs this function wants a string and when I use the field name it says "unknown column". Thanks anyway. -Original Message- From: Colin Kettenacker [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 5:32 PM To: Mysql_List (E-mail) Subject: Re: WoW SQ

MySQL

Hola, Tenia instalado MySQL 3.23.53 en mi pc. He reinstalado todo el sistema y lo he vuelto a instalar, pero no consigo arrancar el servidor sql. La instalación la he hecho según indica el manual y tal como la habia hecho en la otra ocasión. Cuando quiero arrancar el servidor (/bin/safe_mysqld --u

EXCEPT, NOT IN

hi MySQL 3.23.52 could not make my way throuh the JOIN statement. i would like to accomplish something like what EXCEPT does in other databases, with a full SQL-statement after the EXCEPT. xxxIDref is a foreign key. first i have a table with users ID Name 1 John Doe 2 Jane Doe 3 Me Myself th

mi_test_all error help

I am using BSDI 4.3, and downloaded MySql source code 3.23.53. After untarring it, it passed ./configure --prefix=/usr/local/mysql. But when I run make, finally it says make: don't know how to make mi_test_all. Stop *** Error code 1 Your help will be appreciated Shawn Xu _

ÓòÃû×¢²á£¬ÐéÄâÖ÷»ú³ö×â

Ç×°®µÄÅóÓÑ£º ÄúºÃ£¡ ÕâÊÇÀ´×ÔÏÃÃÅÊÐӯͨԶº½µç×ӿƼ¼ÓÐÏÞ¹«Ë¾µÄÎʺ¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£ÎÒÃÇÕæ³ÏµÄÏ£ ÍûÄúÄܳÉΪÎÒÃÇÔÚ¹óµØÇøµÄÖØÒª»ï°é¡£ÎÒÃÇÊÇÒ»¼ÒÖÂÁ¦ÓÚ»¥ÁªÍøÐÅÏ¢·þÎñ¡¢µç×ÓÉÌÎñ·þ ÎñºÍÆóÒµÓ¦Ó÷þÎñµÄ¸ßм¼ÊõÆóÒµ¡£ÎÒÃÇÓÐ×ŶàÄê´ÓʲÙ×÷ϵͳµÄ¾­Ñé,ÕâΪÎÒÃǵĿռä Îȶ¨ÌṩÁ˱£Ö¤.ÎÒÃǵķþÎñ×ÚÖ¼ÊÇ:Îȶ¨

Re: take one database offline

another trick that might work is just to deny access to everyone to the database. if no one has access to it, then its as good as gone. i don't know if MySQL would allow just grant blah on *.* to user; revoke all on disabled_db.* from user; and alot of it depends on how the security is setup a

re: Join-question

Michelle, Thursday, December 05, 2002, 5:46:03 PM, you wrote: MdB> I believe this question is solved by a join, but I MdB> haven't really got a hang of it. MdB> My table: MdB> -- MdB> | uid | rootid | parentid | name | MdB> -

re: Index timestamp column

Michal, Tuesday, December 03, 2002, 7:19:08 PM, you wrote: MF> Its possible to use index on this query ?? MF> select .. MF> from .. MF> where timestamp_col<2002110100 and timestamp_col>2001110100 MF> I have index on timestamp column, but EXPLAIN says that not using any of MF> possi

re: mysql select query returns incorrect no of rows

Vinay, Wednesday, December 04, 2002, 3:05:03 PM, you wrote: VM> I m developing a web based application using Tomcat, Struts, JSP, mysql. VM> I m using mysql 3.23.39-max-nt and mysql-connector-java-2.0.14 to access VM> mysql through java 1.3.1. VM> But sometimes the select query on 1 particular t

RE: WoW!!!! SQL is something!

Thanks - this is even better - I will give it a try. -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 6:19 AM To: Norris, Joseph; Mysql_List (E-mail) Subject: RE: WoW SQL is something! select req_number, right(concat('00',trim(re

Re: Slow performance using 3.23 on RH 8.0

On Wed, Dec 04, 2002 at 05:06:54PM -0500, Ledet, Mike wrote: > I tried your TOP suggestion but didn't see anything out of the ordinary. > Swap size was constant (6400 or so) and didn't increase or decrease under > load. Familiarize yourself with vmstat if you aren't already and then run `vmstat 1`

Join-question

I believe this question is solved by a join, but I haven't really got a hang of it. My table: -- | uid | rootid | parentid | name | -- | 1 | 0 | 0| name1| | 2 | 1 | 1| name2| | 3 | 1

Re: UPDATE ... SELECT FROM ... :)

On Wed, Dec 04, 2002 at 04:32:35PM -0500, Michael T. Babcock wrote: > information from "a" to "b". Any ideas for a one-shot SQL command to do this? > I'm about to try selecting everything from "b" and the CommID from "a" as a > join into a temporary table, then "REPLACE" it back into "b". In ca

Re: Join-question

Hi: You might find these articles from O'Reilly Network will help clear the water. http://www.onlamp.com/pub/ct/19 Doug On Thu, 5 Dec 2002 07:46:03 -0800 (PST), Michelle de Beer wrote: >I believe this question is solved by a join, but I >haven't really got a hang of it. > >My table: >-

Re: Join-question

- Original Message - From: "Michelle de Beer" <[EMAIL PROTECTED]> > I believe this question is solved by a join, but I > haven't really got a hang of it. > > My table: > -- > | uid | rootid | parentid | name | > -

Re: Join-question

* Michelle de Beer > I believe this question is solved by a join, but I > haven't really got a hang of it. > > My table: > -- > | uid | rootid | parentid | name | > -- > | 1 | 0 | 0| name1| > | 2 | 1

Re: Multiselect

* Daya Krishan Dubey > can anybody tell me how can i select,update, delete the records from two > table having same structure in the mysql. "select", "update" and "delete" are three different operations. From your example data, it looks like you want to do "select". > For ex > > MainTable > -

Re: I can not post to this list after I have joined

Mysql, sql,query --- [EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to > be either spam or > simply off topic to our filter. To bypass the filter > you must include > one of the following words in your message: > > sql,query > > If you just reply to this message,

re: Table copy problem

Oláh, Thursday, December 05, 2002, 2:44:24 PM, you wrote: OB> I want to copy one table's structure to another (non existing) table, but i OB> didn't find any command or example to do that. Exactly, the situation is the OB> following: OB> A dynamic database structure has tables. We want to copy any

re: Multiselect

Daya, Thursday, December 05, 2002, 4:14:02 PM, you wrote: DKD> can anybody tell me how can i select,update, delete the records from two DKD> table having same structure in the mysql. DKD> For ex DKD> MainTable DKD> --- DKD> id(int)|val (varchar) DKD> ---

re: Problems Configuring MySQL...

Alejandro, Thursday, December 05, 2002, 4:03:23 PM, you wrote: ACG> Hi all and thx in advance for trying to fix my problem. ACG> I'm instaling for the first time MySQL and when I try to test the program, I ACG> receive an error like "Cannot connect to localhost (100060)"...How can I ACG> configure

  1   2   >