RE: JOIN to the same table multiple times

Ok, I've answered my own question but now have another. How do I reference the sitename for the 3 sites? sitename returns the last sitename for all 3 I tried S1.sitename etc. but it doesn't work. $query = "SELECT * FROM department LEFT JOIN sites S1 ON deptsite1=S1.sitekey LEFT JOIN sites S2 ON

Re: Select query

On 6/7/01 5:33 PM, "Gary Huntress" <[EMAIL PROTECTED]> wrote: > I'll bet it's a roundoff problemtry select * from sequence_protein where > mol_wt> 53211.62 and mol_wt < 53211.63 > > > Regards, > Gary "SuperID" Huntress > === > FreeSQL.org

Re: Mysql SQL behaviour with a plus sign

In the last episode (Jun 07), [EMAIL PROTECTED] said: > It looks like mySQL is funny about a + next to a - in a string. > > > If I do select count(*) from Table where Column like '%+---%' > I get 0 records. > If I do select count(*) from Table where Column like '%---%' > I get 70652 records. >

RE: can i keep a connection to the database open

In PHP you would use "pconnect" but there is little or no time advantage, but you mite use all your threads up? Simon -Original Message- From: Harsh [mailto:[EMAIL PROTECTED]] Sent: 07 June 2001 14:35 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: can i keep a connection to the data

Re: Select query

On 6/7/01 4:50 PM, "Eric Fitzgerald" <[EMAIL PROTECTED]> wrote: > When comparing float values, you have to use '' around the value. > > Your query should look like this: > select distinct sequence_id from sequence_protein where mol_wt = '53211.62'; Ok, I should have mentioned that I tried the q

Re: Please can you help me find the right file to download

Hello Stephen, Thursday, June 07, 2001, 5:41:39 PM, you wrote: SC> I am after a version of MySQL with a graphical interface. SC> I don't know which files to download or what to do with them once SC> downloaded. SC> I am keen to try out mysql but I am having difficulty understanding what to S

Re: New To mySQL

Hello Geoffrey, Thursday, June 07, 2001, 3:34:32 PM, you wrote: GVN> Hi all, GVN> I am a new user of mysql DB. GVN> I am working with WN NT 4. GVN> I already downloaded the mysql binary package for window. GVN> I installed it. GVN> But, now I don't know where to begin. How to start the DB.

libwrap problems (compiling) and config questions

Hello everyone. I have hit a snag trying to compile mysql 3.23.38. After running this configure command: CFLAGS="-O3 -mpentiumpro" CXX=gcc CXXFLAGS="-O3 -mpentiumpro -felide-constructors -fno-exceptions -fno-rtti" ./configure --with-berkeley-db --with-libwrap --with-named-z-lib --without

Re: [OT] Javascript Manual

Start with the inventors of Javascript, Netscape: http://developer.netscape.com/docs/manuals/javascript.html You can down load a number of manuals. I learned most of what I know from those manuals. The other good place for specific questions is the javascript news group comp.lang.javascript

Re: Speed

At 16:10 +0300 07-06-2001, Sinisa Milivojevic wrote: >Thierry Coopman writes: > > Hi, > > > > I was wondering where the limits of MySQL are. > > > > I need >2000 updates per second on a table with +-20 rows. > > > > I was wondering what the ideal hardware to accustom that would be. > >

Re: New To mySQL

Start with the manual - Original Message - From: "Geoffrey Van Nuffelen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 07, 2001 5:34 PM Subject: New To mySQL > Hi all, > > I am a new user of mysql DB. > > I am working with WN NT 4. > I already downloaded the m

Re: Select query

You could try something like mysql> select sequence_id from sequence_protein -> where truncate(mol_wt, 2) = 53211.62; And, if you look truncate up in the manual, I think it even gives an explanation as to why. - Original Message - From: "Hannes Niedner" <[EMAIL PROTECTED]> To: <[EMA

Re: Chroot problems

On Wednesday 06 June 2001 08:53, dariofg wrote: > Hello, > > I'm trying to run mysql in a chroot jail, but the server > errors out. I've modified safe_mysqld so it would call > MySQL with the following command: > > nice --5 nohup /usr/local/mysql/libexec/mysqld -- > basedir=/ --datadir=/var --use

RE: MySQL security settings

I installed MySQL on Windows NT. Currently, I login in using annoyomous user. I can't seem to login in as root user. The syntax is : mysql -u root -p xxx It's seems funny as I can see the root password in the MySQL database --> user table. Any help ? Nyon

Re: parse error in config.inc.php3 on line 1 in phpMyAdmin

on 6/7/01 17:58, Zak Greant at [EMAIL PROTECTED] wrote: > Barry C. Hawkins wrote: >> Esteemed colleagues, >> The php list is down, and I am sure someone knows what to do about > this >> in this list. The issue is that I receive the error >> >> Parse error: parse error in config.inc.php3 on line

Re: INSERT.

Check out last_insert_id in the manual. - Original Message - From: "Jorge Oliveira" <[EMAIL PROTECTED]> To: "Mysql@Lists. Mysql. Com" <[EMAIL PROTECTED]> Sent: Friday, June 08, 2001 7:43 Subject: INSERT. > Hi, > > I have two tables in my database: > > #TB1 > ID_tb1 (auto-incremented)

64-bit build of mysql's libiodbc?

Currently the shared library object made within ../mysql/libiodbc* is 32-bit. Is there a way to modify the configuration for automake to create a 64-bit shared library object instead? Thanks Jeff Tanner Viathan - Before postin

Re: Installing, following directions, discovering problems.

"natch" <[EMAIL PROTECTED]> wrote: > # /usr/libexec/mysqld > Fatal error: Please read "Security" section of the manual to find out how to > run mysqld as root! > 010606 10:15:41 Aborting This is often caused by trying to start mysql when logged in as the incorrect system user. Try logging in as

Re: Select query

When comparing float values, you have to use '' around the value. Your query should look like this: select distinct sequence_id from sequence_protein where mol_wt = '53211.62'; - Original Message - From: "Hannes Niedner" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 07

Re: problems getting asp to talk to mysql

At 05:46 PM 6/7/2001 +0100, michael.mansfield wrote: >my isp olm.net are not helping. > >what needs to be installed on a unix server to enable an asp page to talk >to mysql please. afaik you need myodbc installed on the asp web server box: hth

Re: PHP/MySQL running out of memory -- SOLVED

Hi all: As a follow-up to a problem I was having earlier: I was using Clay Johnson's tutorial to build an index of my tri-drs.org database. It wasn't working. I made some modifications to try and get it to work. Thanks to James who suggested using mysql_free_result. The script works now!! For

Re: DuBois's book's scripts - where to get them?

>I have the book, are the little scripts in the book >available online? > >I went to the book's site at >http://newriders.com/books/title.cfm?isbn=0735709211 >which sent me to the author site at >http://www.mysql.com/Contrib/Examples/ >but gets the no permission error >"You don't have permission t

Re: Select query

Switch the column type to double. From the manual: If you are comparing FLOAT or DOUBLE columns with numbers that have decimals, you can't use =! This problem is common in most computer languages because floating-point values are not exact values: mysql> SELECT * FROM table_name WHERE float_co

Re: Pound (£) Symbol and MySQL

- Original Message - From: "technical Support" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 08, 2001 4:52 Subject: Pound (£) Symbol and MySQL > Hello All, > > When I insert data submitted via a web page into mySQL, the pound (£) > symbol gets converted to something lik

User variables

Are there any issues with user variables ( SET @variable:=) overflowing memory on the server? I am considering using user variables to implement a simple psuedo stored procedure API whereby an API user can set variables for a query in one function, and call the query later on in another functi

INSERT.

Hi, I have two tables in my database: #TB1 ID_tb1 (auto-incremented) ID_tb2 name address #TB2 ID_tb2 (auto-incremented) method status I need to run a query that inserts values into #TB1 and #TB2, having #TB1.ID_tb2 equal to #TB2.ID_tb2. Since #TB2.ID_tb2 is auto incremented, I d

Re: Borland C++Builder compile error

At 10:03 07/06/2001 -0700, Jay Stewart wrote: Hi! Please add #include at your main unit. Regards, Miguel >I am attempting to add SQL client-server functionality to a Window's (2000) >app I am developing in Borland's C++Builder v5. After installing the mysql C >API, including the mysql.h header

parse error in config.inc.php3 on line 1 in phpMyAdmin

Esteemed colleagues, The php list is down, and I am sure someone knows what to do about this in this list. The issue is that I receive the error Parse error: parse error in config.inc.php3 on line 1 upon trying to access phpMyAdmin 2.1.0 from the web. MySQL 3.22.23 is on the same Linux

Re: Cant connect

Well, from the error, one of them is not correct. Since you didn't supply the code you used, my best guess is your host is incorrect. I am guessing you have something other than 'localhost'. If that's not working, '127.0.0.1' may do the trick. If not, check your grant tables again. - Orig

Installing, following directions, discovering problems.

First off I want to thank anyone who helps. I know helping new people trying to install can be a pain but I'll try and cooperate. I installed Redhat 7.0 with the mySQL packages. I read that there were patches for the mySQL install on Redhat so I downloaded the RPM for the version I had mysqlcli

Re: Help required for OLEDB on win32 for MySQL(linux)

At 20:56 07/06/2001 +0530, asit wrote: Hi, Please take a look on the help file, where you should find that your connection string is wrong. You find the instructions of the connection string just below of Overview item. server=192.168.100.101 ? Regards, Miguel >Hi, > >I am facing problem whil

Re: What am I missing?

You don't need MySQL-bench-3.23.38-1.i386.rpm to run mysql but if you still want to use it, you need to install perl first. - Original Message - From: "Mike Jimenez" <[EMAIL PROTECTED]> To: "Mysql" <[EMAIL PROTECTED]> Sent: Friday, June 08, 2001 1:35 Subject: What am I missing? > rpm -i

Re: [OT] Javascript Manual

Hello SED, Friday, June 08, 2001, 12:28:37 AM, you wrote: S> Hi, I know this is off topic but does anyone here know of a good manual S> website which shows Javascript from A-Z (like the PHP-manual and S> MySQL-manual). I know of a lot of java-code sites but none of them show S> the basic thought

Re: Chroot problems

On Thu, Jun 07, 2001 at 04:56:12PM -0700, Kyle Hayes wrote: > > One of the problems I had when running MySQL in a chroot jail was > that the /etc/passwd, /etc/shadow etc. had to be correct in the > jail. However, I don't think I am running it in the same > configuration that you use. See below.

Cant connect

Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in setup.php on line 92 I am sure that all information is correct as far DB name user name and password any ideals

Re: Pound (£) Symbol and MySQL

Check for a call to htmlentities() in the PHP code. That is probably the cause of the behavior. --zak - Original Message - From: "technical Support" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 07, 2001 2:52 PM Subject: Pound (£) Symbol and MySQL > Hello All, > > Wh

Update phone inner join tmpphone....

I tried this query: Update phone inner join tmpphone on phone.empno = tmpphone.empno set phone.lname = tmpphone.lname, phone.fname = tmpphone.fname and it didn't work. This does work in MSSqlServer 7. Is this syntax (or something like it) supported by MySQL??

Re: installation problem

Is this a new installation? Then the -p option is not required. -p is only used once you have set the initial password. - Original Message - From: "Michela Robustelli" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 07, 2001 23:20 Subject: installation problem > i've

JOIN to the same table multiple times

### Creating a Telephone / Information Directory with MySQL / PHP3 People belong to a department & a site. Need to be able to: List all people List all people within a Department List all people within a sit

Re: Please can you help me find the right file to download

There is no full blown graphical version of the database itself. You still need to download the normal version itself and then download a graphical front end for administration. The main software you need can be found at http://www.mysql.com/downloads/mysql-3.23.html and the graphical interface

Re: can i keep a connection to the database open

At 07:05 PM 6/7/2001 +0530, Harsh wrote: >i want to write a web-based chat application in Perl which runs on Unix >server with mySQL as backend. The application needs to continouly >interact with database hence instead of opening a DBI connection in each >perl page, I wish to keep a live open conn

Re: Stored procedures (really sorry for bringing this up)

Hi John and Sinisa, I don't know if this helps but we are using php scripts in place of "stored procedures". Our client/server apps open up an https or http connection to a php server and pass in the script name and variables in the URL (like cgi). It's not "stored procedures", but is pretty

update log

Hi, I'm using version 3.22.32 on RH6.2. When I run "show variables" it indicates that log_update is ON, which is what I want. The datadir is /var/lib/mysql. I have not done anything to change the name of the file, and according to the documentation, it should be in the datadir. For the life

Re: problems getting asp to talk to mysql

At 05:46 PM 6/7/2001 +0100, michael.mansfield wrote: >my isp olm.net are not helping. > >what needs to be installed on a unix server to enable an asp page to talk >to mysql please. OK: is the ASP running on Unix as well? Who's flavor ASP is it? ChiliSoft? -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+

Mysql: java vs. php

Here's a left-field question: Does there happen to be a compelling reason for me to look into php when using a MySQL database rather than my current Java usage. I know the easy answer would be that if I know java, then stay with javait's a more versatile language, and so on. But, are there

Problems installing on Solaris 2.6

I'm sure this has been beat into the ground here, but I've nowhere else to turn. When running ./configure --prefix=/usr/local/mysql I get the following error: configure: error: can not run test program while cross compiling Can anyone explain to me how to get around this? Thanks, Aaron -

Re: parse error in config.inc.php3 on line 1 in phpMyAdmin

Barry C. Hawkins wrote: > Esteemed colleagues, > The php list is down, and I am sure someone knows what to do about this > in this list. The issue is that I receive the error > > Parse error: parse error in config.inc.php3 on line 1 > > upon trying to access phpMyAdmin 2.1.0 from the web.

Re: New To mySQL

Hello Geoffrey, Thursday, June 07, 2001, 3:34:32 PM, you wrote: GVN> Hi all, GVN> I am a new user of mysql DB. GVN> I am working with WN NT 4. GVN> I already downloaded the mysql binary package for window. GVN> I installed it. GVN> But, now I don\'t know where to begin. How to start the DB.

Re: encrypt wierdness

On Thu, 7 Jun 2001, Richard Ellerbrock wrote: > Looking at the encrypt function, it optionally takes a salt parameter. Using encrypt >without specifying a salt yields random results: > > mysql> select encrypt('qwerty'); > +---+ > | encrypt('qwerty') | > +---+ > |

Select query

What do I do wrong? The query result is not supposed to be an empty set (please cc your response to [EMAIL PROTECTED]) mysql> select sequence_id, mol_wt from sequence_protein limit 1; +-+--+ | sequence_id | mol_wt | +-+--+ | 100368 | 53211.62 | +---

Slow Query... Good indexes...

Dear Sirs, We have a very large database (badge_history has > 4,000,000 rows) and the explain for our query looks like this: By using indexes for a query, the product of the row estimates from an explain statement are less than 200,000. The problem is that this query times out. There is only

RE: Problems installing on Solaris 2.6

hi. rtfm. http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#So laris -ravi. -Original Message- From: Aaron Williamson [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 07, 2001 3:06 PM To: [EMAIL PROTECTED] Subject: Problems installing on Solaris 2.6 I'm sure this

[OT] Javascript Manual

Hi, I know this is off topic but does anyone here know of a good manual website which shows Javascript from A-Z (like the PHP-manual and MySQL-manual). I know of a lot of java-code sites but none of them show the basic thought, syntaxes etc. - so can anyone pin-point me? Regards, Sumarlidi Einar

dealing with datetime

Hi, Just working here on a php-mysql project and came to a weird problem, See this: mysql_query("UPDATE trackvisits SET hitcount=hitcount+1,refreshtime=now(),lastlength=now()-arrivetime WHERE username='$visitor'"); Especially notice the lastlength=now()-arrivetime . Both lastlength and arrivet

Re: mysql daemon aborting abnormally (rh linux 6.2)

At 11:43 AM 6/7/2001 -0400, Duane Douglas wrote: >At 02:44 PM 6/7/2001 +0800, Rolf Hopkins wrote: >>Sure it hasn't already started? Do ps -ef | grep mysqld to find out. i resolved this issue. please disregard. if (duane.douglas) { coder = asp * cold fusion * xml * xsl * sql server * javascrip

Re: New To mySQL

I agree. The online manual is wonderful: http://www.mysql.com/ ...and the book by Paul Dubois is fabulous: http://www.amazon.com/exec/obidos/ASIN/0735709211/o/qid=991937746/sr=2-1/ref=aps_sr_b_1_1/107-9361976-5006147 These two resources will have you up in no time. A little reading will get yo

DuBois's book's scripts - where to get them?

I have the book, are the little scripts in the book available online? I went to the book's site at http://newriders.com/books/title.cfm?isbn=0735709211 which sent me to the author site at http://www.mysql.com/Contrib/Examples/ but gets the no permission error "You don't have permission to access

Re: MySQL with perl

I've encountered this several times. When on the web I just use redirect pages. I'll submit the data to a page that puts the information into the database, and then puts a header() call to redirect them to the real finishing page, passing any minor variables I may need. This way also has the un

Re: MySQL too slow

On Thu, Jun 07, 2001 at 12:56:24PM +0500, Muhammad Asif wrote: > > i have MSAccess table with 1 records without any index > i import same table in MySQL without any index > > When i access data from this table through ODBC in ColdFusion: > > Data from Access took 14 Sec and > Data from MySQL

What am I missing?

rpm -i MySQL-3.23.38-1.i386.rpm MySQL-client-3.23.38-1.i386.rpm MySQL-bench-3.23.38-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.38-1 Thanks Mike - Before posting, please check:

This is a bit off topic but...

How can I AUTOMATICALLY export an MS ACCESS table and its data using a proggie language such as VB or VC. I NEED TO DO THIS IN A PROGRAM: CLICK ON FILE -> EXPORT IS NO HELP!! I don't want to use a module in the db because the user is going to be given a choice of any tables from any db. Are t

configure error on Cobalt OS

i am unable to execute the configure command as part of the mysql installation. if i execute this statement using 'configure" found in /usr/doc/libtool-1.3.5/demo/: [root /mysql-3.21.33c-pc-linux-gnu-i686]# /usr/doc/libtool-1.3.5/demo/configure --prefix=/usr/local/mysql here is the message from

errcode 13

hi there, i've got a problem which someone might be able to help me with. i'm importing text files into a database in mysql using mysqlimport : /users/mysql/bin/mysqlimport -u * databasename *.txt however i'm getting the following error all the time: Can't get stat of '/datenbank/ense

Mysql SQL behaviour with a plus sign

It looks like mySQL is funny about a + next to a - in a string. If I do select count(*) from Table where Column like '%+---%' I get 0 records. If I do select count(*) from Table where Column like '%---%' I get 70652 records. How can I make it insensitive to a +- Thanks in advance. Piyush.

Borland C++Builder compile error

I am attempting to add SQL client-server functionality to a Window's (2000) app I am developing in Borland's C++Builder v5. After installing the mysql C API, including the mysql.h header and setting my include and library paths appropriately, I was unable to compile the API code. The compiling err

Re: Socket Problem

Sebastian Koschinski wrote: > Hi, > > Can't connect my MySQL 3.23 via PHP, on console it works fine, but via > PHP it says "Can't connect via socket /var/lib/mysql/mysql.sock"...file > exists, its suid and 777. So where is the problem > > Thanx And the permissions on /var/lib/mysql? > > --

problems getting asp to talk to mysql

my isp olm.net are not helping. what needs to be installed on a unix server to enable an asp page to talk to mysql please.

MySQL working on a cluster

I have a question: On a cluster, is it possible to have several MySQL instances (one per node) each having several mysqld processes, working concurrently on NAS (network storage) device, that is mounted on every node, and accessed through a shared filesystem ?? How does mysql controlles the acce

Too many connections!

Ciao guys, I am using MySQL 3.23 on a Linux with Apache/PHP. Last week I first run it, and had a 'too many connections' warning. So, I just set the max_connections variable to 200. And since then, no problem. Here is the /etc/my.cnf file under the [mysqld] group: set-variable=key_buffer=1

Re: mysql daemon aborting abnormally (rh linux 6.2)

At 02:44 PM 6/7/2001 +0800, Rolf Hopkins wrote: >Sure it hasn't already started? Do ps -ef | grep mysqld to find out. > >- Original Message - >From: "Duane Douglas" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Thursday, June 07, 2001 12:57 >Subject: mysql daemon aborting abnormally

encrypt wierdness

Looking at the encrypt function, it optionally takes a salt parameter. Using encrypt without specifying a salt yields random results: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1732533 to server version: 3.23.37-log Type 'help;' or '\h' for help. Type

Re: MySQL with perl

I overcame this by adding to my php script, something that goves the user the results, summerised, of what they added to the database, thus when hitting refresh, it just refreshes the results of what the php script returned, not what they submitted. My php script is below. Pete ");

Help required for OLEDB on win32 for MySQL(linux)

Hi, I am facing problem while connecting to MYSQL server (linux) from Win32 VB client through OLEDB provider from MYSQL. I am successfully connecting to server through MyODBC using DSN but unable to connect to through OLEDB provider ( downloaded from www.MYSQL.com) Following is the script in

RE: Need help on mysql/php

At 2:13 PM +0530 6/7/01, Adrian D'Costa wrote: >On Wed, 6 Jun 2001, Ian Ford wrote: > >> Name your config file config.inc and if any of the below situations >> happen your password and username will not show up in plain text for the >> casual browser. >> (EXAMPLE: >> >> CONFIG.INC >>

installation problem

i've tried to install mysql version 3.23.3 for linux, but I get always the error message if I try to connect to bd: for example /mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' michela ---

Mysql AB question

Just reading that MySQL AB has a new CEO http://www.mysql.com/news/article-67.html. I was wondering if anyone has any info. regarding the future direction of Mysql with respect to the open source community. The news release mentions stuff like value-add services and the pursuit of sound business

Re: Making SQL request from a Mac

> I'd like to get informations from my MySQL Server on LiNUX, and the query > must be made from a Mac (Not an Os X)! Is there a good solution ? > If it's not possible, How can I get access to a PC With windows ? If you run windows, have a look at MySQL-front 1.18: http://www.mysqlfront.de on a m

RE: Access Database into mysql

If you are familiar with perl, try using DBD::ODBC module to pull the data out of Access and use the DBD mysql modules to write the data to mysql. You will have to set up the table structure in mysql to match your Access. -Original Message- From: Ute Hoffmann [mailto:[EMAIL PROTECTED]]

RE: Access Database into mysql

Hi there I am succesfully using DB Tools, you can find it on the MYSQL web site. It works perfectly, you just need to change your date columns, as when it imports, it imports as a DateTime (because that is how access works), and I wanted Date only columns. Otherwise works like a dream Cheerio

Please can you help me find the right file to download

I am after a version of MySQL with a graphical interface. I don't know which files to download or what to do with them once downloaded. I am keen to try out mysql but I am having difficulty understanding what to do with the downloas I have. Is there any chance you can email me the links to th

crash

Compiling MySQL with --with-bdb the mysql daemon crashes at runtime, the crash occures in /lib/libdb.so, I thought it was a linking problem, so i tried to rename the berkeleydb library (libbdb instead of libdb), but the problem is not that. I removed the source installation and installed the binar

mysql DBI install problem

I have a slackware box with Apache Perl 5.6, DBI and mod_perl. I can't get the MYSQL DBI module to install. It's dieing on this line. I'm very perplexed. Ruben umask -a Linux vidor 2.2.13 #127 Thu Oct 21 13:13:20 CDT 1999 i686 unknown make[1]: Entering directory `/root/.cpan/build/Msql-Mys

Socket Problem

Hi, Can't connect my MySQL 3.23 via PHP, on console it works fine, but via PHP it says "Can't connect via socket /var/lib/mysql/mysql.sock"...file exists, its suid and 777. So where is the problem Thanx - Before posting, please

Re: Rookie admin needs install help

At 02:10 PM 6/7/2001 +0800, Rolf Hopkins wrote: >Unix rookie as well? >0 | 0 >\__/ > >Off the top of my head, "rpm -i file_name" should do it. I usually use >redhat's gui. "man rpm" will give you more details. evidently, there's something wrong with the rpm package for linux. the binary at mys

Re: Importing spreadsheet data into MySQL

What you do after you have it in a Acces Database is make a table that looks like the Acces Database in MySQL. And then create a ODBC connection to that Table. Then you run a Query that inserts all the data into the mySQL database from the Acces database like follow : insert into dbo.mySQLEXELD

can i keep a connection to the database open

i want to write a web-based chat application in Perl which runs on Unix server with mySQL as backend. The application needs to continouly interact with database hence instead of opening a DBI connection in each perl page, I wish to keep a live open connection with database. Is it possible ? If yes

MYSQL error

I use mysql with IMP, a webmail application very nice and fast. Till I used the old version of Mysql 3.22.xx i had no problem. Now i upgrade to the new one and often i have problem with mysql cause it doesn't read the packet from the applicatione and it prints a page error on the web. Someone can

Re: Speed

Thierry Coopman writes: > Hi, > > I was wondering where the limits of MySQL are. > > I need >2000 updates per second on a table with +-20 rows. > > I was wondering what the ideal hardware to accustom that would be. > For the moment a SunFire 280R with 1 CPU and the table in memory > (heap

Re: SQL Parser

Manish Chakrabarti writes: > I have a related question. I am looking for a pretty robust SQL parser which > is also > "transparent" in the sense that one can go into it and modify the query > processing parts (i.e. "actions")? > > Does MySQL source distribution include the lex/yacc files specifyi

RE: Compiling an PHP 4.0 module with MySQL

Harry, Thank you it worked, although I don't know why, in fact using "127.0.0.1" without the port also worked. Previously I had been using "localhost" to define the host in my connect functions. I had another reply but this was sent to me directly. This said: "> ./configure --with-mysql=/us

New To mySQL

Hi all, I am a new user of mysql DB. I am working with WN NT 4. I already downloaded the mysql binary package for window. I installed it. But, now I don't know where to begin. How to start the DB. Please, I would like to have some ways to begin. Thanks, Geoffrey...

Access Database into mysql

Hi, I have a database table, which was made with Microsoft Access and am to move the data into a mysql database table. As there are some long entries, which exceed the data size allowed in a table cell by Microsoft Excel I can't export it via Excel and convert it from Excel into a Text Tabs do

Re: Making SQL request from a Mac

>I'd like to get informations from my MySQL Server on LiNUX, and the query >must be made from a Mac (Not an Os X)! Is there a good solution ? Check out MacSQL Monitor ... http://www.runtimelabs.com/ The other options would be a browser-based query tool and I think there may also be some pure jav

Re: Compiling in 64-bit Solaris environment

McCaffity, Ray writes: > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: [Compiling in 64-bit Solaris environment] > > >Description: > checking return type of sprintf... configure: error: can not run > test program while cross compiling > >How-To-Repeat: >Compile any ve

Re: FW: MySQL 3.23.38 on HP UX 10.20

"Tomasz Szymczyk" <[EMAIL PROTECTED]> (by way of Paul DuBois) writes: > mysql, sql, database > > > I'm trying to post you directly, because of stupid filter on > mysql-list which avoid belowed e-mail from posting to list > > could you help us or redirect it to correct p

Re: tunneling

You can try stunnel. The guys at www.stunnel.org (non official site) have a nice howto about connecting two mysql over a SSL tunnel. I'm using it and works perfect. Best regards Dario Scott Alexander wrote: > Hi, > > I have Windows 98 with ssh v2.4. Also on the server is ssh2 2.4 > redhat7.1 >

Re: Stored procedures (really sorry for bringing this up)

John N S Gill writes: > > The company I work for has been considering moving a key database from > MS Access to a proper database. > > We use linux for a lot of the number crunching we do and I was keen for > us to choose MySQL. I happen to think it would be ideal for our > applications. > > U

Re: Problem with adding some functions into MySQL

=?iso-8859-2?Q?Ji=F8=ED=20=A9krabal?= writes: > Hi all, > I'm currently working on project, where I need implement some functions to formate > SQL queries. > It's necessary to add these functions into MySQL. > I read about UDF (user def. functions) and I mean, that it is almost what I want. > Fo

Re: MySQL too slow....

Hello! A lot of people use PHP4 or PERL or C++ and connect *directly using the script. PHP4 has MySql functions built right in for convenience. In PHP for example, just do this: MYSQL_CONNECT("localhost","yourID","yourPassword"); mysql_select_db("yourDB"); $maxi=mysql_query("select fieldname1,

Re: MySQL too slow....

I use PHP, a very special scripting language for the web and has an excellent list of commands to interface with MySQL. I recommend the book professional PHP and also the site php.net thanks, Hasan Impex - Original Message - From: "Muhammad Asif" <[EMAIL PROTECTED]> To: <[EMAIL PROTE

  1   2   >