Multiple copies of messages

I am sorry for the off-the-topic question. I have been receiving random multiple copies of many (but not all) of the messages in this MySQL list - some four or five times. Some of them are copies of messages that were actually sent days previously. It is rather strange behaviour, so I just

Re: Blocked MySQL

I've installed MySQL on SuSe Linux. It's 3.23.43 version. Below should be mirror of 'my.cnf'. Those error messages, which I wrote in my first mail, are shown whatever I type. It doesn't matter whether I 'select', 'update' or something else, always it prints Ignoring query to other database.

unable to drop table

Hi, my name is Alexander and I have the following problem: I created a table with a buggy script. The name of the table is dbimport-import. The script returned an error but the table was created! Now when I try to drop this table, the parser told me that I have a syntax error near '-'! How can

ANNOUNCE: moodss-15.3

Hi everybody: here is a new version of moodss. Check it out! (or at least the screenshots at http://jfontain.free.fr/moodss3.gif or http://jfontain.free.fr/moodss4.gif :). ### CHANGES ### --- version 15.3 --- in moodss, added open file menu entry in order to be able to edit any saved

max() fails on large (but 63bit) bigint values

Description: max() and possibly other builtins fail due to apparent rounding errors for any bigints larger than 53 bits or so. Caveats exist in the manual (section 6.2) about bigints larger than 63bit, but the actual useful limit (for these functions) seems much

Problem

My query: SELECT vgrupp, type, count(*) FROM main GROUP BY vgrupp, type I have a problem with MySQL and a query. If I type the Query in a program with direct db connect, in my case EMS Mysql manager, everything works OK but when I use it from an ASP page it don't. I don't get any matches, it

RE: Reset MySQL Root password

use rpm -Uvh --force $PACKAGE -Original Message- From: Jeremiah Jester [mailto:[EMAIL PROTECTED]] Sent: 18 December 2001 22:35 To: 'MySQL' Subject: Reset MySQL Root password Well it seems as though i may have mistyped my root password for mysql since nothing seems be working. Anybody

RE: Reset MySQL Root password

or rpm -e $PACKAGE then re-install. -Original Message- From: Jeremiah Jester [mailto:[EMAIL PROTECTED]] Sent: 18 December 2001 22:35 To: 'MySQL' Subject: Reset MySQL Root password Well it seems as though i may have mistyped my root password for mysql since nothing seems be working.

RE: Reset MySQL Root password

restart mysql --skip-grant-tables Simon -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: 19 December 2001 10:32 To: Jeremiah Jester; 'MySQL' Subject: RE: Reset MySQL Root password or rpm -e $PACKAGE then re-install. -Original Message- From: Jeremiah

Re: Reset MySQL Root password

Hi, Did u by any choice not FLUSH PRIVELEGES when u changed the root password, if u didnt do this it makes things very easy you could go inside with mysql -u root command, then go into mysql DB -Users table and remove password where root id specified there should be two of em change both of em.

Re: mysql password

Some other details that might be of interest in this case: - it's not a good idea to type the password at the shell prompt (it's then in the command history) rather type mysqladmin -u USERNAME -p Mysql then asks you for a password with it's own prompt the same is for mysql client. - mysql

synopsis of the problem (one line)

Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator: Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release:

RE: MyODBC leaking handles...

Hi again, Some more information; OS: Windows 2000 Professional, SP2a + all patches mySQL 3.32.46 (windows version) myODBC 2.50.37 I open then database, do a select, close the recordset and finally close the database. This results in 2 handles increase. (Notised in windows task manager) If I

Bigger tables vs. several smaller ones?

Hi, I have a db with a table collecting info about people (cca 330 000 rec.). The records have attribut Type which can be 1 or 2 or 3. The query is SELECT .. WHERE Type=1 AND Name LIKE I rarelly restrict in one query agains people with different types ((ta.Type = 1 AND ta.Name LIKE ) AND

commit and rollback commands through php

How can i say commit or rollback using php. i didnot find any commands for commit or rollback for mysql in php. regards, sreedhar - Before posting, please check: http://www.mysql.com/manual.php (the manual)

RE: Reset MySQL Root password

Am 18 Dec 2001 16:11:18 -0800 schrieb Jeremiah Jester: Went through these steps and resetup the tables but im still unable to set a new password. The command i used was: /usr/bin/mysqladmin -u root -p password mypassword I then was prompted for a password. But when it failed to

Re: ISP problems with 3.22.32

Have your ISP check permission on the file and parent directories. Something has changed. Pat... [EMAIL PROTECTED] SW Florida's 1st ISP www.coconet.com - Original Message - From: Bruce Hodo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 19, 2001 12:15 AM Subject: ISP

Re: Reset MySQL Root password

On Wednesday 19 December 2001 12:27 pm, Matthew Darcy wrote: Hi, I am having this exact error message. I have not used mysql before and I mailed this question before and someone answered but it didn't work. I have compiled and installed mysql. I run the mysql_install_db script and it tells

Re: Reset MySQL Root password

Hi, I am having this exact error message. I have not used mysql before and I mailed this question before and someone answered but it didn't work. I have compiled and installed mysql. I run the mysql_install_db script and it tells me to change my password. I have never set a password as this

RE: Backups

Perform a hot copy of the databases (using mysqlhotcopy). This also seems to take a while, but at least the database server does not have to shutdown. The trouble with this is that it locks the table from writes when it does the copy. Some of my tables take a while to copy (they are hundreds

getting there.....slowly

Ok the password problem is sorted just to make sure i am right the command I used was ./mysqladmin -u root password $password I have just ran mysql_install_db which didn't seem to do much except remind me to change me password. I have done a mysqladmin create test1 I then get the error that

Re: Posibility of adding compress_*()/decompress_*() functions

Lester Hightower writes: Hi all, I would like to propose that mysql have compress_*()/decompress_*() functions added that would be similar to des_encrypt()/des_decrypt(). My idea would be to have functions available like: compress_gz()/decompress_gz() compress_bz()/decompress_bz()

Gui's for linux

Hi, I am not normally a fan of gui's but seeing as I am finding mysql a bit different from oracle I could use all the help I can get as my database may end up quite complicated. Are the gui's available for linux ??? are they any good. Thanks, Matt.

RE: Gui's for linux

Try PHPmyadmin Or mysql's own GUI Simon -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: 19 December 2001 13:07 To: [EMAIL PROTECTED] Subject: Gui's for linux Hi, I am not normally a fan of gui's but seeing as I am finding mysql a bit different from oracle I

mysql bug

Dear Sir/Madam I downloaded mysql3.23max version actaually i want to use Innodb type for my tables in the properties its showing Innodb is disabled to enable that i ve to give some path in 'my.cnf' file according to Manual but im not getting the my.cnf file any where in that folder i searche all

mysql bug

Dear Sir/Madam I downloaded mysql3.23max version actaually i want to use Innodb type for my tables in the properties its showing Innodb is disabled to enable that i ve to give some path in 'my.cnf' file according to Manual but im not getting the my.cnf file any where in that folder i searche all

Re: Gui's for linux

hy Am 19 Dec 2001 13:06:30 + schrieb Matthew Darcy: Hi, I am not normally a fan of gui's but seeing as I am finding mysql a bit different from oracle I could use all the help I can get as my database may end up quite complicated. Are the gui's available for linux ??? are they any

Problem with ASP and GROUP BY queries

My query: SELECT vgrupp, type, count(*) FROM main GROUP BY vgrupp, type I have a problem with MySQL and a query. If I type the Query in a program with direct db connect, in my case EMS Mysql manager, everything works OK but when I use it from an ASP page it don't. I don't get any matches, it

Re: Error on Windows 2000 service pack 2

Kemp Randy-W18971 writes: If I install mysql (latest stable version) on Windows 2000, service pack 1, I can type the command d:\mysql\bin mysqld-nt --standalone, and the server runs fine. I then invoke the mysqlgui, and can do anything with table creation, reading, etc. But if I do the same

Re: Posibility of adding compress_*()/decompress_*() functions

On Wed, 19 Dec 2001, Sinisa Milivojevic wrote: Lester Hightower writes: Hi all, I would like to propose that mysql have compress_*()/decompress_*() functions added that would be similar to des_encrypt()/des_decrypt(). My idea would be to have functions available like:

Re: Posibility of adding compress_*()/decompress_*() functions

Lester Hightower writes: On Wed, 19 Dec 2001, Sinisa Milivojevic wrote: Sinisa, Thanks for the reply. You may have not seen it yet, but I sent a followup email stating that, after sending my first email, I had discovered mysqld user-defined-functions (which I did not know existed) and

using REPLACE ( DELETE/ INSERT)

Here is my dayly headbreaking problem to you all, After hours of trieing and reading the manual regarding REPLACE INTO command and INSERT INTO, looking for a way to be able to achieve the following, was not very sucessfull ( can MySQL do what I want in this case ? ) (running MySQL ver

Re: max() fails on large (but 63bit) bigint values

[EMAIL PROTECTED] writes: Description: max() and possibly other builtins fail due to apparent rounding errors for any bigints larger than 53 bits or so. Caveats exist in the manual (section 6.2) about bigints larger than 63bit, but the actual useful limit (for these

mysql gui over internet

Has anyone used a mysql gui that works securely over the internet (through ssh?). Currently I use ssh to do command line mysql, but I thought that a gui on my desktop might work well. I can't afford a vpn, so that isn't an option. -Adam

Upgrading from Version 3.22 to 3.23.46

I have already looked here: http://www.mysql.com/doc/U/p/Upgrading-from-3.22.html I would just like to know if anyone has had any problems with this upgrade. The server is a Red Hat Linux release 6.1 (Cartman) Kernel 2.2.13-0smp on a 2-processor i686. Any help or advice would be very

RE: mysql gui over internet

phpmyadmin run on an secure apache server.. you leave the security up to Apache and the MySQL admin is done with the phpmyadmin interface.. Apache: www.apache.org phpMyAdmin: http://sourceforge.net/projects/phpmyadmin/ Have fun! Ronald -Original Message- From: adam nelson

unable to drop table

I created a table with a buggy script. The name of the table is dbimport-import. drop table `dbimport-import`; # note: inverted quotes gmax - Before posting, please check: http://www.mysql.com/manual.php (the manual)

I *think* that I've just found the most misleading item in MySQLGUI..

Hi folks, I know I had got that working months ago, but now I had to set up another PC for a customer - this time it was a Linux machine. This cost me 2 (TWO) days to find out what was the error of MySQLGUI Error Number One... (***) Can't connect to local MySQL server through socket (111)

group by, order by, temporary table

Hi there, I'm back with yet some questions about group by/order by in mysql.. My first question is how group by is beeing done if I have have columns in the select query that is not in the group by statement. Dring many test with 3.23-42 (Myisam tables) I found out that the content of the

Re: mysql gui over internet

adam nelson writes: Has anyone used a mysql gui that works securely over the internet (through ssh?). Currently I use ssh to do command line mysql, but I thought that a gui on my desktop might work well. I can't afford a vpn, so that isn't an option. -Adam This is a least problem.

Re: I *think* that I've just found the most misleading item in MySQLGUI..

[EMAIL PROTECTED] writes: Hi folks, I know I had got that working months ago, but now I had to set up another PC for a customer - this time it was a Linux machine. This cost me 2 (TWO) days to find out what was the error of MySQLGUI Error Number One... Hi! Our README is quite clear on

Re: RedHat DB?!

And it comes with a nifty price tag: $2,300 USD! Deependra B. Tandukar [EMAIL PROTECTED] writes: What is RedHat Database? Postgresql. Is anybody using it? How is it? Better than MySQL? It's postgresql w/support, so the answer would be the same as regular postgresql vs. MySQL. This means

MySQL Log Management

I am looking for some suggestions for MySQL log management. Just some people to respond to this message with their log rotation, and archival methods. I am just curious to see what others are doing, and to possibly suggest a method for myself to use. Thanks, Shon Stephens

Segmentation Faults on 4.0 Using Linux on Alpha

Greetings: Running a Debian kernel 2.4.9 and MySQL 4.0 compiled and appears to be running. Selects against the local database appear to work fine. I've got a couple userland applications that update data in remote 3.23.x servers that no longer work. I haven't seen anything related to this in

Re: Segmentation Faults on 4.0 Using Linux on Alpha

Van writes: Greetings: Running a Debian kernel 2.4.9 and MySQL 4.0 compiled and appears to be running. Selects against the local database appear to work fine. I've got a couple userland applications that update data in remote 3.23.x servers that no longer work. I haven't seen anything

Re: I *think* that I've just found the most misleading item in MySQLGUI..

Sinisa Milivojevic To: [EMAIL PROTECTED]

Newbie question - Comparison not working.

Please excuse me if this is not the correct place to post this question. I am fairly new to working with MySQL. I have two machines that have the same database, each for different development purposes. There is a table in the database that I regularly query for product info. The table is in

Problem with compiling version 4.0.1

I'm trying to compile version 4.0.1 from the source tree on RedHat 6.1. Configure runs fine, but make gives me the following error: gcc -DDEFAULT_CHARSET_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHAREDIR=\/usr/local/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -DMYSQL_CLIENT

Re: Segmentation Faults on 4.0 Using Linux on Alpha

Sinisa Milivojevic wrote: Van writes: Running a Debian kernel 2.4.9 and MySQL 4.0 compiled and appears to be running. vanboers@tempe:~$ strace ./mysqlscan 1 2 execve(./mysqlscan, [./mysqlscan, 1, 2], [/* 17 vars */]) = 0 ... brk(0x1200ba000)= 0x1200ba000 ---

New world

Hello, I'm new in the world of MySQL and have a question: What Software can I use to programm MySQL clients for HTML(XML) or Java ? Is there a Software which is easy to use ? Thanks a lot for answering, Sven Hammann. - Before

RE: New world

I like PHP. Simon -Original Message- From: Sven Hammann [mailto:[EMAIL PROTECTED]] Sent: 19 December 2001 17:42 To: [EMAIL PROTECTED] Subject: New world Hello, I'm new in the world of MySQL and have a question: What Software can I use to programm MySQL clients for HTML(XML) or

Re: I *think* that I've just found the most misleading item in MySQLGUI..

[EMAIL PROTECTED] writes: But WHY, simply do tell me *why*! *Why* doesn't it know that? I put the path of /var/lib/mysql/mysql.sock in /etc/my.cnf, that should be already enough, isn't it?! Tell me a *plausible* reason why and I shut up. ;-) Greetings Andreas Erase MySQL.options,

Amazon.com clone

Hello list I've been working on Amazon clone for a client, except it doesn't sell books, but helps them to advertise. You can take a look at it at: http://www.ultracgis.com/UltraBooks The client vanished into thin air, and now I am left with this program, and don't konw what I can do with it.

Re: Segmentation Faults on 4.0 Using Linux on Alpha

Van writes: Sinisa: As in possibly the binutils problem? I've had to use: gcc version 2.95.4 20011006 (Debian prerelease) to do any builds of things that need glibc2.3.2, but had to revert to the potato compiler to compile the kernel. What's the recommended compiler/glibc for

Sorting through results

HI This is possibly very easy, but I can't seem to get it right. I have a table that hold some data about properties. The data gets updated from time to time, but each time a new update is done, it get's a new row. The only thing in some cases setting the different entries appart is an

4.0 style full text searching in 3.23.x

I'd quite like to have the whizzy new 4.x style full text searching features, but I'm scared of installing 4.x on a production system, so I'm seeking advice. I see two options: 1. Stop fussing and install 4.x; 2. Patch 3.23.x with 4.x's full text stuff. Has anyone tried option (2), and am I

comments on columns

Hi all- Using mySQL 3.23.44 and new to mySQL, can I assume that I can not add comments on the columns (I see how add comments to a table). Thanks- Beth - Before posting, please check: http://www.mysql.com/manual.php (the

write out tables

It is a newbie question. I am wondering if there is a way to write out a table in plain text form. Thank you in advance! Jinghua Jinghua Tang, Ph.D. Phone: 858-784-8647(o) Department of Molecular Biology, MB-31858-268-9321(h) The Scripps Research

Re: I *think* that I've just found the most misleading item in MySQLGUI..

Sinisa Milivojevic To: [EMAIL PROTECTED]

select 10 of each

How do I select 10 rows with lang = 1 and 10 rows with lang = 2 from a MySQL database ? Please also reply to my E-Mail address. :) Jacob - Before posting, please check: http://www.mysql.com/manual.php (the manual)

::grumble:: SQL Problem (bug?) with HAVING clause?

Here's a conundrum I'm having with MySQL. The following code returns a bunch of records: SELECT sl_Year, sl_DayOfYear, sl_Query, SUM(sl_CountOfOccurrences) AS NumRequests FROM SearchLog GROUP BY sl_Year, sl_DayOfYear, sl_Query one of these records looks

RE: write out tables

Mysqldump will write out all the SQL needed to build the table (in plain text form). Connecting with the client and doing a select * from table will also write out the table in plain text form Finally doing a select into outfile (see manual for syntax details) will also write out the table in

RE: select 10 of each

You'll have to issue two separate queries: select * from table where lang=1 limit 10 and select * from table where lang=2 limit 10 -Original Message- From: Jacob Friis Larsen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 11:46 AM To: Mysql maillist Subject: select 10 of

Re: 4.0 style full text searching in 3.23.x

Martin Oldfield writes: I'd quite like to have the whizzy new 4.x style full text searching features, but I'm scared of installing 4.x on a production system, so I'm seeking advice. I see two options: 1. Stop fussing and install 4.x; 2. Patch 3.23.x with 4.x's full text stuff.

RE: New world

I concur. PHP is straightforward, powerful, and free! You can go to http://www.php.net to download it. Cheers, Fred Woolsey -Original Message- From: Simon Green [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 12:48 PM To: 'Sven Hammann'; [EMAIL PROTECTED] Subject: RE:

RE: select 10 of each

Can't I put an IF / CASE in the query to make it work ? [ www.sharksforum.com | www.eksperten.dk | +45 70 27 07 67 ] -Original Message- From: Brett Error [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 8:01 PM To: 'Jacob Friis Larsen'; Mysql maillist Subject: RE:

RE: MyODBC leaking handles...

Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 3:05 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi again, Some more information; OS: Windows 2000 Professional, SP2a + all patches

RE: Problem with ASP and GROUP BY queries

Hi, -Original Message- From: Mattias Persson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 5:14 AM To: [EMAIL PROTECTED] Subject: Problem with ASP and GROUP BY queries My query: SELECT vgrupp, type, count(*) FROM main GROUP BY vgrupp, type I have a

Decrypting PASSWORD() from MySQL

I have a form for a user to request their forgotten username and password by entering their email address. I then process this using PHP and use mail() to send them their username and password. However, the password is stored in an encrypted PASSWORD('password') field in the MySQL table. How can

RE: Problem with ASP and GROUP BY queries

Try: SELECT vgrupp, type, count(*) as recordcount FROM main GROUP BY vgrupp, type and pull the rs.fields(recordcout) -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 2:25 PM To: Mattias Persson; [EMAIL PROTECTED] Subject: RE: Problem with ASP

RE: ::grumble:: SQL Problem (bug?) with HAVING clause?

Here's a conundrum I'm having with MySQL. The following code returns a bunch of records: SELECT sl_Year, sl_DayOfYear, sl_Query, SUM(sl_CountOfOccurrences) AS NumRequests FROM SearchLog GROUP BY sl_Year, sl_DayOfYear, sl_Query one of these

creating new users

Hi everybody, I'm still new to Linux, and mySQL. I have a mySQL db on a win32 box that I want replicated on my new Linux box. I have managed to do a mySQLdump on the win32 box and have successfully relocated the db to the Linux box, I could though, only do it if I was logged into mySQL as root

Re: Decrypting PASSWORD() from MySQL

- Original Message - From: Zach Curtis [EMAIL PROTECTED] an encrypted PASSWORD('password') field in the MySQL table. How can I retrieve the decrypted password in a SELECT statement? MySQL's password() function is a one way hash. It does not have a decryption function. Regardless, a

Re: Decrypting PASSWORD() from MySQL

zach: How can I retrieve the decrypted password in a SELECT statement? You can't! If you want them to deal with forgotten passwords, here is a standard way: Whenever they submit their email addresses to retrieve their passwords, just generate a random password, and send it to the user's

Re: write out tables

Jinghua Tang wrote: It is a newbie question. I am wondering if there is a way to write out a table in plain text form. Thank you in advance! select [select_options] select_list [into outfile 'file_name' export_options] [from tbl_list] [where where_expr]

Re: Decrypting PASSWORD() from MySQL

Zach Curtis writes: I have a form for a user to request their forgotten username and password by entering their email address. I then process this using PHP and use mail() to send them their username and password. However, the password is stored in an encrypted PASSWORD('password') field in

RE: Sorting through results

* P.Agenbag snip So, how would the query string look that would only return ONE set of data for that specific property? Use the LIMIT clause of the SELECT statement: URL: http://www.mysql.com/doc/S/E/SELECT.html In short: add LIMIT 1 at the end of your query, and it will only return one

Installation Problem: Configure Fails on PS Switches

Greetings, I am trying to install (source distribution) mysql-3.23.46 on a DEC Alpha machine running Digital UNIX V4.0D (Rev. 878). When I run the configure command, I get the following error: checking for ps... /sbin/ps checking how to check if pid exists... configure: error: Could not find

mysql 4.0.0 fulltext stopwords and word weighting

Hi, Is there a way to prevent the 50% occurence threshold in mysql's fulltext search logic that causes words that appear in more than 50% of records to be considered stopwords? I have a table that has less than 1000 records and would like to do a fulltext search on two columns and have them

[ANN] Lasso Resource Guide -- Market your MySQL add-ons to others

Greetings MySQL Users: With MySQL embedded in Lasso Professional 5 (a commercial Web application server), some of you may be interested in upcoming opportunities to increase awareness of resources available to Lasso and Lasso MySQL users. And, more importantly, If you have add-ons to MySQL

odbc connection problem

When I connect through odbc I get a succes with info, when I look at the info I have a sql state of s1000, native error 0. If I try to query the database I get an error and the sql state is s1000 with native error code of 1142. Everything I read on the internet says it's some kind of

RE: Decrypting PASSWORD() from MySQL

Thanks for the suggestions. I guess I can try to: A) Store the password in plaintext if I need to retrieve the password. B) Store the password using PASSWORD() and then generate a new random password if needed, replacing the old password. C) Look into mcrypt, ENCODE()/DECODE(),

Question

Hi There, I got one question for you, so pls help me as i am struggling to solve this problem for the past 2 days. I am running the timetool.cgi file from browser. I am getting the Welcome Screen where i it asks me to select a user. But the drop down list is empty. And if i go to DOS prompt run

MySQL Source Code

Hi all, Does anyone know where I could get all of the source code to build the MySQL software? I wanted to make edits to the SQL language that is embedded in the MySQL software. Is there a way to do that? If not, does anyone have any suggestions on how to do something like that. I want to

Re: select 10 of each

hi there.. no solution from me, but I'm also interested in this type of query (although I only want 1 for each lang) I also wants it in 1 query, not multiple (it would be to many queries) so any answer to this one please please reply to me to :-) although I do read here also... /Christian -

is there a Solaris version of mysql++ c++ API

Hi All, Is there a solaris version of Mysql++ API. I see some downloads under the solaris section but no Mysql++. Is there a patch that I need to install to make it work on Solaris? Thanks for your responses. Uday - Before

Re: Sorting through results

Well there is one easy sollution (if I understand your qestion correctly) What I think you want is an history of old properties and values.. so what to do? well create a history table that hold all these old values and then the normal table only contains 1 value for each property.. So whenever

Re: Decrypting PASSWORD() from MySQL

On Wed, 19 Dec 2001, Matt Wagner wrote: Date: Wed, 19 Dec 2001 13:51:30 -0600 (CST) From: Matt Wagner [EMAIL PROTECTED] To: Zach Curtis [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Decrypting PASSWORD() from MySQL Zach Curtis writes: I have a form for a user to request their

Re: RedHat DB?!

If anyone wants PostgreSQL with support, but isn't interested in Red Hat's thing, PostgreSQL Inc sells commercial support. There are actually some other companies doing that too. On Wednesday 19 December 2001 09:11 am, Christopher R. Jones wrote: And it comes with a nifty price tag: $2,300

Re: Decrypting PASSWORD() from MySQL

Hmm, I can't aggree with having two password columns, one raw password and another is encrypted. It just doesn't make any sence. Why do you need to encrypt the password in that case, don't you still have the original password in yoru database? It just defeats the whole purpose of authentication.

error 1116:Too many tables. MySQL can only use 31 tables in a join

Is there any way that this number could be increased by changing any of the variables in the configure file or is this an internal limitation? I've seen a similar behaviour on SQLServer but that was on a prior version and is supposed to have been fixed on later versions. I'm using one table

Re: Decrypting PASSWORD() from MySQL

sherzodR writes: Hmm, I can't aggree with having two password columns, one raw password and another is encrypted. It just doesn't make any sence. Why do you need to encrypt the password in that case, don't you still have the original password in yoru database? It just defeats the whole

RE: MySQL Source Code

* michael chang Does anyone know where I could get all of the source code to build the MySQL software? URL: http://www.mysql.com/downloads/index.html -- Roger - Before posting, please check:

RE: select 10 of each

hi there.. no solution from me, but I'm also interested in this type of query (although I only want 1 for each lang) If you only want one row for each lang you can do it using GROUP BY... SELECT * FROM table GROUP BY lang Often you would want to use some GROUP BY functions: MIN(), MAX(),

Re: select 10 of each

Roger Baklund wrote: hi there.. no solution from me, but I'm also interested in this type of query (although I only want 1 for each lang) If you only want one row for each lang you can do it using GROUP BY... SELECT * FROM table GROUP BY lang Whoa. Watch out. You can omit columns from a

mysqldump --tab crashes when dumping DB with many tables

Description: This problem pertains to the Sun Solaris distributions, I have not tried others. Description follows: mysqldump --tab runs up against user resource limits on the number of open file descriptors when the number of tables in the database being

errors installing mysql on open unix 8

We are having the following error when installing mysql on open unix 8. We are installing from the open unix 8 skunkware 8 cd Description: Killed Installation of grant tables failed! Examine the logs in /usr/local/var for more information. You can also try to start the mysqld demon with:

Re: errors installing mysql on open unix 8

On Thu, 20 Dec 2001, Duncan Crawford wrote: We are having the following error when installing mysql on open unix 8. We are installing from the open unix 8 skunkware 8 cd Please try the binary on www.mysql.com. You have to have the libraries and linker installed. Also there are a few patches

SOFTWARE to IMPORT CONTACT INFORMATION from MySQL

Dear List, This is my first post, and I appreciate your input on this task: MySQL is collecting CONTACT information of a membership organization. MAIN FUNCTIONS: 1) PRINTING ENVELOPES for a USPS MAILING to all members 2) Maintaining an e-mail list for regular mails to all members QUESTION:

RE: SOFTWARE to IMPORT CONTACT INFORMATION from MySQL

I have had to do this several times already using MS Access. MS Outlook (at least 2000) can export to text, Excel, Access, etc.. I bring the data into Access and create a relational setup and them duplicate it on MySQL through ODBC or ODBC with MyAccess 1.4. OR Export to text and bring it in

  1   2   >