Re: Math Computations

I agree with the suggestion below strip the character and typecast it if necessary. In JSP I think you can convert it to a number and then typecast it. In PHP, I think the principles might be the same. In addition, it might be a good idea to restrict the columns that require computation to a nume

Re: Encrpt/Decrypt

Just want to add a few more things here that might spark your brain cells. All in all I agree with the suggestions presented. Use an encrypt function in your code, for something simple I've created a very basic encryption function in perl using Crypt::Blowfish modules and then I have control of t

Re: [MANY to MANY] relationship with MySQL ???

I guess You could write Your query with JOIN statements to to get all information by one single query, not having to store things in PHP arrays. a simpe one could look like this... /* depending on what criteria is beeing used */ $match = "artist.name = $submitted_artist"; $match = "songs.nam

Re: Table full with InnoDB

Well, it will NOT let me add more ibdata files: Any ideas?? Thanks, Spiros Here is hostname.err (On a 2GB RAM, 2x1000 CPU, ) InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 3 7

Re: regular backup database in mysql

hi i do this on windows2000 like that first I create directory Archive on local disk and in that dir some subdirs like mon,tue ... for every weekday then you should create ms-dos batch file e.g. "back0.bat" in root of disk c:\ and put commands in it: rem BACKUP mysqldump -h192.168.1.1 -uroot -

Re: [MANY to MANY] relationship with MySQL ???

Hi Robbie Reading what I wrote wasn't very clear to me either ;-) > How does song_x_artist reference the other databases? Is there a way to set > up a field to always be a reference to another table? I think you may be talking foreign keys here - something yet to come in MySQL AFAIK. > >

RE: Encrpt/Decrypt

and it's all-around better to encrypt the password BEFORE you transmit it over an unsecure connection, or even between processes on a potentially unsecure machine. This means using, for example, the MD5() function in PHP... > -Original Message- > From: Matthew Smith [mailto:[EMAIL PROTECT

RE: Math Computations

It could be best to parse and remove ',' from both of them first before calculation... R.B.Roa PhilCom Corporation Tel. No. 858- Mobile No. (63) (919-xxx) -Original Message- From: delz [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 1:50 PM

Re: Encrpt/Decrypt

Manish Mehta wrote: > Hi > > I can Encrypt password in mysql using password() command. what is the way > to decrypt the password. > > Manish > Hi Manish / All Somebody correct me if I'm wrong, but I think that what happens is what's called one-way encryption. This is how stuff is don

C API

Hi!! I want to know if there is any datatype in MySQL C API which is similar to a structure in C??? Thanks, Ritu Singla - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.co

Re: Math Computations

Hi All, How do I make calculations in php or mysql if the value has a comma like 2,000 + 32,000 = 34,000. I have a problem calculating if one of my values has a comma. It doesn't display the right output. I'll appreciate anyone who can help me with this. Thanks. Delz. - Original Message -

Re: Encrpt/Decrypt

On Thu, 18 Apr 2002, Manish Mehta wrote: > Hi > > I can Encrypt password in mysql using password() command. what is the way > to decrypt the password. Like most other password functions you'll find in the unix world mysql's password function doesn't 'encrypt' a string, it generates a

Encrpt/Decrypt

Hi I can Encrypt password in mysql using password() command. what is the way to decrypt the password. Manish - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: [MANY to MANY] relationship with MySQL ???

> ...So the table song_x_artist contains references to all artists in a > song and vice-versa. (Field names correspond between tables.) How does song_x_artist reference the other databases? Is there a way to set up a field to always be a reference to another table? I am not quite sure what you

Re: [MANY to MANY] relationship with MySQL ???

This is the classic case for a junction table (aka bridge table, associative table). It sits between Artists and Songs; let's call it PlaysOn. Artists: ArtistID: autoincrement ArtistName: varchar DOB: date etc. Songs: SongID: autoincrement SongName: varchar Duration: in seconds, say etc. PlaysO

Re: [MANY to MANY] relationship with MySQL ???

Hi Robbie, all I have lots of things that need many to many - the way that I do it is this: create table artists ( a_ser int unsigned not null primary key auto_increment, artist_name varchar(64), other stuff... ); create table songs ( s_ser int unsigned not null primary key auto_increment,

Replication Oddity

Hi I am running MySQL 3.23.49a, installed from the "official" RPMs. The master is on a (Linux) machine with a permanent Internet connection and an routeable IP address. The slave is at another location with a *nearly* permanent Internet connection, behind a masquerading firewall. Due to r

[MANY to MANY] relationship with MySQL ???

Hello all, [~~I guess I could do something like MySQL>select FROM "Songs" where "artists" contains $currentArtist~~] I have a sampling section on a site that I am working on and am trying to find out how to display a table of the artists featured in that song. The sample section works as follows

Re: conn.setAutoCommit(false) can't work

At 21:18 -0400 4/17/02, bin cai wrote: >Hi, >currently i got a problem which i am afraid to ask >your help. > >I am using javaservlet and mysql 3.23.49 with innoDB >table type . the code conn.setAutoCommit(false) >doesn't work giving me error message("can't disable >auto_commit"); >I am stuck here

conn.setAutoCommit(false) can't work

Hi, currently i got a problem which i am afraid to ask your help. I am using javaservlet and mysql 3.23.49 with innoDB table type . the code conn.setAutoCommit(false) doesn't work giving me error message("can't disable auto_commit"); I am stuck here. anyone can give me some hint i will really app

RE: some good tutorial

Yeaheverything is open in MySQL environment ...u can read more info in the documentation side of MySQL website... R.B.Roa PhilCom Corporation Tel. No. 858- Mobile No. (63) (919-xxx) -Original Message- From: Ashish Joy [SMTP:[EMAIL PROTECTED]] Sent

myodbc ihtml unknow database

Hello all, I'm running mysql 3.23.44-1, myodbc 2.50.39 compiled with --with-unixODBC", and unixodbc 2.0.7-3, and iHTML. mysql and unixodbc were installed via rpm. All running on the same RedHat 7.2 box. I have set up the necessary system dsn's in /etc/odbc.ini and made sure that all driver

RE: Export

You can use C:\MySQL\Bin\MySQLDump -A > backup_file.sql R.B.Roa PhilCom Corporation Tel. No. 858- Mobile No. (63) (919-xxx) -Original Message- From: Manish Mehta [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 6:09 PM To:

InnoDB or BDB & ON DELETE RESTRICT

If I create a table like this: CREATE TABLE depts ( ID Int AUTO_INCREMENT PRIMARY KEY, name VARCHAR(30) ) TYPE=InnoDB; I add three Records to this table. THen I create this other table: CREATE TABLE employees( ID INT AUTO_INCREMENT PRIMARY KEY, name varchar(20), dept_id INT, FOREIGN

RE: print on top

Hi Jule, You need to sort your records with "ORDER BY" clause . I don't know what your table looks like and obviously don't know if you have suitable columd for it.. Say you have a newsid field defined with int datatype with auto_increment property, then you can issue your statement as "SELECT ..

Re: print on top

In the last episode (Apr 17), Mike said: > use ORDER BY ASC or DESC > > $Query = "SELECT * from $TableName ORDER BY DESC"; "ORDER BY postdate DESC", you mean? :) -- Dan Nelson [EMAIL PROTECTED] - Before postin

Re: TZ setting

Can the TZ be set in my.cnf (my.ini) when the MySQL server starts up? I have read the manual on this, and tried various combinations, but haven't hit the right syntax. Gerald Jensen - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wedne

Re: print on top

Sorry, I forget the column name for the ORDER BY > $Query = "SELECT * from $TableName ORDER BY column_name DESC"; Mike - Original Message - From: "Mike" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Jule Slootbeek" <[EMAIL PROTECTED]> Sent: Wednesday, April 17, 2002 6:45 PM Subject: Re:

RE: One field or numerous datatype-specific tables?

Howdy - Am I missing something? Why would you have to create all of your columns as BIGINT? Whether the "has pool" column is a TINYINT, BIGINT, or whatever, the SELECT statement would be the same, wouldn't it? Won't "SELECT FROM HOMES WHERE HasPool = 1;" return houses with pools regardless o

Re: print on top

use ORDER BY ASC or DESC $Query = "SELECT * from $TableName ORDER BY DESC"; Mike - Original Message - From: "Jule Slootbeek" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, April 17, 2002 6:38 PM Subject: print on top > Hey guys and gals, > I'm writing

print on top

Hey guys and gals, I'm writing this script for my new webpage, and i'm using MySQL to read and add news articles to a page, but everytime i add a new article it puts it under the older one, how can i get it on top? thanks Jule $Link = mysql_connect ($Host, $User, $Password); $Query = "SELECT

Mysql unresponsive ....

Hi all, Last friday we found that mysql was unresponsive (all the SQL activities were on hold) but the daemon was still running. We shutdown the daemon and restarted and everything was OK. My questions: 1) What could cause this behavior ? 2) Is there any way to monitor such a behavior ? any co

One field or numerous datatype-specific tables?

I am having a problem determining the best SQL DB schema to use. I have a table which stores attributes on homes, attributes such as "square footage", "price", or "includes pool". Now the problem I am having is how to store the actual value of the attributes. An attribute like "square footage" or

RE: What is Overhead?

sql,query Regardless of what you might call it, Overhead is what phpMyAdmin calls it. Matthew Walker Senior Software Engineer ePliant Marketing =20 -Original Message- From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]]=20 Sent: Wednesday, April 17, 2002 3:16 PM To: Matthew Walker; '

Number of records updated

Hi All, First, sorry my poor english I'm testing the pre-version of innodb (with on delete cascade) and when I delete some records, the number returned is only the records matched in the parent table. It erases the records in the child tables, but don't count them. This is because I'm using the

RE: What is Overhead?

Overhead is 'wasted' space in the table. It happens if a table has variable length rows, and you delete one in the middle of the table. To fix it, OPTIMIZE the table occasionally. Matthew Walker Senior Software Engineer ePliant Marketing -Original Message- From: Soheil Shaghaghi [mailt

Query problem with insert into....select

hi, i have 2 tables: currencyrates +-+++ | code char(3)|| currency char(3) | | name varchar(10)|| rate double| | bcurrency char(1) |

SV: a query from php doen't work

> Fra: savaidis [mailto:[EMAIL PROTECTED]] > Sendt: 17. april 2002 22:14 > Emne: a query from php doen't work > I get a "Query failed" error on this: > What could hapent? Try to alter this line: $result=mysql_query($buffer); to look like this: $result=mysql_query($buffer) or die($buffer."".my

a query from php doen't work

I get a "Query failed" error on this: What could hapent? I login as with MySQL-Front and pass the same query with no problem. Query's length is about 500 bytes. I need it to send my data to a remote MySQL server. PS I send this here becouse is more related to MySQL than to php. Thanks a lot Ma

RE: LOOKUP

Good point. Also, how would you capture the current enum list to add or substract from? Might have to hold that in an array or constant of some sort depending upon the language used. Andrew Hazen -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 1

RE: new to MySQL

This pages might be helpful: http://www.mysql.com/doc/T/a/Table_types.html http://www.innodb.com/ Gurhan -Original Message- From: Steve Bradwell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 3:06 PM To: [EMAIL PROTECTED] Subject: new to MySQL Hey Everbody, I am still pret

RE: LOOKUP

Hi, Your solution would work if the set of the values you'll get from one table is primary key.. If it is not a primary key, i.e. allowing duplicate values, then everytime there is an insertion to the table you will have to check to see if it is a new-added value or not. Gurhan -Original Mes

RE: Re[2]: sorting

Hi , I have resent another message and corrected that my solution wouldn't work because I oversaw the numbers with more than one digit, like you said. Roger Baklund posted the right syntax for it : -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17

RE: Platforms for MYSQL

MySQL (server) will run on Win9X, WinNt and later platforms. I use it with Delphi on my Win98 laptop and on my Win2K desktop. You will need TCP/IP for your peer to peer network. Much better than Paradox M -Original Message- From: Colin Rooke [mailto:[EMAIL PROTECTED]] Sent: 17 A

new to MySQL

Hey Everbody, I am still pretty new to MySQL and I was wondering if somone can explain the difference between ISAM tables and MyISAM, HEAP, innodb and Merge? Thanks alot, Steve - Before posting, please check: http://www.

some good tutorial

hi everybody, i have just joined the list and wanted to know something about mysql. is there some really good tutorial you think might be good for a starter in mysql. i am a master's student and have some knowledge of databases like ms access, oracle. hope to get some good stuff. regards ash

Re: foreign key on update cascade in mysql doesn't work

Hi! The brand-new source prerelease 3.23.50b-pre which you can download from http://www.innodb.com supports ON DELETE CASCADE and ON DELETE SET NULL. But does not support ON UPDATE CASCADE. Typically a foreign key refers to the primary key of another table, and it is not that common a primary key

RE: Weird MySQL thing

Well, I know how to do it manually, but it is annoying compared to using an interface like phpMyAdmin. But it begs the question as to why adding people to the mysql tables worked fine one day, and not the next. I've restarted/reloaded mysql, restarted my server, looked at permission, etc. Sinc

Re[2]: sorting

Hello Gurhan, Will it put 9a before 19b ? Wednesday, April 17, 2002, 4:51:14 PM, you wrote: GO> If you just do your query as "SELECT FROM SP_rooms ORDER BY room_no" it GO> will give you the results you want.. GO> Gurhan GO> -Original Message- GO> From: Dieter Munnik [mailto:[EMAI

Weird MySQL thing

I am having some trouble with MySQL. Seems I cannot add users. Well, I can add them (through phpMyAdmin, but they are still not able to get into the datasbases. I flushed the tables, too. Current users are not affected. This started, rather suddenly, the day after I was able to do this. Any

RE: transaction with MySQL

* Andrew Chan > Hi there, correct me if I am wrong. Only verion 4.x of MySQL supports > transaction. You are wrong. :) 3.23.*-max binaries support BDB and InnoDB tables, both support transactions. http://www.mysql.com/doc/B/D/BDB.html > http://www.mysql.com/doc/I/n/InnoDB.html > -- Roger --

RE: transaction with MySQL

> Hi there, correct me if I am wrong. Only verion 4.x of MySQL supports > transaction. If I remember correctly, BDB has transaction support and was released during 3.23 development. Sincerely, Craig Vincent - Before posting

Re: transaction with MySQL

Andrew, MySQL-Max-3.23 also supports transactions, and that is a stable release. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Original Message

foreign key on update cascade in mysql doesn't work

Hello, I create innoDB tables database in mysql3.23.49. i create foreign key constraints(On UPdate cascade) in one table. but it seems doesn't work. the system just refused to update. I am wondering the innodb in mysql doesn't support the feature like on update cascade or on delete cascade? thanks

RE: LOOKUP

That's what I thought too. A workaround occurs to me though, but I'm not sure if it would muck things up. At any point where you make a change to the table you want to reference as the "lookup" (as in Access), you could include another sql command to alter the table with the enum column to chang

transaction with MySQL

Hi there, correct me if I am wrong. Only verion 4.x of MySQL supports transaction. Thanks. Andrew _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -

Re: mysql+jdbc+international character support

Hello, Thank you for your immediate reply. What database version have you used these drivers for? Do you have a preference for either? Thanks again. jm "TAKAHASHI, Tomohiro" wrote: > Hi, > Both gweMySQL and MM.MYSQL support Unicode-Nativecode conversion. > > [gweMySQL Driver] > http

RE: LOOKUP

Ugh, I am being too goofy today.. Simon, the answer to the question is no, you can't do that in MySQL. You can, however, create a column with enum datatype and define set of valid values. In a case where you try to insert an invalid value to an enum field, it will insert an empty string for it. Si

Mysql 4.0.1 crashing in fulltext search with some words..

I'm not sure if this has been reported earlier, but my mysql-server goes down if I run a query with two 'match against' where one of them contains/matches the word 'think'... It terminates after the first query, but when I change the word 'think' to 'excel' or any other word it works flawlessy. I

RE: database security

I just bought this book, it's really good so far for MySQL but not sure how indepth the security content is http://www.webmasterbase.com/article/225 Steve. -Original Message- From: Paras Mukadam [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 12:19 PM To: MySQL Subject: datab

Re: MyODBC

Sounds like a user permission problem. Make sure you're allowed to connect from that ip. ( You can check in the 'user' table in the 'mysql' db. ) -- sh On Wed, 2002-04-17 at 09:34, Jim Bahr wrote: > Hi Gang, > > Im trying to set my remote xp pc to connect to my server databases using > MS Acce

security

Can anyone suggest some book on database security. I plan to study some features like Schema-less logins, single sign on, preserving user identity and like in light of MySQL. Regards, Paras. For live cricket scores downloa

Re: can't init my database for innoDB in mysql

Hi! Autoextend is only supported by versions >= 3.23.50. I heard a rumor that a binary of .50 could be out in 2 days. At http://www.innodb.com you can download a source prelease of .50. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/

RE: LOOKUP

Gurhan, I think Simon was looking for a way to make the enum dynamic from another table. ?? Andrew Hazen -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 10:22 AM To: Simon Tienery; [EMAIL PROTECTED] Subject: RE: LOOKUP Hi .. You can

security

Can anyone suggest some book on database security. I plan to study some features like Schema-less logins, single sign on, preserving user identity and like in light of MySQL. Regards, Paras. For live cricket scores downloa

MyODBC

Hi Gang, Im trying to set my remote xp pc to connect to my server databases using MS Access. I have loaded and configured Myodbc21.50.39 (win95) and my DNS but get the following error message when I try to connect in Access. [TXC][MyODBC] Host'hxxx-xxx-xxx.ip, Alltel.net is not allowed to connect

Re: mysql+jdbc+international character support

Hi, Both gweMySQL and MM.MYSQL support Unicode-Nativecode conversion. [gweMySQL Driver] http://www.t3-jpn.com/jdbc/jdbcmysql.html i.e. String url = "jdbc:mysql://server:3306/dbname?characterEncoding=EUC_JP"; [MM.MYSQL Driver] http://mmmysql.sourceforge.net/ Jan-Micha

Changing international charset for ORDER by sorting

Hi! Anybody knows how can I change the character set, when MySQL is running, to be able to do ORDER BY using international strings? I would need to do this without changing config, while I run my perl script. I would need to do sortings for different languages. So locale definition should be cha

database security

Can anyone suggest some book on database security. I plan to study some features like Schema-less logins, single sign on, preserving user identity and like in light of MySQL. Regards, Paras. - Before posting, please check: h

RE: Export

Use MySQLDumpit can help make backups R.B.Roa PhilCom Corporation Tel. No. 858- Mobile No. (63) (919-xxx) -Original Message- From: Manish Mehta [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 5:45 PM To: mysql S

Re: SV: Problem with query

select * from MEMBERS,FEE_PAYMENTS where FEE_PAYMENTS.price < '1' and MEMBERS.memberID = FEE_PAYMENTS.memberID; am I getting close? :o) Mark >The FEE_PAYMENTS table does not have one line corresponding to each line in the >MEMBERS table. > >The members table can look like this: > >MEMBERS >I

Export

Hi, I am working on Mysql . I wants to take backup (export) of my database from dos prompt . Is their any way. Please Tell. Thx in advance Manish Mehta - Before posting, please check: http://www.mysql.com/manual.php (

Alter Table and Replication

I've issued an ALTER TABLE query on a table controlled by my master in a replication to add a column to a table. Since I did this, replication of all tables in the only database being replicated has stopped. Do I have to take a snapshot of the DB and restart replication as per day 1 or is there

C API - intermittent problems with insert

Hello, I'm using the Suse-provided binary of 3.23.47 on Suse7.3 Linux, and I'm having a funny problem with my program, which uses the C API, on this database. The database I'm accessing is using only the BDB table type. The host system is a relatively low powered IBM 300XL, (PII-233, 96MB RAM, 2G

Re: Multiple Inserts

Hi all Thanks for your replies to my question about multiple updates in one query. I think Kittiphum Worachat is right in that I have designed it wrong. I couldn't get it to do what I wanted, so I reverted to single update queries. cheers Mark --- Summary of replies -- from Paul Wilso

Re: Problem with query

Depends on how the fee paymnents are defined. At its simplest: SELECT Members..Name FROM Members WHERE NOT(Members.MemberID = FEE_PAYMENTS.MenmbersID) would select members that have no fee payment records. You could build on it from there... For the mySQL gurus, sorry about the syntax guys, I

Re: Problem with query

select * from MEMBERS,FEE_PAYMENTS where FEE_PAYMENTS.PAID = '0' and MEMBERS. MemberID = FEE_PAYMENTS. MemberID; assuming you have a field PAID, with values 0 or 1,or even YES or NO cheers Mark >I am having a small problem with a small mysql query... > >I want to make a list of: >"WHO HAS NO

Problem with query

I am having a small problem with a small mysql query... I want to make a list of: "WHO HAS NOT PAID THEIR MEMBERSHIP FEE". I guess I could maybe solve this one myself, its not too hard ... I have one table with members MEMBERS -- | MemberID | Name | etc

LOOKUP

Dear Group, Could anyone help me please, I want to create an ENUM column in one table that lists the entries in another table. For example, the sales table to have a "staff" column that automatically gives a choice of the names of all staff listed in the staff table. I have been told that Acces