RE: emergency help

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

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)

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 -rw-rw-

mysqlgui 1.7.5

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

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

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 addres

Re: Bug: mysql uses temp filesort instead of index

> "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?

>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'

Re: RE: UPDATE and ORDER BY troubles

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 n

restore table?

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, please

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 --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

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 doin

help how to undo concat

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 = uncon

Query Help

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 b

ODBC problem

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 prompt==

RE: I can't un-subscribe

-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 i

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

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 if ((conn = do_connect (BTIME_HOST, USER, BTIME_PW, BTIME_DB,

Need Japanese character set files

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 s

Error From JBDC Driver

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 Webma

Re: auto start

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 >

Re: auto start

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

problemi compiling simpl1.cpp for borland

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 - Lc:\borland\bcc55\lib;c

PHP with MySQL and RPM files

$ 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.alibmysq

Newbie problems:I blew it up *sigh*

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 u

Problem with C API and mysql

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 to

Replication out of sync

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 addres

What is the error in this sql query

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), INDEX(page_ID

Re: PHP and MySQL result set navigation

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 wa

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

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

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

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 fus

Re: Clarification wanted

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 Fina

mysql_install_db.sh

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 execu

ODBC question, please reply to an new email address.

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

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 2

What is the error in this sql query

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), INDEX(page_ID

mysqlhotcopy ..

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 corr

Select query

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 th

Some more questions on Replication

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?

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

RE: Logging

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 --log=/var/log/somefil

RE: Some more questions on Replication

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 upda

JDBC - UnknownHostException

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, 1

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

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 root@qsv-cmxdb

RE: Query Help

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 wr

mysqldump

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

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

"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

backup database

Hi, besides using mysqldump, can i just copy the database in the data directory straight  away in windows explorer ?? is this a correct way to do that ?? thanx /---\ Confidential and/ or privileged information may be co

Re: What is the error in this sql query

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, > key

Scripts

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

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 Lis

Query - Performing a Join with a Count()

Hi, I have two tables: IDPERSON NAME AGE 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 this?! Many Thanks,

URGENT Disappear - Reappear Problem

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 o

Re: New install Problem

rjtalbo writes: > Paul > I am a newbie regarding MySQL but have been using Postgresql, DB2 and > for years Sybase.. > My installations are Linux (Caldera 2.3 & 2.4), OS/2 and WinNt. > My needs are a lan / Wan database..encompassing above OS's. > Problems: DB2 in Lan format too expensive >

Re: Problem with C API and mysql

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

Jim, Could you post the whole exception frame? Also, run "ping " 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 = mm.mysql-2.0.4 and Ja

Have you seen this error message?

Hi, When I try to start mysqld.exe under Win98 I get error: C:\mysql\bin>mysqld Can't initialize InnoDB as 'innodb_data_file_path' is not set Can anyone help with this? Thanks, Sean .

Re: Embedded System

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 qu

Re: Bug: mysql uses temp filesort instead of index

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: >http://

Re:Have you seen this error message?

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 a

Cannot compile MySQL 3.23.38 on solaris.

>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 included.

Creating functions

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 dynam

Re: problemi compiling simpl1.cpp for borland

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 /*/ /*/ /*/ \*\_ |*| |*||*| mailt

Re: Need Japanese character set files

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 di

Slave Stop

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 o

Re: mysqlgui 1.7.5

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

Re: Problem with C API and mysql

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

Re: Embedded System

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

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

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 start

RE: Help! MySQL variables laugh at me

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

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 13

create username/password with mysqladmin???

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

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

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

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 optimize

RE: Select Letter/Number

-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 you

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 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 submi

Help us make MySQL better

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 Server.

Best Column Type for Currency Calculations

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 postin

RE: safe_mysqld not working properly

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?

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 record

RE: convert microsoft sql

Mysql has a converter in it's package. Look under the scripts directory for MySQL. --- Brad Dameron Network Account Executive TSCNet Inc. www.tscnet.com

Re: Need Japanese character set files

> 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

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 deadl

RE: convert microsoft sql

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 structure

Re: Need Japanese character set files

On 2001 Jun 06, Anatole <[EMAIL PROTECTED]> wrote: > > I installed MySQL from an RPM file on Linux. When I use the mysql>show > 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 d

Creating functions

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 dyn

Re: Best Column Type for Currency Calculations

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)]

> > 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

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

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?

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 > r

Re: Newbie with PHP

"Harry Bakken" <[EMAIL PROTECTED]> wrote: > 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 If you post your code to the list, perhaps someone

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

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 Wit

events that i can trigger on intervals.

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 PHP.

Need help on mysql/php

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

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. - B

Re: Best Column Type for Currency Calculations

On Tue, 05 Jun 2001 12:53:50 -0500 (CDT), Don Read <[EMAIL PROTECTED]> wrote: We use DECIMAL(X,X) for all our currency related data columns, works perfectly. Usually DECIMAL(9,2) seems to work the best. >> >>On 05-Jun-01 Aaron Clausen wrote: >>> I've been having some problems with currency cal

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

---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   >