Big ass query?

Hi ya'll! I have a little problem with a query, no actually not o little problem but a big one. I haven't got o clue how to write it. This is what I want: This is the table id | drink_id | ing_id | vol_id --- 1 | 10 | 1 | 5 2 | 10 | 5 |

Re[3]: Proposition: Attach a comment to each connection

Bonjour Werner, My web site as a lot of hits (really!), it's load balanced on the web side on more than 30 servers. I've to save database load as much as possible. The problem with your implementation is that it needs at least one more insert query for each page or even more if

Can't download files from MySql.com

Hi all, Did anyone experience any difficulty on downloading files from mysql.com?? I tried to download MyODBC from the download page but none of the downloads seems working at all Regards, Michael

Re: Can't download files from MySql.com

try going downloading it from www.rpmfind.net thats a good site too bye Luis - Original Message - From: "Michael Tam" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Sent: Thursday, July 05, 2001 12:36 AM Subject: Can't download files from MySql.com Hi all, Did anyone experien

Re: different subdir for database

At 12:10 05/07/2001 +0800, Jaime Teng wrote: Hi, You can simulate the symbolic link on Windows using the today Win32 MySQL 3.23.39 distribution. You have in this distribution the following Max MySQL servers: 1- mysqld.exe the debug version. 2- mysqld-max.exe the optimized version for Win9x and N

Alternate database handlers / tests

Hi, did anybody ever try to run the standard test suite with another table handler? We think about switching to InnoDB, but we see problems..: - The maximum blob/text length. We use MySQL for our support emails. (Restructuring the database to use a mix of InnoDB and myISAM would work, but not

Unlock tables when process has killed.

Hello, All. Help me. One process locks a table. Then it has been killed. The table remains locked. How unlock the table if the process is not exist? Thanks in advance. Nick. - Before posting, please check: http://www.mys

three tables and count() - Urgent i need it to my job !!

Hi my friends !! Some few days i have problems with count(). i have 3 tables: t1 holds: +++ | id | number | +++ | 1 | one| | 2 | two| | 3 | three | | 4 | four | | 5 | five | | 6 | sixs | +++ t2 holds: ++---+-

Re[4]: Proposition: Attach a comment to each connection

Bonjour Werner, >> Am I naive or is this a viable proposition? WS> Oh, I see, you would like to connect this information with the WS> pid, right? I wouldn't know how to do that. How do you get a pid? WS> Is this something MySQL could provide? No, not with the pid. With the number of pla

Problems Installing MySQL

We have installed the Red Hat Linux 7.1 Deluxe Edition on a Pentium III PC (450MHZ) with 128MB RAM. We installed the Workstation option. The OS is Windows 98 Millennium Edition. There are 2 Hard Drives. The 6GB Drive has Windows 98 Millennium Edition installed. The 4GB Drive has the Red Hat Linux

Re: Unlock tables when process has killed.

On Thu, Jul 05, 2001 at 10:55:33AM +0300, Nick Kostirya wrote: > Hello, All. > > Help me. > > One process locks a table. Then it has been killed. The table > remains locked. How unlock the table if the process is not exist? If that's what happened, you've found a bug in MySQL. Can you reliably

RE: ERROR :Can't find file: './mysql/host.frm' (errno: 13)

Allthough I had changed the permission of the directory, my troubles follow again, I reinstall the package and all turn rigth. > -Mensaje original- > De: Gerald Clark [SMTP:[EMAIL PROTECTED]] > Enviado el: martes 3 de julio de 2001 16:52 > Para: [EMAIL PROTECTED] > Asunto:

Init Mysql throuht the sockets

I´ve already installed mysql, but i can only connect via TCP/IP, and i can´t do it by socket. I´ve got all the permissions rigth and the mysql.socket file in the rigth directory. Can anybody help me? Thanks.

mysql 3.23.38 bug

Hello mysql, It seems like if load data infile initiated to dammaged table sometimes after repair it does not unblock itself: maindb:/spylog/db/tmpd # mysqladmin processlist | grep -v Sleep ++--++---+-+---+--+

Re: Re[4]: Proposition: Attach a comment to each connection

> The only thing I would like is to be able to attach a comment to a > connection id which could be returned by the "mysqladmin process" > command. And something that would not add more load to Mysql nor > more coding in the client. Yes!! Great idea. This would be helpful for ho

Re: Unlock tables when process has killed.

Sorry. It's possibly a bug under WinNT (version 3.23.39). For Linux (debian) is OK (version 3.23.39).! Now "KILL id_process" executed and executed hitherto. - Original Message - From: Jeremy Zawodny <[EMAIL PROTECTED]> To: Nick Kostirya <[EMAIL PROTECTED]> Cc: mysql <[EMAIL PROTECTED]> Se

Re[6]: Proposition: Attach a comment to each connection

>> The only thing I would like is to be able to attach a comment to a >> connection id which could be returned by the "mysqladmin process" >> command. And something that would not add more load to Mysql nor >> more coding in the client. AB> Yes!! Great idea. This would be helpfu

Re: Proposition: Attach a comment to each connection

This thread has been "interesting" to follow. But I considered it completely "blue sky". Are you guys supporting a change to the MySQL wire protocol? Are you guys supporting a change to _all_ API's that currently use MySQL that would then have to stick somewhere all these "nice" things in the e

compile

Hi! I download mysql 3.23.39 source code and compile it on HP-UX 11.00. It shows error message as attached text file. Can you tell me how to solve it? Thank you for replying. - Before posting, please check: http://www.mysql.

LOAD DATA INFILE

Hi, I have a CSV-file exported from another database. It contains fields with dates and dates and times. A somplefied CSV-file version looks like so. 20.12.1999;21.12.1999 03:35:27 When I import it with LOAD DATA INFILE... and use fieldtypes "date" and "datetime" it sadly does not work. It i

Re: Unlock tables when process has killed.

At 12:26 05/07/2001 +0300, Nick Kostirya wrote: Hi! Nick I have interest how you did the lock and how the table remains locked on NT. Below I show you a sequence on Win2k machine and how you see after a kill I was able to insert a new row to the table. The client was put down without to close the

client library

Hi! Sorry for bothering you again. Can you tell me more about how to compile client library? I want to install DBD module after installing mysql binary and it can't find client library. Is it true that if I compile source code successfully, it will be included? It seems that the document of DBD mo

Re: LOAD DATA INFILE

>From my experience, if you want to import data into a date field, you have to make >sure that the date format in your csv file conforms to a date format required by >MySQL. This part is covered in MySQL documentation. So, your 20.12.1999 date >should become 2001-12-20 and so on. P.S. Don'

Re: Linking C++ API

Malkhaz Mangoshvili writes: >Hello. My name is Mike. I am writing a C++ program to access a MySQL database. I >have MySQL-3.23.36 server running on Linux Mandrake 8.0. I downloaded mysql++-1.7.9 >version from the internet and installed it successfully. When I try to compile my C++ >program

Re: Proposition: Attach a comment to each connection

I don't know why I got interested in this thread... I suppose you don't need a change to the wire protocol if you have, logically, something like below. The API has to be changed, however. id = do_a_connedtion(arg) set_comment_on_connection(id, "this_is_my_comment") // later some_array = g

Permission

Hi All ! I have just installed MySQL and do not know how to setup permissions for the database that I have just created. Can anyone help Thanks Pankaj Ahuja - Before posting, please check: http://www.mysql.com/manual.php

Problems Installing MySQL

We have installed the Red Hat Linux 7.1 Deluxe Edition on a Pentium III PC (450MHZ) with 128MB RAM. We installed the Workstation option. The OS is Windows 98 Millennium Edition. There are 2 Hard Drives. The 6GB Drive has Windows 98 Millennium Edition installed. The 4GB Drive has the Red Hat Linux

Re: Mysql and Cobalt

dijana cetinic writes: > Hi all, >just a quick question .. has neone setup mysql on a cobalt RAQ4 before? If so >ne > recommendations on how to go about doing it? > > thanx heaps > > D I have never done it, but those that have done it have used ODBC. Nije lako ali je moguce . -

RE: Insert queries add TWO records to database

I'm not convinced as I have the same problem in Netscape. More likely to be a PHP or MySQL configuration problem as the code is fine. Or maybe IIS? May try it on a different server. Regards, John Stoops Software Engineer _ Neutralize (*\*) Independent On

Re: Unlock tables when process has killed.

Thanks, Miguel. I understand. If after killing a process, program of this process come to the end incorrectly (fail), then the table remains locked. Something like have than mysql.exe after killing process don't touch. Other mysql.exe will wait for this process killed, but it doesn't kill while m

Re: Mysql and Cobalt

At 07:45 05/07/01, dijana cetinic wrote: >Hi all, >just a quick question .. has neone setup mysql on a cobalt RAQ4 > before? If so ne >recommendations on how to go about doing it? I've installed it on a Cobalt RAQ. I tried several of the rpm files (from both MySQL and Red Hat), but none

Re[3]: Trouble with mysql

Hello Michael, Wednesday, July 04, 2001, 1:49:25 AM, you wrote: MW> Next time the table gets corrupt, please upload a copy to 'secret' MW> before you repair it so that I can take a look at this when I come MW> back. OK. MW> Do you have anything in the logs about the table being automaticly re

First time MySQL

Hi, I am first time user of MySQL. My ISP has just been installed mysql... I have connected to server through telnet and access MySQL by following command.. and connected successfully. mysql -h myhostname -u root -p password :- mysq> But when I tried to access any database or trying to create

Enhanced MySQL

Hello All, Was wondering if anyone is fimilar with NuSphere's http://www.nusphere.com/ Enhanced MySQL and what advantages, if any it may have. THX, Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://ww

Re: compile

abins writes: > Hi! I download mysql 3.23.39 source code and compile it on HP-UX 11.00. > It shows error message as attached text file. Can you tell me how to > solve it? Thank you for replying. Mailing list manager stripped off your attachment. Instead of building MySQL try using binary from o

Re: LOAD DATA INFILE

Hi, thanks for your answer. You never have problems since youalways use the date format in the standard way, no european exception ;-) mmhhh... It's hard to make the company administering the original data base change the export format. So I'll have to import dates as strings and somehow conve

RE: Enhanced MySQL

Foxserv is also go it has Apache/PHP/MYSQL for Windows Its pretty good and easy to install. http://sourceforge.net/projects/foxserv/ nusphere has Perl and if your not planing on using it theirs no need for it. Cesar Cuneo President Corpsoft Inc. 10855 NW 33 Street Miami FL 33172 Tel. 305-97

RE: LOAD DATA INFILE

This is what i wrote to convert dates in PHP before putting them into db: $new_date = dbDate($HTTP_POST_VARS["Date"]); // Converts DD/MM/YY to /MM/DD function dbDate($date) { $pos1=strpos($date,'/')+1; $pos2=strpos($date,'/',$pos1)+1; $month=substr($date,$pos1,$pos2-$pos1-1); if (str

error 127

MySQL version .38 With a query that is supposed to retrieve something like 8 records from a MyISAM table, I often get the following error: 010705 16:16:26 read_next: Got error 127 when reading table ./sunbow_domains/junit_userprof and the query aborts. Also, I have very often the followin

How to create...

Hi, 1) I am migration from Oracle to MySQL DB. How can I create the SEQUENCE and the TRIGGER in MySQL "style"/"way" . /**/ CREATE SEQUENCE SYS_MSG_TEMPL_SEQ MINVALUE 1 MAXVALUE 999 CYCLE; CREATE TRIGGER sys_msg_templ_trig BEFORE INSERT O

Re: LOAD DATA INFILE

Hi, it seems to me I have to do something like this. It originally was my goal to only use SQL but this does not seem to be possible. Or do you think it's possible to reformat the string using left(), mid() and right() functions in MySQL and put it in a date-field? Best regards and thanks so

Re: Unlock tables when process has killed.

At 14:09 05/07/2001 +0300, Nick Kostirya wrote: Hi Nick, One more thing: the client application is running locally in the same computer of the MySQL server or remotely connected ?. What type of table you are using: MyISAM, BDB or InnoDB. Regards, Miguel >Thanks, Miguel. > >I understand. >If afte

Permission

Hi, Check out this URL it is very good to start with. URL: http://home.ubalt.edu/abento/797/mysql/ I hope that it will help Best Regards, Ilan _ ILAN FAIT Tel: 972-9-9519133 Ex.247iWeb Technolo

Update locking table forever

My site regularly gets extremely slow. When I check the running queries with 'show processlist;' I get this: update XYZ set ... where id=... select ... from XYZ where id=... select ... from XYZ where id=... select ... from XYZ where id=... [...100's of similar selects...] in other words: a single

Re: Unlock tables when process has killed.

locally and MyISAM - Original Message - From: Miguel Angel Solórzano <[EMAIL PROTECTED]> To: Nick Kostirya <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; Miguel Angel Solórzano <[EMAIL PROTECTED]> Sent: Thursday, July 05, 2001 3:35 PM Subject: Re: Unlock tables when process has killed. At 14

RE: Insert queries add TWO records to database

Check your access_log (or IIS equivalent -- if this is occurring on IIS then it's got to be a php bug). I wasn't convinced that it was strictly a browser issue (IE) when apache support laid blame there. However the problem DOES go away by using an older version of apache, AND was not reproducabl

RE: LOAD DATA INFILE

Only if the date being converted is a standard length, i.e. not 2/4/99 All dates would have to be DD/MM/ or MM/DD/, eg. 02/04/1999 If so then yes it can be done in MySQL else u wouldn't know your /'s from your dates John (*\*) -Original Message- From: Bernhard Doebler [mailto:[

Re: No way to get offending Lines during laod data ?

[EMAIL PROTECTED] writes: > 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: > > database,sql,query,table > > If you just reply to this message, and include

Indexing is slow

We are using mysql 3.23.39 . We have the table p6882 with following structure : +---+-+--+-+-+-- --+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+-- --+ | id| int(10)

Re: three tables and count() - Urgent i need it to my job !!

Ireneusz Piasecki wrote: > > Hi my friends !! > > Some few days i have problems with count(). > i have 3 tables: > > t1 holds: > +++ > | id | number | > +++ > | 1 | one| > | 2 | two| > | 3 | three | > | 4 | four | > | 5 | five | > | 6 | sixs | > +-

RE: Proposition: Attach a comment to each connection

Dropping into the thread late, but two points: For all of the standard reasons, different database clients should use different usernames. In the limit, you could just make the username contain the comment. Beyond that, you can already accomplish 90% of what you'd want by simply coding your que

Re: three tables and count() - Urgent i need it to my job !!

Original Message - From: "Robert Vetter" <[EMAIL PROTECTED]> To: "Ireneusz Piasecki" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, July 05, 2001 4:26 PM Subject: Re: three tables and count() - Urgent i need it to my job !! > > > Ireneusz Piasecki wrote: > > > > Hi my frien

Re: Indexing is slow

Pawan Tejpal SA Intellectual Property Ptejpal Knowhow Informatics NIC wrote: > > We are using mysql 3.23.39 . > We have the table p6882 with following structure : > > +---+-+--+-+-+-- > --+ > | Field | Type| Null | Key | Default | > Extra

problem mysql is running 10 minutes and then shuts down.

Hi With this message: show table status/usr/bin/safe_mysqld: line 156: 30874 Segmentation fault nohup $ledir/mysqld --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR --skip-locking >>$err_log 2>&1 Please help want is wrong. Regards Gerlinde BLITZ Internet Service GmbH

Re: Reporting Tool : Linux?

>OK, what are all you guys using for a reporting tool, with MySQL as a >backend (where you don't need Windows) I use StarOffice to connect to MySQL and generate reports. StarOffice is free and runs on Linux (I actually use it on Solaris myself).

Mac OS X Server 10.0.4 and startup

Hi -- Has anyone installed MySQL on MacOS X Server and has safe_mysqld start automatically at boot? On my LinuxPPC box, I add the provided startup script to the /etc/rc.d dir structure. In MacOS X, there is no such directory. Thanks! -- Patrick Larkin Information and Communications Techno

web search form for a mysql database

I have mysql 3.23.38, php4.03, apache1.3.14. I have a small database of dealer bulletins. I have created a web page to allow easy input of new bulletins into the database, and a second web page to display those bulletins. On this page are links to allow displaying the bulletins in several differan

Re: Store picture

- Original Message - From: "Duncan Hill" <[EMAIL PROTECTED]> To: "MySQL News Group" <[EMAIL PROTECTED]> Sent: Wednesday, July 04, 2001 7:46 PM Subject: Re: Store picture > On Wed, 4 Jul 2001, Moonesh Suggun wrote: > > > hi To All, > > > > Has anyone try to insert images e.h. gif into my

Re: Query from two different databases ?

use 'select/insert/... db1.tbl2.fields3, ... db2.tbl3.fld4 from db1.tbl2, db2.tbl3 ... ' etc. in your query. "Andrey F. Mindubaev" wrote: > > Hi, > > How to create query to get data from tables of two different databases ? > > Best regards, Andrey > [EMAIL PROTECTED] > > -

Re[2]: Proposition: Attach a comment to each connection

Bonjour Justin, "user agent" was just an example of what the commentary could be. You could put what you want as long as it's a string. I agree with you and I already had this reflection that it could be a modification that could create some problems to some. Instead of modifyin

Re[2]: Proposition: Attach a comment to each connection

Bonjour Justin, JF> I don't know why I got interested in this thread... More important (or less), why are you so negative ? JF> I suppose you don't need a change to the wire protocol if JF> you have, logically, something like below. The API has JF> to be changed, however. JF> id = do_a

Re[2]: Proposition: Attach a comment to each connection

Bonjour Scott, SH> Beyond that, you can already accomplish 90% of what you'd want by SH> simply coding your queries as "/* Comment */ SELECT ...", and so SH> on. For connections which are not currently running a query, this SH> won't work - but in my experience, you usually don't care muc

RE: web search form for a mysql database

Here's a simple search in MySQL and PHP. Cheers M;-) Search.php3: Searching the Guest Book Searching the Database search for: Srch.php3: "; echo " Visit time and date User Name Last Name Email "; while ($r = mysql_fetch_array($result)) { // Begin while

Re: Alternate database handlers / tests

On Thu, Jul 05, 2001 at 09:52:43AM +0200, Matthias Urlichs wrote: > Hi, > > did anybody ever try to run the standard test suite with another > table handler? I thought the MySQL team did that... > We think about switching to InnoDB, but we see problems..: > > - The maximum blob/text length. We

moving entire databases

Hi While moving computers I tried to copy my entire database by just copying the c:\mysql\data directory and after I have installed a new mysql database on the new computer I just relpaced the data directory with my own archived one . Now when I try to start the server it gives an error host.

INSERT INTO

Hi, I am trying to insert data from one table to another with the command: INSERT INTO attrib_values (attrib_id,attrib_value) values (Select attrib_id,attrib_default_value FROM attribs) And I get error massage: You have an error in your SQL syntax near 'Select attrib_id,attrib_default_val

Re: web search form for a mysql database

What if you want to search for a number of terms? Say you have a database of common computer problems and solutions with a (simplifid) schema like this: Name Email Problem Solution Say you want to search on the Problem field. The Problem field would be strings of text like "Problem with aut

Re: moving entire databases

On Thu, Jul 05, 2001 at 06:41:15PM +0100, christopher sagayam wrote: > Hi > > While moving computers I tried to copy my entire database by just > copying the c:\mysql\data directory and after I have installed a new > mysql database on the new computer I just relpaced the data > directory with my

MySQLGUI

Are there any know issues or bugs with MySQLGUI running on Solaris 8 thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To reque

Re: moving entire databases

Wonderful answer ..my problem solved Thanks chris - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "christopher sagayam" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, July 05, 2001 6:49 PM Subject: Re: moving entire databases > On Thu, Jul 05, 2001 at

Re: Problems Installing MySQL

Oh, and if you're going to use this system as a server for intranet/internet resources, why do you have a Win98 drive installed ?? You won't be able to use it if you're going to keep the system up, running Linux... - Original Message - From: "Steve Brazill" <[EMAIL PROTECTED]> To: "Gavi

Re: Proposition: Attach a comment to each connection

BAUMEISTER Alexandre wrote: > > Bonjour Justin, > > JF> I don't know why I got interested in this thread... > > More important (or less), why are you so negative ? > Je ne suis pas contre. I just haven't felt the need for this, but after reading your scenario, I can't understand why. Email

RE: INSERT INTO

On 05-Jul-01 Ilan Fait wrote: > > > Hi, > > I am trying to insert data from one table to another with the command: > > INSERT INTO attrib_values (attrib_id,attrib_value) values (Select > attrib_id,attrib_default_value FROM attribs) > > And I get error massage: > > You have an error in yo

Re: web search form for a mysql database

I think then you get into using Index's or FullText searchs http://www.mysql.com/doc/M/y/MySQL_indexes.html http://www.mysql.com/doc/F/u/Fulltext_Search.html -Original Message- FROM: Patrick J. Larkin TO: MySQL List DATE: Thu 7/5/01 11:51 SUBJECT: Re: web search form for a mysql data

MS-DOS

Hi, I'm starting mysql in a DOS window. Is there a possibility to use the arrow buttons to go up and down within the last used commands? thanks and regards, Sibel. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://person

Re: web search form for a mysql database

For my needs, that would not be necessary, just a simple single word search. I now have to figure out how to integrate what Mr. Massey suggested into my existing form, so far I have not got it to work. I guess I'm just stupid with mysql, I'm a newbie just trying to get something the marketing pe

Re: web search form for a mysql database

First NO ONE IS STUPID! Somethings have to be learned that's all. Now back to the search function. I use http://www.weberdev.com and a few other sites to pull tutorials from that show you how to do different things. Go join and search for Search and you'll find that there are allot of other s

Re: MS-DOS

WinME has this built right in, elsewise try doskey Matt "TrollBoy" Wiseman Webmaster: Shoggoth.net Site Designer: phpslash.org The oldest and strongest emotion of mankind is fear, and the oldest and strongest kind of fear is fear of the unknown. -H.P. Lovecraft ---

Re: MS-DOS

On Thu, Jul 05, 2001 at 03:17:05PM -0400, Matt TrollBoy Wiseman wrote: > > WinME has this built right in, elsewise try doskey How does WinME know what to do in the mysql command-line interpreter? Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-78

Can't get keys for table

I am getting an error when try to use mysqldump on a database. /usr/local/mysql/bin/mysqldump: Can't get keys for table agora (Lost connection to MySQL server during query) When this happens, I get a message in the error log saying the database has been restarted. mysqld restarted on Thu Jul 5

Re: web search form for a mysql database

Thanks, I guess I just meant I'm just stupid on this subject, not stupid overall, heh heh. Anyway, thanks for the reference, I'll check it out shortly. -- Chip <[EMAIL PROTECTED]> on 07/05/2001 09:03:56 PM Internet mail from: To: [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Subject: Re: web

problems with dowloads

I cant download in this link: Win32 static binary of MySQLGUI 1.7.5-1 The client software. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Can't init Databases

I get an error 'Can't init databases' how would I fix that? - Oso - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread,

RE: MS-DOS

hi. use mysqlc instead of mysql when you start the client. hth. -ravi. -Original Message- From: Sibel Toprakkiran [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 2:35 PM To: [EMAIL PROTECTED] Subject: MS-DOS Hi, I'm starting mysql in a DOS window. Is there a possibility to u

indexing

Hi, I'm using MySQL 3.23.39 under Red Hat 7.1 on a Pentium III 600mhz with 640MB of Ram. I only 1 table in a database with 5.6 million records and I'm currently trying to index a varchar(100) field. I started the query "alter table mytable add index myfield (myfield)" at 10am EST this morning

RE: MS-DOS

hi, thanks a lot. It's going. regards, sibel. --- Ravi Raman <[EMAIL PROTECTED]> wrote: > hi. > > use mysqlc instead of mysql when you start the > client. > > hth. > -ravi. > > -Original Message- > From: Sibel Toprakkiran [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 05, 2001 2:

LIKE Magic

Hello! Could somebody explain me why it's like that: mysql> select count(*) from docs where kword_10 LIKE '%Ukraina%'; +--+ | count(*) | +--+ |1 | +--+ 1 row in set (0.09 sec) ^^^ This is true! mysql> select count(*) from docs where kword_10 NOT LIKE '%Ukraina%'

update

How do I do to execute a UPDATE using sub query as in the example below? update veiculo2000 set marca = ( select arq2.marca fromveiculo arq2 where veiculo2000.status_veic = '0'

Innodb

Anybody know why when I enable the Innodb in the /etc/my.cnf it tells me can't init databases? - Oso - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the li

restorin a nt 4 database

Hi, cen anyone help me with this question. > >To restoring a database [in the event of a disk crash for example], > run the restore from tape and rebuild the database, then > take the transaction logs and upload those into the database to bring it > up to date. > > >From what I can tell, Mysq

Re: LIKE Magic

You must have 8001 - 1 - 2788 NULLs for kword_10. Please confirm it. Jakub Wasielewski wrote: > > Hello! > > Could somebody explain me why it's like that: > > mysql> select count(*) from docs where kword_10 LIKE '%Ukraina%'; > +--+ > | count(*) | > +--+ > |1 | > +-

Re: Innodb

On Thu, Jul 05, 2001 at 04:29:05PM -0400, Brandon Berry wrote: > > Anybody know why when I enable the Innodb in the /etc/my.cnf it > tells me can't init databases? Did you put all the InnoDB related options in your my.cnf file? Could you post the relevant section and the error message you got? J

Re: LIKE Magic

> Dibo Chen == [EMAIL PROTECTED] napisał(a): > You must have 8001 - 1 - 2788 NULLs for kword_10. Please confirm it. Yes it's true! But why NOT LIKE gives false for NULL values? How can I get rid of this NULL's? Is "update docs set kword_10 = '' where kword_10 IS NULL" enough? Cheers, I love

RE: Innodb

These are the options I used. [mysqld] innodb_data_file_path = ibdata; innodb_data_home_dir = /usr/local/mysql/data set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = /usr/local/mysql/data set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=50M set-

Browser GUI

Hi All, I've been looking at alot of the GUI's offered at mysql.com, and was wondering if someone could recommend a good full MySQL administrator, for fully maintaining MySQL server/clients that is used thru the browser and not locally on a PC. thanks, Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=

Re: How delete the first register in a table?

Hi. Within SQL, there is no such concept like "first in a table". By specification the internal table order is undefined and completely open to the actual implementation and may change anytime without notice. You may not rely on it. Order is determined on retrieval (SELECT) with the ORDER BY cla

connecting to mysql securely via network

If I connect to mysql: mysql -u username -p wherever.net is that encrypted at all? and if I make a network program via the C API, would that be encrypted too? Thanks James Gosnell [EMAIL PROTECTED] - Before posting, p

RE: Innodb

hi. make sure you have the right binary...i believe it's called mysql-max or something... hth. -ravi. -Original Message- From: Brandon Berry [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 4:55 PM To: Ravi Raman Subject: RE: Innodb It's a binary install. - Oso -Original

Loading data into a remote server from csv file?

I need to be able to add a .csv file into a database table running on a mysql server of IP address 10.0.0.10 I know that "load data infile 'me.txt' into table stock;" will do the job locally but what's the easiest way for me to add me.txt to stock on 10.0.0.1? For arguments sake we can

newbie - connecting to data base with php sql_pconnectstatement

I am trying to connect to a mysql server fom a php script using the php sql_pconnect statement. I have used "localhost" as the host name, and the userid and password I normally use when connecting from the console. However, when executing the sql_pconnect statement I get an error message that r

  1   2   >