Question of MySQL

2001-11-28 Thread EdwardSPL
Hello, If you are using MySQL ( install by rpm packages ) with Red Hat 6.2 , please let me know ! Thank for your help ! Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists

RE: Beginner - Updating a Table from a File

2001-11-28 Thread Thomas Spahni
On Tue, 27 Nov 2001, john wrote: >I want to be able to do an update from a text file I have placed in the > /tmp dir. I have searched the "Manual" and it does not state how to do this. John, It took me not too long to find in the very fine Manual: ---quote - `LOAD DATA INFILE'

Error: Connecting remotely to mysql server

2001-11-28 Thread nimeesh patel
hi i installed mysql on redhat 7.1 .It's working fine for localhost. i made the user entry in mysql-user table as '192.168.1.20','test','test','Y','. and try to connect from 192.168.1.20(linux-system) but it is giving error as Error: host '192.168.1.20' is not allowed to connect to this MyS

Re: MySQL v4 FTS speed

2001-11-28 Thread Sergei Golubchik
Hi! On Nov 28, Gordan Bobic wrote: > On Tuesday 27 Nov 2001 23:28, Sergei Golubchik wrote: > > > > Another question - is there a way to acquire a list of words in the FTS > > > index? Someting like > > > > > > SELECTWord, > > > count(*) AS Frequency > > > FROM

gcc: can´t find executable

2001-11-28 Thread Sven Gauger
hi, i´m relatvely new to linux and i wanted to compile mysql on suse linux 7.3 minimal installation. i installed the gcc and make programs when i run ./configure --with-prefix=/usr/local/mysql the program performs some checks. it says that gcc is installed and ready but then it exits and says g

Install mysqlgui

2001-11-28 Thread Urtzi Larrazabal
Dear friend, I am planning to install mysqlgui in my Solaris 2.8 O.S. but I haven't any idea what steps should I follow to install it. I would be gratefull if you could help me. Best regards, Urtzi Larrazabal. ---

Re: MySQL v4 FTS speed

2001-11-28 Thread Gordan Bobic
On Wednesday 28 Nov 2001 10:37, Sergei Golubchik wrote: > Just added: > > % ./ft_dump > > Use: ./ft_dump [-dscvh] > > -d dump index (incl. data offsets and word weights) > -s report global stats > -c calculate per-word stats (counts and global weights) > -v be verbose > -h

Re: MySQL v4 FTS speed

2001-11-28 Thread Sergei Golubchik
Hi! On Nov 28, Gordan Bobic wrote: > On Wednesday 28 Nov 2001 10:37, Sergei Golubchik wrote: > > > Just added: > > > > % ./ft_dump > > > > Use: ./ft_dump [-dscvh] > > > > -d dump index (incl. data offsets and word weights) > > -s report global stats > > -c calculate per-word sta

Security problem in Access database

2001-11-28 Thread Jack
Dear all I'm planning to make a webpage which will let the user to enter the leave request record into one of the database's table. Actually the user can add, update the record with this table. Here is the question i want to ask: 1. What should i do if i want to limit the user which can only edit

INNER JOIN doesn't work correctly..

2001-11-28 Thread Sergey S. Kostyliov
>Description: Query with INNER JOIN return 0 rows, but the same query + yet another WHERE condition return 1 row >How-To-Repeat: Query: SELECT orders_common.vendor_id FROM orders_common INNER JOIN orders_common_count ON (orders_common.id=orders_common_count.o

MySQL strange error: lost connection during query

2001-11-28 Thread zeus
>Description: When 2 concurrent processes access the database 'sometimes' MySQL reports this error to both processes at the same time. It happens very rarely and about 10 seconds later they continue with its normal work. When we increase the number of processes accessing the database th

MySQL strange error: lost connection during query

2001-11-28 Thread zeus
>Description: When 2 concurrent processes access the database 'sometimes' MySQL reports this error to both processes at the same time. It happens very rarely and about 10 seconds later they continue with its normal work. When we increase the number of processes accessing the database th

MySQL strange error: lost connection during query

2001-11-28 Thread Zeus Gómez Marmolejo
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: MySQL strange error: lost connection during query >Description: When 2 c

error log

2001-11-28 Thread Alejandro Moia
Hello, I've updated my mySQL from version 3.21 to 3.23, and (after this change) all of my perl programs which use mysql, prints to STDERR, a debug (?) message like this: SV = RV(0x84ec388) at 0xb2f0 REFCNT = 1 FLAGS = (ROK,READONLY) RV = 0x8552d3c Then, I updated the mySQL version to 4

information retrival from database

2001-11-28 Thread sunil nair
please mail me a detailed note on information retrival from database. address:[EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -

4.0: wrong/nondeterministic results with latin1_de

2001-11-28 Thread fschmidt
>Description: With latin1_de character set and non binary strings I get results differnet from each other for queries that should IMHO produce the same result sets. Example (see test set below): In a table containing 1 hört 2 hoert 3 hört I expect as result for mysql> select *

Re: information retrival from database

2001-11-28 Thread Gerald R. Jensen
Read The Manual! - Original Message - From: "sunil nair" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 28, 2001 7:20 AM Subject: information retrival from database please mail me a detailed note on information retrival from database. address:[EMAIL PROT

Install Problem

2001-11-28 Thread Arp, Jo-An
This all started when the Boss asked for Mysql...and perl...and... I started by updating the installation of gcc (2.95). No problems. I installed perl (5.005_03) with gcc, again no problems. Except for gcc, no other configure flags were given to perl. Someone else installed a binary distributi

RE: information retrieval from database

2001-11-28 Thread Sander, Ryan
Hmmm. That's a pretty generic statement. There are lots of different ways to get information from a database. Need more info. Ryan Sander Web Developer [EMAIL PROTECTED] http://www.cantonrep.com > -- > From: sunil nair > Sent: Wednesday, November 28, 2001 8:20 AM > To

Re: Newbie Question

2001-11-28 Thread Etienne Marcotte
Are all displayed messages on the database? I'd suggest building static html files for the threads of the forum, with the message contents into the database, so you only have to query the database when there is a new post/edit/delete. All other times your server would be serving static pages, wh

Re: Install Problem

2001-11-28 Thread Boyd Lynn Gerber
On Wed, 28 Nov 2001, Arp, Jo-An wrote: > This all started when the Boss asked for Mysql...and perl...and... > > I started by updating the installation of gcc (2.95). No problems. > I installed perl (5.005_03) with gcc, again no problems. > Except for gcc, no other configure flags were given to per

Re: Failure to enforce length of fields to index corrupts tables

2001-11-28 Thread Sinisa Milivojevic
You wrote: >Description: > Documentation section 6.5.7 regarding create index states: "For CHAR and >VARCHAR columns, indexes can be created that use only part of a column, using >col_name(length) syntax. (On BLOB and TEXT columns the length is required.)" > It's still possible in

update bug

2001-11-28 Thread Daniele Gasperini
I am using mysql 3.23.41 and I discovered this bug. Imagine you have a varchar column named nick. If you send this query it correctly fails: select * from users where nick = 0; because data types are different but if you issue this one: update users set psw = "mypsw" where nick = 0; it modifies al

Problem with Fulltext search

2001-11-28 Thread HOD Team - Cafe
I'm using a MySQL ver. 3.23.41 And I don't seem to be able to create a FullText index. Below is my Table and the index I want to add. create table cal_bruger( ID int(4) unsigned zerofill NOT NULL auto_increment, Navn varchar(20) binary NOT NULL , EfterNavn varchar(20) binary NOT NULL , adresse va

Beginner question

2001-11-28 Thread Etienne Marcotte
When creating a table, can we specify that the combinaison of two fields needs to be unique but each of those two fields may have duplicates, just not both the same? Can we have a required attribute on one of two fields? I have phone_line_french and phone_line_english, i require one of those two

RE: Beginner - Updating a Table from a File

2001-11-28 Thread john
Tom, Yes, but won't this only replace and not load the rest of the items in the file? This is my code, but it only updates the existing items. load data local infile '/tmp/Parts.txt' >replace >into table Parts >fields optionally enclosed by '"' >termin

INNER JOIN doesn't work correctly..

2001-11-28 Thread Michael Widenius
Hi! > "Sergey" == Sergey S Kostyliov <[EMAIL PROTECTED]> writes: >> Description: Sergey> Query with INNER JOIN return 0 rows, but the same query + yet another Sergey> WHERE condition return 1 row >> How-To-Repeat: Sergey> Query: Sergey> SELECT orders_common.vendor_id Sergey>

Failure to enforce length of fields to index corrupts tables

2001-11-28 Thread Michael Widenius
Hi! > >How-To-Repeat: > Create table with field-type of TEXT. > CREATE INDEX AnyName ON Table(TextField); > Issue an update to a pre-existing record for the incorrectly indexed >TextField. > >Fix: > mysql should throw an error to the client if request is made t

Index Cleanup

2001-11-28 Thread C. Williams
Just wondering, say I have a couple of indexes on a table that grows linearly over a month. I have a script working in the background that archives anything in that table older than a month, so I effectively have a moving 1 month window of data. Does MySQL cleanup the index records accordingly

InnoDB Database

2001-11-28 Thread Meital Geron-Issers
Hello, I've just install mysql 4.23.44. (Till today I used 4.23.38 with the defualt tables). I created an InnoDB Database and add to it 4 tables. I read in the manual that I should get only .frm file for each table and that is what I got. But, now, when I am trying to connect to the Database, mys

Re: Security problem in Access database

2001-11-28 Thread Carl Troein
Jack writes: > 1. What should i do if i want to limit the user which can only edit the > record belongs to him/her. i mean user can only update to his own record but > not the others!! This sort of security is best handled at the application level. If you don't want your users to access the dat

Re: Can't make after ./configure

2001-11-28 Thread Sinisa Milivojevic
Gordan Bobic writes: > On Tuesday 27 Nov 2001 23:33, you wrote: > > > gcc version 3.0.2 > > It would appear that you tried compiling using the GCC 3.0.2 compiler. Try > downgrading to 2.95.3 (the last stable release) and try again. > > Regards. > > Gordan > gcc 3.0.2 is just fine, only set

Re: How to install mysqlgui?

2001-11-28 Thread Sinisa Milivojevic
Peter Smith writes: > Hello, I would like to know how to install mysqlgui and also fltk, flek, > mysql++ > > I have been to mysqlgui's install.txt, but not enough information on > installation, it only gives info on what you need to have to make mysqlgui > work. > > Could you get back to me a

Re: VC++ - MFC Question

2001-11-28 Thread Sinisa Milivojevic
Mike Gleason Jr Couturier writes: > Hello all ! > > I'm creating an MFC program with the mySQL API. > Everything is working fine but when exceptions > occurs (ie when connecting, changing databases...), > I can't display the er.error message to the user... > > How can I convert the error message

Re: Install mysqlgui

2001-11-28 Thread Sinisa Milivojevic
Urtzi Larrazabal writes: > > > Dear friend, > > I am planning to install mysqlgui in my Solaris 2.8 O.S. but I haven't any idea what >steps should I follow to install it. I would be gratefull if you could help me. > > Best regards, > > Urtzi Larrazabal. > If you have SPARC, try the e

Re: INNER JOIN doesn't work correctly..

2001-11-28 Thread Sinisa Milivojevic
Sergey S. Kostyliov writes: > >Description: > Query with INNER JOIN return 0 rows, but the same query + yet another > WHERE condition return 1 row > >How-To-Repeat: > Query: > SELECT orders_common.vendor_id >FROM orders_common > INNER JOIN orders_common_count > ON (

2 Articles on Threads and Joins?

2001-11-28 Thread Jonathan Hilgeman
I'm basically looking for two things: 1) An article/tutorial/document discussing operating system threads. I keep hearing about LinuxThreads on FreeBSD, and how MySQL won't run correctly with pthreads or something like that. I need to learn about threads and when and where they're used or not use

Re: MySQL strange error: lost connection during query

2001-11-28 Thread Sinisa Milivojevic
Zeus Gómez Marmolejo writes: > SEND-PR: -*- send-pr -*- > SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as > SEND-PR: will all comments (text enclosed in `<' and `>'). > SEND-PR: > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: MySQL strange error: lost connecti

Re: INNER JOIN doesn't work correctly..

2001-11-28 Thread Sergey S. Kostyliov
Hi, > > AND and orders_common.id=1060340 > > Result - 1 row > > You have two AND's one after another. > > Try with one AND and tell us what you get ... Two AND is a typo Real query has only one AND I'll send full test case via ftp in a one hour Best Regards,

RE: Beginner - Updating a Table from a File

2001-11-28 Thread john
mysql> load data local infile '/tmp/Parts.txt' -> replace -> into table Parts -> fields -> optionally enclosed by '"' -> terminated by ',' -> ('PN','APN','C','Q','D') Query OK, 100946 rows affected (39.66 sec) Records: 100946 Deleted: 0 Skipped: 0 Warnings: 2 This has o

date type

2001-11-28 Thread Jose Gerardo Amaya Giron
Hello all I got a a simple question, I changing from access to MySQL. I have in access some fields that have date and time. What type of field in MySQL can handle this. thanks Gerardo Amaya - Before posting, please check: h

GUI

2001-11-28 Thread Simon Green
Hi all This is probably a silly question but Can MySQL GUI connect from my windoz desktop to my Unix box? Just can not seem to get it working! Simon - Before posting, please check: http://www.mysql.com/manual.php (the m

RE: date type

2001-11-28 Thread rick herbel
timestamp -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jose Gerardo Amaya Giron Sent: Wednesday, November 28, 2001 8:43 AM To: [EMAIL PROTECTED] Subject: date type Hello all I got a a simple question, I changing from access to MySQL. I have in access

I uploaded a bug report innerjoin.tar [was: INNER JOIN doesn't work correctly..]

2001-11-28 Thread Sergey S. Kostyliov
Hi, I uploaded the file innerjoin.tar to ftp://support.mysql.com/pub/mysql/secret. please reject my first attemp with name "innerjoinbug.tar" (problems with kde :-( ) Please let me know if I can be of further help. Thank you guys, I think you are doing a wonderful job! Best re

Re: GUI

2001-11-28 Thread Sinisa Milivojevic
Simon Green writes: > Hi all > This is probably a silly question but > Can MySQL GUI connect from my windoz desktop to my Unix box? > Just can not seem to get it working! > > Simon Yes, of course it can. Start "Options", fill it up correctly and click to "Save" if you wish to connect always

Re: date type

2001-11-28 Thread Fabio Roger
timestamp is a good start - Original Message - From: "Jose Gerardo Amaya Giron" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 28, 2001 2:42 PM Subject: date type > Hello all I got a a simple question, I changing from access to MySQL. I > have in access some field

Format of doubles in queries(feature request)

2001-11-28 Thread Roland
Hello, I don't know if this is the right mailing list for a simple feature request, but please read on anyway. SKIP TO THE END IF YOU JUST WANT TO READ THE FEATURE REQUEST. As a Java programmer, I often access a MySQL database trough a driver, and notice a little problem: The MySQL format for D

Please redo this horrible web page

2001-11-28 Thread raezor
Let's make everything as hard as is possible for the "newbies". Please alphabetize or at least use some sort of date organization for the http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b instead of making us search through every entry, including those that have never been responded to. The Messages b

RE: date type

2001-11-28 Thread Alok K. Dhir
You probably want to start with datetime rather than timestamp, as timestamp comes with some additional magic to auto-set it for you and you may not want this. A good source for this type of information is, incidentally, the MySQL reference, at www.mysql.com. > -Original Message- > From:

Re: Please redo this horrible web page

2001-11-28 Thread Etienne Marcotte
I know you won't read my answer since I'm not from mysql but I wanna give my 2 cents. First don't you think you could go the "smooth" way for making a request? Either I'm not in a good mood or I can't read english, but your post seemed harsh. It's probably a really huge task to have this archiv

MySQL 3.23 Manual - PDF

2001-11-28 Thread A. Clausen
Is there still a PDF-formatted version of the MySQL 3.23 manual available? A. Clausen [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.c

mysql v. 3.23.45 - Brazilian Portuguese Error Messages Files Update and Bug Report

2001-11-28 Thread Roberto de Martin Serqueira
Hi, I'm forwarding you the file named mysql_3.23.45_pt-brazil.zip (I have uploaded it to address ftp://support.mysql.com:/pub/mysql/Incoming) which contains the updated Brazilian Portuguese idiom version of files ERRMSG.TXT and ERRMSG.SYS, to be parked in directory mySQL\share\portuguese. The

Re: date type

2001-11-28 Thread Jose Gerardo Amaya Giron
Thanks I now understand the difference. I can use a timestamp If I used a database to log access for example I only make an insert to the other fields and the timestamp insert the current time and date right? Gerardo Amaya "Alok K. Dhir" wrote: > You probably want to start with datetime rather

Re: date type

2001-11-28 Thread Etienne Marcotte
right Etienne Jose Gerardo Amaya Giron wrote: > > Thanks I now understand the difference. I can use a timestamp If I used a > database to log access for example I only make an insert to > the other fields and the timestamp insert the current time and date right? > > Gerardo Amaya > > "Alok K.

Re: Failure to enforce length of fields to index corrupts tables

2001-11-28 Thread Matt Johnson
In article <[EMAIL PROTECTED]>, Michael Widenius <[EMAIL PROTECTED]> writes >I just tested this with the upcoming MySQL 4.0.1: > >mysql> create table t1 (a text); >Query OK, 0 rows affected (0.01 sec) > >mysql> CREATE INDEX t1 ON t1(a); >ERROR 1170: BLOB column 'a' used in key specification witho

fetching & object design

2001-11-28 Thread Richard Reina
I am OO newbie, but in an effort to consolidate a lot of reusable code, I am trying to design an object in perl ( I think that's the right word) that will match an array to the fields in an input/output screen (template, form). It's rough going for me since the joins themselves are complicate

RE: Please redo this horrible web page

2001-11-28 Thread Johnny Withers
Really... you could also search it with some sort of search function in your browser.. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Etienne Marcotte [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 12:16 P

mysql@lists.mysql.com

2001-11-28 Thread oc
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:Otavio >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release:

Re: MySQL 3.23 Manual - PDF

2001-11-28 Thread Tony
Image you had a product and wanted to make a PDF manual available for your users. Where would you put it? Website, under documentation. BINGO! http://www.mysql.com/downloads/download.php?file=Downloads/Manual/manual.pdf Not sure why this MySQL list has so many questions and folks have t

Another basic question - index()

2001-11-28 Thread Etienne Marcotte
What is the exact difference between this index(col1,col2). that index(col1),index(col2). and this index(col1),index(col2),index(col1,col2). I read in the manual about it, but it's not really clear about the way to should be used / created. Any sql pseudo-teacher in here? :) Thanks a lot, Eti

Re: MySQL 3.23 Manual - PDF

2001-11-28 Thread Etienne Marcotte
i have to disagree you should read it before asking us to go read it! Title is on top of each page: "MySQL Technical Reference for Version 4.0.1-alpha" I am also looking for the latest 3.xx version manual. Etienne Tony wrote: > > Image you had a product and wanted to make a PDF manual availa

Re: MySQL 3.23 Manual - PDF

2001-11-28 Thread A. Clausen
- Original Message - From: "Tony" <[EMAIL PROTECTED]> To: "A. Clausen" <[EMAIL PROTECTED]>; "MySQL Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, November 28, 2001 11:20 Subject: Re: MySQL 3.23 Manual - PDF > > Image you had a product and wanted to make a PDF manual available for you

RE: Please redo this horrible web page

2001-11-28 Thread john
Ms./Mrs. Marcotte, First, since you asked, I am not a smooth talker, I am an asshole through and through. When things aren't right I'll be the first to let you know. Have you ever seen the movie "The American President"? Well, in order to make things work for non-pro's the pro's have to be rem

index questions 2nd request

2001-11-28 Thread rick herbel
Questions about index mysql> show index from listing; +-++-+--+-+- --+-+--+ | Table | Non_unique | Key_name| Seq_in_index | Column_name | Collation | Cardinality | Sub_part | +-++

RE: Please redo this horrible web page

2001-11-28 Thread john
Mr. Winters, They do have a very slow search engine built in to the site. Look at the header. -Original Message- From: Johnny Withers [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 1:09 PM To: 'Etienne Marcotte'; 'raezor' Cc: 'MySQL Lists'; [EMAIL PROTECTED] Subject: RE

Dynamic arrays in table?

2001-11-28 Thread Chris Comeau
I'm new to MySQL and i'm having some trouble with creating a table with the format i need. I need to create a table for user information (name, email, phone) and a list of purchased items (IDs) that will grow or shrink with time, in some kind of dynamic array. Is it possible to have this in o

error codes question

2001-11-28 Thread Cindy
I tried checking for error codes in the documentation, but didn't find anything particularly useful. I'm getting this: mysql> load data infile '/export/home/Scratch/WordIndex.txt' into table wordindex (aid, wid, wordform, start, length); ERROR 1030: Got error 28 from table handler In case it h

Re: Please redo this horrible web page

2001-11-28 Thread Erik Price
On Wednesday, November 28, 2001, at 02:44 PM, john wrote: > pages every day. Things on the list are no way near how easy they can > be. I > cannot fathom why this is not a newsgroup, and why every person/eu has > to be > flooded with so much email that has nothing to do with them or their > q

RE: Please redo this horrible web page

2001-11-28 Thread Ravi Raman
Hi. Not really interested in getting involved in the flamewar that seems to be brewing, but this might help: http://www.nexial.com/mailinglists/ -ravi. -Original Message- From: john [mailto:[EMAIL PROTECTED]] Sent: November 28, 2001 2:52 PM To: Johnny Withers; 'Etienne Marcotte' Cc: 'M

Large Unique Rows

2001-11-28 Thread Jonathan Hilgeman
I know this is a really simple thing that I'm just missing. Basically I want to store Apache logs in a mySQL database, in a table with 9 fields. I want each entry to be completely unique via all 9 fields. So, if fields 1-8 in a new record are all identical to fields 1-8 in an existing record, but

Re: Please redo this horrible web page

2001-11-28 Thread massey
Solution is simple Either 1. Filter your e-mail to specific folders 2. Remove yourself > > On Wednesday, November 28, 2001, at 02:44 PM, john wrote: > >> pages every day. Things on the list are no way near how easy they can >> be. I >> cannot fathom why this is not a newsgroup, and why ever

Re: Proposal for two (or more) new time and date functions

2001-11-28 Thread btjones
I think while you've got the hood up, a better method of doing the difference between two dates should be derived. Unless I'm going about this all wrong, the only way to get the time difference between two values currently is: UNIX_TIMESTAMP(end_datetime) - UNIX_TIMESTAMP(start_datetime)

RE: Please redo this horrible web page

2001-11-28 Thread john
Thanks for the input -Original Message- From: Ravi Raman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 2:28 PM To: john; Johnny Withers; 'Etienne Marcotte' Cc: 'MySQL Lists'; [EMAIL PROTECTED] Subject: RE: Please redo this horrible web page Hi. Not really interested in

Re: Dynamic arrays in table?

2001-11-28 Thread Chris Comeau
In addition to the purchased list, we want to have a "with list" kind of feature where you could add and remove things you might want to buy... So we would need to have some kind of array for each user that lists the ids of the puchasable items, that can grow and shrink... Any ideas? Thanks.

in_array function?

2001-11-28 Thread Steve Osborne
Simple question for one of you I am sure. I'm new to mysql (and php) and I am hoping someone can explain exactly what the 'in_array' function does. (Although I am new to mysql and php, I have programmed in extensively in Visual Basic, and have a little bit of experience in C, C++, and Java, so f

Re: Dynamic arrays in table?

2001-11-28 Thread Chris Comeau
We'll be using PHP, but right now, i'm just learning MySQL through the terminal client. I don't think strings would do the trick here... There will be alot of data, so it might get messy in a short time. It also seems like a slow way of doing it. We might need to change the item ids in the fut

RE: Please redo this horrible web page

2001-11-28 Thread Keith C. Ivey
On 28 Nov 2001, at 15:28, Ravi Raman wrote: > Not really interested in getting involved in the flamewar that seems to be > brewing, but this might help: > > http://www.nexial.com/mailinglists/ Does that work for you? The "MySQL" button on the side links to a URL that just redirects back to ht

Re: Dynamic arrays in table?

2001-11-28 Thread Steve Osborne
Ideally, you will want at least 2 tables. One for user info, and another for purchase information. One easy way to think of database normalization is to make sure that each table only has one purpose, ie user information. (Obviously, for security reasons, you would want to remove credit card inf

RE: Proposal for two (or more) new time and date functions

2001-11-28 Thread Alok K. Dhir
See: DATE_ADD(date,INTERVAL expr type) DATE_SUB(date,INTERVAL expr type) ADDDATE(date,INTERVAL expr type) SUBDATE(date,INTERVAL expr type) > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > m] On Behalf Of [EMAIL PROTECTED] > Sent: Wednesday, November 28, 2

RE: Please redo this horrible web page

2001-11-28 Thread john
Erik, Thanks for your input. I had no idea of what a troll was. I have seen the term flung about before, but I had no idea I was being a troll. So, a person who just sends an email to a list that has a valid complaint is not a troll, but if they send it with an attitude, because they are frust

Re: Php connection with mysql?

2001-11-28 Thread Ryan Fox
In your situation, MySQL sees the client to be the web server, as it is the box that connects to the database and executes queries. If you need finer granualarity on the access controls at the MySQL level, you can pass different usernames/passwords to MySQL through the php mysql_connect() functio

RE: Another basic question - index()

2001-11-28 Thread Norman L. Smith
> > What is the exact difference between > this > index(col1,col2). > that > index(col1),index(col2). > and this > index(col1),index(col2),index(col1,col2). > > I read in the manual about it, but it's not really clear about the way > to should be used / created. > > Any sql pseudo-teacher in h

Re: Please redo this horrible web page

2001-11-28 Thread Steve Werby
"raezor" <[EMAIL PROTECTED]> wrote: > Please alphabetize or at least use some sort of date organization for the > http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b instead of making us search > through every entry, including those that have never been responded to. Personally, I prefer the format of t

Re: Php connection with mysql?

2001-11-28 Thread Jason Burfield
Calvin... The connection is being made from the machine on which php is running. Most likely the web server. It is not connecting from your browser. So, these tables are checking the privileges of the connection. -- Jason On Wed, 2001-11-28 at 16:14, Wee Chua wrote: > Hi all, > I have a que

Re: in_array function?

2001-11-28 Thread Steve Werby
"Steve Osborne" <[EMAIL PROTECTED]> wrote: > Simple question for one of you I am sure. I'm new to mysql (and php) and I > am hoping someone can explain exactly what the 'in_array' function does. > (Although I am new to mysql and php, I have programmed in extensively in > Visual Basic, and have a

Re: Please redo this horrible web page

2001-11-28 Thread Erik Price
John, I know what you mean, to some extent. I bought a recently-published book that served as an introduction to MySQL and PHP. I thought it would be perfect -- it seemed to be engagingly written, and specifically dealt with what I wanted to learn about. The only problem was that the editi

RE: Please redo this horrible web page

2001-11-28 Thread Ravi Raman
That has happened to me occasionally, I wrote it off as me being tired. It seems to work now, although a date/thread list would be nice. But those (along with my email address!) are all over the net. -ravi. -Original Message- From: Keith C. Ivey [mailto:[EMAIL PROTECTED]] Sent: November

Re: in_array function

2001-11-28 Thread Steve Osborne
Thanks for the help regarding my php question (in_array function) Sorry I posted it here; obviously I was a bit confused. Thanks again, Steve Osborne Database Programmer Chinook Multimedia Inc. - Before posting, please chec

What is errno: 13

2001-11-28 Thread Venu Allavatam
Hello All: I am working on a particular database, which I created some days ago in mysql ver. 3.23.36. I am quite sure that I have not made any changes to the system (Dell WS with Red Hat Linux 7.1) either. What I see is this... ### [Venu@localh

Error on new connection socket: Invalid argument

2001-11-28 Thread Jeff Hinds
I have an application that is developed in perl using dbi and mysql that has been working well for some time now. However, I have received emails and phone calls asking if the server is down. I look at the service and the system is up however, the mysql error log reports the following message:

Re: Please redo this horrible web page

2001-11-28 Thread Neil Zanella
Dear mysql developers, Personally, I think your web pages are very nice and also user friendly. I have no idea about what this fuss is all about. Regards, Neil - Before posting, please check: http://www.mysql.com/manual.p

Re: MySQL 3.23 Manual - PDF

2001-11-28 Thread A. Clausen
If you wouldn't mind, though I think the folks at MySQL.Com should consider throwing a copy back up. Maybe I'm just a nervous nelly, but I won't be moving update Mysql 4 until it's beyond the alpha stage. I'm running an accounts receivable system, and I just upgraded to 3.23.45 yesterday.

Re: What is errno: 13

2001-11-28 Thread Dibo Chen
Error code 13: Permission denied Venu Allavatam wrote: > > Hello All: > I am working on a particular database, which I created > some days ago in mysql ver. 3.23.36. I am quite sure > that I have not made any changes to the system (Dell > WS with Red Hat Linux 7.1) either. What I see is > this

Re: What is errno: 13

2001-11-28 Thread Tyler Longren
I think that's the error code that's spit out when permissions are wrong on the DB file. You might want to check permissions. Good luck, Tyler Longren - Original Message - From: "Venu Allavatam" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 28, 2001 4:10 PM Subje

Re: Please redo this horrible web page

2001-11-28 Thread Alexander Skwar
So sprach »Keith C. Ivey« am 2001-11-28 um 16:27:46 -0500 : > Does that work for you? The "MySQL" button on the side links to a Yep, it does. Mozilla 0.9.6, Opera 5.05tp1 and Konqueror 2.2.1 checked; all on Linux. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote

Re: query syntax question

2001-11-28 Thread Benjamin Pflugmann
Hi. On Wed, Nov 28, 2001 at 02:26:45PM +0900, [EMAIL PROTECTED] wrote: > i want to do this: > > SELECT matrix.matrixId FROM matrix, language WHERE (matrix.fromLanguageId = > language.languageId AND language.isoLanguageId = 25) AND > (matrix.toLanguageId = language.languageId AND language.isoLang

Re: MySQL hang after select count()

2001-11-28 Thread Benjamin Pflugmann
Hi. Please post the result of EXPLAIN for the two queries. Bye, Benjamin. On Wed, Nov 28, 2001 at 12:50:21PM +0700, [EMAIL PROTECTED] wrote: > I dont understand mysql eat system 13 load average after that mysql hang while > runing query via web using DBD-Mysql and DBI. > Everyone help

Failing to connect to MySQL via ODBC/PHP

2001-11-28 Thread mweb
Hello, I am testing a web page on my server (code and result of phpinfo attached). In the browser window I get several errors like this: Warning: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in /home/marco/publ

Re: Please redo this horrible web page

2001-11-28 Thread Colin Faber
Hi guys, Locally I've already redone that for mysqldeveloper.com, Give it a look-see http://www.mysqldeveloper.com/lists/ Alexander Skwar wrote: > > So sprach »Keith C. Ivey« am 2001-11-28 um 16:27:46 -0500 : > > Does that work for you? The "MySQL" button on the side links to a > > Yep, i

Re: Error on new connection socket: Invalid argument

2001-11-28 Thread Cindy
"Jeff Hinds" writes: >I have an application that is developed in perl using dbi and mysql that has >been working well for some time now. However, I have received emails and >phone calls asking if the server is down. I look at the service and the >system is up however, the mysql error log repo

  1   2   >