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 ch
>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 fo
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:
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 o
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 + sort_buff
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 t
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 p
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
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
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
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 "
u
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'
statement
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]>
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:
Check in your browse
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 Pl
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 12510,K
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 cha
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
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
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 simp
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 simp
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
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]
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,
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.
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 My
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
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 cons
28 matches
Mail list logo
