AW: Duplicate Entry in Key 1

Hello Gerald, what would you suggest?? Should I give you a list of all 600.000 entries in the table?? And there is nothing special about the structure ... they are similar .. with only one single-column primary key. And the key being different each time I run the script should tell you that there

running mysql

Hi all, I have just compiled mysql 3.23.33 with db 3.2.9a and successfully installed it. However when I try and run the server it Seg faults > /usr/local/mysql/bin/safe_mysqld & spitting out this error message Starting mysqld daemon with databases from /usr/local/mysql/var /usr/local/mysql/bin

searching ALL tables

Hi all, I just want to know how to search all tables I can work out how to search one table, or a few of them at a time but since we have 1000+ tables, I figure there must be an easyer way I have tried using % & * instead of the table name, but with no luck Hope someone can help Thank you in adva

Free Hosting

Does anyone know where to get a hosting that is free to support MySql with PHP. I need to try out first before purchase a parking space at internet. Regards Cally

BACKUP TABLE causes the error"The handler for the table doesn't support check/repair"

i am using MySQL version 3.23.33 and i created a database with one simple table called "chapters" according to http://www.mysql.com/doc/M/y/MyISAM.html MyISAM is the default table type in MySQL Version 3.23 so the "chapters" table should be a MyISAM table. i populated the table with some inform

indexes on TEMPORARY HEAP tables ignored in ORDER BY / GROUP BY

Hi, I'm not subscribed to the list so please CC: me on replies. Why are indexes on TEMPORARY tables created with TYPE=HEAP ignored when doing a query involving ORDER BY or GROUP BY? These indexes are used in some selects involving a WHERE clause, so obviously the index isn't completely worthless

Re: locking oddity

thanks, Then I imagine, as a rule, I should be thinking about changing that server variable to set selects to always have priority? Without transactions, one should never have a situation where any ill effects can result from delaying "users" that issue live insert or update requests until the p

How can i duplocate a database???? i 've tried mysqldump can get it towork ANy ideas??

I am trying to make several copies of a database i have tried mysqldump -databasename can some one throw a piece of code please; Thanks

RE: updating table 1 where table 2 condition? & join

Hi, on item two, you need to do a self join, and then select 'having max(t1.date)=max(t2.date)' I have a similar query, where I want to select the record with the highest number of transactions for each client, which is solved by: SELECT t1.code, u.name, t1.site_code, t1.we_date, Max(t1.express

RE: locking oddity

Hi, Imagine the scenario of the following happening in quick succession: user1: select * from table --- ticks away, doing the select user2: select * from table --- also ticks away user3: insert into table ... --- locked!, waiting for selects to finis

Interminable myqld processes

I have been having some trouble recently with mysql creating some processes that don't ever seem to terminate, and chew up a lot of cpu time. I can't locate the problem in my code at all, but I was just wondering if anyone else had had similar problems. Matt __

Can't start the server

I ran mysql_install_db it created the tables and the database fine. but I am having trouble starting the server i am getting error cannot connect with /var/lib/mysq/mysql.sock (111) Any clue? _ Get your FREE download of MSN Explorer

Impossible to use/launch Mysql++ and Mysqlgui: idea, suggestion, ...

Hello, Currently, I'm evaluating the last version of MySQL products : mysql-3.23.33 mysql++-1.7.8 mysqlgui-1.7.4 (beta) I have big pb to launch mysql++ and mysqlGui : it crashes during DB connection After spending many days trying to solve this issue by myself (reading doc., readin

select within select

hi, i was wondering if the above is possible in mysql. i was working on a query but it keep throwing me syntax error. example: sql> select * from table1 where id in (select id from table1 group by id having count(id) > 1) the above statement works perfectly in mssql... thanks & regards, lance

FAQ

Hello, Is there a FAQ/archive site that I can search in for answers to problems; in particular I'm having problem installing MySQL 3.23.33 binary. There seems to be no such link on MySQL's home page. Thanks Hamid

locking oddity

Hi, Can someone explain this? | 13 | XX | chrome | XX | Query | 1 | Locked | SELECT name FROM users WHERE uid=288950 || | 376 | XX | chrome | XX | Query | 1 | Sending data | SELECT uid FROM users WHERE name |like '%Fuzzster' limit 1 | | 397 | XX | chrome | XX | Query | 1 | Locked | SELECT uid,

updating table 1 where table 2 condition? & join

Hello All, Two items: 1. UPDATING TABLE 1 WHERE TABLE 2 CONDITION Is it still true I cannot update table 1 on a table 2 field condition? example: UPDATE member SET member.acluser='6' where payment.memberexpires < '2001-03-09' ... big sigh ... 2. JOIN SYNTAX I need help with a specific join sy

Re: More on: mysqld got signal 11

Most of the times I have seen signal 11 in the past, it turned out to be bad memory. Once I saw it with a bad motherboard. Another time, it was a bad stick of RAM. The bad stick was a really hard one to track down as you needed to have something really finicky get put at that address before

Re: Optimizing JOINS -- related matter

Hi, I'd try to `optimize' the tables in the first place. Have you tried to select and group by PR1.pollResponsesID instead of PR2.pollResponsesID? As they are the equal, the result should be the same, but the query might get optimized better. Hope this helps, Jan "Oson, Chris M." wrote: >

Re: Cold Fusion

At 13:53 08/03/2001 -0800, Andrew Staples wrote: Hi! I did a CF tag for Coldfusion to build and remove DSN files for MyODBC. The dll is called mydsn.dll and you find it at our contribution page and you can get the source code for VC++ too. Regards, Miguel >New to list, and to mySQL. If there are

got it installed, but can't run daemon

On system: SuSE 7.1 Professional MySql version: Ver 3.23.32 for pc-linux-gnu on i686 have also run the mysql_install_db, which says that all files have been installed. when running safe_mysql & 1) mysqld errors out 2) I get the following in linux.err Jerry

Re: Removing duplicates from a table

on 3/8/01 3:40 PM, Scott Wang at [EMAIL PROTECTED] wrote: > select distinct addr from tablename outfile filename.txt > > But how can I write the data to another table or even > replace the information in the table with the output info? insert into (addr) select distinct addr from You would p

Removing duplicates from a table

Hi guys, I set up a table that I'll be using for a mailing list. Two fields: id and addr. The id is a unique primary key that is used to "identify" (?) the email address in the addr field. How can I remove duplicate addresses in the addr field? I know of the select distinct addr from tabl

RE: More on: mysqld got signal 11

Damn! It took longer, but crashed again. The stack trace has been the same as the last three crashes: # resolve_stack_dump -s /tmp/mysqld.sym -n mysqld.stack 0x40097532 __evoke_link_warning_llseek + 937652786 0x80b3360 mysql_update__FP3THDP13st_table_listRt4List1Z4ItemT2P4ItemUl15enum_duplicate

Re: key lengths

I have a similar problem indexing a TEXT field. I am trying to create a unique index on the first 1024 characters of a TEXT field: * >mysql * Welcome to the MySQL monitor. Commands end with ; or \g. * Your MySQL connection id is 66 to server version: 3.

Re: Cold Fusion

> 1. Can CF work with mySQL via myODBC on win2k? Of course. That's the beauty of ODBC, as long as your language can call an ODBC connection (which CF can of course) you can use it. > 2. Is there a better way to use CF and mySQL? With what goal in mind? If you're worried about the overhead tha

Re: Cold Fusion

Andrew Staples wrote: > > New to list, and to mySQL. If there are archives available, please let me > know--I'll search them. > > I have a client who is building a new win2k server, and wants to use > ColdFusion to connect to a mySQL db, instead of MS SQL7.0. Docs show it > will work with myOD

Purging databases

What is the process to purge databases in mysql? Thanks in advance, Aruna. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: problems with tutorial

Hello David, Thursday, March 08, 2001, 11:44:21 PM, you wrote: DP> folks, DP> I need help. I installed mysql on NT, everthing seems fine. I wanted to insert fields into a table, as described in the tutorial from a file. It said the default that delimits a field is a tab, DP> so I added fields

RE: problems with tutorial

Need more info. Which tutorial? Are you trying to insert data into a table or put new fields into an existing table? Cal http://www.calevans.com -Original Message- From: David Phoon [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 3:44 PM To: [EMAIL PROTECTED] Subject: problem

Cold Fusion

New to list, and to mySQL. If there are archives available, please let me know--I'll search them. I have a client who is building a new win2k server, and wants to use ColdFusion to connect to a mySQL db, instead of MS SQL7.0. Docs show it will work with myODBC, but gives examples for Unix. 1.

Does FULL TEXT speed up LIKE matches also ?

I find the fuzzy matches from MATCH and AGAINST to be too unpredictable. Does using a FULL TEXT index also speed up simple LIKE searches ? - Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.

Re: newbie mysqldump problem

On Thu, Mar 08, 2001 at 03:33:54PM -0600, Gerald L. Clark wrote: > > Well, I am running 3.23.33, and it works for me. > I'm working via ssh on an ISP's host. I wonder if there are permissions that have to be set in order to run mysqldump. Out of curiosity, I tried it on another ISP running MySQ

problems with tutorial

folks, I need help. I installed mysql on NT, everthing seems fine. I wanted to insert fields into a table, as described in the tutorial from a file. It said the default that delimits a field is a tab, so I added fields delimited by tabs. (i used microsoft edit to create the file). i have also

Re: newbie mysqldump problem

Well, I am running 3.23.33, and it works for me. Doug Poland wrote: > > On Thu, Mar 08, 2001 at 03:03:43PM -0600, Gerald L. Clark wrote: > > mysqldump --databases db1 db2 db3 ... > > > > Note, these are complete databases, NOT tables. > > > > to try it do: > > > > mysqldump --databases mysql >

please unsubscribe me

I wish to unsubscribe from this service, but although I tried before, I couldn't. Can somebody unsubscribe me please or tell me how to do it. Edd. [EMAIL PROTECTED]

Error -1: table handler

Hello, I ran some interesting queries on a certain table in my mysql-3.22.32, solaris 2.6. The queries hanged and I got this error: Error -1 from table handler. Now I can only connect to the DB using the 'mysql -A' option and I cannot access that particular table. All queries on it, even simple

Re: newbie mysqldump problem

On Thu, Mar 08, 2001 at 03:03:43PM -0600, Gerald L. Clark wrote: > mysqldump --databases db1 db2 db3 ... > > Note, these are complete databases, NOT tables. > > to try it do: > > mysqldump --databases mysql > I've tried that. But I tried it again anyway. This is a screen copy... admin:~$

Re: how do you select by date?

Thanks to everyone who helped so quickly =) Based on what people said, I was able to come up with a solution. The goal was to get a total number of log entries from a given month and year. The query we came up with is: select count(*) as Total from log where month(datestamp) = '$current_mont

Re: newbie mysqldump problem

mysqldump --databases db1 db2 db3 ... Note, these are complete databases, NOT tables. to try it do: mysqldump --databases mysql Doug Poland wrote: > > Hi, > > I'm having a dickens of a time getting mysqldump to > work. No matter what I enter, mysqldump says... > > /usr/local/mys

Upgrade with unexpected results

Can anyone shed a little light on this for me? I've got a mysql installation that has been running for over 2 years now. As the database has grown to over 250Meg (not TOO large at all) things have kind of slowed down. We're running this on a RH box with mysql v3.23.32. So, we bought a new s

newbie mysqldump problem

Hi, I'm having a dickens of a time getting mysqldump to work. No matter what I enter, mysqldump says... /usr/local/mysql/bin/mysqldump: option `--databases' doesn't allow an argument I've perused the list archives and looked at the manual. It should work but doesn't. What am I doing

Re: how do you select by date?

.WHERE monthcol=MONTH(now()). I think this should work. > Hi =) > > Could you help? I have a table with a datetime field and I'm trying to > figure out how to format an SQL query to select records only from within > the current month. Any help would be greatly appreciated. > > Thanks, >

Sum of a CASE Expression

I can't see how CASE works ?? Manual is fairly breif on the subject. The SQL below has some kind of snag. Is this getting too hairy to use CASE within a sum expression ?? Any thoughts or comments would be appreciated. SELECT Sum(DebtorTrans.OvAmount + DebtorTrans.OvGST + DebtorTrans.OvFreight

Re: mysql_install_db problem

scripts/mysl_install_db --user=mysql Now that you have files and directories created under the wrong user, you can chown -R mysql /usr/local/mysql/var or whatever the data directory is on your system. Titus Purdin wrote: > > I am installing mysql-3.23.33-dec-osf5.1-alphaev6 on a DEC Alphastati

how do you select by date?

Hi =) Could you help? I have a table with a datetime field and I'm trying to figure out how to format an SQL query to select records only from within the current month. Any help would be greatly appreciated. Thanks, -Ed -

Re: Problem

As noted on the mysql website, you need to use the gnu version of zip (gtar-sparc)if you are on solaris, as you are /Cody Caughlan ALICE CHIAPPETTA wrote: > I have downloaded the stable release for Solaris. Everytime I try to > gunzip and tar it. Everything works till the end then I get

Patch: Failed INSERT DELAYED blocks future INSERTs in 3.23.32

Hi! > "Lance" == Lance Lovette <[EMAIL PROTECTED]> writes: Lance> If I INSERT DELAYED into a table with an auto_increment column and specify a Lance> value of NULL for that column, the query fails. This is to be expected. Lance> After this failure however, normal INSERT queries start piling

Re: mysql_install_db problem

I am having the same problem, and can't seem to find a work around. If you go to version 29a I believe it works fine. -Eric >>> Titus Purdin <[EMAIL PROTECTED]> 03/08/01 11:25AM >>> I am installing mysql-3.23.33-dec-osf5.1-alphaev6 on a DEC Alphastation running True64 Unix version 5.0A. Logg

Problem

I have downloaded the stable release for Solaris. Everytime I try to gunzip and tar it. Everything works till the end then I get a checksum error. It never creaed the var directory in the mysql directory. Could this be the problem. I have even try to download the software from the Wisconsin mi

Re: MySQL proxy

Hi Right now I'm happy. Sorry for spam. I had an error in mys socket coke. By P.S. Proxy works well and gives many possibilities. Daniel Łaś wrote: > > Hi > > I follow this list for long time. This is first time I have to ask the > question. > > I'm developing something like proxy for mysq

mysql_install_db problem

I am installing mysql-3.23.33-dec-osf5.1-alphaev6 on a DEC Alphastation running True64 Unix version 5.0A. Logged in as root, when I run scripts/mysql_install_db as part of the installation, it runs as far as % scripts/mysql_install_db Preparing db table Preparing host ta

Bug in MyODBC 2.50.36-nt ??

Hi everybody, I am using a MySQL Database with MyOdbc 2.50.36-nt under WinNt SP6a and Win 2000 SP 1. The language of my frontend is CA Visual Objects (ClassMate library for SQL) When skipping through my data set with nRetCode = SQLExtendedFetch(HStatement,SQL_FETCH_NEXT,0,@nNumRows,@nRow

More on: mysqld got signal 11

Hi! I have received several emails from people that choose not to (or can not) post to the list about mysql segfaulting. At the moment, I have the segfaults stopped by doing all of the below, I don't know (yet) which are to blame or in what combination: 1) Eliminate insert delayed (not really n

INSERT delayed and concurrent inserts

Hi! Does MySQL's insert delayed handler insert concurrently with selects on MyISAM tables like the non-delayed inserts? Sincerely, Steven Roussey Network54.com http://network54.com/?pp=e - Before posting, please check: htt

MySQL proxy

Hi I follow this list for long time. This is first time I have to ask the question. I'm developing something like proxy for mysql. Everything works fine except when mysql client working with mysql over proxy is reciving bigger amount of data. For example big resultset. Let me explain situation.

MySQL and Z39-50

Can anyone recommend a Z39-50 Server to use with MySQL? thanks Melanie Dutkiewicz -- Melanie Dutkiewicz, PhD.Tel: (604) 278-3411x2520 MacDonald Dettwiler direct line: (604) 231-2520 13800 Commerce Parkw

Re: select DISTINCT() hang - but non corrupt table

No, it is not disk space.. it is not table corruption either.. it is server confusion, with no diagnostic information output. Symptom again: hang on straight forward queries involving a total index scan, with either count(*) or distinct(*), usually stuck with 100% cpu use of the thread in 'sendi

Optimizing JOINS -- related matter

Hello, On a related matter, do the various JOIN's (LEFT, INNER, and OUTER) use a temp file when processing? Table pollResponses: +-+---+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-

MySQL Failover solutions?

Hi, We are implementing a linux cluster, and rather than get gouged by oracle (in performance and licensing) would much rather use MySQL. I searched through the archives and found several references to failover and replication but still have some questions. If I understand correctly, repl

Re: optimising joins: where vs. using/on

Christian Hammers wrote: > > On Thu, Mar 08, 2001 at 10:29:20AM -0700, Steve Ruby wrote: > > He is doing an inner join, you are doing a left join, they (potentialy) > > do not produce the same results. > Hmm have to think about it... inner means fields where the right table has > a NULL value in

Re: optimising joins: where vs. using/on

Christian Hammers wrote: > > On Thu, Mar 08, 2001 at 10:29:20AM -0700, Steve Ruby wrote: > > He is doing an inner join, you are doing a left join, they (potentialy) > > do not produce the same results. > Hmm have to think about it... inner means fields where the right table has > a NULL value in

Re: Duplicate Entry in Key 1

Tobias Wolff wrote: > > Hello, > I have searched the mailing list for this topic, but didn't find a match vor > my problem. > > I am working on Linux Mandrake with MySQL 3.23.33 installed from the RPMs > for Mandrake. I am trying to convert a ACCESS database to MySQL using a perl > script. The s

Re: Converting a FreeBSD UNIX Mysql Database

Tom Flanagan wrote: > > Does anyone know how to convert a FreeBSD UNIX MYSql database to Windows > NT/2000 MYSql Database? > > Thanks, > > Tom Flanagan > If you are using MyISAM tables (3.23.x) you can simply copy them from one computer to the other. If you are using ISAM tables like in 3.2

Re: optimising joins: where vs. using/on

On Thu, Mar 08, 2001 at 10:29:20AM -0700, Steve Ruby wrote: > He is doing an inner join, you are doing a left join, they (potentialy) > do not produce the same results. Hmm have to think about it... inner means fields where the right table has a NULL value in the condition are left out, right? >

Re: Duplicate Entry in Key 1

If you are using MS Access, the easiest way is to export the tables via the ODBC driver. Simply right click on your table name, then click export. At the bottom of the list there the ODBC option. I haven't had any problems using this method of transferring tables, other than the fact that MySQL

Re: optimising joins: where vs. using/on

Steve Ruby wrote: > > Christian Hammers wrote: > > > > Hello list > > > > While browsing old sources by a former employee I realised that he always > > did comma seperated joins and then a "where" > > FROM > > tablea a, tableb b, tablec c > > WHERE > > a.id=b.i

Re: Converting a FreeBSD UNIX Mysql Database

In the last episode (Mar 08), Tom Flanagan said: > Does anyone know how to convert a FreeBSD UNIX MYSql database to Windows > NT/2000 MYSql Database? Just copy the files over to the new machine. No conversion necessary. -- Dan Nelson [EMAIL PROTECTED] -

Re: optimising joins: where vs. using/on

Christian Hammers wrote: > > Hello list > > While browsing old sources by a former employee I realised that he always > did comma seperated joins and then a "where" > FROM > tablea a, tableb b, tablec c > WHERE > a.id=b.id and b.nr=c.nr > whereas I learned to

Converting a FreeBSD UNIX Mysql Database

Does anyone know how to convert a FreeBSD UNIX MYSql database to Windows NT/2000 MYSql Database? Thanks, Tom Flanagan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: optimising joins: where vs. using/on

In the last episode (Mar 08), Christian Hammers said: > While browsing old sources by a former employee I realised that he > always did comma seperated joins and then a "where" > FROM > tablea a, tableb b, tablec c > WHERE > a.id=b.id and b.nr=c.nr > whereas I l

optimising joins: where vs. using/on

Hello list While browsing old sources by a former employee I realised that he always did comma seperated joins and then a "where" FROM tablea a, tableb b, tablec c WHERE a.id=b.id and b.nr=c.nr whereas I learned to do FROM tablea a

BLOB

Hi What is the best way to download and upload BLOB object to MySQL database using Java, JDBC I tried using load_file in an INSERT query but it did not work Also I would like to know how to read the BLOB objects from the database Hesh

Duplicate Entry in Key 1

Hello, I have searched the mailing list for this topic, but didn't find a match vor my problem. I am working on Linux Mandrake with MySQL 3.23.33 installed from the RPMs for Mandrake. I am trying to convert a ACCESS database to MySQL using a perl script. The script makes connections to the ACCESS

Oracle to mySQL

I am porting an application from Oracle to mySQL and I have this query which I need to port: select id, senderID, recipientFirstName, recipientLastName, recipientGender, occasion, month, day, sentDate from reminderclub where (sentDate is null or sentdate-sysdate>30) and (to_date(month||'/'||day||

Re: Connect MySQL from Python

The following URL Points to the Python MySQl interface. Also Zope is a web applications server written in python which has the ability to connect to MySQL. http://dustman.net/andy/python/MySQLdb/ ±i¸Î¯q wrote: > Dear Guys, > > Is there any API or modules to connect MySQL from Python?? > > -- >

Re: Installation MySQL

Yoann Chevalier writes: > Bonjour, > > Tout d'abord, il s'agit d'une liste de diffusion anglaise, donc si tu veux > que le plus de monde puisse t'aider, il vaut mieux faire la demande en > anglais. > Ensuite, il faut eviter d'envoyer des e-mail sous forme HTML, car pour > certains utilisat

Re: sql_yacc on IBM S/390 Mainframe

John Nealy writes: > I am trying to compile version 3.23.33 on Linux on an IBM S/390 mainframe. > I the following entry to > config.sub to get configure to recognize the machine type: > > # Added a CPU type for the S/390 so we could compile. J. Nealy 3/5/2001. > s390-*) >

Re: Poddible SHOW DATABASE || TABLE bug in 3.23.33

[EMAIL PROTECTED] wrote: > Whops ! This is the know bug, but I did mysqlbug on this machine a fwe weeks ago, and have only just sorted out the mailserver today - and did not notice this in the queue - appologies for wasting anyones time with this. As an aside has anyone got further than this b

Re: Installation MySQL

Bonjour, Tout d'abord, il s'agit d'une liste de diffusion anglaise, donc si tu veux que le plus de monde puisse t'aider, il vaut mieux faire la demande en anglais. Ensuite, il faut eviter d'envoyer des e-mail sous forme HTML, car pour certains utilisateurs (UNIX,Mac) ca devient illisible !! Et de

DIGITECNIA.COM -SOLUCIONES WEB-

DIGITECNIA.COM presenta su nuevo portafolio de Soluciones Internet: -Hosting -Desarrollo de Sitios Web -Diseño y Animacion Multimedia -Comercio Electronico -eMarketing Con Excelentes Precios, Servicio y Soporte que garantizan el exito de la presencia de su empresa en la red. Visitenos en: http:

Re: C API

Mark I ran into a similar problem building a VB maintenance program for a database that resides on Linux. Many of my queries were too big for MyODBC to return. I ended up using the count function to find out how many records would be returned then allowing the user to fetch them in blocks via li

Antwort: php libraries

On 08.03.2001 13:39:34 James Makunike wrote: > Where do I get the php libraries as one file? What do you mean? http://www.php.net has the sources and binaries - Before posting, please check: http://www.mysql.com/manual.p

Poddible SHOW DATABASE || TABLE bug in 3.23.33

>Description: SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e a nice list of blanks - no of blank lines equals number of databases / tables) >How-To-Repeat: Do a mysqlshow or SHOW DATABASES under mysql >Fix: >Submitter-Id: >Originator:Greg Cope >Organization: >

Re: reinstall mysql

Hi Have tried to start it manually instead of reinstalling it? Seung-woo Nam Rashid Zolqarnain wrote: > Hello, > I installed MySql serevr version 3.23.33 on Red Hat Linux 7.0. > Sometimes when I reboot the system, MySql do not work. I have to > uninstall and then reinstall > MySql serv

INSERT DELAYED and auto_increment: NULL or 0?

I am confused about the way INSERT DELAYED reacts to setting an auto_increment field to NULL. I am inserting records into a table where one of the columns is auto_increment. Usually when setting the value of an auto_increment field in an INSERT query I pass a value of NULL. When I do the same thin

Fwd: Quick question

If you can deal with the technical query below it would be much appreciated. Many Thanks Sunit - Original Message - > From: Jonas Norrman <[EMAIL PROTECTED]> > Message-ID: <[EMAIL PROTECTED]> > Date: Thu, 8 Mar 2001 17:49:37 +0100 (CET) > To: Sunit Modi <[EMAIL PROTECTED]> > Cc: [EM

Improving MySQL installation in ApacheToolbox - RFC

Dear All I've been using apachetoolbox - a shell script that installs apache with the options of including lots of modules (php, mod_ssl, mod_perl etc ...). Its great for installing a custom apache (something I do all to often ;-). It offers a menu and will download / configure / complie any ne

Re: wishlist: create_tmp_priv in mysql.db

Christian Hammers writes: > Hello > > I like to propose the attribute create_tmp_priv as little alternative to > create_priv. > > The reason is that due to the lack of sub-selects temporary tables which > can be created with the same name at the same time by many connections are > ofte

RE: RENAME CRASH MySQL

Read the manual about security and stuff -Original Message- From: Fabien COMBERNOUS [mailto:[EMAIL PROTECTED]] Sent: donderdag 8 maart 2001 15:48 To: Sinisa Milivojevic Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: RENAME CRASH MySQL I'm working with Linux Mandrake 7.0 with MyS

UDF 'create function' error, or is it just me?

Hi! I've compiled the udf_example.cc file into an so, copied it to /usr/lib, but when i issue a CREATE FUNCTION lookup RETURN STRING SONAME "udf_example.so"; I get: Error 1041: Out of memory. I've searched the mailing list and the web, and all the information I get is that it seems to only funct

buggy support for cp1257

Hello mysql, (Note: this post contains characters in windows-1257 encoding, they may appear incorectly in your e-mail clients). I believed everything is OK with MySQL support for cp1257 charset until I actually tried to sort records alphabeticly. What I find out was: 1. Typo in cp1257.conf sor

sql_yacc on IBM S/390 Mainframe

I am trying to compile version 3.23.33 on Linux on an IBM S/390 mainframe. I the following entry to config.sub to get configure to recognize the machine type: # Added a CPU type for the S/390 so we could compile. J. Nealy 3/5/2001. s390-*) basic_machine=s390-ibm

Re: RENAME CRASH MySQL

I'm working with Linux Mandrake 7.0 with MySQL_GPL-3.20.32a-18mdk and MySQL_GPL-shared-libs-3.20.32a-18mdk and MySQL_GPL-client-3.20.32a-18mdk and perl-Mysql-1.19_14-1mdk I have thoses process running on my computer : root 4798 1 0 Mar07 ?00:00:00 sh /usr/bin/safe_mysqld root

reinstall mysql

Hello, I installed MySql serevr version 3.23.33 on Red Hat Linux 7.0. Sometimes when I reboot the system, MySql do not work. I have to uninstall and then reinstall MySql server. What could be the problem? Rashid - Befo

Re: "Sending data", but no data sent?

Can anyone tell me how to UNSUBSCRIBE from this LIST. Thanks a lot "Matthias Urlichs" <[EMAIL PROTECTED]> wrote: > > Hi, > > Sinisa Milivojevic: > > First of all, where have you got 3.23.34 when it is not out ?? > > > It's the version in your current BitKeeper archive. > > > Second what type

Re: C API

Mark Selby writes: > Hi all, > > When having performed a query with a LIMIT, is there any way to get > the total records that would have been retrieved without the LIMIT > being used (other than building and executing a separate COUNT (*) > query) ? > > Please CC to this email address a

Newbie Select Problem URGENT

Hi All I am trying to compare information in 2 different tables and return matches. The problem is that this query only returns the listings where I want it to return a row from AutoEmail when it finds a match. What am I doing wrong? SELECT * FROM AutoEmail, listings WHERE ((listings.prop_styl

Re: help for mysql installation

liu hui wrote: > > hello; > I meet a problem when I wont to install mysql3-23-33. > after I run the command > ./configure > a error report to me > the last several line are printed as followed: > " > checking whether stat file-mode macros are broken... no > checking return type of signal handle

Re: RENAME CRASH MySQL

Jocelyn Bernier writes: > Hi, > > I use MySQL version 3.23.33 on Windows NT 4.0 SP6. When I use the command > ALTER TABLE ... RENAME TO ... most of the time my MySQL service stop. I > need to restart it from the service control panel. I don't have any errors > in the logs. When restarted, m

  1   2   >