Hi Marc,
> Thanks Jacques & Christopher,
>
> you are telling on your site (compliment, really nice work), that your
> MySQLX-component is quicker then ODBC.
> Any benchmarking about it ?
Yes, although not prominent, we've had this on your site for a while:
http://www.scibit.com/Products/Software
At 10:49 AM 1/22/2001 -0800, Ann Ricchiazzi quoth:
>Dear mySQL Users,
>
>I am trying to choose between mySQL and Oracle for a Linux server. My
>specific questions are:
>
>1) Will mySQL handle 3000 hits/day well?
Yes, over the last 219 hours one of my servers has been averaging 55.417
queries/sec
Read the archives. The detailed story can be found there. Use newest MySQL
and newest PHP CVS. These errors will go away.
Maciek
> -Original Message-
> From: tc lewis [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 23, 2001 3:56 AM
> To: [EMAIL PROTECTED]
> Subject: aborted connectio
Hello Michael,
Tuesday, January 23, 2001, 2:02:33 AM, you wrote:
Peter>> I saw this many times on different machines and this sequince never
Peter>> resolves itself ( the locks never disapears). Always the only way to
Peter>> fix this is to kill one of the queries. I killed query #16 and
Pete
To whom it may concern,
I get this error when I run make test.
Details
Perl-5.003_03
MySQL-3.23.32
SCO UnixWare 7.1.1
Developement System that comes with UW 7.1.1
libz 1.1.3
What is this sysbol __llasgdivu that is referenced in libmysqlclient.so.10
used or does it come from? Does any one else
* Paul DuBois <[EMAIL PROTECTED]> [010122 21:03]:
> >Is there a newbie resource somewhere for Those-Too-Stupid-to-Live?
> >
>
> Did you run mysql_install_db ?
>
Yes. Several times. :-) The database files are created in /var/mysql.
There may be some confusion in this port as to where the datb
I'm trying to get MySQL running under NetBSD 1.5, and am having
problems getting mysqld running at boot time. It starts, but quits
almost right away. If I start mysqld using mysqld.server the log
file indicates that the table mysqld.host is not found. If I use
safe_mysqld the log file just i
Paul DuBois wrote:
>
> In a table with no deleted rows, INSERTS happen by adding the row to
> the end of the table. An UPDATE won't necessarily be able to replace
> the row in-place (the new data may be longer than the old), so you won't
> be able to perform concurrent SELECTS along with the
At 12:00 PM +0900 1/23/01, Nat Sakimura wrote:
>?Hi.
>
>In the MyISAM table without any deleted rows,
>I read in the documentation that INSERT and
>SELECT can occur concurrently.
>
>What about UPDATE? I presume update will
>issue exclusive lock to the table unlike
>insert, but I wanted to know for
Hi.
In the MyISAM table without any deleted rows,
I read in the documentation that INSERT and
SELECT can occur concurrently.
What about UPDATE? I presume update will
issue exclusive lock to the table unlike
insert, but I wanted to know for sure.
Also, after deleting some rows in the table
we're seeing a lot of errors like these in our error log files from mysql:
010122 17:38:52 Aborted connection 177373 to db: 'XXX' user: 'YYY'
host: `ZZZ' (Got an error reading communication packets)
i haven't investigated too too much about this yet, but i was wondering
what common problems th
in the mysql manual, i noticed:
"Even though Berkeley DB is in itself very tested and reliable, the MySQL
interface is still considered beta quality. We are actively improving and
optimizing it to get it stable very soon."
a team i'm in is considering trying bdb tables for some things for a queu
Actually, the TEXTAREA tag does capture the line breaks, they get stored in the mysql
table in a text type column. When I query the table and re-display the TEXTAREA, the
line breaks are preserved. I am using Perl CGI scripts with DBI, DBD-MySQL.
I defined the TEXTAREA (in perl):
$portdesc
Mike,
I'm assuming that you are trying to output this to a webpage.
I think your problem is that, HTML does not use line breaks in the
document. You can try this out by making a simple webpage like this:
A
B
C
D
When you view this in your internet browser, you will see
At 6:36 PM -0700 1/22/01, [EMAIL PROTECTED] wrote:
>When I submit a form and enter it into the database
>it does not recognize when the user presses enter.
>It keeps coming up as one long line, and for poetry,
>it doesn't look very pleasant.
This doesn't really have anything to do with MySQL. It
When I submit a form and enter it into the database
it does not recognize when the user presses enter.
It keeps coming up as one long line, and for poetry,
it doesn't look very pleasant.
I would love if anyone could help me because it would
very much help me when creating future projects. I am
on
Pass the option --bind-address=x.x.x.x to safe_mysqld .. see
http://www.mysql.com/doc/C/o/Command-line_options.html.
-ai
On Mon, 22 Jan 2001, Irong Lungs Jr wrote:
> Anyone know how to bind / set mySQL to listen on a specified IP on a
> multi-homed machine (my machine running mySQL as 3 diff I
At 7:17 PM -0500 1/22/01, Irong Lungs Jr wrote:
>Anyone know how to bind / set mySQL to listen on a specified IP on a
>multi-homed machine (my machine running mySQL as 3 diff Interfaces, and I
>only want to accessible via the local eth0 interface)
Try running mysqld --help to get a list of option
> If I call mysql_close()
> on a connection that's already closed, will it just return quietly or
> will it segfault?
You can and should always call mysql_close(). It won't yield problems
regardless of the DB's state.
Regards,
Nick G.
-Original Message-
From: [EMAIL PROTECTED] [mailto:
Sorry, but our mailserver is down again (Exchange ;), so I had to read via
web
and search my list-archiv for your mailadress.
We tested the system on a Dual-P3-800Mhz-1GB while developing.
Now it's running on a E4500 with 6x400Mhz and 8 Slaves (P3-800).
Our site generates currently 1,5-2 Million
Anyone know how to bind / set mySQL to listen on a specified IP on a
multi-homed machine (my machine running mySQL as 3 diff Interfaces, and I
only want to accessible via the local eth0 interface)
-
Before posting, please check
My bad... They aren't scheduled to come out until 3.24. Sorry.
.:: Nathan Cook [ [EMAIL PROTECTED] ] ::.
Systems & Network Administrator :: Programmer
[ phone - 208.343.3110 ][ pager - 208.387.9983 ]
- Original Message -
From: "tc lewis" <[EMAIL PROTECTED]>
To: "Nathan Cook" <[EMAIL PROT
select max(rating) from singlemalts will give you the highest value
or
select * from singlemalts order by rating desc
will give all the rows ordered by rating and the first row will have the
highest value
Richard Reina wrote:
> I've tried the manual (and the Oreily MySQL book) and played arou
Select * from singlemalts order by rating limit 1;
Now, you have to share your samples with the rest of us! :)
Cal
http://www.calevans.com
-Original Message-
From: Richard Reina [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 21, 2001 12:49 PM
To: [EMAIL PROTECTED]
Subject: SELECT F
>Description:
I have compiled MySQL 3.23.32 on Slackware 7.1 with BerkeleyDB support.
Configure, make and make install work fine without any errors, however as
soon as I run scripts/mysql_install_db it fails:
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello monty,
Peter> After I got mysql/system crash I often see the following after I
Peter> bring mysql up again:
Peter> ruby:~ # w
Peter> 9:37pm up 7:35, 1 user, load average: 0.01, 0.04, 0.06
Peter> USER TTY
I've tried the manual (and the Oreily MySQL book) and played around with
MAX() and GREATEST() but could not figure it out.
|ID |NAME |RATING |
|213|McCallen 12| 9 |
|214|Glenmorangie | 8 |
|225|Glenlevit | 7 |
How do I select the one with highest
Hi!
> "Filippo" == Filippo Carletti <[EMAIL PROTECTED]> writes:
>> >Sometimes something bad happens in a server and it is hard to figure out
>> >what is going on because we can not get in. I'd like to suggest a change
Filippo> for
>> >MySQL 4 protocol, such that a connection from localhost
Hi!
> "Christian" == Christian Hammers <[EMAIL PROTECTED]> writes:
Christian> Hello
Christian> Here is something from the Debian bug tracking system for you. If fixes
Christian> the compilation problems on Alpha architecture.
Christian> bye,
Christian> -christian-
>> downloaded
Hi,
Its in the manual, but it is something like
ALTER TABLE Discharge ADD PRIMARY KEY (Vessel, Voyage, PortName);
Regards
Quentin
-Original Message-
From: Don [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 23 January 2001 10:39
To: msql list
Subject: Creating keys
The online documentatio
Hi.
I am not sure what you compare against, because the description of the
second test script is not clear to me in the given context.
Anyhow, the difference probably comes from the fact, that MySQL has to
use indexes to find the row which matches to the id and has to access
about log(65000) =~
Hi All,
Are there any switches to force MyODBC to do a "Silent" install?
Thanks,
Lee Jenkins
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t
Hi.
On Mon, Jan 22, 2001 at 11:37:23PM +0200, [EMAIL PROTECTED] wrote:
> > "Huang-Ming" == Huang-Ming <[EMAIL PROTECTED]> writes:
>
> Huang-Ming> hi Tim,
>
> Huang-Ming> thanks for the prompt response which is hard to be seen with Oracle and
>Microsoft.
>
> Huang-Ming> sorry, i should ha
On Mon, 22 Jan 2001, Christian Rabe wrote:
> we use mysql here for our whole site. there are up to 500
> inserts/second alone from the stockdata-feed and thats only part of
> our site and about 200-300 selects/second per machine. in
> combination with replication (3.23.xx) you can near to limitle
Nathan Cook wrote:
>
> Note: As of version 3.2.3gamma Mysql Supports Sub-Selects.
See... I know I've been spending too much time at the computer when
I get email in my dreams :)
what version are you talking about anyway, that number isn't even
a valid version number..
-
Do this instead:
ALTER TABLE Discharge ADD PRIMARY KEY (Vessel, Voyage, PortName);
-Tilghman
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -Original Message-
> From: Don [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 22, 2001 15:39
>
er, what?
did i miss something? heh.
-tcl.
On Mon, 22 Jan 2001, Nathan Cook wrote:
> Note: As of version 3.2.3gamma Mysql Supports Sub-Selects.
>
> .:: Nathan Cook [ [EMAIL PROTECTED] ] ::.
> Systems & Network Administrator :: Programmer
> [ phone - 208.343.3110 ][ pager - 208.387.9983 ]
>
Hi,
we use mysql here for our whole site.
there are up to 500 inserts/second alone from the stockdata-feed and thats
only part
of our site and about 200-300 selects/second per machine.
in combination with replication (3.23.xx) you can near to limitlessly
scale (if you have limitless money for sla
> "Huang-Ming" == Huang-Ming <[EMAIL PROTECTED]> writes:
Huang-Ming> hi Tim,
Huang-Ming> thanks for the prompt response which is hard to be seen with Oracle and
Microsoft.
Huang-Ming> sorry, i should have had studied hard the manual a year ago. regarding the
error, however, would the err
The online documentation only has a syntax example of creating a key
consisting of a single column. I wish to create a primary key
encompassing three columns. Here is my syntax:
create primary key on Discharge (Vessel, Voyage, PortName);
where Discharge is my table name and all three fields na
On Mon, 22 Jan 2001, Don wrote:
> Hi,
>
> I'm looking at the docs for the UPDATE syntax right now!
>
> Here is my code (in Perl):
>
> $sqlCmd = $dbh->prepare("UPDATE Ports SET Country = $country,
> TransPort = $transPort,
>
This problem is not necessary a mysql problem, it might be a problem with
your server or whatever you're using to access your database.
For example, if you're using PHP to access your database, you should ask
the PHP mailinglist :)
(if you are using PHP btw, you migth not be closing your connect
I suggest you read up on the GRANT syntax :)
http://www.mysql.com/doc/G/R/GRANT.html
What you need done can either be done through issuing a GRANT statement,
or modifying the mysql table manually. If you're not too familiar with
MySQL, I suggest you use the GRANT.
Atle
On Mon, 22 Jan 2001, A
mySQL Users,
Have any of you had any cases of corrupted data in my SQL? We are choosing
between Oracle and mySQL, and it boils down to just a few key issues at this
point. Integrity of data is one of them.
Your answer before 3:00 would be most helpful, as that is when we have a
meeting to discus
>Description:
23655:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in
./bin/my_print_defaults: _F64_fstat
23655:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in
./bin/my_print_defaults: _F64_stat
23655:./bin/my_print_defaults: /sbin/loader: Error: Unresolved sy
>Description:
httpd5%14664:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in
./bin/my_print_defaults: _F64_fstat
14664:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in
./bin/my_print_defaults: _F64_stat
14664:./bin/my_print_defaults: /sbin/loader: Error: Unreso
Hello monty,
After I got mysql/system crash I often see the following after I
bring mysql up again:
ruby:~ # w
9:37pm up 7:35, 1 user, load average: 0.01, 0.04, 0.06
USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT
root pts/0mail.local9:37pm 0.00s
Hi folks
I have downloaded DB tools and took a quick look at it and it seemed to me
that exporting from excel table can only be done
by creating some new table for that purpose in the db. But what do I want to
do? I`d like to copy the contents of excel file to an existing table into
fields that I
Hi!
Because of the core-dump bug when getting an Aborted Connecting
when running a mysqld compiled for debugging, we decided to make a
new release almost at once.
This also fixes a timing problem in replication.
Hopefully we don't need to do many more 3.23 releases :)
Changes in release 3.23
> "AR" == Ann Ricchiazzi <[EMAIL PROTECTED]> writes:
AR> I am trying to choose between mySQL and Oracle for a Linux server. My
AR> specific questions are:
AR> 1) Will mySQL handle 3000 hits/day well?
You need to define what a "hit" is. Is it a simple select on the
primary key of a single t
Hello,
I am using MySql in my ISP, this is the first time I downladed the big
guy himself in my machine. It is working fine as stand alone.
My question is , how to use MySql using java programs. I downloaded
RESIN1.1 and copied the JAR file to the following directory
c:\resin1.1\lib and I adde
Hello, I'm new to this list, and apologize as I'm sure this has been
covered many times...
I'm upgrading from MySQL 3.22.27 to 3.23.31 on Solaris 2.7, and would
like to experiment with BDB tables.
After reading the 3.23 manual, I'm still unclear whether I need the
MySQL source distribution to ha
> >Sometimes something bad happens in a server and it is hard to figure out
> >what is going on because we can not get in. I'd like to suggest a change
for
> >MySQL 4 protocol, such that a connection from localhost can still get
> >through even if there are too many connections.
>
> It is already
Note: As of version 3.2.3gamma Mysql Supports Sub-Selects.
.:: Nathan Cook [ [EMAIL PROTECTED] ] ::.
Systems & Network Administrator :: Programmer
[ phone - 208.343.3110 ][ pager - 208.387.9983 ]
- Original Message -
From: "Scott Gerhardt" <[EMAIL PROTECTED]>
To: "Ann Ricchiazzi" <[EMAIL
On Monday 22 January 2001 11:11, Steven Roussey wrote:
>Hi!
>
>Sometimes something bad happens in a server and it is hard to figure out
>what is going on because we can not get in. I'd like to suggest a change for
>MySQL 4 protocol, such that a connection from localhost can still get
>through even
What would I have to do (sql expression) if I want to have a user be able
to access database from anywhere (so I don't have to make additions for all
the hosts).
database=list
username=bigpapa
password=see5060
What would be the route to do that?
Thanx
--
Hi!
Sometimes something bad happens in a server and it is hard to figure out
what is going on because we can not get in. I'd like to suggest a change for
MySQL 4 protocol, such that a connection from localhost can still get
through even if there are too many connections.
Sincerely,
Steven Rouss
Thanks Jacques & Christopher,
you are telling on your site (compliment, really nice work), that your
MySQLX-component is quicker then ODBC.
Any benchmarking about it ?
Also - does your component support ADO-objects ? - specially Recordsets ..
or do you have something similar ?
How can you acces
hi,
i have a web serverrunning redhat linux 7
i installed mysql 3.23.30 two weeks ago and it has begun to cause problems
i get a "lost connection during query" every half a minute, basicly my web site is dead
i tried instaling the 3.23.32 ( stable you call it! ) and i get the same response
i'm in
Hello Ann,
The answer to you question depends on how you plan to use the database (i.e.
financial trancactions, serving data on the web etc.) as well as financial
considerations. MySQL is free and Oracle is expensive.
Here are some questions you should answer:
1.) Do you need full Transaction
On Mon, 22 Jan 2001 10:49:28 -0800, Ann Ricchiazzi
([EMAIL PROTECTED]) wrote:
>Dear mySQL Users,
>
>I am trying to choose between mySQL and Oracle for a Linux server.
My
>specific questions are:
>
>1) Will mySQL handle 3000 hits/day well?
I'm on a site that does 90,000 database-heavy pages a day
Ann Ricchiazzi wrote:
>
> Dear mySQL Users,
>
> I am trying to choose between mySQL and Oracle for a Linux server. My
> specific questions are:
>
> 1) Will mySQL handle 3000 hits/day well?
> 2) Does mySQL handle multi-media file formats? For example, if I want to
> store audio clips, or Flash m
Dear mySQL Users,
I am trying to choose between mySQL and Oracle for a Linux server. My
specific questions are:
1) Will mySQL handle 3000 hits/day well?
2) Does mySQL handle multi-media file formats? For example, if I want to
store audio clips, or Flash movie clips, or PowerPoint presentations,
If a connection has been closed by the mySQL server, like in a timeout
condition, does the API function mysql_ping() awake the connection again if
the reconnect flag was set, or will it just return a lost server error?
In other words, if I'm testing to see if a long-unused connection is dead
befo
Don wrote:
>
> Hi,
>
> I'm looking at the docs for the UPDATE syntax right now!
>
> Here is my code (in Perl):
>
> $sqlCmd = $dbh->prepare("UPDATE Ports SET Country = $country,
> TransPort = $transPort,
> Sus
Hi Noor, Here is my my.cnf file, it has almost nothing in it.
[mysqld]
port=3306
set-variable = max_allowed_packet=1M
log-update
[mysql.server]
user=mysqladm
[mysqldump]
And Here are some stats for you, it sounds like our servers are very
close. I am using DELL 2400's with 2 processors. I
Change your second query to:
SELECT COUNT(*) FROM newsStories WHERE MATCH summary AGAINST
(LCASE('news'));
Unfortunately this will be a little slow when you have a few million
records. I have tried in the past to look for solutions to getting the
number of matches in a more efficient way than do
Hi,
I'm looking at the docs for the UPDATE syntax right now!
Here is my code (in Perl):
$sqlCmd = $dbh->prepare("UPDATE Ports SET Country = $country,
TransPort = $transPort,
Suspended = $suspended,
Hi,
Thought I'd try sending the message again, maybe you all missed the first
time.
I am using Mysql version 3.22.32 and MyODBC version 2.50.3300 to connect to
a Lotus Approach 97 front-end. I have been having some problems with
boolean values.
Is there anybody out there that has used Mysql
Good Day All,
This will work...
mysql> SELECT storyID, title, summary, MATCH summary AGAINST (LCASE('news'))
AS probability
-> FROM newsStories WHERE MATCH summary AGAINST (LCASE('news')) > 0
LIMIT 0, 5;
But this will not...
mysql> SELECT COUNT(*), MATCH summary AGAINST (LCASE('news')) AS
Hi Ken,
After making the world last week, I've updated sources for Apache,
MySQL, PHP and mod_ssl. Afterwards, recompiled all of them, stopped
previous instances, installed them again and then started all of them.
So yes, I did recompile MySQL.
Regarding the conservative configuration settings,
> "l" == lkeeton <[EMAIL PROTECTED]> writes:
l> First does anybody know the website address for that searchable
l> site that allows you to search on mysql archive emails. I would
l> appreciate if I could get that. I also am looking for opinions on
Does anyone read the footers on the message
First does anybody know the website address for that searchable site
that allows you to search on mysql archive emails. I would appreciate if I
could get that. I also am looking for opinions on the installation of MySql on
the Cobalt Raq3. I am really interested in installing the RPM's for that
First does anybody know the website address for that searchable site
that allows you to search on mysql archive emails. I would appreciate if I
could get that. I also am looking for opinions on the installation of MySql on
the Cobalt Raq3. I am really interested in installing the RPM's for that
At 2:15 PM +0100 1/22/01, Torkil Grindstein wrote:
>Hi.
>
>I'm running a mysql database, to which queries seem to take way
>too much time. The database contains just two tables, each with
>approx 10.000 rows. Simple select() calls to these can take more
>than a minute. Can this be right?
Can you
I tried RedHat, but had the same problem getting apache and php and mysql to
talk to each other. I decided to try Mandrake 7.2 and it did all the work
for me.
Murdmath
- Original Message -
From: "Luis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTE
Don wrote:
>
> Hi,
>
> I'm using Perl to maintain a database. I'd like to search for a record
> in a database and if it does not exist, add it. Otherwise, just update
> the fields. In my script, I have:
>
> $sqlCmd = $dbh->prepare("SELECT PortName FROM Ports where PortName =
> '$port' ");
>
mssql2mysql converts Microsoft SQL Server databases to MySQL
mssql2mysql is VB/VBA code (you need VB6 or a VBA6 capable program such as
Excel 2000 or Word 2000 to run it)
mssql2mysql is free (GPL)
for more informations see:
http://www.kofler.cc/mysql/
Michael Kofler
---
Hi Sinisa and everyone,
I have a question for Noor, after updating freeBSD-stable last
week, I assume you did a "make world", but did did you recomiple
MySQL under that update? The compiler itself was broken on the older
FreeBSD and was not fixed till the 12th of Jan (except by patches on
th
Hi Marc,
All your questions could be answered at:
http://www.scibit.com/MySQLX
try the Sample Website
> Hello,
>
> Hope this list is right for a newbie question.
>
> I would like using mySQL as an ODBC-database on a Win NT Server with MIS,
>
> ... That means, I am having a Website developed
Hi,
I'm using Perl to maintain a database. I'd like to search for a record
in a database and if it does not exist, add it. Otherwise, just update
the fields. In my script, I have:
$sqlCmd = $dbh->prepare("SELECT PortName FROM Ports where PortName =
'$port' ");
$sqlCmd->execute();
Where '$p
Laurie Savage wrote:
>
> I am unable to connect to MySQL either as root or user unless I issue a
> "mysqld --socket=/var/lib/mysql/mysql.sock - u root" command. This is good
> for all users as long as the machine is booted.
>
> I have checked Ksysv and mysql is enabled at startup.
>
> I have co
Herald van der Breggen writes:
> Sinisa Milivojevic wrote:
>
>
> Do you know whether the problem is related to glibc 2.1, or to the 2.2
> kernel or to both ?
>
> With other words : do I really need the 2.4 kernel, which will be al lot
> of work, since a lot has changed (firewalling fo
[EMAIL PROTECTED] wrote:
>
> Thanks Matt.
> MySQL is finally working.
> But the problem now is that PHP is not recognizing its MySQL
> functions. The error I am getting is:
>
> Fatal error: Call to undefined function: mysql_pconnect() in
> /var/www/html/Willy/MySQL/test1.php on line 28
>
> Well
hi Tim,
thanks for the prompt response which is hard to be seen with Oracle and Microsoft.
sorry, i should have had studied hard the manual a year ago. regarding the error,
however, would the error message be better to tell users to adjust relevant
configuration than only to say "MySQL gone a
Sinisa Milivojevic wrote:
>
>
> Hi!
>
> The above is an already reported problem that occurs only on SMP Linux
> on the high load.
>
> A solution is to try kernel 2.4, glibc 2.2 (when stable) and to build
> properly MySQL on that setup.
>
>
> Regards,
>
> Sinisa
Do you know whether the pr
Hello,
Hope this list is right for a newbie question.
I would like using mySQL as an ODBC-database on a Win NT Server with MIS,
... That means, I am having a Website developed with ASP/SQL-Server, and I just would
like changing the databaseserver (SQL-server out, mySQL in )
The ASP-clientside
Noor Dawod writes:
> Hi Sinisa
>
> Is the FreeBSD problem previously submitted by me known to you?
>
> Noor
Ken Manzel has submitted many valuable messages to this mailing list
concerning many important patches for FreeBSD 4.* threads.
He has even provided names of files and dates when
Herald van der Breggen writes:
> Does a downgrade to MySQL 3.22.x help ? (seems less work to me, but I'l
> investigate the other possibilities anyway).
>
>
No, downgrading would not be beneficial to you !
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*
Hello,
we're using mysql.pm to connect to mysql from perl. After installing a second
Mysql-Server we need to connect to the new installation using another port.
Unfortunately we did not find out how to do this up to now. Setting mysql_tcp_port or
mysql_unix_port in the perl-script doesn't work
Hello
Here is something from the Debian bug tracking system for you. If fixes
the compilation problems on Alpha architecture.
bye,
-christian-
--
codito ergo sum - I code, therefore I am!
On Sun 21 Jan 2001, Cristian Ionescu-Idbohrn wrote:
> downloaded 3.23.31. Builds just fi
I have replied to this before and you would have found it in the archives too. Novell
lacks a thread library! If you can port a thread library or write your own, you maybe
able to get it to work. The thread library is the key to making MySQL work. If you
have that, you are 95% there!
--
Richar
Hi
Let's look at this:
# select SubString_Index("10.0.0.0/24","/",1);
10.0.0.0
# select ewu_aton("10.0.0.0");
167772160
# select ewu_aton( SubString_Index("10.0.0.0/24","/",1) );
280239936
Why this? My self written ewu_aton seems to work korrectly when calling
it with any normal argument. The
Amiph wrote:
>
> Hi !
>
> Ok. I've made correctly replication with two servers in a two-way replication. Both
>servers are master/slave. But I would like to know if is it possible to make three
>servers to replicate and receive the updates from each others like this:
>
> a sends updates to b
Yes, mysql can do date arithmetic. Read up on date_add and date_sub functions in the
manual.
--
Richard Ellerbrock
[EMAIL PROTECTED]
>>> Mike Podlesny <[EMAIL PROTECTED]> 2001/01/22 03:01:10 >>>
I have a script that saves a date in to a mySQL database. The date I want
to be saved is 14 days fr
Hi Sinisa
Is the FreeBSD problem previously submitted by me known to you?
Noor
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 22, 2001 3:32 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Unexplained high-loads
> I am writing a database to store student academic records at my local
> high school. I wish to generate attractively published reports home to
> parents.
>
> Does anybody know of a method or product that will produce elegantly
> formatted reports from MySQL?
StarOffice can create reports from
Does a downgrade to MySQL 3.22.x help ? (seems less work to me, but I'l
investigate the other possibilities anyway).
Sinisa Milivojevic wrote:
> Herald van der Breggen writes:
> > Hello Noor,
> >
> > I am struggling with a similar problem on a linux based system. It's a
> > Netfinity 450
Herald van der Breggen writes:
> Hello Noor,
>
> I am struggling with a similar problem on a linux based system. It's a
> Netfinity 4500R, dual pentium, RAID-5 with a rather new ServeRaid-4L
> scsi controler.
>
> On certain moments, mostly in the peak hours, mysql suddenly behaves
> w
Mark Papadakis writes:
> Hi all,
>
> I was wondering what's wrong with a query like this:
>
> select itemlist , sum(field1), count(*) as cnt from table where where conditions
>group by id having cnt=2 order by field_x, field_y desc limit 10
>
> I am expecting to get the requested r
1 - 100 of 121 matches
Mail list logo
