Re: Processing the join

I am interested in the internal join algorithms, not the join types that can be found in the manual. My question is how the join types in the manual are processed internally? Or, what are the different join algorithms supported by MySQL? > It depends on your database & query structure and es

error while make of 3.23.52

Hi All! mysql, sql, query > I am trying to install mysql-3.23.52 . I configured with following command > and then had run make. Make gives the following errors. Please help > > ./configure --with-low-memory --with-innodb > --with-mysqld-ldflags=-rdynamic > > > errors during make > > s

Mysql with innodb support

I am setting up a web site with Linux (redhat 7.1), apache, php and mysql. I need the version of mysql with innodb support. Can anyone indicate to me what file or files I need to obtain to install thecorrect version of mysql and where I can down load them? Thanks in advance Regards Peter Goggin

do i must use mysql_free_result()?

hi all:) int main(void) { . rs=mysql_store_result(&connection);//get result to rs .. mysql_free_result(rs);// it is necessary ??? rs=mysql_store_result(&connection);// get result to rs again. }

MySQL and Kylix 2 problem

I am using Kylix 2 Pro on Caldera 3.1.1 with MySQL 3.23.33-9 and getting SIGSEGV faults. I looked on Borland site 6 months ago and found reference that version 3.32 will not work and they tested on 3.22 which works well. I have looked on MySQL today and find that the latest is 3.23.5x., leads me

Re: Problems with alias names in WHERE clause

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On September 10, 2002 22:32, Paul DuBois wrote: ... > You can't refer to aliases in WHERE clauses. Aliases refer to columns > that have been selected, WHERE clauses determine which columns should > be selected. In essence, WHERE refers to "input" c

mysql install Q... error connecting /tmp/mysql.sock

Hi, I have redhat linux 7.1 and I have downloaded mysql-3.23.52 and followed all the instructions as to how to install and how to bring up the database the scripts/mysql_install_db worked fine and then I did ./bin/safe_mysqld and that worked fine too but when I tried to execute the mysql prog

mysql

Mysql Please remove me from your list - Original Message - From: <[EMAIL PROTECTED]> To: "laura papas" <[EMAIL PROTECTED]> Sent: Tuesday, September 10, 2002 6:07 PM Subject: Re: email > Your message cannot be posted because it appears to be either spam or > simply off topic to our filte

Re: Problems with alias names in WHERE clause

At 20:57 -0700 9/10/02, Nicholas Berry wrote: >I search high and low for an explanation of this at >http://www.mysql.com/doc (hoping I didn't overlook anything) thought it >might be easier to ask this list to see if I'm the only one with this >problem. > >With the query statement - > SELECT i.id

MySQL and Kylix 2 problem

I am using Kylix 2 Pro on Caldera 3.1.1 with MySQL 3.23.33-9 and getting SIGSEGV faults. I looked on Borland site 6 months ago and found reference that version 3.32 will not work and they tested on 3.22 which works well. I have looked on MySQL today and find that the latest is 3.23.5x., leads

Problems with alias names in WHERE clause

I search high and low for an explanation of this at http://www.mysql.com/doc (hoping I didn't overlook anything) thought it might be easier to ask this list to see if I'm the only one with this problem. With the query statement - SELECT i.id image_id, ifnull(i.photographer,"6") photo_id, ifnull

Re: Default Win install --> mySQL autostarts when booting?

At 10:43 +0800 9/11/02, Uriel Wittenberg wrote: >Sorry for not specifying: I'm using WinXP HOME. > >I did the normal default install. It seems to start up the mySQL server >automatically when I start up Windows. Hence my question: > >Is there a standard way to change that so the server only runs w

Re: Default Win install --> mySQL autostarts when booting?

Sorry for not specifying: I'm using WinXP HOME. I did the normal default install. It seems to start up the mySQL server automatically when I start up Windows. Hence my question: Is there a standard way to change that so the server only runs when explicitly invoked? - Original Message -

Re: MySQL Question

The optimization is understandable but I'm not sure how much it would affect it if you did the select outside the insert statment vs inside. Either way you are selecting the same thing but I dont know which way is better. Well just playing around with it for a bit I think I found something. The va

RE: Windows XP Installation Problems

At 16:40 10/9/2002 -0700, Lukoni, Bryan AG:EX wrote: Hi, >Thanks Michel: > >Enabled the error reporting, but no luck. I'm stumped why I am not seeing >any error messages when it fails to install. Do you know if the MYSQL >installation makes any modifications to the registry or adds files to the >s

MySQL Cookbook software distribution available

I've put up the "recipes" distribution that will accompany the upcoming MySQL Cookbook (O'Reilly & Associates). It's available at the book's companion web site: http://www.kitebird.com/mysql-cookbook/ Note that this is more or less a "pre-release", because I still have some cleaning up to

new user's login

Hi I added a new user in mysql using the following mysql>insert into user values('localhost','aman',PASSWORD('mysql024'),'Y','Y','Y','Y','Y','Y','N',' N','N','N','N','N','Y','Y'); mysql>insert into user values('%','aman',PASSWORD('mysql024'),'Y','Y','Y','Y','Y','Y','N','N','N',' N','N','N','Y','Y'

Re: Default Win install --> mySQL autostarts when booting?

> Which version of WinXP (Pro or Home)? > > On WinXP Pro, you'd have to install MySQL as a service, in which case it can > either started manually or automatically. WinXP Home is more like WinME > (yuck!) or Win98, where you can start MySLQ from a batch file. WinXP Home is MUCH more stable than M

RE: Default Win install --> mySQL autostarts when booting?

You are right, Paul ... the service is optional on WinXP Pro. I'm a creature of habit! -Original Message- From: Paul DuBois [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 7:32 PM To: Gerald R. Jensen; Uriel Wittenberg; [EMAIL PROTECTED] Subject:Re: Default Win

mysql installation error... mysql.sock file not found

Hi, I have redhat linux 7.1 server and I have downloaded the binary version of mysql 3.23.52 and I have installed the same version on other servers and it was all fine but on this server I am getting the following error [root@abacusweb mysql]# bin/safe_mysqld & [1] 21278 [root@abacusweb mysql]#

Re: MySQL Question

At 17:16 -0700 9/10/02, Mark S Lowe wrote: >I have to do an insert and need to nest a select inside. I have tons >of documentation on a very simple version of this, however my >requirements are one step beyond that. Here is what I'd like to do >in MySQL: > >insert into > >table1 > >(column1, co

Re: Default Win install --> mySQL autostarts when booting?

At 18:47 -0500 9/10/02, Gerald R. Jensen wrote: >Which version of WinXP (Pro or Home)? > >On WinXP Pro, you'd have to install MySQL as a service, ??? Have to, or have the option to? > in which case it can >either started manually or automatically. WinXP Home is more like WinME >(yuck!) or Win9

Re: MySQL Question

>From my experince this is not possible. Is there any reason why you can not simply do two inserts following each other? INSERT INTO table1(column1) SELECT column1a FROM table2 WHERE [something] INSERT INTO table1(column2) VALUES(valueFromMemory) (as if you didnt know that already) =D There shoul

MySQL Question

I have to do an insert and need to nest a select inside. I have tons of documentation on a very simple version of this, however my requirements are one step beyond that. Here is what I'd like to do in MySQL: insert into table1 (column1, column2) values (select column1a from table2 where [som

CoreReader

I am the creator of CoreReader and have done rudimentary testing against MySql. However, not being familiar with that data source, I hesitate to state that CoreReader runs against it without problems. Has anybody who knows what they are doing used CoreReader with MySql enough to say that t

Re: Default Win install --> mySQL autostarts when booting?

Which version of WinXP (Pro or Home)? On WinXP Pro, you'd have to install MySQL as a service, in which case it can either started manually or automatically. WinXP Home is more like WinME (yuck!) or Win98, where you can start MySLQ from a batch file. - Original Message - From: "Uriel Witt

Re: need help on DROP.

Clarify your question ... are you trying to drop TABLES, DATABASES, or modify user privileges? If you are trying to modify user privileges, use GRANT or REVOKE. - Original Message - From: "Daniel Curry" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 10, 2002 6:26 PM

Re: need help on DROP.

Paul, Thank you. That did it. You are correct I needed to DELETE. Paul DuBois wrote: > > At 16:26 -0700 9/10/02, Daniel Curry wrote: > > I am unable to find the specific DROP command to remove only test@%, > >test\_%@%, > >snort@localhost, and snort@%. > > I think you want DELETE, not DRO

RE: Windows XP Installation Problems

Thanks Michel: Enabled the error reporting, but no luck. I'm stumped why I am not seeing any error messages when it fails to install. Do you know if the MYSQL installation makes any modifications to the registry or adds files to the system directory. If not I could probably just copy the complete

Re: need help on DROP.

At 16:26 -0700 9/10/02, Daniel Curry wrote: > I am unable to find the specific DROP command to remove only test@%, >test\_%@%, >snort@localhost, and snort@%. I think you want DELETE, not DROP. DELETE FROM db WHERE Db='test' AND Host='%'; DELETE FROM db WHERE Db='test\_' AND Host='%'; DELETE FR

need help on DROP.

I am unable to find the specific DROP command to remove only test@%, test\_%@%, snort@localhost, and snort@%. I am trying to clean up my db information. Thank you. mysql> select * from db; +---+--++-+-+-+-+---

Default Win install --> mySQL autostarts when booting?

Does a normal WinXP installation of WinXP result in the mySQL server being automatically started up whenever one boots up the system? If so this is not well documented and it's not an appropriate default, at least not for everyone. Is there a standard way to change that so the server only runs whe

Re: Windows XP Installation Problems

Hi Bryan, could it be that you deactivated the Windows XP error reporting function? Activate it for the Windows Operating System and All Programs and try installing MySQL again. If an error message occurs the provided data might help you track down the problem... If not don't forget to deactivate

Re: 'mysqladmin shutdown' doesn't shut it down...

Eric Lamendola wrote: > Hey, > > I thought you could just use > > mysqladmin refresh -pPASSWORD -- or > mysqladmin reload -pPASSWORD > > To kickstart logging again? > > If not - hey, what do I know > > Eric Lamendola > Yeah that only restarts the binary log. I like to have a human-readable log

Re: [PHP] Questions regarding inserting and updating data into a MySQL db

Thanks for the tip I will try that, I'm still learning MySQL and PHP, although I did a couple of complex applications, there are some techniques that still are 'obscure' to me. Regards, Ricardo Fitzgerald AXIS Computers - Original Message - From: "Chris Shiflett" <[EMAIL PROTECTED]> To:

Re: [PHP] Questions regarding inserting and updating data into aMySQL db

You should search for some SQL tutorials on the Web. What it sounds like you are looking for is the "update" SQL statement which modifies an existing row (for your second form, for example). Thus, you "insert" the row to create it (which assigns the key using the auto increment), then "update"

RE: deleting frequently = OK?

sql, query thanks for the note brent. > If you don't have any variable length > fields (ie. varchar) then all your record > lengths are exactly the same and the > "empty" space can be reused for new records, > preventing fragmentation. i think we can do this. sin

can not connect or log into MySQL anymore.

version: 3.23.37 running on an RAQ Problem: I can not log into MySql as root - it hangs after I give it a password. Background: MySql was running fine for a year and then just stopped running. Symptoms: 1) Mysqld is running when I reboot the server but can't be shut down (/usr/share/mysql

Web Usage queries against apache logs

Hi everyone - We recently started logging our apache logs directly into a mysql db. Two questions: 1. The db files are growing fairly rapidly. Will inserts begin to slow the larger the database gets? Is there a recommended method for rotating the database every few gigs (it's all in one tabl

SQL help, search with related record in 2nd table

I am looking for some help on a SQL query to perform a search, but constrain the search to those records which have a related record in a second table. What I think I need is a subselect, but since this is not possible in 3.23.47, I am looking for work around. I have one table for Visitors (ke

Re: mySQL on AIX 4.3.3 problem: errmsg.sys missing?

Make sure mysql is the owner of /usr/local/mysql. With Linux the command is chown -R mysql /usr/local/mysql This recursively makes mysql the owner, and keeps security tight. Xiaolin Zhao wrote: >Dear Gerald, > >Many thanks! > >I just did a chmod -R a+r, then everything is fixed. > >It is kin

Re: Innodb X myisam

> I have been working with Mysql-Myisam, but when I converted to Inoodb > I > noticed that my queries were much slower. > Why? Inno DB handles transactions. So if they are "on" it generally would be slower vs. if they are "off" since it has to keep both copies of data (before and after change) > w

Innodb X myisam

I have been working with Mysql-Myisam, but when I converted to Inoodb I noticed that my queries were much slower. Why? what can I do for best the performance? When do I have to use the innodb? Best regards. Thank you! - Bef

Schema changes affect regular select?

Do schema operations affect regular statements? I've run "alter table add column ..." on the large table and it coinsided with "select fld from same_table limit 0,1". And this select returned as if no records were available though there were plenty. Is this normal? Should schema changes run inde

RE: Convert dates for import into Mysql

Thanks to Peter's hint here's an example of how I'll be doing it using PHP: David > -Original Message- > From: Peter Engström [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 10, 2002 12:18 PM > To: David Yee > Cc: [EMAIL PROTECTED] > Subject: Re: Convert dates for import into Mys

Found a bug with... CREATE SELECT IF?

>Description: Apparently in 4.0.3 does not like if statements in it's SELECT query... A query that once worked now returns 0 when I use an IF, rather than the proper value >How-To-Repeat: This is a simple example of how I am able to recreate... CREATE TEMPORARY TABLE temp SELECT IF(LENG

RE: Convert dates for import into Mysql

Hi Peter- thanks for the reply. Yes I do use PHP but I was not aware of those two functions. I was just going to do a str_replace() for all the different months, then do an explode on the date and re-arrange it, but these two functions may provide a much better solution. David > -Original

Re: Convert dates for import into Mysql

Hi David! What language do you use to build your application? You can do this easily with PHP. Please have a look at the following functions http://se.php.net/manual/en/function.strtotime.php http://se.php.net/manual/en/function.strftime.php Best regards /Peter - Original Message - F

Convert dates for import into Mysql

Hi all. Does any one know how to convert dates like "06-Sep-02 00:00:00" into the mysql datetime format? The main challenge here is probably converting the 3 letter abbreviations for the month. Thanks for any input. David - Be

RE: Selecting data from one table if it's NOT in another

Try this (not sure the syntax is exactly right since I'm more used to Oracle's outer join syntax): select * from main left join activity on main.user = activity.id where activity.id is null; This should return only the users in main that are not in activity. --Walt Weaver Bozeman, Montana -

Re: mySQL on AIX 4.3.3 problem: errmsg.sys missing?

Dear Gerald, Many thanks! I just did a chmod -R a+r, then everything is fixed. It is kind of lasy and security breaking act, but at least that confirms the nature of the problem. Best regards, Allen Zhao --- Gerald Clark <[EMAIL PROTECTED]> wrote: > Make sure mysql has search privileges thr

Re: deleting frequently = OK?

As is usually the case, it depends on your table structure and how you are deleting. If you don't have any variable length fields (ie. varchar) then all your record lengths are exactly the same and the "empty" space can be reused for new records, preventing fragmentation. I'm only 95% positive

Error during make for mysql 3.23.45

Hello everybody, I am getting the following error during make of mysql 3.23.45 on solaris 2.5. Anybody has an idea please reply Thanks, Niranjan ake[1]: Entering directory `/homes/woprf/n/niranjan/tmpfiles/mysql-3.23.45' Making all in include make[2]: Entering directory `/homes/woprf/n/niranja

Selecting data from one table if it's NOT in another

> > >Hi all > >There's probably a simple answer to this but I can't find it and it's >doing my head in. > >I have two tables: >main contains user data, address,name,etc. >activity contains user activity > >'user' in main has the same value as 'id' in activity > >I want to produce a list of users

Re: mySQL on AIX 4.3.3 problem: errmsg.sys missing?

Make sure mysql has search privileges through all the directories to the file. Xiaolin Zhao wrote: >Hi, > >Yes, it is existing: > >ibmaix:/usr/local/mysql # ls -al >./share/mysql/english/errmsg.sys >-rw-r--r-- 1 mysqlsystem 12183 Sep 09 17:02 >./share/mysql/english/errmsg.sys > >The m

Mysql database lockup (v3.23.49)

All, We are experiencing a strange problem where one minute everything is running fine on mysql, then the next minute, all queries seem to lockup. Can anybody provide guidance to me so I can determine the cause of the lockups? So far I dump the proc logs every minute via cron. I have found th

RE: Windows XP Installation Problems

Thanks, I have the installation files on the HD, not using the CD. I do have admin access to the machine, never had a problem installing programs before. Can you explain how to make XP can run in 16 bit mode. -=Bryan=- > -Original Message- > From: b.ware [mailto:[EMAIL PROTECTED]] > S

Re: Missing an answer to an topic (Finding gaps in db)

Hi, If you wish to find NUMBERS which are missing, i think you can try this: set @a:=0;/*initialise variable a*/ select @a:=@a+1,IF(YOUR_COLUMN_INT_TYPE= @a,'OK',@a:= @a+1) FROM YOUR TABLE; Don't forget to initialise variable 'a' for every time when run the second query. This is work indeed

Unable to find MySQL-DBI-perl-bin RPM?

Hello, I recently started trying to learn MySQL, and toward that goal I thought it would be a good idea to put it on my Redhat Linux system. I downloaded all the RPMs I could find, since I'm still fairly new to Linux and the whole tarball idea is strange to me. However when I go to install the

Re: mysterious disconnects during processing

Your db admin should know that ;) Otherwise, you can do a mysqladmin variables and look at 'datadir' value. In this directory, you should find a file named .err (see http://www.mysql.com/doc/en/Error_log.html). Regards -- Joseph Bueno Derrell Durrett wrote: > Joseph Bueno wrote: > > >>Have yo

Re: mysterious disconnects during processing

Joseph Bueno wrote: > Have you looked at mysql error log file on the server ? Where would I find that? Derrell > > Derrell Durrett wrote: > > Since I didn't get a response, I tried one of the suggestions here. See my >response to > > it below. > > > > Additionally, I've turned on the environ

Re: mysterious disconnects during processing

Hi, Have you looked at mysql error log file on the server ? Regards -- Joseph Bueno Derrell Durrett wrote: > Since I didn't get a response, I tried one of the suggestions here. See my response >to > it below. > > Additionally, I've turned on the environment variables DBI_TRACE and PERL_DBI_

Re: Missing an answer to an topic (Finding gaps in db)

At 4:54 +0200 9/10/02, Jan Broermann wrote: >Hi, >I'm missing an answer to a topic which came up a couple of days /weeks ago. >For a database i'm administrating I would like to find out, which numbers >(of invoices) >are missing in our database. Is there a way to get this result set thru SQL? >Or

Re: MySQL LOGS

At 7:32 +0100 9/10/02, nick gatsis wrote: >Does anybody know how to make log files for each of my >databases? Log files are not written on a per-database basis. >Thanx > >sql, query - Before posting, please check: http://ww

Re: mySQL on AIX 4.3.3 problem: errmsg.sys missing?

Hi, Yes, it is existing: ibmaix:/usr/local/mysql # ls -al ./share/mysql/english/errmsg.sys -rw-r--r-- 1 mysqlsystem 12183 Sep 09 17:02 ./share/mysql/english/errmsg.sys The mysqld is run as mysql user. That is why I can not understand it. Any idea? Best regards, Allen Zhao --

Re: mysterious disconnects during processing

Since I didn't get a response, I tried one of the suggestions here. See my response to it below. Additionally, I've turned on the environment variables DBI_TRACE and PERL_DBI_DEBUG, both to level '8'. This produces voluminous, but not particularly illuminating, output. If anyone has a suggesti

Re: Confused, discombobulated, weirded out, upset! --Windowsstandalone user

At 23:52 +0800 9/10/02, Uriel Wittenberg wrote: > >If mysql works fine, then you've already started the server. > >Then does a normal Windows installation set it up so the server autostarts >whenever you boot up? I did not manually start the server. It might be installed as a service. > >You h

Re: Confused, discombobulated, weirded out, upset! --Windows standalone user

>If mysql works fine, then you've already started the server. Then does a normal Windows installation set it up so the server autostarts whenever you boot up? I did not manually start the server. >You have to restart the server before it will notice the [mysqld] option group change. After I add

Re: Re: LOAD DATA LOCAL INFILE "not allowed this version"?

THANKS VERY MUCH! That worked! - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 10, 2002 9:15 PM Subject: re: Re: LOAD DATA LOCAL INFILE "not allowed this version"? [.] Put local-infile=1 in the [mysqld] and [my

Re: Confused, discombobulated, weirded out, upset! --Windows standalone user

Sorry! I made a mistake here. I still have the questions below but my problem with LOAD DATA is SOLVED! I made an editing mistake when updating the my.cnf(my.ini) files. - Original Message - From: "Uriel Wittenberg" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 10,

Re: MySQL 4.0.2, 4.0.3,4.0.4 replication circle broken.

At 12:09 +0400 9/10/02, Artem V. Ryabov wrote: >Hello Victoria, > > As far as I see bug of muliple log files still not fixed regardless > of last change in 4.0.4: > 'FLUSH LOGS removed numerical extension for all future update logs.' This bugfix affects the update log, not the binary update

Re: MySQL Monitoring Alerts

Mike, I totally agree. The log solution wasn't my idea though . No matter what language you write the script in, any type of ""Get some kind of response by throwing something against the server and seeing if it sticks"" response will get you the information you need. I set up a dummy account

Re: Confused, discombobulated, weirded out, upset! --Windowsstandalone user

At 23:37 +0800 9/10/02, Uriel Wittenberg wrote: >I seem to have a version problem. I'm using v. 3.23.51 on a Windows >standalone system -- there is no network here. *ALL I want* is to run MySQL >standalone on this machine. So do I need to "start the server"? MySQL seems >to mostly work fine if I j

Confused, discombobulated, weirded out, upset! --Windows standalone user

I seem to have a version problem. I'm using v. 3.23.51 on a Windows standalone system -- there is no network here. *ALL I want* is to run MySQL standalone on this machine. So do I need to "start the server"? MySQL seems to mostly work fine if I just go and do: C:\mysql\bin> mysql without "starti

Re: MySQL Monitoring Alerts

Eric, Isn't letting an outside connection access to your log file a "little dangerous"? Why not create a dummy table with just one record in it, restrict it to read access only, then use your chron job on a remote computer to run a PHP/Perl script to access that record over the net. I

RE: MySQL Monitoring Tool

Tom, What type of problems AREN'T you detecting? I'd take a wild guess and say you're only checking MySQL every 5 minutes or so. You can decrease the frequency between checks for more updated status. There are two variables that you need to look at: normal_check_interval, which is part of the

RE: Goodday

Yeah, you missed this: http://home.rica.net/alphae/419coal/ It's a really old, particulary disgusting and quite successful scam. Markus -Original Message- From: Andrew Pickett [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 10:03 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTE

Re: MySQL Monitoring Tool

Hi Tom, If you are not happy with netsaint you might want to try http://jfontain.free.fr/moodss/index.html . I do not use this, however I understand alot of work has gone into it. I am curious as to why you say: > We are presently using a program known as NetSaint to monitor our services > b

deleting frequently = OK?

hello sql, query for various reasons, i need to do a cron job that will take a snapshot of table1 (by snapshot i mean a temporary table), do some processing, and then save some scientific calculations to table2. after this, i need to "refresh" table1 -- i.e., truncate it entirely. i need to d

Re: Processing the join

It depends on your database & query structure and especially what indexes are available. If you just put "explain" in front of your query you will be able to see how mysql will execute your query. On Tuesday, September 10, 2002, at 09:45 AM, Toni Strandell wrote: > > How does MySQL process a j

RE: Goodday

'mysql' there need to be a better filter. Yes, We get this letter 20 times a weeks. I will forward this on to the FBI to add to their list. -Original Message- From: Clive Smart [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 9:55 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]

RE: Goodday

> -Original Message- > From: Andrew Pickett [mailto:[EMAIL PROTECTED]] > > > Hitch free? Incredible, in that case I'll give you all > my personal bank details. > I can't lose! > Am I a sucker or did I miss something here. As I understand it, they start by requesting that you finance

RE: Goodday

Don't reply or they'll get your Email address. ;-) Regards ** * K e i t h B u r k e* ** * Experience IT Ltd * Phone : +353 1 x

Re: Goodday

I think the only filters on this list are that it must contain 'sql' or 'query'... The message starts with 'Attn: mysql', so I guess it got thru. Justin on 10/09/02 11:55 PM, Clive Smart ([EMAIL PROTECTED]) wrote: > How did this get past the filters? > > Ocita Gabriel wrote: >> Attn: mysq

Re: Goodday

Simply having that Attn: mysql , row in it. The word 'mysql' passes through the filter. Not making that Ocita G less of an idiot, though. On Tue, 10 Sep 2002, Clive Smart wrote: > How did this get past the filters? > > Ocita Gabriel wrote: > > Attn: mysql , > > > > My name is Ocita G, the ma

Re: Goodday

Hitch free? Incredible, in that case I'll give you all my personal bank details. I can't lose! Am I a sucker or did I miss something here. Ocita Gabriel wrote: > Attn: mysql , > > My name is Ocita G, the manager, credit > and foreign bills of Ecobank Plc. I am writing in > respect of a forei

RE: Goodday

This must be a great scam. I'm starting to see'em all over the place. --Walt -Original Message- From: Ocita Gabriel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 3:53 PM To: [EMAIL PROTECTED] Subject: Goodday Attn: mysql , My name is Ocita G, the manager, credit and for

Re: Goodday

How did this get past the filters? Ocita Gabriel wrote: > Attn: mysql , > > My name is Ocita G, the manager, credit > and foreign bills of Ecobank Plc. I am writing in > respect of a foreign customer of my bank with account > number 14-255-2004/utb/t who perished in a plane crash > [Korean A

Re: Cannot create Full-Text INDEX

At 9/9/2002, you wrote: >Dear all, >I have installed mysql 4.0.2 alpha log (actually compiled by me) in a >linux box (Mandrake 8.2) and for 2 months was working perfectly. After >migrating some data from an other installation (Windows 2000 / mysql 4.0.1 >alpha log) my FULL-TEXT indexes stop fun

Re: mySQL on AIX 4.3.3 problem: errmsg.sys missing?

Is the file there, and readable by the user 'mysql' ? Xiaolin Zhao wrote: >Hi, All > >I am trying to make MySQL 4.0.3b work with AIX 4.3.3. >But whenever I did the `./bin/safe_mysqld &` command, >I get following error: > >020910 08:31:33 mysqld started >020910 8:31:33 Can't find messagefile >

Goodday

Attn: mysql , My name is Ocita G, the manager, credit and foreign bills of Ecobank Plc. I am writing in respect of a foreign customer of my bank with account number 14-255-2004/utb/t who perished in a plane crash [Korean Air Flight 801] with the whole passengers aboard on August 6, 1997. Since t

Processing the join

How does MySQL process a join between tables? Does it always use nested-loop join, or does it use sort-merge join if the table is sorted before joining it? Is the join algorithm merge if the tables are already sorted on the join attributes (through an index)? Sincerely, Toni Strandell --

re: Cannot create Full-Text INDEX

At 04:05 PM 9/10/2002 +0300, you wrote: >Nikolaos, >Monday, September 09, 2002, 7:51:43 PM, you wrote: > >NG> I have installed mysql 4.0.2 alpha log (actually compiled by me) in a >linux >NG> box (Mandrake 8.2) and for 2 months was working perfectly. After >migrating >NG> some data from an other

mySQL on AIX 4.3.3 problem: errmsg.sys missing?

Hi, All I am trying to make MySQL 4.0.3b work with AIX 4.3.3. But whenever I did the `./bin/safe_mysqld &` command, I get following error: 020910 08:31:33 mysqld started 020910 8:31:33 Can't find messagefile 'mysql-4.0.3b/share/mysql/english/errmsg.sys' 020910 8:31:33 Aborting 020910 08:31

Re: 'mysqladmin shutdown' doesn't shut it down...

Hey, I thought you could just use mysqladmin refresh -pPASSWORD -- or mysqladmin reload -pPASSWORD To kickstart logging again? If not - hey, what do I know Eric Lamendola At 11:12 AM 9/10/02 +1000, Daniel Kasak wrote: >Hi all. > >I've been using MySQL-4.0.3 (on Slackware-8.0) for a week or

Re: MySQL Monitoring Alerts

Hey, I noticed another response about "tailing the log" and looking for information in the "err" log which looks like a great solution. However, if you have an extra computer laying around, you can also set up a cron job with a shell script that connects to the server (via telnet or using a m

re: Cannot create Full-Text INDEX

Nikolaos, Monday, September 09, 2002, 7:51:43 PM, you wrote: NG> I have installed mysql 4.0.2 alpha log (actually compiled by me) in a linux NG> box (Mandrake 8.2) and for 2 months was working perfectly. After migrating NG> some data from an other installation (Windows 2000 / mysql 4.0.1 alpha l

re: Crash, 98 and 2000

Mustafa, Tuesday, September 10, 2002, 10:19:14 AM, you wrote: MY> we use mysql 3.23.46-max-nt at customer pc. Some customers use Windows2000, MY> but some use Win98. Mysql Database that run at Win98 platform, sometimes MY> crashes, and i cannot repair it. The error often ise 144 Error that "TABLE

Re: show tables

DB independent? As in an entire list of tables in your MySQL server? Or as in independent from MySQL to say MS SQL Server? If the later then I'm sure each db as some form of query to get a list of tables, just look it up. I don't think there would be a unified way simple because each db is complet

Re: Select question

You would have to do something like: SELECT * FROM users WHERE CONCAT(firstname, " ", lastname) = "John Smith" That should get you what you want. If your taking your DB from MS SQL to MySQL only a few queries will port directly over. You have to be careful that you follow the MySQL syntax and func

  1   2   >