Perl DBI secret command?

Hi, just stumbled across the following piece of code: my $rowcount = $sth-rows(); And I checked it out compared to a count of the fetched rows from an SQL QUERY. AND It matched exactly! BUT, I can't find the command rows() in the DBI documentation. What's the story? Have I unearthed a

Re: Perl DBI secret command?

No conspiracy, read it again ! ;) http://www.perldoc.com/cpan/DBI.html#rows Joseph Bueno Jeff Snoxell wrote: Hi, just stumbled across the following piece of code: my $rowcount = $sth-rows(); And I checked it out compared to a count of the fetched rows from an SQL QUERY. AND It matched

Re: Connection ms access to mysql

Hi, I think is better to export your each table from Access to a .txt formatted file...fields separated by ',' and end_of_line by ';'.It's better to avoid Cr or CrLf. Copy the .txt files into MySQL server host in a directory where MySQL have reading rights. And after this you can import in your

Escape char in fulltext search

On Tue, Nov 26, 2002 at 02:30:41PM +0100, Sergei Golubchik wrote: On Nov 25, Grzegorz Paszka wrote: Hi. Could You explain me for what is macro misc_word_char ? A word must have true_word_char on both ends, and there should not be two adjacent misc_word_char's in the word. E.g.

MySQL error messages list

Dear all (especially MySQL gurus), I have another question regarding MySQL error messages. I know that error messages are stored in errmsg.txt for different languages. We all love error 1064 (You have an error in your SQL syntax). My question: Where can I find a list of _all_ (not just common,

RedHat 8, mysql-server-3.23.54a-4 and relocating the data directory

Hi All! I'm new to the list, but I've been using MySQL under Red Hat for a couple of years now. I'm in the process of setting up a new Red Hat 8 box and I want to change the data directory to a different location (/raidarray2/data/mysql). I've edited the /etc/my.cnf as: [mysqld]

Re: Perl DBI secret command?

At 9:39 + 1/18/03, Jeff Snoxell wrote: Hi, just stumbled across the following piece of code: my $rowcount = $sth-rows(); And I checked it out compared to a count of the fetched rows from an SQL QUERY. AND It matched exactly! BUT, I can't find the command rows() in the DBI documentation.

Connection problem with MySQL 3.23.52 on RH 8

Hello. I get this message when trying to connect via TCP/IP. Both locally and remotely ERROR 2013: Lost connection to MySQL server during query What does it mean. I can't find any relevant documentation. Installation i a standard RH8 with MySQL rpm's Sorry for the disturbing you with this

Connection problem with MySQL 3.23.52 on RH 8

Hello. I get this message when trying to connect via TCP/IP. Both locally and remotely ERROR 2013: Lost connection to MySQL server during query What does it mean. I can't find any relevant documentation. Installation i a standard RH8 with MySQL rpm's Sorry for the disturbing you with this

Re: Disable autocommit by default

Philip, Jani promised that in February 2003 you can set autocommit=0 globally in my.cnf. I am carbon copying this to Jani. The feature is widely requested. Regards, Heikki Subject: Disable autocommit by default From: Philip Molter Date: Thu, 16 Jan 2003 15:41:47 -0600

Re: Perl DBI secret command?

hi pls look into man DBI and find there this command. kr mr Jeff Snoxell [EMAIL PROTECTED] 01/18/03 10:45 AM Hi, just stumbled across the following piece of code: my $rowcount = $sth-rows(); And I checked it out compared to a count of the fetched rows from an SQL QUERY. AND It matched

MySQL PHP

hello all, I'm posting on 2 lists because I'm not sure were the problem is, so I'm hoping that some one can help me out. I'm running a stock RH8 machine running amongst other things MySQL 3.23.52-3, Apache 2.0, PHP 4.2.2-8.0.5 When I try a simple php script that is this (sensitive information

Re: MySQL PHP

Hello Ryan, Did u compile PHP with mysql support enabled?as in did your configure line have something like this ./configure --with-mysql=/path/to/mysql? Regards, Eric === Kamara Eric Rukidi Mpuuga Computer Frontiers International Plot 32 Lumumba Avenue P.O Box

Re: MySQL PHP

Hey everyone, Thank you all for your quick responses and the problem was that I did not have mysql support installed for php... installed the required rpm and did a httpd restart and it wrks now!! Thanx again, Ryan __ Do you Yahoo!? Yahoo! Mail

Re: Column names

But I know that the _ character is used as a wildcard for any single character. wouldn't it be considered it as a wild card when using it in a column name? Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [EMAIL PROTECTED] - Original Message - From: Keith C. Ivey [EMAIL PROTECTED] To:

Re: Column names

At 15:21 +0200 1/18/03, Octavian Rasnita wrote: But I know that the _ character is used as a wildcard for any single character. wouldn't it be considered it as a wild card when using it in a column name? Depends on the context. If you issue a SHOW COLUMNS FROM mytable LIKE 'my_col'

why? mysql dead but subsys is locked

I just installed mysql binary in my Linux system. I tried ./bin/safe_mysqld also tried /etc/init.d/mysqld start the system always give me starting MySQL [OK] information. Then the mysqld ended running. /etc/init.d/mysqld status gives me information like mysql dead but subsys locked

How to install MySQLCC on W98

Hi, The MySQLCC's setup.exe program is calling MSIEXEC windows installator. I have no such program on my W98. Is it a problem only of my windows 98 or it is possible to use MySQLCC only on w2000 and newer? Is there any way how to install MySQL Control Center without MSIEXEC? Thanks Michal

PRIMARY KEY

According to the MySQL documentation (Section 6.5.3, CREATE TABLE syntax): If you don't have a PRIMARY KEY and some applications ask for the PRIMARY KEY in your tables, MySQL will return the first UNIQUE key, which doesn't have any NULL columns, as the PRIMARY KEY. How does any application ask

Re: MySQL PHP

Ryan, Eric, Did u compile PHP with mysql support enabled?as in did your configure line have something like this ./configure --with-mysql=/path/to/mysql? You can test this by writing a file (named whatever you want, I call it phpinfo.php) with one single line like this: ?=phpinfo()? Check in

Re: PRIMARY KEY

Rob, If you don't have a PRIMARY KEY and some applications ask for the PRIMARY KEY in your tables, MySQL will return the first UNIQUE key, How does any application ask for the PRIMARY KEY? Is this an ODBC call, or are their command line and built-in functions? I couldn't find this in the

Re: How to install MySQLCC on W98

Since you are on Windows I will suggest take a look at SQLyog at http://www.webyog.com/sqlyog I prefer it over MySQLCC Karam --- Michal Seidl [EMAIL PROTECTED] wrote: Hi, The MySQLCC's setup.exe program is calling MSIEXEC windows installator. I have no such program on my W98. Is it a

Re: PRIMARY KEY

Rob, I'm not questioning what MySQL does, only how. MySQL does not act without a request, so my question is (now), How do you ask MySQL what the PRIMARY KEY of a table is? SHOW KEYS FROM tbl In an application, next thing you would do is check what the value of 'Key_name' is (which is the

Re: FreeBSD: MySQL crash when importing 148 MB dumpfile

Hi Maximo, The problem is that you have a config that requires more memory than you have available. Please reduce key buffer, record buffer and sort buffer. The clues are: 030117 17:02:55 Out of memory; Check if mysqld or some other process uses key_buffer_size + (record_buffer +

SQL Count Query

I've got a table whose structure looks like this: CREATE TABLE IF NOT EXISTS calc_hits (id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, hit_date DATETIME NOT NULL, PRIMARY KEY (id)) AUTO_INCREMENT = 1; On a web site, a row gets inserted into this table whenever a visitor uses a certain tool

Bugreport

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: rjaising To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] Description:

Re:SQL Count Query

a row gets inserted into this table whenever a visitor uses a certain tool on the site based on this approach your table does not have any entries for the days that no one uses the certain tool on the site. As a result your query can not pull out records which don't exist. You could catter

mysql 4.0.8 on solaris 8 problem

i have installed mysql4(binary version) on solaris but i get this error when i try to run it: ld.so.1:bin/mysqld : fatal : libCstd.so.1 : open failed : No such file or Directory what could be wrong? - Before posting, please