does anyone know how i might be able to create a random number between 0 and
100 using java? using the number in my database.
thanks,
Kit
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
-
On Thu, Aug 23, 2001 at 06:55:42AM -0700, xiyuan qian wrote:
>
> Hi, I am running mysql-3.22.27 for many months. But today, the
> mysqld always core dump. The running platform is FreeBSD3.4.
>
> I checked the dumped core and find that it seems that the core dump
> has something with the /usr/lib/
Martijn Rotteveel schrieb am Freitag, 24. August 2001, 00:21:53:
> i need a SIMPLE method for performing some pre defined actions on my tables,
> these actions involve retrieving strings, recombining them and inserting
> into another table.
I don't know exactly what you mean, but if I do, I w
On Thu, Aug 23, 2001 at 01:50:36PM -0700, Angel Behar wrote:
> Hi !!
>
> I'm trying to compile mysql-3.23.41 on a FreebSD 3.3 box but I can't
>
> I'm using latest gnu make version and this is the first time that I
> have problems compiling mysql so if any of you can help me I'll
> appreciate.
>
On Thu, Aug 23, 2001 at 07:54:38PM +0200, Osus wrote:
[snip]
> when I run this query
> mysql> explain select Nick from mytable where Inicial='P' AND Sexo=1 and
> ok=1;
> .
> +--+--+---+-+---
> --+---+--++
> | table
Sorry, one more thing occurred to me. Should I install these in any
particularorder?
George
- Original Message -
From: George Pitcher <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 24, 2001 7:37 AM
Subject: installing mysql - what should go where [linuxppc]
> Hi all,
Hi all,
Having ditched yesterday's attempts to get MySQL up and running with PHP I'm
trying again from scratch.
I'm currently downloading the 3.23.27-1 rpm's from ausmac.net. Theye are:
'db engine', client, devel, shared, bench (should I also download and
install the xmbase-grok as well.
In or
On Thu, Aug 23, 2001 at 07:21:10PM +0200, Gregorio Ramón Alberdi Díaz wrote:
>
> A query with a ORDER BY clause over a numeric field, will be fast if
> this field have a index or this doesn't influence the anwer time of
> the query.
MySQL is going to prefer an index on the column(s) used in the
i configured mysql with
./configure --prefix=/usr/local --localstatedir=/usr/local/var
--with-mysqld-ldflags=-all-static --disable-shared
--with-unix-socket-path=/usr/local/var/mysql.sock --with-pthread
--enable-thread-safe-client --with-mysqld-user=mysql --without-debug
--with-extra-charset
On Thu, Aug 23, 2001 at 04:09:24AM -0500, Andres Berger wrote:
>
> Oracle gives to system managers a "feel of security" because if
> something goes wrong, they can blame Oracle as their last resort,
> but if they choose MySQL and the system fails for any reason, the
> CEO will doubt about his exp
On Thu, Aug 23, 2001 at 05:07:35PM -0500, Gary Jollymore wrote:
>
> how would i get a file such as /files/photo.jpg into a mysql table
> such as
>
> create table photo ( code decimal(6,0), photo blob);
>
> i tried insert into photo values('4142','/files/photo.jpg'); which
> of course just put th
On Thu, Aug 23, 2001 at 01:15:25PM -0400, Robinson, Mike wrote:
>
> I just set up a master/slave replication scheme and all is well, but
> through the procedure did get bit on the tail.
>
> After the setup, and after the master and slave mysql servers had
> been started, I got some error messages
Hi !!!
)-Original Message-
)From: aDragon [mailto:[EMAIL PROTECTED]]
)Sent: Thursday, August 23, 2001 10:22 PM
)To: [EMAIL PROTECTED]
)Subject: question about use JDBC to connect with MySQL in JSP,please help
)
)
)hello,everyone,
)I am using JDBC in JSP to connect with MySQL under BEA
hello,everyone,
I am using JDBC in JSP to connect with MySQL under BEA WEBLOgic Server 6.0,
I have copied the following codes from a book, but the server always says that
It was wrong, expecial the variable "con", I don't know why even thinking hard!
please help,thanks.
the code following:
On Thu, Aug 23, 2001 at 03:19:17PM -0700, Bryan Coon wrote:
> Hi,
>
> We have a somewhat tricky problem that I need some help with. What
> we have is one machine (the master) that we use for database
> development, and two dedicated nodes (slaves) on a beowulf cluster
> that house the non-dev da
Elizabeth,
sorry. misleading information. ssl support is still on the to-do list for mysql
version 4.0, so not available yet as production.. It is documented anyhow and i bumped
into it. try stunnel for the time being... sorry it's late.
regards,
rene
On Thu, 23 Aug 2001 08:44:36 +0100
"Eli
Elizabeth,
sorry, 1 mistake: binary seems not to support mysql by default. so at least i'm not
sure, maybe somebody else can clear this out.
However using mysql's built-in ssl support seems like the best and easiest solution to
me, prefered above tunneling.
regards,
rene
On Thu, 23 Aug 20
On Thu, Aug 23, 2001 at 06:30:37PM -0700, Armando Cerna wrote:
> HI installed the mysql-server port in freebsd and the
> /usr/local/etc/rc.d/mysql-server.sh file just disapeared its done this before
> and I fixed it by reinstalling I think but I would like to avoid this. Does
> anyone know an
On Fri, Aug 24, 2001 at 09:05:35AM +0800, Osman Omar wrote:
> Hi,
Hi yourself. Sorry for my last reply. I regret the insult.
> Example, I have data inside my table
>
> id model data_in
> 1 str-de453 20010910
>
> Now I have new update data inside text file
>
> eg model date_i
Elizabeth,
Last conversation i recommended tools like ssh (you could also succesfully use stunnel
(http://www.stunnel.org), i tried and it works well).. but.. there is an easier way.
Guess that it depends on the mysql version your ISP is running, elsewise ask them to
upgrade.. Also make sure yo
At 5:18 PM -0700 8/23/01, Igbar Foosenhopper wrote:
>Is it possible to use current_date (mysql function) to generate a
>default for a column?
No. Defaults must be constants.
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
>
>If so .. what would the syntax look like. I have tried several thing
HI installed the mysql-server port in freebsd and the
/usr/local/etc/rc.d/mysql-server.sh file just disapeared its done this before
and I fixed it by reinstalling I think but I would like to avoid this. Does
anyone know anything about this?
Armando
-
Hello all,
I'm planning to create an web-based glossary (actually Spanish<>English
glossary of retail banking terminology, so my buddies and I can
collaboratively prepare to interpret at a conference in a few months).
I'll be using either Perl/DBI or PHP, the only languages I speak.
Is there an
Hi,
Example, I have data inside my table
id model data_in
1 str-de453 20010910
Now I have new update data inside text file
eg model date_in
str-de453 20010911
How can I use LOAD DATA INFILE REPLACE to update new data into my table
***I read manual but cannot file any ex
At 19:51 23/08/2001 -0400, [EMAIL PROTECTED] wrote:
>Thanks for the info.
>
>You refer to file mysql.dsw for the 3.23.41 distribution.
Yes. Just now I am working in the 4.0 tree. When I finished it
I will send an e-mail for our lists, how to do.
Regards,
Miguel
>I was specifically interested i
On Thu, Aug 23, 2001 at 04:15:47PM -0700, Edgart Gonzalez wrote:
> Hi guys,
> Could you please tell us if can I make a distributed query inside ob mysql>
> Something like :
>
> SELECT A.c1, b.c2 from serverA.TableA A, serverB.TableB B
Wow, that would slow a db down. Not only are you waiting for
Is it possible to use current_date (mysql function) to generate a
default for a column?
If so .. what would the syntax look like. I have tried several things
and it doesn't seem to like it.
If not .. how could I generate a default of todays date (of course
dependent on the date of insert)?
Tha
I am currenly using Valueweb.net
and they do not support ODBC connection.
So i have to use MySql to connect my .MDB to the web.
but i need a guide how to do it.. i am using MS access 97 right now
I will pay for the support if you can get this to work for me
please contact me ASAP
thanks,
Paul
---
Hi guys,
Could you please tell us if can I make a distributed query inside ob mysql>
Something like :
SELECT A.c1, b.c2 from serverA.TableA A, serverB.TableB B
Or if this functionality is schedule for a future (which) release.
Thank you much in advance.
Edgart
At 1:09 PM -0700 8/23/01, Truoc Duong wrote:
>Hi,
>
>I am using mod_perl and MySQL 3.23.38 on Red Hat Linux
>6.2 and my following codes occasionally got an error.
>
>$SQL = 'SELECT col1,col2 FROM table1'.
> ' WHERE keya=1 AND keyb=2';
>$STH = $DBH->prepare($SQL) || die $SQL;
>
At 4:06 PM -0600 8/23/01, Tom Burkhardt wrote:
>Greetings List,
>
>Using mysql, after doing a query using the "select *" statement, how do
>is place this into a hash? Or a
>text file for that matter? There must be a rather simple answer around.
There may be, but your message doesn't contain eno
From: chad
To: [EMAIL PROTECTED]
Subject: Error using Msql-Mysql-modules-1.2216 with MySQL
>Description:
I am trying to install Msql-Mysql-modules-1.2216 for Perl.
The 'make' runs just fine, but when I run the test suite
'make test', it gives the following error (extremely
Hi all,
i need a SIMPLE method for performing some pre defined actions on my tables,
these actions involve retrieving strings, recombining them and inserting
into another table.
i thought about MySql++, but is there a simpler way to accomplish this kind
of tasks ?
regards,
Martijn.
Netherland
Sorry... correction again... I don't use this particular command so I
actually had to test it. :)
It's "safe-show-database" .. notice the - instead of _ .
[EMAIL PROTECTED] wrote:
It's "safe_show_database", not "safe_show_databases"
"Ulv Michel" <[EMAIL PROTECTED]> wrote:
>
>
> Or you
Well, looks like I found the culprit.
Increasing thread_cache_size from 0 to 50 totally alleviated the stress
(both on the database and our clients). Recommended by the manual,
of course.
For list-archival's sake:
FreeBSD 4.3-STABLE
/etc/my.cnf:
[mysqld]
user=mysql
set-variable = wait_timeou
Hi,
We have a somewhat tricky problem that I need some help with. What we have
is one machine (the master) that we use for database development, and two
dedicated nodes (slaves) on a beowulf cluster that house the non-dev
databases.
What we need is to mirror the master to the slaves, but not ne
how would i get a file such as /files/photo.jpg into a mysql table such as
create table photo ( code decimal(6,0), photo blob);
i tried insert into photo values('4142','/files/photo.jpg'); which of course
just put the file name into the 'photo' column.
gary
[EMAIL PROTECTED]
Greetings List,
Using mysql, after doing a query using the "select *" statement, how do
is place this into a hash? Or a
text file for that matter? There must be a rather simple answer around.
Your input is most apprecitated.
Tom
--
Bin Cai schrieb am Donnerstag, 23. August 2001, 23:24:01:
> could you tell me how to store image in mysql database and display on web
> using java. urgently
Do it like any other insert, but care for special characters. In
php, you would wrap data with addSlashes() and remove them on
retrieval
Hi,
could you tell me how to store image in mysql database and display on web
using java. urgently
Thank you very much
bin cai
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mys
We upgraded our convergent e-business enterprise database server from mysql
3.22 to 3.23 yesterday. The upgrade process itself was smooth and
sexy.
Unfortunately, the dbms is overall slower for us. What's worse,
some maintenance scripts are losing their connections in the
middle of their runs.
I execute this SQL with mysql 3.23.39 (all platform, Windows98, Windows2000 and Redhat
Linux 7.1), but it's very very slowly.
alter table mytable order by my_column;
mytable has 3,000,000 rows, my_column is define as char(15).
But when mytable has 1,000,000 rows, it's very fast, abou
Hello List!
I am having an extremely unusual problem with MySQL3.22.27 running on a
Sun UltraII Solaris 7 (latest patches applied). This implementation of
MySQL 3.22.27 has been rock solid for better than 2 years now.
We have a primary/failover system here, and the primary 'sync
Hello thanks before all,
i've have a mysql 3.22.15 gamma , and 3.22.16 gamma in two Solaris on
Sparc ( SunOS 5.7, 5.8 ). This mysql are in a site in "production", and
i'd like to join the data bases in another data base in another machine
( solaris on Sparc ).
I've installed in this third mach
At 08:02 23/08/2001 -0400, [EMAIL PROTECTED] wrote:
Hi!
>Are instructions available for building the MySQL source tree on a Win32
>platform for a Win32 target?
Not yet. However here the basic steps.
Minimal Requirements:
- VC++ 6.0 compiler
- MySQL source distribution:
http://www.mysql.c
Hi,
I am using mod_perl and MySQL 3.23.38 on Red Hat Linux
6.2 and my following codes occasionally got an error.
$SQL = 'SELECT col1,col2 FROM table1'.
' WHERE keya=1 AND keyb=2';
$STH = $DBH->prepare($SQL) || die $SQL;
if ($STH->execute() >= 1) {
$rec = $STH->fetchrow_
Jeremy Falcon schrieb am Donnerstag, 23. August 2001, 21:46:02:
> Contact your ISP and ask them if they already have and/or willing to set-up
> something for you.
Yes, there are always many ways to do things - but before I give
another, I'd really like to hear about the kind of task at hand
Contact your ISP and ask them if they already have and/or are willing to
set-up something for you. Here's an instance. One host I have used before
is TierraNet. They use cron to run a CGI script, named crontask.cgi, at
3AM. You can put anything you want to in that script (Perl, C/C++, etc.) to
>also try enabling the slow-log and track down any long queries.
just did that, so we'll go through that now, there are some in there...
>Have you tuned any of the cache parameters for the large amount of
>memory you have?
yes, we have done extensive tuning. Is there something I can provide
Hi !!
I'm trying to compile mysql-3.23.41 on a FreebSD 3.3 box but I can't
I'm using latest gnu make version and this is the first time that I have
problems compiling mysql so if any of you can help me I'll appreciate.
Thanks in advance.
Angel.
Making all in client
gmake[2]: Entering direct
It's "safe_show_database", not "safe_show_databases"
"Ulv Michel" <[EMAIL PROTECTED]> wrote:
>
>
> Or you can add
>
> safe_show_database
>
> to your my.cnf, or call safe_mysqld with the added option "
> --safe_show_database"
do you have to compile mysql with some special parameter? My version
Elizabeth Alderton schrieb am Donnerstag, 23. August 2001, 09:44:36:
> Thanks for suggesting cron - can you tell me what it is?
cron is a program on Linux to run scheduled programs. So you
write a program and tell cron to execute it in any kind of
interval you can think of. I don't know if you
Look at your /etc/my.cnf where the location of mysql socket is specified.
Also, I think RH 7.0 has a MySQL rpm installation already there. All you do
is to enable it with /usr/sbin/setup.
Hope this helps.
Shu
At 01:28 PM 6/1/2006 +0530, sachin wrote:
>Hello,
>I am working on RH Linux 7.0
>MySq
Hello Trond,
Thursday, August 23, 2001, 8:01:33 PM, you wrote:
TEG> Peter Zaitsev <[EMAIL PROTECTED]> writes:
>> I'm trying to compile mysql 3.23.41 with recent glibc 2.2.4 but this
>> somehow does not work with the following diagnose:
TEG> It builds just fine with glibc 2.2.4 on a current
I think you have bigger issues going on with your setup than killing a perl
script causing corruption issues. I have experienced very little (almost no)
corruption with any of my mysql tables using various versions of mysql for
extended periods of time (the times the tables were corrupted it was u
I had trouble learning column permissions on Win98 because a possible bug
got in my way. I think that there is a problem with the tables_priv part of
the user verification. According to mysqld, I am using "Ver
3.23.39-max-debug for Win95/Win98 on i32" of the program. I submit this bug
because I
My thoughts exactly when i fisrt suggested a VPN. I think it would be one of
the best alternatives. You said you use an ISP. Do you mean a dialup? How
long does this data transfer normally take?
Chris Lathem
Network Administrator
SkyHawke Technologies
[EMAIL PROTECTED]
601.605.6100 Ext. 109
Fax:
>
> mysql> explain select * from dominf.domip order by ip desc;
>
> 'ORDER BY something DESC' does not use an index. It must
> be ascending. See the manual.
Also, I forgot, if you do this often and it needs to be in DESC order, you
can always alter the app to create and use an extra column 'ip_de
Chris,
mysqld.exe in version .38 was accidentally compiled with
__NT__ defined. Use mysqld-max.exe from the same
distribution or download a newer version from www.mysql.com
Note that the web page www.innodb.com/bugfixes.html
contains information about known bugs, patches to them,
and, if already
On 23-Aug-2001 Filippo Galante wrote:
> I´m converting an old DBF aplication to MySql an I´m having a very strange
> problem.
> When I first execute a query it takes from 12 to 30 seconds to have an
> answer, after that it runs in about 2 or 3 seconds.
Because it's got the index ( & maybe the re
On 23-Aug-2001 Tim Cowan wrote:
> Hi
>
> Is it possible to use 2 or more fields to become the primary key. I have a
> table
>
> CREATE TABLE tmptraining (
> rowid int(10) unsigned NOT NULL auto_increment,
> sid char(32) NOT NULL default '',
> expiry date NOT NULL default '-00-00',
>
On 23-Aug-2001 Giannis wrote:
> I cant appear greek fonts in my web pages.
> My configuration is:(linux, apache-tomcat, JBoss application server and
> mysql)
> I make some JSP pages and i have problem with the greek fonts.
> I put a meta tag:
> but i doesnt work.
> What is my wrong?
>
do you ha
I have this table
+---+--+--+-++--
--+
| Field | Type | Null | Key | Default| Extra
|
+---+--+--+-++--
--+
| ID| int(10) unsigned | | PRI
--- Werner Stürenburg <[EMAIL PROTECTED]> wrote:
>
>
> Calvin Xu schrieb am Donnerstag, 23. August 2001,
> 03:16:09:
>
> > select
> subject,subhead,subsubhead,data2,data3,see_also
> > from npl_detail where ( (subject like '% asia %'
> OR
> > subhead like '% asia %' OR subsubhead like '% asia
>
A query with a ORDER BY clause over a numeric field,
will be fast if this field have a index or this doesn't influence the anwer
time of the query.
Thanks.
--
Gregorio R. Alberdi Díaz - <[EMAIL PROTECTED]>
AVILÉS (ASTURIA
try using inet_ntoa() function.
On Thu, 23 Aug 2001 12:19:54 -0700
Jamil Farshchi <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I am trying to convert a hex number that is stored in a mysql db into an ip
> address. Here is my problem: I can convert the original integer into a hex
> number like so:
I just set up a master/slave replication scheme and all is well,
but through the procedure did get bit on the tail.
After the setup, and after the master and slave mysql servers
had been started, I got some error messages that pointed to
a type in the slave's my.cnf file. I shut the slave down,
f
I recently installed MySQL, Ver 11.15 Distrib 3.23.38, for Win95/Win98
(i32), on a Windows 95 system running version 4.00.950C. When I tried to
initialise the database I got the following error:
C:\mysql\bin>mysqld
InnoDB: The first specified data file c:\dbData\dbData1 did not exist:
InnoDB: a n
Being a newbie to database design, I wonder if those more experienced could
give me an opinion on what constitutes "good practice" - as opposed to what
is technically possible. I know what I want to do is technically possible,
but am I lining mself up for trouble by doing it?
I know that it is a
I cant appear greek fonts in my web pages.
My configuration is:(linux, apache-tomcat, JBoss application server and
mysql)
I make some JSP pages and i have problem with the greek fonts.
I put a meta tag:
but i doesnt work.
What is my wrong?
Hello,
I am trying to convert a hex number that is stored in a mysql db into an ip
address. Here is my problem: I can convert the original integer into a hex
number like so:
For example:
mysql> select distinct HEX(ip_src) from iphdr;
---
|ip_src|
---|
|80B7EB99 |
|
> From: Elizabeth Alderton [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 23, 2001 9:26 AM
>...
> Dear Chuck
>
> Your idea has given me an idea.
>
> How about:
>
> When we actually collect the data, we encrypt it so that it is
> actually held
> in mysql in an encrypted form? Then it can
Peter Zaitsev <[EMAIL PROTECTED]> writes:
> I'm trying to compile mysql 3.23.41 with recent glibc 2.2.4 but this
> somehow does not work with the following diagnose:
It builds just fine with glibc 2.2.4 on a current development version
of Red Hat Linux (Roswell + a few minor updates).
Did y
main.cc: In function `void if_conn()':
main.cc:464: no matching function for call to `MysqlConnection::clinet_info
()'
main.cc:529: no matching function for call to `MysqlConnection::clinet_info
()'
make: *** [main.o] Error 1
I am using mysql++-1.7.9, and do not see any references to clinet_in
on 8/23/01 12:35 AM, Werner Stürenburg wrote:
> Is it an option to drop the table and recreate and repopulate it?
>
> I would give it a try and think that your problem will be gone.
> You can easily do that with mysqldump. Ask again if you need more
> help.
Hi, Werner:
I tried this, and it did
OK folks - I found it - tucked away in the /home/ folder.
GP
- Original Message -
From: George Pitcher <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 23, 2001 3:59 PM
Subject: Re: where should the mysql folder be?
>
> - Original Message -
> From: <[EMAIL PROT
I´m converting an old DBF aplication to MySql an I´m having a very strange problem.
When I first execute a query it takes from 12 to 30 seconds to have an answer, after
that it runs in about 2 or 3 seconds.
It´s a very large file (ZipCodes) and I must seek by ZipCode, by State/City/Street
(where
- Original Message -
From: <[EMAIL PROTECTED]>
To: George Pitcher <[EMAIL PROTECTED]>
Sent: Thursday, August 23, 2001 4:03 PM
Subject: Re: where should the mysql folder be?
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypas
Hi!
Maybe you already have a my.ini or my.cnf
file in winnt or winnt\system directory, or
some other directory and
that overshadows the file you have in C:\
What do
dir /s my.cnf
dir /s my.ini
say?
Your innodb start options look ok. For some
reason MySQL does not see the options
you have spe
I tried it in the command line. And it works. But in the programm is still
doesn't.
MySQL Query Failed. Error 1030: Got error -1 from table handler
>
> Message-Id: <[EMAIL PROTECTED]>
> Date: Thu, 23 Aug 2001 04:53:44 -0400
> To: [EMAIL PROTECTED]
> From: "Jason G." <[EMAIL PROTECTED]>
> Subjec
Thanks Paul,
Can I install the Client from the same rpm that the server came from or is
it a diff download?
George
- Original Message -
From: Paul Foxton <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 23, 2001 3:02 PM
Subject: RE: Installing on Linuxppc???
> Hiya,
>
Hello,
I am trying to find a distribution of the source for the
"Include files and libraries for develpment" for OS X.
Does anybody know where I can get this??
I'm trying to get the dbf2mysql converter to work in OS X
but somebody told me that I needed to install the
developer edition of MySQ
Assuming you are on windoze, try www.mysqlfront.de. I use it on my NT
laptop.
GP
- Original Message -
From: j.urban <[EMAIL PROTECTED]>
To: Neil Tompkins <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, August 23, 2001 3:08 PM
Subject: Re: mySQL Interface Programs
> Check out
Hello,
I have libz-1.1.3-284 installed on my Linux but when i try install
apache 1.3.20 with mysql 3.23 and php 4, i've the message
collect2: ld returned 1 exit status
make[2]: *** [target_static] Error 1
make[2]: Leaving directory `/home2/mvmendes/apache/apache_1.3.20/src'
make[1]: *** [build-s
Hiya,
Yes, when you install from an rpm you just get the server, so you need to
download the client programs binary in a seperate rpm and install them too.
Also, the rpm decides where to install everything so you don't actually end
up with a base install dir for MySQL. Your data directory shou
Check out urSQL from http://www.urbanresearch.com/ursql
On Thu, 23 Aug 2001, Neil Tompkins wrote:
> Hello,
>
> Currently to connect to mySQL server I use MS Access and ODBC. I have
> noticed that the update when scrolling through records is not very good.
> Can anyone recommend and suggesti
Peter Zaitsev writes:
> Hello Sinisa,
>
>
> If I'm not mistaken this shows version 2.2.4
>
>
> SM> And your compiler was built with which glibc ??
> 2.2.0 from suse 7.1
>
>
>
>
> --
> Best regards,
> Petermailto:[EMAIL PROTECTED]
>
>
You have got only one
when i'm connecting to the base with the prompt => no problem
in a file test toto.c :
mysql_connect(&MSQL_IDENBASE,localhost,root,mysql);
==> no problem
But in a big application, when i try to connect by
mysql_connect(&MSQL_IDENBASE,localhost,root,mysql);
==> error 2004
Somebody know something
Hi all,
Brand new to this list.
I have MySQL running happily on my NT laptop. I decided it was time to
migrate to Linux so I have set up an old Mac (nubus) with Linux-PPC-2000Q4
and have tried to install MySQL with varying degrees of difficulty.
After some very futile attempts at a source compi
Hi, I am running mysql-3.22.27 for many months. But
today, the mysqld always core dump. The running
platform is FreeBSD3.4.
I checked the dumped core and find that it seems that
the core dump has something with the
/usr/lib/libc_r.so file when it called the thread
subroutine.
Please help me!
Sir,
I was able to successfully use the JDBC driver to connect from a
Linux computer to a mysql database resident on another computer
running Linux. The Linux computers are running Java Version 1.1. I
am now trying to use the same JDBC driver to connect from a Sun
Solaris 8 to a Linux compute
somebody know what means this error (with mysql_connect)
thank you
Nicolas.
PS : i don't have the file "mysqld_errors.txt"
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
How about 'Database System Concepts' by Abraham Silberschatz and others.
It takes you from relational calculus through index data structures,
transactions, concurrency control and new db applications.
You could also look at the classics by Date Introduction to database
systems 7th ed.
---
These are some remarks on mysql(3.23.32) with regard to
my experience
with data crash and recovery. It is not meant to be
negative in any sense
and I am actually very thankful there is a database
like Mysql around.
On the other hand, if these experiences are not due
to some mistake on m
Tim Cowan wrote:
>
> Hi
>
> Is it possible to use 2 or more fields to become the primary key. I have a
> table
>
Yes
> CREATE TABLE tmptraining (
> rowid int(10) unsigned NOT NULL auto_increment,
> sid char(32) NOT NULL default '',
> expiry date NOT NULL default '-00-00',
> arena
Peter Zaitsev writes:
> Hello Sinisa,
>
> Thursday, August 23, 2001, 3:42:53 PM, you wrote:
>
> This is strange As I've compiled plain gcc 2.2.4 into other directory
> and now running --with-other-libc= and It swears about glibc 2.2.3
> therefore my system glibc is 2.2.0 and I have never used 2.
I am not sure about the primary key.
You can create a UNIQUE index on (field1, field2, field3, field4)...
(I have done this)
This will prevent any duplicate rows from being inserted.
Hope it Helps,
-Jason Garber
Lead Programmer - pulseaday.com
At 08:07 AM 8/23/2001 -0400, you wrote:
>Hi
>
>I
Hello Sinisa,
Thursday, August 23, 2001, 3:42:53 PM, you wrote:
SM> Peter Zaitsev writes:
>> Hello mysql,
>>
>> I'm trying to compile mysql 3.23.41 with recent glibc 2.2.4 but this
>> somehow does not work with the following diagnose:
>>
>> l/var\""-DSHAREDIR="\"/us
Hi
Is it possible to use 2 or more fields to become the primary key. I have a
table
CREATE TABLE tmptraining (
rowid int(10) unsigned NOT NULL auto_increment,
sid char(32) NOT NULL default '',
expiry date NOT NULL default '-00-00',
arenaid tinyint(1) unsigned NOT NULL default '0',
Are you using BIND? You may want to make sure you applied your new changes
to it and also make sure your
/etc/host.conf has the right order for searching in it.
Rob
- Original Message -
From: "Tim Cadell" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Wednesday, August 22,
1 - 100 of 140 matches
Mail list logo
