Hi,
I've downloaded mysql 3.23.46 version and currenlty runnig
solaris 2.8 relase 10/00 on intel platform.
I'm getting the following error during the ./configure stage in
creating
my makefile.
checking size of char... 0
configure: error: No size for char type.
A likely cause for this co
How about
UPDATE
myTable
SET
DueField = 0,
StatusField = if(StatusField='O', 'C', StatusField)
WHERE
PrimaryKeyField = 'XYZXYZ'
See
http://www.mysql.com/doc/C/o/Control_flow_functions.html
for more info on IF() function.
-steve
At 12:41 P
On Saturday 08 December 2001 09:01 pm, Colin Faber wrote:
> Is anyone else interested in documenting libmysqlclient? Just a basic
> set of function guidelines would be nice.
The public API is documented in our manual...
--
MySQL Development Team
For technical support contracts, visit https://or
At 3:19 PM -0800 12/8/01, Rob@TH wrote:
>Hmm still nothing :/
>Any other possibilities?
The suggestion offered below is a workaround that seems logical given
the lack of ORDER BY RAND() prior to MySQL 3.23. Unfortunately, it
doesn't work due to the behavior of the optimizer in pre-3.23 versions.
Thank you for that , I just needed somewhere to start from and am new to
doing something like this.
-Original Message-
From: Neil Zanella <[EMAIL PROTECTED]>
To: "Barry.J.Rumsey" <[EMAIL PROTECTED]>
Date: Sun, 9 Dec 2001 00:29:40 -0330 (NST)
Subject: Re: Join
>
> Before you proceed I w
Is anyone else interested in documenting libmysqlclient? Just a basic
set of function guidelines would be nice.
--
Colin Faber
(303) 859-1491
fpsn.net, Inc.
-
Before posting, please check:
http://www.mysql.com/manual.php
Before you proceed I would advise you to revise your relational model.
For instance why do you have both id and artistid in both tables?
Can more than one artist sing or participate in the production
of the same song? If yes then your database should probably look like:
Artists(artist_id, artist
I have a database with two tables:
table1 id, artistid, artist
table2 id, artistid, songtitle
What I would like to know is how do I join these two. artistid in both
of them have the same value. What I'm after in the end is to be able to
search by artist and return a list of songtitles from that
Still not compiling. New issue now...
# rpm -q gcc
gcc-3.1-0.10
./configure --cache-file=config.cache --with-mysqld-user=mysql
--localstatedir=/usr/local/mysql/var --prefix=/usr/local/mysql
--with-unix-socket-path=/usr/local/mysql/lock/mysql.sock
--without-berkeley-db --without-bench --enable-sh
On Sunday 09 December 2001 07:19, [EMAIL PROTECTED] wrote:
> Hmm still nothing :/
> Any other possibilities?
>
> Rob
> - Original Message -
> From: "Kodrik" <[EMAIL PROTECTED]>
> To: "Rob@TH" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Saturday, December 08, 2001 8:45 AM
> Subject: Re
Hi Tony,
- Original Message -
From: "Tony Buckley" <[EMAIL PROTECTED]>
> Coming from an Oracle background, I started off hating mySQL. So far, I
> have only 'played' with it, but now have enough confidence to start using it
> for real. It is super fast and my test loads (as much as I
At 7:39 PM +0100 12/8/01, Fred Taurus wrote:
>Hello
>
>Is it possible to put the result of a Mysql request in a file
>
>and how to do this ?
>
>I try
>
>mysql >SELECT name from table where name like 'B%'; > file.txt
>
>but error !
>
>Thanks for your help
>
>Frederic
mysql> \T query.out
Logging to
At 6:55 PM -0500 12/8/01, Mike Gleason Jr Couturier wrote:
>Hello list !
>
>Is there a command to know the current database name
>the user is using ...
>
See
http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
>Or in mySQL++, is there a way to know the current database
>the u
Rob:
I assume you are using something like PHP as a front-end. I think you would
be best to SELECT the desired field, append the new data then UPDATE the
database row using SET xx WHERE xx etc.
Gerald Jensen
- Original Message -
From: "Rob@TH" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Hi all,
Is it possible to add more data to a field in mysql without deleting other
data in that same
field?
Lets say I have field called info. I have entered data into it by a form.
Now when I return to the form I want to add more info to it without deleting
all the existing data.
Hmmm
Rob
-
Hello list !
Is there a command to know the current database name
the user is using ...
Or in mySQL++, is there a way to know the current database
the user is using ?
Thanks !
-
Before posting, please check:
http://www.m
Well, I can't currently link you to the systems I'm mentioning, but we have
performed several restore's from dumps in the last several weeks on my
current project (due to some really messed up hardware). Considering the
fact that the db's are a little over 20gb, I consider them pretty large, a
Thanks Richard and you others for good input concerning "Annoying article",
I myself have nothing but good experience from using the MySql database but
reading articles like this one and another one on the same web talking about
"when you outgrow MySql, then you must change to the more advanced d
This is my first question to the list.
Anybody know of a condensed index/glossary
of SQL keywords that MySQL ver. 3.22.19 uses?
Neo-Genus Multimedia Studios
Boyd White
Database Engineer
[EMAIL PROTECTED]
(903)731-9644
-
Before
Dear Mike,
I recommend that you
1. stop waiting for response from the user group
2. 'find' every occurance of *MySQL* in you machine
3. Delete it.
4. download the latest version
5. attempt to rpm -inh the new version
6. upon failure, go back to using MS Access and windoz
Mike
--- Mike Willia
Rob@TH wrote:
> Hmm still nothing :/
> Any other possibilities?
[ Selecting a random entry from a database ]
Generally this is a hard problem. Ordering by rand() is really wasteful
because the DB has to select *all* entries, order them, and then pick one.
There are more efficient solutions a
Hi:
Just a short Q:
- if I install MySQL through rpm is it possible with any sort of
postintallation to change the code page e.g. from Latin-1 to Latin-2.
Thanx and bye.
Bojan
--
~~~
Bojan IVANCIC
Ljubljana, SLOVENIA
[EMAIL PROTECTED]
~~
Arjen,
"Arjen G. Lentz" wrote:
> Hi,
>
Thanks for the great reply!
>
> - Original Message -
> From: "Richard S. Huntrods" <[EMAIL PROTECTED]>
>
> > Basically, the "mysqldump" output is missing the "use xxx" command to
> > change to the target database. I have a perl script that does t
Hmm still nothing :/
Any other possibilities?
Rob
- Original Message -
From: "Kodrik" <[EMAIL PROTECTED]>
To: "Rob@TH" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, December 08, 2001 8:45 AM
Subject: Re: Random
> Try
>
> ("select field 1, field2, field3, rand() as rnd
> wher
Hi,
I have to port an SQL expression like
DELETE FROM TableA FROM TableB WHERE TableA.ID = TableB.IDA AND
TableB.IDB=42
from another SQL dialect to MySQL. The twice "FROM" is no mistake, it's done
to declare "TableB"
for the WHERE expression.
In (some) other SQL dialects this is possible/lega
Hi!
We just found out that recent MySQL AB binaries on Windows have
UNIV_SYNC_DEBUG defined in univ.i. That makes InnoDB a lot, maybe 10 times,
slower than the normal version.
Miguel is right now compiling new binaries where the flag is set right. Thus
if you have seen high CPU usage on Windows,
>
> I used Oracle8i before (under very heavy load) and did not have any
problems
> there. I am now using MySql under not so heavy load and have not yet had
any
> problems with it, but just want to be prepared when and if they come
along.
>
Oracle 8i rel 3 enterprise edition - 28,000 pounds sterl
Check out the 'INTO OUTFILE' portion of the 'SELECT' command:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SELECT
-rh
>Hello
>
>Is it possible to put the result of a Mysql request in a file
>
>and how to do this ?
>
>I try
>
>mysql >SELECT name from table where name
Hello
Is it possible to put the result of a Mysql request in a file
and how to do this ?
I try
mysql >SELECT name from table where name like 'B%'; > file.txt
but error !
Thanks for your help
Frederic
-
Before posting, pl
Hi,
- Original Message -
From: "Richard S. Huntrods" <[EMAIL PROTECTED]>
> Basically, the "mysqldump" output is missing the "use xxx" command to
> change to the target database. I have a perl script that does that (and
> extracts the table defs to another file for documentation).
Have
Hi Erik,
- Original Message -
From: "Erik Price" <[EMAIL PROTECTED]>
> I see. If I mentally apply this advice to the rest of my database, it
> seems that I should index (or apply a prefix index) to any column that
> holds search criteria -- such as files.file_name or
> subprojectweb.su
Can anyone tell me where I could find a good tutorials on join & multi
select queries from a database
Thank You
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Try
("select field 1, field2, field3, rand() as rnd
where blah blah blah
order by rnd limit 1")
On Saturday 08 December 2001 10:35 am, [EMAIL PROTECTED] wrote:
> Hi,
>
> I am trying to pull up one random name in mysql 3.22.21 but not having much
> luck.
> Here is what I have done:
> $select=$
Ingvar,
I have not used mysql data dumps directly to restore my databases, but I
take the mysqldump output and massage them a bit, then use them for
restores.
Basically, the "mysqldump" output is missing the "use xxx" command to
change to the target database. I have a perl script that does that
You're using a _very_ old version of the MM.MySQL driver. This problem has
been fixed quite awhile ago. Please upgrade to the latest driver, which is
2.0.8 available from http://mmmysql.sourceforge.net/
-Mark
>
> Chris Stark wrote:
>
> >
>
> > Hi,
>
> >
>
> > I am having a problem with t
Hi,
I am trying to pull up one random name in mysql 3.22.21 but not having much
luck.
Here is what I have done:
$select=$dbh->prepare("select * from $thetable where url is not null order
by rand() limit 1");
I have tried everything, but nothing seems to work. Can anyone help.
Rob
-
Couldn't find answer to this question anywhere.
A newbie OSX and MySql question:
I installed MySql through Fink but now that I try to start up I type
"mysqld" at the
prompt, but all I get is this:
mysqld: Can't change dir to '/sw/var/mysql/' (Errcode: 13)
011208 16:11:38 Aborting
011208 16:1
I installed MySQL-3.23.26-1.i386.rpm and MySQL-client-3.23.26-1.i386.rpm on
RedHat 7.1, but for some reason mysqladmin does not show up. I have removed
it and reinstalled, but it is not there. Any ideas how to resolve this?
Raymond
--
Dear sir,
I used mysql-3.23.46 running on RedHat-7.2.
When I used command below.
./configure --prefix=/usr/local/mysql --with-charset=tis620
It has messages below.
checking size of char... 0
configure: error: No size for char type.
A likely cause for this could be that there isn't any
Yeh I forgot to originally state that I was using freebsd. You were correct,
freebsd is compiled by default to not allow processes bigger than roughly
500megs. I recompiled the kernel, changing the limit to 1.5 gigs and now it
runs fine using all my memory.
For anyone else who needs the howto for
Hi all,
Just browsing through the windows application Thumbs Plus! and I see it can
be linked via ODBC to external database servers. Seeing that all my other
databases are there already I can see and opportunity to share some
information.
Is there anyone here with experience of using MySQL as th
Mike Copeland writes:
> Greetings!
>
> I am new to MySQL. How do I link the help file (*.cnf) to MySQLGUI?
> I read the readme files, not sure where to put the *.cnf so it is in the
> path for MySQLGUI. Any help you can give me would be greatly appreciated.
>
> (I am learning development in PHP,
I was just reading an annoying article from a user who was moving from MySql
to Postgres because of stability problems and because of problems restoring
"large" MySql data-dumps. I checked his site and it does not have the
appearance of a very heavy loaded site so I am not sure what he means by
la
If you are running FreeBSD, there is an inner limit, which doesn't allow
malloc() calls greater then 500MB. You need to reconfigure the kernel
sources and recompile (or change your InnoDB parameters to use less then
500MB of RAM).
Chris Schreiber
-Original Message-
From: Heikki Tuuri [m
Rich,
>I have a system with 1gig of ram and i am trying to get the innodb buffer to
>be about 750megs. Whenever I set the value in the database config file it
>won't start with an error along the lines of,
>
>011207 21:02:42 mysqld started
>InnoDB: Fatal error: cannot allocate 67108864 bytes of
45 matches
Mail list logo