Bug report

2001-06-05 Thread Chris McCormick
Disclaimer: I am new to MySQL, and don't know the correct procedure for submitting bugs. A quick search on Google and the MySQL site provided no clear answer to my problem. My setup: Pentium II 350 MHz, running Win98. 64MB RAM. What I tried to do: I attempted to run C:\mysql\bin\mysqld

problem with distinct, group by, and join all together

2001-06-05 Thread Will Wohlman
mysql desc logs ; ++---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-+---+ | USERNAME | varchar(8)| | PRI | | | | TITLE

RE: emergency help

2001-06-05 Thread Ouyang, Sunny
Thank you very much for your help. I got it fixed with the command 'safe_mysqld--old-protocol ' Thank YOU!!! -Original Message- From: Nico D [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 10:44 AM To: Simon Green Cc: Ouyang, Sunny; '[EMAIL PROTECTED]' Subject: RE: emergency

auto start

2001-06-05 Thread Francois Boucher
Somebody install Mysql and apache for me, but forgot to set it auto-boot Each time i reboot i need to do # safe_mysqld --log --user=mysql and # apachectl restart I want it auto-boot, what can i do? François Boucher [EMAIL PROTECTED]

RE: emergency help

2001-06-05 Thread Johnny Withers
You have old style passwords in your mysql.user table.. you need to add --old-protocol to the start line in the startup script in /etc/rc.d/init.d then you should update the passwords to the new style.. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985

Re:Bug report

2001-06-05 Thread Heikki Tuuri
Chris, you should run mysqld-max.exe on Win 98. mysqld.exe was accidentally compiled with __NT__ defined, and that causes the assertion failure. This is fixed in 3.23.39: InnoDB asks from the OS whether it is Win 95, 98, ME, or NT, 2000. MySQL documentation you find at www.mysql.com, and InnoDB

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

2001-06-05 Thread Mike Broxterman
Neglected to mention the host.frm file _does_ exist. @ ls -al /usr/local/pkg/mysql/var/mysql/ total 134 drwx-- 2 root other512 Jun 1 07:53 . drwxr-xr-x 4 mysqlmysql512 Jun 4 09:17 .. -rw-rw 1 root other 0 Jun 1 07:53 columns_priv.MYD

mysqlgui 1.7.5

2001-06-05 Thread Dennis M. Gray
I have been unable to use the create table or edit table features of mysqlgui. Are this meant to work out of the box or is there more configuration I must do? I have tried with both 1.7.4 for Windows and 1.7.5 for Linux. Thanks

Some more questions on Replication

2001-06-05 Thread Warren van der Merwe
database,sql Hi again I have some questions re: Replication My sites are all connected via a dial-up modem, so I have a program what once a day will dialup and connect Site A to Site B, 1. how do I get the slave to start updating right there on the spot without having to wait 2. how do I know

Replication out of sync

2001-06-05 Thread Warren van der Merwe
Hello Firstly, big thank you to all who helped me get my replication going. When I was playing around, I managed to get one of my table out of sync, on the one server I have 8 records and on the other 9. I know exactly what happened, it was when server B was not replicating to the correct

Re: Bug: mysql uses temp filesort instead of index

2001-06-05 Thread Ben Escoto
SM == Sinisa Milivojevic [EMAIL PROTECTED] wrote the following on Mon, 4 Jun 2001 13:41:08 +0300 (EEST) SM One more thing. SM Can you try to run ANALYZE TABLE on sequence_data and see if SM that changes anything ... I got the +--+-+--+--+ |

Serious security bug?

2001-06-05 Thread jboyd
Description: User able to (accidentally!!) change/reset their own password despite not having *any* access to the mysql database How-To-Repeat There's the trick. We can't reproduce but this happened twice. However the setup of our (very recent) mysql installation is so simple that it's

Re: RE: UPDATE and ORDER BY troubles

2001-06-05 Thread X Gogo
Well, Jeff you are right! I've just taken the wrong line from .mysql_history file. It was one of my thousands of tries to make the ORDER BY work with UPDATE. What I really try to do is ORDER BY the 'received' column, which is a timestamp. The point is if I have plenty of alarm messages which are

restore table?

2001-06-05 Thread Richard Reina
I accidently overote a table in my database. I need to restore an individual table from a backup that I made on tape drive with dump. How can I restore just the individual table with restore -i. Richard - Before posting,

Logging

2001-06-05 Thread Glenn Emery
Hi All, I'm trying to turn on logging for MySQL 3.23.36 and upon running /etc/rc.d/init.d/mysqld start --log=/var/log/somefilename I still get Log|OFF when I run mysqladmin variables I'm running MySQL 3.23.36 on RedHat 7.1 Thanks! Glenn

newbie theory question

2001-06-05 Thread August Simonelli
Hi all, I have recently set up a linux box with red hat 7.1. i installed mysql and php and apache and have a really cool development area that works nicely. i am running mysql 3.23.32 and would like to upgrade it ... on the mysql site it has patches and full server rpm's ... what should i be

help how to undo concat

2001-06-05 Thread Jaime Teng
Hi, I have a database column of char(250); I can insert enmass a string into said column using: update tablename set columnname = concat(columnname, 'string'); but how do I undo that? Is there a function that is exactly the reverse of concat such that: update tablename set columnname =

Query Help

2001-06-05 Thread Daren Cotter
I have a database which has about 100,000 emails. I need to write some function to retrieve the domains of all these emails, and the count of each, to help catch cheaters. I began by just selecting all the emails with my query, and trying to use PHP to do all the work, but I think this could all

ODBC problem

2001-06-05 Thread
Dear Sir, For many times, I encountered the same problem as the follow. Maybe it is a general question for you. Would you please reply me the method to correct the program? Best Regards, Freda -- Error

RE: I can't un-subscribe

2001-06-05 Thread Darin E. Sease
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: June 04, 2001 11:27 AM To: Darin E. Sease Subject: Re: I can't un-subscribe Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must

Can mysql_close (conn) Be Modified to Close the Handle Immediately? (Possible Feature Request)

2001-06-05 Thread Van
Greetings: I haven't seen any discussions on reducing the duration of a network connection on port 3306 after issuing a mysql_close, so it makes sense to inquire whether anyone has addressed this. The code follows: // main.c #include mysql.h if ((conn = do_connect (BTIME_HOST, USER, BTIME_PW,

Need Japanese character set files

2001-06-05 Thread Narendra Phadke
Hi, I am storing Japanese data inside MySQL. MySQL supports all the Europian languages and other languages like korian and Hebru, and you have all the character set files for all these languages inside the C:\mysql\share\charsets directory. But this directory does not contain Japanese character

Error From JBDC Driver

2001-06-05 Thread gbengus
I am running the attached file on Red Hat 7.1 and getting the following error SQLException: Server configuration denies access to data source SQLState: 08001 VendorError: 0 Thanks Anthony __ Get your own FREE, personal Netscape

Re: auto start

2001-06-05 Thread Van
Francois Boucher wrote: Somebody install Mysql and apache for me, but forgot to set it auto-boot Each time i reboot i need to do # safe_mysqld --log --user=mysql and # apachectl restart I want it auto-boot, what can i do? François Boucher [EMAIL

Re: auto start

2001-06-05 Thread Tonu Samuel
On Mon, 4 Jun 2001, Francois Boucher wrote: Somebody install Mysql and apache for me, but forgot to set it auto-boot Each time i reboot i need to do # safe_mysqld --log --user=mysql and # apachectl restart I want it auto-boot, what can i do? If you want to auto-boot, you should first

problemi compiling simpl1.cpp for borland

2001-06-05 Thread cecca libero
i download the borland compiler ver 5.5 but i've got some problems... Anyone have a sample line for compiling with bcc32? this is the line that i'm trying but it doesn't work...(i attach the log) bcc32 -Ic:\borland\bcc55\include;c:\mc\include\mysql;c:\mc\include\sqlplus -

PHP with MySQL and RPM files

2001-06-05 Thread Neil Zanella
$ MYSQL=/usr/local/mysql $ ./configure --with-mysql=$MYSQL Then PHP finds the following files in $MYSQL/lib: $ ls $MYSQL/lib libdbug.a libmygcc.a libmysqlclient.a libmystrings.a libmysys.a With the RPM files one finds: $ ls /usr/lib/mysql libdbug.a libmerge.a libmyisammrg.a

Newbie problems:I blew it up *sigh*

2001-06-05 Thread Mist Dragon
Hi! I just installed mysql 3.23.38b max to my Suse Linux 6.2. Everything worked fine until I wanted row locking. I created innodb table and tried the instructions from manual and curiosly, those did not work - transactions committed automatically regardless what I did. Then I looked the manual

Problem with C API and mysql

2001-06-05 Thread kenneth johansen
hello everybody. Ive been working with perl and mysql for some time, but recently i had to move over to C and as such i wrote a small test program, just to get to know the mysql C API. Well, things didnt go as i thought. i kept getting linking problems and in the end my test program was limited

Replication out of sync

2001-06-05 Thread Warren van der Merwe
Hello Firstly, big thank you to all who helped me get my replication going. When I was playing around, I managed to get one of my table out of sync, on the one server I have 8 records and on the other 9. I know exactly what happened, it was when server B was not replicating to the correct

Re: PHP and MySQL result set navigation

2001-06-05 Thread Steve Edberg
If you want to repeatedly loop through a result set in PHP, you can use mysql_data_seek($result, 0); to reset the pointer to the first row. See http://www.php.net/manual/en/function.mysql-data-seek.php -steve At 9:33 AM +0800 6/4/01, Rolf Hopkins wrote: Yep, that's the

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

2001-06-05 Thread Van
Mike Broxterman wrote: Neglected to mention the host.frm file _does_ exist. @ ls -al /usr/local/pkg/mysql/var/mysql/ total 134 drwx-- 2 root other512 Jun 1 07:53 . drwxr-xr-x 4 mysqlmysql512 Jun 4 09:17 .. -rw-rw 1 root other 0 Jun 1

how to create username/password in mysql for linux???

2001-06-05 Thread Duane Douglas
hello, i'm new to mysql, so please bear with me. i installed the mysql 3.23.38 rpm package for linux. how do i create a username and password? from which directory should this be done from? also, from which directory can i connect to mysql? tia if (duane.douglas) { coder = asp * cold

Re: Clarification wanted

2001-06-05 Thread Jeremy Zawodny
On Mon, Jun 04, 2001 at 02:44:28PM +0530, [EMAIL PROTECTED] wrote: Hi, We are developing a portal which has pictures of machines in the form of HTML pages. I want to know whether I can store HTML in You can. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance

mysql_install_db.sh

2001-06-05 Thread Helene Daignault
Hello , my name is helene daignault ,I wsould like to know if I can receive more explicit explication to install mysql server on my mandrake 7.2 , I've done everithing in the manual , but I always got the error when I try to install mysql_install_db.sh you should do a make install before

ODBC question, please reply to an new email address.

2001-06-05 Thread
Dear Sir, For many times, I encountered the same problem as the follow. Maybe it is a general question for you. Would you please reply me the method to correct the program? Because the network reason, please reply to [EMAIL PROTECTED]. Best Regards, Freda

RE: Some more questions on Replication

2001-06-05 Thread Simon Green
Hi Warren I think what you what to do is more of a backup. Replication is set up to be connected all the time. It helps with redundancy and load sheared. Do you what to merge the DB's one a day? Simon -Original Message- From: Warren van der Merwe [mailto:[EMAIL PROTECTED]] Sent: 04 June

What is the error in this sql query

2001-06-05 Thread Syed sumair
What is the error in this sql query ??? _ CREATE TABLE page( page_ID INT (9) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT, relative_path VARCHAR (200) Not NULL, keywords VARCHAR (200) , have_vote ENUM (3), PRIMARY KEY(page_ID), UNIQUE(page_ID),

mysqlhotcopy ..

2001-06-05 Thread Alice Tan
but i still got no idea how to run mysqlhotcopy ? run in where ? how ? Original Message- On Fri, Jun 01, 2001 at 03:35:57PM +0800, Alice wrote: i have no idea on how to run mysqlhotcopy in the query tool or it is not suppose to run in query tool. is this correct ?

Select query

2001-06-05 Thread Syed sumair
Database... SElect Query. Please subcribe me in digest mode Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Some more questions on Replication

2001-06-05 Thread Warren van der Merwe
database,sql Hi again I have some questions re: Replication My sites are all connected via a dial-up modem, so I have a program what once a day will dialup and connect Site A to Site B, 1. how do I get the slave to start updating right there on the spot without having to wait 2. how do I know

Re: Serious security bug?

2001-06-05 Thread Tonu Samuel
On Mon, 4 Jun 2001 [EMAIL PROTECTED] wrote: Description: User able to (accidentally!!) change/reset their own password despite not having *any* access to the mysql database How-To-Repeat There's the trick. We can't reproduce but this happened twice. However the setup of our (very

RE: Logging

2001-06-05 Thread Simon Green
Have a look at /etc/my.cnf Simon -Original Message- From: Glenn Emery [mailto:[EMAIL PROTECTED]] Sent: 04 June 2001 19:14 To: [EMAIL PROTECTED] Subject: Logging Hi All, I'm trying to turn on logging for MySQL 3.23.36 and upon running /etc/rc.d/init.d/mysqld start

RE: Some more questions on Replication

2001-06-05 Thread Warren van der Merwe
Hi Nope you are wrong. I want it exactly the way it is. I have three sites, all must have access to the same data, within 24 hours. Therefore I don't want to have to backup and restore, I want to dialin, receive the latest, and disconnect. My setup will be triangular, so that once Site A has

JDBC - UnknownHostException

2001-06-05 Thread Bombardier Systems Consulting
Hello, I am running RedHat=7.1, MySQL= 3.23.36, JDBC = mm.mysql-2.0.4 and Java =1.3.1. I am trying to open MySQL through the JDBC driver and get the java.net.UnknownHostException error...this is all on one machine I have used the MySQL db with perl and it seems fine. I have tried localhost,

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

2001-06-05 Thread Mike Broxterman
Downloaded, compiled, installed, ran mysql_install_db. However, when I try to start using safe_mysqld I get the Can't find file error. root@qsv-cmxdb1:...pkg/mysql bin/safe_mysqld Starting mysqld daemon with databases from /usr/local/pkg/mysql/var 010604 08:44:28 mysqld ended

RE: Query Help

2001-06-05 Thread Simon Green
select distinct substring_index(email, @, -1) as Domain from users Hope this helps Simon -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: 05 April 2001 04:02 To: [EMAIL PROTECTED] Subject: Query Help I have a database which has about 100,000 emails. I need to

mysqldump

2001-06-05 Thread Alice
i saw % myswldump samp_db /usr/archieves.mysql.samp_db.1999-10-02 syntax in the Paul Dubois mySQL book, but this is command for unix, how abt windows syntax ?? /---\ Confidential and/ or privileged information may be

Embedded System

2001-06-05 Thread Richard Cochius
Hallo, I only got one question: Will there be an embedded version of MySQL for PDAs, like Palm or Compaq. Greetings Richard Cochius

Re: I can't un-subscribe

2001-06-05 Thread Van
Darin E. Sease wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: June 04, 2001 11:27 AM To: Darin E. Sease Subject: Re: I can't un-subscribe Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To

Re: What is the error in this sql query

2001-06-05 Thread Ansgar Becker
have_vote ENUM (3), must be this: have_vote ENUM ('3'), Greetings, Ansgar What is the error in this sql query ??? _ CREATE TABLE page( page_ID INT (9) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT, relative_path VARCHAR (200) Not NULL, keywords

Scripts

2001-06-05 Thread Manuel Dugué
Hi, I created some Scripts of the Type *.sql. In these Scripts there are pure SQL Statements, seperated by a ';'. How can I execute those Scripts (automated) in mySQL? Is there a possibility to make one Script, that starts other scripts... Can anybody help me? thanx Manuel

RE: What is the error in this sql query

2001-06-05 Thread David Lidstrom ( Cabesa )
I believe the ENUM-length is faulty! It should be somthing like this: have_vote ENUM(yes, no), Check the manual: http://www.mysql.com/doc/E/N/ENUM.html \d -Original Message- From: Syed sumair [mailto:[EMAIL PROTECTED]] Sent: den 1 juni 2001 01:11 To: MySQL List

Query - Performing a Join with a Count()

2001-06-05 Thread Jorge Oliveira
Hi, I have two tables: TBPersons IDPERSON NAME AGE TBCOURSES IDCOURSE IDPERSON TITLE DESCRITION Each Person have (or may have) many courses. I want to perform a query that retrieves the total of courses for each person, displaying also the name and age. Can someone please help me with

URGENT Disappear - Reappear Problem

2001-06-05 Thread Richard McKenney
We have a table whose entries seem to be disappearing at random. We are accessing our MySQL 3.22.32 database with PHP4 on a Linux 6.0 586 machine. Up until yesterday, we would lose about one entry per week in a single table. The rest of the tables seem fine. However, yesterday one of

Re: Problem with C API and mysql

2001-06-05 Thread Gerald Clark
kenneth johansen wrote: } + i compile this with: gcc -I/usr/local/mysql/include/ -L/usr/local/mysql/lib/ program.c -lmysqlclient add -lz -- Gerald L. Clark [EMAIL PROTECTED]

Re: JDBC - UnknownHostException

2001-06-05 Thread Kevin Whitney
Jim, Could you post the whole exception frame? Also, run ping whatever JDBC driver uses and make sure the name/address can be resolved. Kevin Bombardier Systems Consulting wrote: Hello, I am running RedHat=7.1, MySQL= 3.23.36, JDBC =

Have you seen this error message?

2001-06-05 Thread sales
Hi, When I try to start mysqld.exe under Win98 I get error: C:\mysql\binmysqld Can't initialize InnoDB as 'innodb_data_file_path' is not set Can anyone help with this? Thanks, Sean .

Re: Embedded System

2001-06-05 Thread Cal Evans
If you are running Linux on your iPaq, I believe I saw someone had actually compiled it on that platform. Cal - Original Message - From: Richard Cochius [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 05, 2001 4:03 AM Subject: Embedded System Hallo, I only got one

Re: Bug: mysql uses temp filesort instead of index

2001-06-05 Thread Sinisa Milivojevic
Ben Escoto writes: message, but everything is the same as before (query still takes a long time and explain says it is still using filesort). -- Ben Escoto - Before posting, please check:

Re:Have you seen this error message?

2001-06-05 Thread Heikki Tuuri
Hi! If you are running on Win 98 you should run mysqld-max.exe, because mysqld.exe was accidentally compiled with __NT__ defined. If you do not want to use InnoDB transactional tables, you should put the line skip-innodb in my.cnf. If you want to use InnoDB tables you can look at the manual

Cannot compile MySQL 3.23.38 on solaris.

2001-06-05 Thread Petter Lindqvist
Description: checking for restartable system calls... no checking need of special linking flags... none checking for working const... yes checking for inline... inline checking for off_t... yes checking for st_rdev in struct stat... yes checking whether time.h and sys/time.h may both be

Creating functions

2001-06-05 Thread Jiri Skrabal
Hi all, I need some help. I would like to create a procedure, which will transform input parameters into a query string and this string execute like a SQL command. I see a functionality of UDF but I mean, that it is useable only like ABS() functions etc. I would like to bind advantages of

Re: problemi compiling simpl1.cpp for borland

2001-06-05 Thread Sinisa Milivojevic
Hi! Please use MySQL++ version for Borland and when you do, use the .mak files that are provided in the package. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*|

Re: Need Japanese character set files

2001-06-05 Thread Timothy Smith
On 2001 Jun 04, Narendra Phadke [EMAIL PROTECTED] wrote: I am storing Japanese data inside MySQL. MySQL supports all the Europian languages and other languages like korian and Hebru, and you have all the character set files for all these languages inside the C:\mysql\share\charsets

Slave Stop

2001-06-05 Thread Warren van der Merwe
Hi there When issuing this command it seems like MYSQL process hangs. The server still responds, etc etc but the process that issued that command says waiting for slave to die and that takes a long time, eventually after 20 minutes I just disconnected the two servers and the process continued

Re: mysqlgui 1.7.5

2001-06-05 Thread Sinisa Milivojevic
Dennis M. Gray writes: I have been unable to use the create table or edit table features of mysqlgui. Are this meant to work out of the box or is there more configuration I must do? I have tried with both 1.7.4 for Windows and 1.7.5 for Linux. Thanks No wonder you could not do it.

Re: Problem with C API and mysql

2001-06-05 Thread Sinisa Milivojevic
kenneth johansen writes: hello everybody. Ive been working with perl and mysql for some time, but recently i had to move over to C and as such i wrote a small test program, just to get to know the mysql C API. Well, things didnt go as i thought. i kept getting linking problems and in the

Re: Embedded System

2001-06-05 Thread Sinisa Milivojevic
Richard Cochius writes: Hallo, I only got one question: Will there be an embedded version of MySQL for PDAs, like Palm or Compaq. Greetings Richard Cochius Hi! The answer is Yes in MySQL 4.0. What would you need it for ?? Regards, Sinisa __ _ _ ___

Re: What is the error in this sql query

2001-06-05 Thread Rolf Hopkins
I would say line 2, DEFAULT 0 not DEFAULT '0'. - Original Message - From: Syed sumair [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Friday, June 01, 2001 7:11 Subject: What is the error in this sql query What is the error in this sql query ???

Re: Scripts

2001-06-05 Thread Dibo Chen
Manuel Dugué wrote: Hi, I created some Scripts of the Type *.sql. In these Scripts there are pure SQL Statements, seperated by a ';'. How can I execute those Scripts (automated) in mySQL? mysql -u ... -p.. -h ... scr1.sql etc. Is there a possibility to make one Script, that starts

RE: Help! MySQL variables laugh at me

2001-06-05 Thread Remco Brood
if faq had a sequenced primary key you could do the following select a.sezione, IF(a.sezione = b.sezione, no,yes) as hasChanged from faq as a, faq as b where faq.id = faq.id -1 -Original Message- From: Luca Accomazzi [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 11:02 AM To:

RE: URGENT Disappear - Reappear Problem

2001-06-05 Thread Simon Green
I have only seen this when some thing was looking are the db files independed of mysqld. This was when I used isamchk to resort and fix a table but did not flush tables after. Hope this helps Simon -Original Message- From: Richard McKenney [mailto:[EMAIL PROTECTED]] Sent: 05 June 2001

create username/password with mysqladmin???

2001-06-05 Thread Duane Douglas
hello, i'm running mysql 3.23.38 on linux. how do i create a username and password with mysqladmin? from which directory do i do this? tia if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server * javascript }

occasionaly over-riding values

2001-06-05 Thread Dave Brown
Hi, we have a database where users sign up to one program of several (eg. in the user table there is a field prog_id referencing the auto_increment key of the program table) The program table holds a multitude of information (text, varchar, decimal, int, date fields) For some users they need a

convert microsoft sql

2001-06-05 Thread Christian Schäfer
hi there, my client has some databases on a m$ sql server and wants them to be converted to mysql (to use on a cheaper provider). has anyone ever done this before? are there many differences in the syntax or would it be easy to translate? maybe there's tool? thanks for your help! christian

PHP/MySQL running out of memory

2001-06-05 Thread Emma Jane Hogbin
Hi all: I'm not sure if this script is really running out of memory because of MySQL doesn't have enough memory, or if it's because it's a poorly written script. I was hoping that someone might be able to take a look at the script for me and let me know if they could find any ways to

RE: Select Letter/Number

2001-06-05 Thread Marcus Ouimet
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 11:54 PM To: Marcus Ouimet Subject: Re: Select Letter/Number Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter

Newbie with PHP

2001-06-05 Thread Harry Bakken
I apologize if this seems simple, or stupid, or if there is an answer in the archives. I am under an extreme deadline to get my PHP generated form into MySQL. I am trying to collect an order then pass the variables in to a validation page where the customer will review the information then

Help us make MySQL better

2001-06-05 Thread Timothy Smith
MySQL is taking a survey of MySQL users. As a bribe to get more people to fill out the survey, we are giving away three Palm PDAs and ten autographed MySQL books. Please take about ten minutes to fill out the web page: http://www.mysql.com/survey/ MySQL is an Open Source Database

Best Column Type for Currency Calculations

2001-06-05 Thread Aaron Clausen
I've been having some problems with currency calculations in SQL queries. I've been using Double, but often get some very small rounding errors. What is the recommended column type for currency in MySQL? Aaron - Before

RE: safe_mysqld not working properly

2001-06-05 Thread Angerer, Chad
Hello! I have just installed mysql-3.23.38 from source on a Mandrake 8 Linux box. I installed the db tables with mysql_install_db the user mysql owns the files in the mysql dir. when I go to start up the mysql daemon using ./safe_mysqld --user=mysql I get this Starting mysqld daemon with

Inserting 307,284 lines. Is this ok?

2001-06-05 Thread Mike Mike
Hello I was wondering if inserting 307,284 is to much to put into one table. Can MySQL handle this? Its a 70MEG File. I have a 550 with 256MEG ram but it only shows 64. I don't know how to make it show 256 and running redhat 6.1. The table has 12 colums and does not have much data in each

RE: convert microsoft sql

2001-06-05 Thread Brad Dameron
Mysql has a converter in it's package. Look under the scripts directory for MySQL. --- Brad Dameron Network Account Executive TSCNet Inc.

Re: Need Japanese character set files

2001-06-05 Thread Anatole
Only single-byte character sets with simple sorting rules can be described by the *.conf files. More complex character sets must be compiled into the server. The binaries that MySQL distributes have all supported character sets included. You can see what character sets are available

Re: Newbie with PHP

2001-06-05 Thread Tyrone Mills
Can you post some code? - Original Message - From: Harry Bakken [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 05, 2001 8:09 AM Subject: Newbie with PHP I apologize if this seems simple, or stupid, or if there is an answer in the archives. I am under an extreme deadline

RE: convert microsoft sql

2001-06-05 Thread Crercio Osmaildo da Silva
Hi, You can use DBTools (for windows http://dbtools.vila.bol.com.br)) to convert the structure (without indexes) and data to mySQL by using ODBC DSN, or you can dump the data into a TXT file and then import it into mysql with LOAD DATA ... I'm working on a wizard to convert a completely

Re: Need Japanese character set files

2001-06-05 Thread Timothy Smith
On 2001 Jun 06, Anatole [EMAIL PROTECTED] wrote: I installed MySQL from an RPM file on Linux. When I use the mysqlshow variables like 'character_sets'; as you mentioned above, I do, indeed, show sjis. This means that the sjis character set is compiled into the server already, so you do not

Creating functions

2001-06-05 Thread Jiri Skrabal
Hi all, I need some help. I would like to create a procedure, which will transform input parameters into a query string and this string execute like an SQL command. I see a functionality of UDF but I think, that it is useable only like ABS() functions etc. I would like to bind advantages of

Re: Best Column Type for Currency Calculations

2001-06-05 Thread Ron Beck
convert everything to pennies and use integers? Aaron Clausen wrote: I've been having some problems with currency calculations in SQL queries. I've been using Double, but often get some very small rounding errors. What is the recommended column type for currency in MySQL? Aaron

FW: [Fwd: (no subject)]

2001-06-05 Thread Longo, Joseph
hello everyone.. RedHat LInux 6.2. PC. mysql. when i start mysql with 'safe_mysqld ' i get the following: [root@kauai bin]# safe_mysqld [1] 872 [root@kauai bin]# Starting mysqld daemon with databases from

RE: Best Column Type for Currency Calculations

2001-06-05 Thread Don Read
On 05-Jun-01 Aaron Clausen wrote: I've been having some problems with currency calculations in SQL queries. I've been using Double, but often get some very small rounding errors. What is the recommended column type for currency in MySQL? DECIMAL(9,2) Regards, -- Don Read

Re: Newbie with PHP

2001-06-05 Thread B. van Ouwerkerk
Just a few thoughts. Does the user who needs to insert have enough rights to do so. Is your mysql server up and running.. If you want to take a look at a tutorial: www.devshed.com Bye, B. At 09:09 5-6-01 -0600, Harry Bakken wrote: I apologize if this seems simple, or stupid, or if there is

Re: Inserting 307,284 lines. Is this ok?

2001-06-05 Thread Tonu Samuel
On Tue, 5 Jun 2001, Mike Mike wrote: I was wondering if inserting 307,284 is to much to put into one table. Can MySQL handle this? Its a 70MEG Yes. This is not so much at all. File. I have a 550 with 256MEG ram but it only shows 64. I don't know how to make it show 256 and running

Re: Newbie with PHP

2001-06-05 Thread Steve Werby
Harry Bakken [EMAIL PROTECTED] wrote: snip form into MySQL. I am trying to collect an order then pass the variables in to a validation page where the customer will review the information then submit it for the database. When I submit the /snip If you post your code to the list, perhaps

RE: Inserting 307,284 lines. Is this ok?

2001-06-05 Thread Johnny Withers
At boot time you can pass a flag to lilo to force a certian amount of ram.. i think it's something like this: lilo: linux mem=256 307,000 rows in mysql is easy, mysql can handle a lot more rows than that. You shouldn't have any trouble with this amount of data. - Johnny

events that i can trigger on intervals.

2001-06-05 Thread Hasan Niyaz
Hi, I have a room inventory. Clients can block rooms them but I want to release them after a specified time if they do not release them normally via the given link. I want to be able to trigger an event to release the rooms after the time limit. Is there any way I can do this with MySQL or

Need help on mysql/php

2001-06-05 Thread Ed Peddycoart
I recently move my website to FastWebServers.com. MySQL and PHP is provided. I have a control panel which allows me to initialize MySQL for my use. The initialization creates a db, named celticblues_com (my domain is celticblues.com). So far, I have added a table to my database, and added the

exporting from MS Access

2001-06-05 Thread apt_renter
Hi, Has anybody perfected a method of exporting tables from Ms Access to a MySQL database? Every time I export my tables I lose the primary key definition. Is there a trick to stop this from happening? thanks in advance. -

Re: Inserting 307,284 lines. Is this ok?

2001-06-05 Thread Rafael Martinez
---Reply to mail from Mike Mike about Inserting 307,284 lines. Is this ok? Hello I was wondering if inserting 307,284 is to much to put into one table. Can MySQL handle this? Its a 70MEG File. I have a 550 with 256MEG ram but it only shows 64. [] I have a database with 20-30

  1   2   >