password() function not used when creating root password

2001-02-19 Thread root
I have just created a root password in MySQL without using the PASSWORD function. In the user table i put in a root password, like this. mysql UPDATE user SET Password='new_password' WHERE user='root'; mysql FLUSH PRIVILEGES; Now i am denied access. How do start the mysql server now? The

Re: password() function not used when creating root password

2001-02-19 Thread Rolf Hopkins
Look up skip grants in the manual. - Original Message - From: "root" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 19, 2001 16:09 Subject: password() function not used when creating root password I have just created a root password in MySQL without using the PASSWORD

Fw: Display information

2001-02-19 Thread Milo Stefani
- Original Message - From: "Ron Beck" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 16, 2001 7:12 PM Subject: Re: Display information SELECT id,lot_id,lot_type FROM scrap_table ORDER BY id limit 1932,10; seemed promising but it put them in oldest-to-newest order

RE: [php_mysql] Creative solution with XML,PHP,MYSQL

2001-02-19 Thread Tom Knight
I hate to say it, but the only way I can see of doing this offhand is with ecmascript dhtml or does that Dynamic Data Binding (only works with ie5, or 5.5?) do this sort of thing? Either way, you're looking at unbounded fun catering for different browsers. -Original Message-

Mysql and Labview?

2001-02-19 Thread Heinz Herren
Hi, do you have any information or useful links to the subject "using LabView and MySQL"? many thanks, Heinz Herren *** Iset GmbH Heinz Herren Bahnweg 2 CH-3177 Laupen +41 (0)31 747 69 88 (Tel) +41 (0)31 747 65 49 (Fax) E-Mail: [EMAIL PROTECTED] WWW:

client -- server versions ?

2001-02-19 Thread Justin
Hi - sorry one other question, Does the protocol between client (mysql command line, DBI::mysql and so on), and server, change from minor version to minor version, or from major version to major version ie, 3.22.x to 3.23.x ? I've found that older client machines can talk to an upgraded server

Re: version 3.23.32 feels less stable - error 127 ..

2001-02-19 Thread Joseph Bueno
Justin a crit : I'm having difficulties with version 3.23.32 in production.. after giving up on my own compiled version, which I compiled in the same way, on the same box, with the same flags as 3.22.32, I was getting occasional core dump/restarts.. so I reverted to the mysql.com binary

Re: Mysql and Labview?

2001-02-19 Thread Jeremy D. Zawodny
On Mon, Feb 19, 2001 at 10:10:50AM +0100, Heinz Herren wrote: Hi, do you have any information or useful links to the subject "using LabView and MySQL"? Please do 60 seconds of research before you ask the list. This took me 10. http://www.google.com/search?q=labview+and+mysql Jeremy --

Re: client -- server versions ?

2001-02-19 Thread Jeremy D. Zawodny
On Mon, Feb 19, 2001 at 04:15:41AM -0500, Justin wrote: Hi - sorry one other question, Does the protocol between client (mysql command line, DBI::mysql and so on), and server, change from minor version to minor version, or from major version to major version ie, 3.22.x to 3.23.x ? My

iNNOBASE

2001-02-19 Thread Peter Zaitsev
Hello mysql, Good day. I'm now trying to build mysql 3.23.34 aviable in bitkeeper tree, to get a chance to check innobase table handler before release is out, to make chance for release to be more stable :) Currently I have the following problem - innobase is allready in tree but

Projects

2001-02-19 Thread naveed
Dear team, Welcome to the mysql mailing list, ithis is my first mail to the list. i am a perl developer with mysql as backend. You can give me projects of perl with mysql as backend. naveed - Before posting, please check:

Re: Secure connection with SSH

2001-02-19 Thread Tõnu Samuel
Andrea wrote: Depending on manual, i have information about conecting to a remote MySql from windows with SSH and there a site http://www.doc.ic.ac.uk/~ci2/ssh/ But this site is gone.. :( Where i can download a free ssh ? This is offtopic. Hint: download it from http://www.google.com

Unlock table without restarting

2001-02-19 Thread Dorthe Luebbert
Hi, how can I unlock a table/process with mysqladmin etc. without restarting the server? Thanx Dorthe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

RE: [PHP] Creative solution with XML,PHP,MYSQL

2001-02-19 Thread James Moore
-Original Message- From: Siim Einfeldt aka Itpunk [mailto:[EMAIL PROTECTED]] Sent: 17 February 2001 14:25 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP] Creative solution with

Re: Unlock table without restarting

2001-02-19 Thread Fred van Engen
On Mon, Feb 19, 2001 at 12:59:51PM +0100, Dorthe Luebbert wrote: Hi, how can I unlock a table/process with mysqladmin etc. without restarting the server? If you want to unlock a table that is locked by a query then you will need to kill the thread that executes the query. It's up to you

Help for my first approach

2001-02-19 Thread Jose Luis Faria
Hello, this my first approach to mysql++. I have installed - redhat 7.0 MySQL-shared-3.23.33-1 MySQL-client-3.23.33-1 MySQL-3.23.33-1 MySQL-devel-3.23.33-1 mysql++-1.7.8-1 when I try to build the first example(simpe1.cc attached) this giv me some errors, like this:

RE: Innobase + transactions row level locks will be released in a few days in MySQL 3.23.3x

2001-02-19 Thread Mehalick, Richard RE SSI-GRAX
Will I be able to change my BDB tables into Innobase tables using Alter table and how does INNOBASE tables differ from the GEMINI tables (when they are available)? - / Rick Mehalick Senior Consultant / Shell Services International SSI-GPAX /

Re: C API

2001-02-19 Thread Sinisa Milivojevic
Julie Baroff writes: Already I use the client timeout, it's not work when server is under high load crawling to the standstill. I hope it would wait 1 second for working connection or stop with error but it not. There are two timeouts in recent 3.23 client versions and

RE: Innobase + transactions row level locks will be released in a few days in MySQL 3.23.3x

2001-02-19 Thread Robin Keech
On a related note, how mature is the Innobase code? It is mostly new? Or like NuSphere's Gemini, it is older code which has been adapted to fit in with MySQL's table handler interface? Thanks! Jeremy Hi, I am also very interested in finding more out about innobase - code maturity, company

Re: Mysql++ runtime problem

2001-02-19 Thread Sinisa Milivojevic
sas writes: I have no problem compiling sample program (I compiled it in this way: gcc -lsqlplus -I/usr/include/mysql -L/usr/local/lib/ -o sample sample.cc) But when I execute the binary, I got this error message: [root@sas /root]# ./sample ./sample: error while loading shared

Re: Help for my first approach

2001-02-19 Thread Sinisa Milivojevic
Jose Luis Faria writes: Hello, this my first approach to mysql++. I have installed - redhat 7.0 MySQL-shared-3.23.33-1 MySQL-client-3.23.33-1 MySQL-3.23.33-1 MySQL-devel-3.23.33-1 mysql++-1.7.8-1 when I try to build the first

Comparing dates

2001-02-19 Thread Nick Didkovsky
Hello, Is there a more general way to compare DATE values than the following. ...WHERE TO_DAYS(myDateField) TO_DAYS('2001-02-14'); I really have to objection to converting to a common unit of days in order to compare (as long as I don't care about comparing times within the same day), but I

mysqladmin

2001-02-19 Thread Zen Woo
Hi, mysqladmin: unable to change password; error: 'You are using MySQL as an anonymous users and anonymous users are not allowed to change passwords' How do I correct this problem? Thanks, Zen - Before posting, please

Re: iNNOBASE

2001-02-19 Thread Heikki Tuuri
Peter, I guess you mean the source tree at www.bitkeeper.com? The interface file ha_innobase.cc can be found there, but not yet the Innobase source, I think. Then it cannot yet be compiled from the source tree, because it needs Innobase header files. But we should have the source out by

Re: Comparing dates

2001-02-19 Thread Peter Skipworth
Can you just not use... ...WHERE myDateField '1997-10-04 22:23:00' ...WHERE myDateField '1997-10-04' ? regards, P You get the idea... thoughts? Best, Nick - Before posting, please check:

Re: list of databases

2001-02-19 Thread Gerald L. Clark
mysqlshow should work just fine. Tim Chambers wrote: Is there any way I can generate a list of the databases in mysql, perhaps with the mysqlshow command and some fancy grep? I'm looking for a list separated by spaces, something that I could use in a bash script. Thanks, Tim

Re: daemon doesn't start at boot; RHL 6.2

2001-02-19 Thread John Hunter
"Atle" == Atle Veka [EMAIL PROTECTED] writes: Atle You say you go to runlevel 5 at boot? In that case, you need Atle to put the S99mysql into the rc5.d/ directory.. That worked. Thanks, John Hunter - Before posting,

Re: Problems with SHOW DATABASES / TABLES

2001-02-19 Thread Gerald L. Clark
I also rebuilt 3.23.33 today for SCO Openserver 5.0.4 and RedHat Linux 6.2. Show Databases works just fine here. Sinisa Milivojevic wrote: HI! In response to several mail messages on mailing list that were centered around some misbehaviour of SHOW DATABASES / TABLES, I have tested

Re: Problems with SHOW DATABASES / TABLES

2001-02-19 Thread Sinisa Milivojevic
Gerald L. Clark writes: I also rebuilt 3.23.33 today for SCO Openserver 5.0.4 and RedHat Linux 6.2. Show Databases works just fine here. Thanks ! Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic

Re: [php_mysql] Creative solution with XML,PHP,MYSQL

2001-02-19 Thread Irmund Thum
Tim Ward schrieb: the complication in your case is that some of the js (building the arrays and the table) needs to be built by the php. I've never tried this but it should work if you just echo it as you would html. yes - php can write out an external .js what is loaded by JavaScript --

Re: Innobase + transactions row level locks will be released in a few days in MySQL 3.23.3x

2001-02-19 Thread Heikki Tuuri
Hi again! There were several questions on the mailing list, which I try to answer: - The MySQL manual says that you can convert between different table types using ALTER TABLE, the same should hold for the Innobase table type, though I must admit I have not yet tested it. ALTER TABLE is a

Error 127

2001-02-19 Thread Lauri Vain
Hello everybody, About two hours ago I had a system crash and one of my MySQL databases was extensively used at the same time. When the system went back up, the table (the table has 37000 rows) that was used at the time of the crash started to give me the error : Got error: 1030: Got error 127

SQL Exception java.sql.SQLException: General error: Got error -30996 from table handler

2001-02-19 Thread johnm
How-To-Repeat: On two or more client machines Note this will not happen using 'virtual clients', i.e. one machine running mucltiple threads Open Connection Turn AutoCommit off db.setAutoCommit(false); loop through 10,000 queries, commiting

Re: MySQL-Excel data correlation

2001-02-19 Thread Ken Menzel
We have a ton of data in MS Excel that I need to put into a Solaris based MySQL dB. The data needs input such that it correlates across several different tables (i.e. I can't just do table dumps). What is the most efficient way to do this? Thanks, Valerie Hi Valerie, My opinion would

SV: Comparing dates

2001-02-19 Thread Pal Wester
Actually, there should be a function which does the oposite of the DATE_FORMAT function, ie. converting a string to date. but as long as you use mysql notation on dates, you can write ...WHERE myDateField '2001-02-14'; As I'm in norway and wriote norwegian applications I usually get dates on

RE: MySQL-Excel data correlation

2001-02-19 Thread Brian Kaney
You may also want to check CPAN for Spreadsheet::ParseExcel. I haven't dug into it too deep yet, but it looks like it can parse native .xsl data. Brian -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED]] Sent: Monday, February 19, 2001 11:08 AM To: Joe Ferrara; [EMAIL

RE: Executing multiple SQL commands.

2001-02-19 Thread Michael Lépine
Could you provide us with the error messages you are getting?!?! My apologies. The problem appears to have been the copying of unexpected characters into the SQL. I generated the SQL for the tables and put it into a file. Apparently when I copy and paste the SQL, some hidden characters are

Re: SV: Comparing dates

2001-02-19 Thread Nick Didkovsky
Thanks, Pal, I tried that and got an error, which led my down the road to using TO_DAYS() etc... Will try again, and post the error if it reoccurs. Best, Nick Pal Wester wrote: Actually, there should be a function which does the oposite of the DATE_FORMAT function, ie. converting a string to

Re: CREATE from a mysqldump won't CREATE a table in 3.23?

2001-02-19 Thread Gerald L. Clark
Check the manual. "Type" is a reserved word. "Date" is a reserved word. Martin wrote: The following CREATE TABLE came from a mysqldump. When I use the same create statement to create the table under mysql 3.23 I get an error: # MySQL dump 8.12 # # Host: localhostDatabase: installers

RE: FILE_TO_EOF additional info

2001-02-19 Thread Fr3dY
Hi. I'll be more precise: I'm trying to compile MySQL 3.23.32 it under Amiga, with EGCS 2.91.66 using some kind of UNIX emulation. I've already ported other programs like Lynx, Yacas, MUD/IRC clients... I've found that F_TO_EOF is defined as 0L in mysql/include/my_global.h,

Help with slow select count(*)

2001-02-19 Thread Robin Keech
Hi, Can anyone please explain the following? I do two select count(*)'s from a big table, (21,000,000 + rows 6.5 Gb). All columns in the where are indexed. The first select is very quick, the second very slow. The ONLY difference is the value of one column variable (queue_id), which is an

Something wrong with 3.23 v???

2001-02-19 Thread Abraham García
Hi everybody, First excuse me about my bad English I have a weird (at least weird for me) problem trying to connect to mysql server v 3.23... When I try to connect from some sites, I got an ERROR 1045: Access denied for user: 'user@host' (Using password: YES) I'm sure the privilege tables are

Re: mysqladmin

2001-02-19 Thread Rolf Hopkins
What is the command you are using to change password? - Original Message - From: "Zen Woo" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 19, 2001 22:16 Subject: mysqladmin Hi, mysqladmin: unable to change password; error: 'You are using MySQL as an anonymous users

Linking MySQL with other programs

2001-02-19 Thread Neera P. Sood
Hello, I'm trying to compile and link MySql with a CORBA (ORBacus) client and I get the following error message: Undefined first referenced symbol in file __muldi3 /opt/mysql-3.23.32-sol8/lib/mysql/libmysqlclient.so

MysqlTool problems

2001-02-19 Thread Kevin O
Hello all, I'm trying to use MysqlTool 0.90 and am getting the following error when I pull up the web interface: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Only thing is, /var/lib/mysql/mysql.sock does exist and I'm able to connec to the database

Index Question(again).

2001-02-19 Thread
No Body answered my previous mail. plz help me. I have three tables. i) student_info3 i) grade_ex3 i) test_info and, There are those Index In student_info3 table : index(student_no) In grade_ex3 table : index(student_no, test_no) In test_info table : index(test_no) When I use

Re: special characters in MySQL query

2001-02-19 Thread Thalis A. Kalfigopoulos
If you are using PHP there is the htmlspecialchars() function that will do just that for you. cheers, thalis - Original Message - From: "Robert Heron" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 6:35 PM Subject: special characters in MySQL query

moving database to another computer

2001-02-19 Thread Ming Hsu
Hi, I've been working with mysql for a couple of months now for my website. Now I have to move to a different server, and would like to move the database as well. Problem is I have no idea what this entails and how to do it. Can someone help me? Thanks. Ming Hsu

Compiler errors

2001-02-19 Thread John Markunas
Hi Tru64 Compile errors. Running V4.x Tru64 gcc 2.95.2 gnumake 3.x attempting build of mysql 3.23.32 or 3.23.33 Getting error sql_string.cc: In Method 'bool string::(double,unsigned int=2)' : sql_string.cc:181 Implicit declaration of function

date functions in GROUP BY?

2001-02-19 Thread stirra
I have a table with a date field, and would like to sort it on month and day. What I would like to do is: SELECT lastname,firstname,dob FROM table1 GROUP BY month(dob),day(dob) (where dob is a column of type 'date') but that doesn't work. I'm using MySQL 3.22.32. I saw one post about

error 35 with my.cnf

2001-02-19 Thread Max Harper
I work for a web hosting company that has mysql 3.22.23 on one of our servers. The server is Free BSD unix version 3.5. It seems every few weeks it pops up with this error. System Error: DBI-connect(WWWThreads:localhost) failed: Can't create a new thread (errno 35). If you are not out of

Re[2]: iNNOBASE

2001-02-19 Thread Peter Zaitsev
Hello Heikki, Monday, February 19, 2001, 5:24:10 PM, you wrote: HT Peter, HT I guess you mean the source tree at www.bitkeeper.com? The interface HT file ha_innobase.cc can be found there, but not yet the Innobase HT source, I think. Then it cannot yet be compiled from the source tree, HT

RE: Index Question(again).

2001-02-19 Thread Quentin Bennett
Hi, For such small tables, does it matter. MySQL will optimise queries the best way it thinks it can. In this case, in the first query, only the index file for student_info3 will be used, so that might have a bearing. In the second query, where all columns from the student table are requested

Re: moving database to another computer

2001-02-19 Thread Laurent Oget
On Mon, Feb 19, 2001 at 04:34:05AM -0700, Ming Hsu wrote: Hi, I've been working with mysql for a couple of months now for my website. Now I have to move to a different server, and would like to move the database as well. Problem is I have no idea what this entails and how to do it. Can

mysqldump

2001-02-19 Thread John Jensen
I have an existing mysql database I am trying to back up before upgrading to 3.23 from 3.22. Both the mysqldump and mysqladmin commands tell me I am accessing as the wrong user when I execute from the bash prompt, even as root. From the mysql prompt, these commands are not recognized at all.

Re: list of databases

2001-02-19 Thread Rosana C. Centrone
You can also use mysql and query "show databases" as in this sample script I transcript: DBS=`mysql -e "show databases"` for db in $DBS ; do if [ "$db" != "Database" ] ; then # skip the title "Database" included in the output of command DBS. mysql -e "show tables from $db"

Re: mysqldump

2001-02-19 Thread John Jensen
Okay, so I got it using the mysql root password as an option, but I find not evidence of a backup or sql file being created, unless I add a pipe and redirection instructions to the command. The mysqldump command is either putting the dump in a location I don't know about (and can't seem to

Re: mysqldump

2001-02-19 Thread Fred van Engen
On Mon, Feb 19, 2001 at 11:39:07AM -0800, John Jensen wrote: I have an existing mysql database I am trying to back up before upgrading to 3.23 from 3.22. Both the mysqldump and mysqladmin commands tell me I am accessing as the wrong user when I execute from the bash prompt, even as root.

mysqldump problems too

2001-02-19 Thread jaco
I'm having problems with mysqldump too. I'm trying it on a Suse Linux 6.2 system, from the /usr/bin directory as root, typing ./mysqldump --all-databases backup.sql as is explained on http://www.mysql.com/doc/m/y/mysqldump.html The response is : ./mysqldump: unrecognized option

Re: mysqldump

2001-02-19 Thread Hardy Merrill
By "even as root", do you mean that you did something like this: $ mysqldump -u root -p db_name db_name.sql ? The "root" user *in* MySQL should have privileges to run mysqldump. Describe the situation in a little more detail if you're still having problems - like: * what is the exact

Re: mysqldump

2001-02-19 Thread John Jensen
Thank you Fred, that helps On 19 Feb 2001, at 21:23, Fred van Engen wrote: On Mon, Feb 19, 2001 at 11:39:07AM -0800, John Jensen wrote: I have an existing mysql database I am trying to back up before upgrading to 3.23 from 3.22. Both the mysqldump and mysqladmin commands tell me I am

Re: Apache 1.3.17 and mod_auth_mysql problem.

2001-02-19 Thread btjones
As far as my understanding at this point, mod_auth_mysql 2.20 is no longer being developed by the original author. I have modified the source code and configure options of mod_auth_mysql 2.20 to make it work with Apache 1.3.x (it was developed for 1.2.x) as well as am testing a version

Re: C API

2001-02-19 Thread Julie Baroff
There are two timeouts in recent 3.23 client versions and several timeouts on the server. Check that you have set the right ones. Regards, Sinisa Ok, thank you - Before posting, please check:

Optimizing Queries

2001-02-19 Thread Jim Bayers
I have a non-profit site that uses mysql. I need to optimize two queries so they won't put such a load on the mysql server. If I don't lighten the load, they've treatened to kick us off. What columns are best to index? SELECT messages.ID as ID, title, text, user_id, username, email

Microsoft SQL Server linking to MySQL

2001-02-19 Thread Aaron Weiker
I'm trying to set up a link to MySQL through Microsoft SQL. I set up a ODBC DSN using MyODBC and I told Microsoft SQL to link through an ODBC Datasource. Everything seems to work except I can't query anything. This is a statement I try. SELECT * FROM [MySQL].mysql.db This is the error message

Re: float value is changed

2001-02-19 Thread William R. Mussatto
Floats are inexact. If you want exact try the numeric data type. Its stored as a character. On Sat, 17 Feb 2001, Xi Jiang (ITSPORTSNET) wrote: Date: Sat, 17 Feb 2001 21:05:25 -0700 From: Xi Jiang (ITSPORTSNET) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: float value is changed

error 35 with my.cnf

2001-02-19 Thread Max Harper
I work for a web hosting company that has mysql 3.22.23 on one of our servers. The server is Free BSD unix version 3.5. It seems every few weeks it pops up with this error. System Error: DBI-connect(WWWThreads:localhost) failed: Can't create a new thread (errno 35). If you are not out of

Re: mysqldump problems too

2001-02-19 Thread Fred van Engen
On Mon, Feb 19, 2001 at 09:26:34PM +0100, jaco wrote: I'm having problems with mysqldump too. I'm trying it on a Suse Linux 6.2 system, from the /usr/bin directory as root, typing ./mysqldump --all-databases backup.sql as is explained on http://www.mysql.com/doc/m/y/mysqldump.html

Re: mysqldump

2001-02-19 Thread Fred van Engen
On Mon, Feb 19, 2001 at 12:22:04PM -0800, John Jensen wrote: Okay, so I got it using the mysql root password as an option, but I find not evidence of a backup or sql file being created, unless I add a pipe and redirection instructions to the command. The mysqldump command is either putting

+ or - in place of = does what???

2001-02-19 Thread Jordan
First time here, sorry if this is too much of a novice question to get answered... I just sent the command: DELETE FROM users WHERE user_num+"AL011-33"; by accident (I meant to use an "=" not the "+"). It killed 81 rows. I restored the data, but I couldn't find anything in the docs about

auto_increment and last_insert_value()

2001-02-19 Thread Doug Linley
I have a table that I created that has a primary key field that should be auto_incremented. To fill in this value I am calling insert into player_table(playerid, player_name) values (LAST_INSERT_ID() + 1, '$player_name'); My problem is that I'm getting duplicated key values because

[chris@debian.org: Bug#86033: [PATCH] Alpha patches for mysql]

2001-02-19 Thread Christian Hammers
Hello In case this patch wasn't post here. bye, -christian- Package: mysql Version: 3.23.33-1 Severity: important Tags: patch Below is a patch against mysql 3.23.31 (but applies well to 3.23.33-1) for things to work properly on Alpha. I've been applying this diff against most of the

How to connect MySql with ChiliASP on a Linux Cobalt ?

2001-02-19 Thread Denis Fohl
Hi, i'm a newbe with MySql and the list. I've made an application on my local host using ASP/Access and now i must transpose it on a Cobalt system with Linux and ChiliAsp/Mysql. I'm looking for the connection strings and principles to use but i can't find them. Is there someone to help me ?

Re: Something wrong with 3.23 v???

2001-02-19 Thread Fred van Engen
On Mon, Feb 19, 2001 at 06:44:50PM +0100, Abraham Garca wrote: I have a weird (at least weird for me) problem trying to connect to mysql server v 3.23... When I try to connect from some sites, I got an ERROR 1045: Access denied for user: 'user@host' (Using password: YES) I'm sure the

Re: Optimizing Queries

2001-02-19 Thread Tõnu Samuel
Jim Bayers wrote: I have a non-profit site that uses mysql. I need to optimize two queries so they won't put such a load on the mysql server. If I don't lighten the load, they've treatened to kick us off. Check the manual chaper about optimizations, especially about EXPLAIN command. This

Re: + or - in place of = does what???

2001-02-19 Thread René Tegel
i guess the calculation returns a result (ie: whether it's successfull or not), so '1-1' evaluates true; but 1-A evaluates false because A is not a number so you can't calculate on it. So in your case, this would be: where user_num+"AL011-33" if user_num='0': where '0'="%any%"; /// returns

RE: auto_increment and last_insert_value()

2001-02-19 Thread Quentin Bennett
Hi, Your are using LAST_INSERT_ID wrong. You should just do: insert into player_table(player_name) values ('$player_name'); And then use LAST_INSERT_ID to find out what player_id was assigned. Although "LAST_INSERT_ID() + 1" will give you "your last value +1", another client might already

Re: auto_increment and last_insert_value()

2001-02-19 Thread Minh Dam
Hi Doug, Try to use insert into player_table(playerid, player_name) values (auto, '$player_name); Cheers, Minh Dam On Mon, 19 Feb 2001, Doug Linley wrote: I have a table that I created that has a primary key field that should be auto_incremented. To fill in this value I am calling

Re: date functions in GROUP BY?

2001-02-19 Thread Fred van Engen
On Mon, Feb 19, 2001 at 11:06:21AM -0800, [EMAIL PROTECTED] wrote: I have a table with a date field, and would like to sort it on month and day. What I would like to do is: SELECT lastname,firstname,dob FROM table1 GROUP BY month(dob),day(dob) (where dob is a column of type 'date')

Re: special characters in MySQL query

2001-02-19 Thread Rolf Hopkins
I think you mean addslashes() - Original Message - From: "Thalis A. Kalfigopoulos" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 20, 2001 2:37 Subject: Re: special characters in MySQL query If you are using PHP there is the htmlspecialchars() function that will do

Re: Microsoft SQL Server linking to MySQL

2001-02-19 Thread Rolf Hopkins
I never tried but I would have thought you would type a normal table name in your SELECT statement. It looks like your writing SQL statements meant for MS SQL and not mysql. - Original Message - From: "Aaron Weiker" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 20,

Strange errors

2001-02-19 Thread Chuck Carson
I am getting this error when running a CGI script that inserts into a table. The script works fine about 90% of the time but I get these occasionally. Sometimes I will keep hitting the back button and re-submitting the form and I sometimes get this as well. ie (the same logical path throgh the

Re: Microsoft SQL Server linking to MySQL

2001-02-19 Thread Ed Carp
I'm trying to set up a link to MySQL through Microsoft SQL. I set up a ODBC DSN using MyODBC and I told Microsoft SQL to link through an ODBC Datasource. Everything seems to work except I can't query anything. This is a statement I try. SELECT * FROM [MySQL].mysql.db This is

Re: special characters in MySQL query

2001-02-19 Thread Ed Carp
Rolf Hopkins ([EMAIL PROTECTED]) writes: I think you mean addslashes() If you are using PHP there is the htmlspecialchars() function that will do just that for you. I have written a program which reads data from WWW forms and passes it to MySQL queries. All works fine except

Re: Something wrong with 3.23 v???

2001-02-19 Thread Ed Carp
Fred van Engen ([EMAIL PROTECTED]) writes: On Mon, Feb 19, 2001 at 06:44:50PM +0100, Abraham García wrote: I have a weird (at least weird for me) problem trying to connect to mysql server v 3.23... When I try to connect from some sites, I got an ERROR 1045: Access denied for user:

Re: ENUM or not ENUM?

2001-02-19 Thread tc lewis
check out the "set" type instead of enum. http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Column_types http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SET -tcl. On Tue, 20 Feb 2001, [KOI8-R] "îÉËÏÌÉÎ óÅÒÇÅÊ" wrote: Hello I have situation

Re: ENUM or not ENUM?

2001-02-19 Thread Rolf Hopkins
I would leave it the way it is, if I were you except for one thing. Change the table name Colours to CarColours. Will make it a little less confusing in the future. - Original Message - From: " " [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 20, 2001 10:12 Subject:

Re: CREATE from a mysqldump won't CREATE a table in 3.23?

2001-02-19 Thread Rolf Hopkins
The reason why I didn't answer this is because I think there is a bug somewhere. How was a dump file allowed to be created with reserved words? or better still, how where "illegal" column names allowed to be created in the first place? - Original Message - From: "Gerald L. Clark"

Re: Linking MySQL with other programs

2001-02-19 Thread Vivek Khera
"-lm" has been specified in the linker option line. Before or after the -lmylsqlclient flag? It needs to be after. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D.Khera Communications, Inc. Internet: [EMAIL PROTECTED]

Printed MySQL manual

2001-02-19 Thread Denis L. Menezes
Hello friends. Can anyone please advise how I can obtain a printed copy of the MYSQL manual? thank you. denis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Help with access denied

2001-02-19 Thread diego López
Hi all, i installed successful Mysql ver 3.25.33-1 after that i changer the root password and when i make a connection looks like i am connecting with the user @localhost instead the root user [root@halley bin]# mysql -u root mysql ERROR 1044: Access denied for user: '@localhost' to database

RE: Printed MySQL manual

2001-02-19 Thread Don Read
On 20-Feb-01 Denis L. Menezes wrote: Hello friends. Can anyone please advise how I can obtain a printed copy of the MYSQL manual? $ cd /usr/local/share/doc/mysql $ lpr manual.txt -- or -- http://www.mysql.com/documentation/mysql/full/ (then click the PRINT thingy) thank you.

synopsis of the problem (one line)

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

install mysql at DEC UNIX osf

2001-02-19 Thread Yuandan Zhang
hi, my system is OSF1 V4.0 878 alpha, I tried to install mysql-3.23.30-gamma-dec-osf5.1-alphaev6. I think this is binary distribution. the path in bin/mysqlaccess has been changed to reflect my installation path. when I run scripts/mysql_install_db it showed following error message, please

Re: Help with access denied

2001-02-19 Thread Rolf Hopkins
You mean 3.23.33??? Try: mysqladmin -u root password new-password If that fails, start mysql server with skip grants and change the password that way and then restart the server. Skip grants is in the manual. If you still have problems, look at the permissions on the mysql directories/files.

Re: Help with access denied

2001-02-19 Thread Mohamad Ilhami
On Mon, 19 Feb 2001, [iso-8859-1] diego López wrote: Hi all, i installed successful Mysql ver 3.25.33-1 after that i changer the root password and when i make a connection looks like i am connecting with the user @localhost instead the root user [root@halley bin]# mysql -u root mysql

RE: Help with access denied

2001-02-19 Thread diego López
thanks in advice I already did something like that .. the problem was i erase all the content of the mysql directory and i creaste a new mysql database, and when i try to restar the mysql daemon (/etc/rc.d/init.d/mysql start) i get a message like: [root@halley mysql]# Starting mysqld

need mysql sample to accomplish existing asp function

2001-02-19 Thread Joe and Nancy
I am in a time crunch to get mysql working on my site. I export inventory records out of my Peachtree software into Excel and planned to use that .xls table to show product pricing and availability on my web pages. Below is sample asp code that works. My ISP had told me they support asp, but

Re: need mysql sample to accomplish existing asp function

2001-02-19 Thread Ed Carp
Joe and Nancy ([EMAIL PROTECTED]) writes: I am in a time crunch to get mysql working on my site. I export inventory records out of my Peachtree software into Excel and planned to use that .xls table to show product pricing and availability on my web pages. Below is sample asp code that

Re: RE: Help with access denied

2001-02-19 Thread Ed Carp
=?iso-8859-1?Q?diego_L=F3pez?= ([EMAIL PROTECTED]) writes: I already did something like that .. the problem was i erase all the content of the mysql directory and i creaste a new mysql database, and when i try to restar the mysql daemon (/etc/rc.d/init.d/mysql start) i get a message

  1   2   >