my code attempt
#!/usr/bin/perl -w
#for test using socket input from
$remote_host = "linus.chemeketa.edu";
$port = "10152";
$hostname = '127.0.0.1'; # localhost
$portdb ="3306"; # default mysql port
$database = "track"; # database name
$user = "david"; # database user name
$password =
Chinese OS: Read the manual on how to set the default character set and
language in mysql.
English OS: You will need to build a UI to be able to enter Chinese
characters. Chinese characters should go in as ASCII garbage but will be
displayed as Chinese characters on a Chinese OS without any prob
>We are getting problems in running mysql after installation.
>Since you have already running mysql we seek your advise on the
>following.
Do you already have a mysqld running (ps -ax).
>Also please guide how users are created and groups are set to user
>mysql.
Read the manual and/or buy the b
Hi,
I have a table that I'd like to set up along the following lines:
table events:
...
next_event datetime
period varchar(5)
period_tvarchar(15)
...
and at some point, do an update on every row to the tune of:
UPDATE events SET next_event = DATE_ADD(NOW(), INTERVAL period period
On Tuesday 03 April 2001 17:12, Jean-Luc Fontaine wrote:
> On my replicated linux machines with the latest 3.23.36 rpm from mysql.com,
> I have been getting the following errors lately:
>
> 010403 17:08:35 Slave: received 0 length packet from server, apparent
> master shutdown: (0)
> 010403 17:0
On 04.04.2001 08:55:04 Nicolas Villatte wrote:
> is it possible? If yes, how ?
Could someone *PLEASE* add this to the FAQ?
There are two answers you'll get:
a) Don't store the binary data in the database. Instead store nothing but the
metadata.
b) Also store the binary data in the database.
HHG> You must go to control panel of windows in Data Sources(ODBC) section and add
your DSN of you new MySQL database and then you can explor the database by browsing
your ODBC avilable databases .
HHG> You can check MyODBC manual for this .
Yes, this worked for me too.
However ... I can only
L> Ok i'm still a little bit lost. I have a database in MySQL called "irm"
L> In the ODBC Data Source 32 bit I went in user dsn and added user data source
L> called irm the driver is mysql
L> not this is were i dont understand .
L> In the field that says Windwos DSN name I put "irm"
L> MySQL I
Hi,
I'm using BDB, and I had the same doubts you ask for.
For install BDB:
- You need the source version 3.23.34a +
- You need to compile using the BDB option
You can create a BDB table by using "TYPE = BDB" at the end of create table.
In order to check if the BDB is working you can:
- try
I would rather store the files on disk and the filenames in the database for more
speed.
I'm a developer on a website which members have an uploaded image of theirself..
We just have a image directory with filenames as [username].jpg
This dir is therefore easily mapped to the web with an Alias
Hi friends ...
I have sent once my problem, but don't know why, I haven't recieved any
answer or solution for it ...
Actually, I have installed MySql 3.22.21 on my SERVER NT4, and installed the
MyODBC, I have installed them on my D drive ( the WINNT is installed on D
drive) , and when I type fr
Hi Friends ...
When I type mysql from the command prompt ... an error occured :
ERROR 2003: Can't connect to MYSQL server on 'localhost' (10061)
What is the problem?
Hanan
_
Get Your Private, Free E-mail from MSN Hotmail
Statically Compiled MySQLGUI 1.7.4
<../Downloads/mysqlgui/mysqlgui-linux-static-1.7.4.tar.gz>
I need to know whether I have to compile or do anything else with the above other than
download and unzip it. When I do that (into c:\mysql\ directory) the file mysqlgui is
not an application file s
On Mon, 2 Apr 2001, Derek Sivers wrote:
> Date: Mon, 02 Apr 2001 19:42:18 -0700
> From: Derek Sivers <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: NEW "MAKE" BUG? sigcontext.h
>
> Doing a "make" on the newest MySQL stable 3.23.36 source tarball - on a
> stock Cobalt RaQ3 (Linux 386) wh
Hello,
I have created a table in mysql that has a date field, i have written
an asp code which saves the date in Mysql -MM-DD format but when
retrieving the content of the field it returns in m/d/yy format although
i have set the system format of date as DD/MM/. Is there any
addi
Ouch! I don't know if many people would recommend this method - that's a
fair bit of unnecesary overhead to place ony our server...depending, of
course, on how often these images are created/modified/read.
P
>
> Here's how I do b) in PHP:
>
> 1) Get the MIME type of the image.
> 2) Read the b
Hi,
I'm trying to install mySQL on a BSDI machine. But this is not working.
Could someone help me on this ?
I have downloaded the version for BSDI en unzipt it whit the tar and gz.
So far so good, but then
You have to do all kinds of things that are not allowed.
I am just a user on the s
You may look at the MySQL related code in phpAds from phpwizard.net:
http://www.phpwizard.net/projects/phpAds/
It will bring you all you need in code, but I've tested that system on a website
with 30 concurrent users with 2 ads (2 image SELECTs) per pageview and
that was a bg performance bust
"Martin van Wilderen" <[EMAIL PROTECTED]> wrote:
> I am just a user on the system, so NOT root. The system is from our ISP
> and webhoster (named xs4all). They say that I have to setup and install
> it my self.
Your web hosting company must not be familiar with MySQL. It must be
installed by the
Hi,
I dowloaded and installed the source distr 3-23-36 for Solaris, and tested
the BDB+INNOBASE features.
I tried to do the same for NT-Win2000, but the source 3-23-36 seems not
include the BDB+INNOBASE sources!
if (this si true)
How we can bypass that?
else
where the sources ar
I just had my mysql server go down - the processes still appeared to
be running, but were not accepting connections. The only entry in my
hostname.err log was as follows...
010404 11:12:07 Aborted connection 31 to db: 'unconnected'
user: 'root' host: `localhost' (Got an error writing commun
At 10:41 4-4-01 +0200, hanan khader wrote:
>Hi friends ...
>I have sent once my problem, but don't know why, I haven't recieved any
>answer or solution for it ...
Perhaps because you try to run MySQL on Windows.. I think most people on
this list are familiar with MySQL on Linux.
I found a link
>When I type mysql from the command prompt ... an error occured :
> ERROR 2003: Can't connect to MYSQL server on 'localhost' (10061)
>What is the problem?
>Hanan
Don't send me a copy of your message.. I'll get mine from the list..
Did you follow all instructions as found in the manual and from
>I am just a user on the system, so NOT root. The system is from our ISP
>and webhoster (named xs4all). They say that I have to setup and install
>it my self.
>
>Someone out there ? That knows?
Try to install to another location, like your userdir.
If that's not working find yourself another ho
Thanx Everybody,
it worked and now it is running ...)))
Hanan
>From: "Steve Werby" <[EMAIL PROTECTED]>
>To: "Martin van Wilderen" <[EMAIL PROTECTED]>,
><[EMAIL PROTECTED]>
>Subject: Re: BSDI 4.1
>Date: Wed, 4 Apr 2001 06:09:20 -0400
>
>"Martin van Wilderen" <[EMAIL PROTECTED]> wrote
Hi ,
One of my Tables Got Corrupted , when i ran the myisamchk i got the error mentioned
below and later the table does not have any data . Is my Data Lost or is there any way
i can recover the data ?
Kiran
Data records: 4113
Wrong bytesec: 31-139- 8 at 0; Skipped
Found link
Hi!
On Apr 03, Oson, Chris M. wrote:
> Hello,
>
> I have a site that I'm trying to implement a search engine on existing and
> archived news stories on a medium text datatype in a database.
>
> I read the documentation and got it running, but unless I missed something
> it's not doing what I
On 04.04.2001 11:21:46 Peter Skipworth wrote:
> Ouch! I don't know if many people would recommend this method - that's a
> fair bit of unnecesary overhead to place ony our server...depending, of
> course, on how often these images are created/modified/read.
Do you mean the base64 part, or what?
Sudheer Palapparambil writes:
> Hi,
>
> I am using MySql on Redhat Linux 7.0. Recently I downloaded mySql++.
> I installed and confugured it as per the instruction given. But when
> I try to run the files in the examples directory I get the error
> 'Segmentation Fault (core dumped)', pls he
On 04.04.2001 08:49:07 Nanjunda BM Prasad wrote:
> i have set the system format of date as DD/MM/. Is there any
> additional things to do ? pls. send me the solution.
use date_format to return the date in any format you want.
--
Dear sir,
I have downloaded mm.mysql driver. it is working with Sun Java. But i
don't know where i have to place in Tomcat server as per your documentation it jhas to
be put in WEB-INF/lib as a jar file i tried this also but it is not taking the
driver still it is showin
Rebecca Saxon writes:
> Can a program connect to an Oracle (or Sybase, Informix or DB2) database using
>MySQL++?
Nope !!
Most of the other RDBMS have their own C++ API's, although not as good
or advanced one.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*
Hi,
When you do a query inside a while loop in PHP,
does it dramatically slow down the loading of the
page? For example,
while($row = mysql_fetch_row($result)) {
$id = $row[0];
$query2 = "select field from some_table
where(id='$id')";
$result2 = mysql_result($query2, $link);
}
Does it ha
John Dillon writes:
> Using Windows and Statically Compiled MySQLGUI 1.7.4, it appears to refuse to
>connect until I go to Options and Apply again every time I wish to connect.
>
> Grant/revoke crashes the application, while appearing to be downloading data through
>my modem. I don't get
Hi!
On FreeBSD there was a problem that ALTER TABLE and any operation
involving more than about 150 rows hung, with CPU running at 100 %.
I found now the reason. FreeBSD does not seem to reschedule
threads even after the time quota of some 10 msec, if a thread is
spinning and constantly executin
Dillon, John writes:
> Statically Compiled MySQLGUI 1.7.4
><../Downloads/mysqlgui/mysqlgui-linux-static-1.7.4.tar.gz>
>
> I need to know whether I have to compile or do anything else with the above other
>than download and unzip it. When I do that (into c:\mysql\ directory) the file
>m
Paolo Michetti writes:
> Hi,
>
> I dowloaded and installed the source distr 3-23-36 for Solaris, and tested
> the BDB+INNOBASE features.
>
> I tried to do the same for NT-Win2000, but the source 3-23-36 seems not
> include the BDB+INNOBASE sources!
>
> if (this si true)
> How we
>"Bob Hall" <[EMAIL PROTECTED]> wrote:
> > Quorting someone else who's name is no longer present:
> > >Is there any way to make one field in a table calculate another field.
> > >I'm making a DB that calculates commissions. So in the money_made
> > >field would have the # of sales (sales field
You can do that with one mysql query. Create a comma delimited list of $id
and change your where clause to "WHERE id in (your comma delimited list)".
- Original Message -
From: "Cody Law" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 20:11
Subject: Does quer
yes, you really should be using an inner join and just looping through the
one result set.
On Wednesday 04 April 2001 12:11 pm, Cody Law wrote:
> Hi,
> When you do a query inside a while loop in PHP,
> does it dramatically slow down the loading of the
> page? For example,
>
> while($row =
"Cody Law" <[EMAIL PROTECTED]> wrote:
> When you do a query inside a while loop in PHP,
> does it dramatically slow down the loading of the
> page? For example,
>
> while($row = mysql_fetch_row($result)) {
> $id = $row[0];
> $query2 = "select field from some_table
> where(id='$id')";
> $re
I'm working on a MySQL db and I was just curious what type of query was
faster.
e.g.
I have this table1
id (auto# primary key) | date| Name | address | email
I want to insert a new name into the DB.
Which method would be faster?
1.
INSERT INTO table1 VALUES(null,null,'Bryan',null,null);
2.
INS
Yippee!
What shall we do with our prize money? Buy something new to
the MySQL kitchen :)?
Heikki
.
Dear MySQL Kitchen List,
Congratulations!
You just won US$10.00!!
We just gave away US$25,000.00!!
And you MySQL Kitchen List are among the lucky
2500 people
randomly selected to rece
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Are you bored and want some excitement?
Las Vegas Has Just Showed Up In Your Neigbourhood!
In fact, you wont even have to leave your computer!
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Queensclub Online Casino
Hi there,
i have a similar query regarding calculated fields. i have a table
which stores the 3 test results in a particular subject. i need to find the
average of the best 2 of the tests, i.e for a entry of 46,47,48 i need to
find average of 47 and 48. as of right now i am using a field to
not for speed, but i defitively prefer your second query. Reason for this is
simple: you name the field you want to insert.
with your first query, if you'd ever alter the table you would have to check
all your source code that interacts with this table.
speed difference should be very minimal an
Dear Sir,
I am new in using mySQL database. The
purpose of this email is to enquire bout the method
used to connect both the Java Programming and mySQL
database together. Thanks.
Regards,
Randy
__
Do You Yahoo!?
Get email at your own domain wit
Not sure how helpful I'll be able to be for you. I installed
MySQL-3.23.36-1.i386.rpm and MySQL-client-3.23.36-1.i386.rpm packages. I
verified that everything worked as root and then shutdown the server. I
then followed the steps outlined on p. 476 of the manual (also p. 419 of
Monty Widenius'
somehow my post screwed up here it is in it's entirety.
could i respectfully request help, i am totaly lost as to how to format this code
as well as only been with mysql & perl for 2 weeks.
i am trying to take a real time internet tcp feed that is a comma deliminated row
and input into fields i
TheCasino.com - Serving ''Winners'' Since 1999!!
Dear MySQL List,
Congratulations and welcome to TheCasino.com!!
To confirm, you have successfully registered as a Real Player. From
now on, every time you log on your Email Address will appear automatically.
And for security, you will need t
Hello
My provider 1&1-Puretec (www.puretec.de)
hosting more than 1.000.000 domains
runs about 14 Databaseserver with MySQL 3.22.32-log
on Linux dual Penti-III 500Mhz machines.
In the last 6 month the average uptime of the mysql-servers was around 8 hours.
As I asked them why their mysql-serve
Hello. My name is Emil, I'm from at company called ES Design.
My problem is that I whant to do this.
When a user creat's a database it shoudl be installed in ~userdir/my_db
and when root/superuser creat's a database is would be in /path/to/mysql/var.
I have understand that it would work... with
I frequently get a error 127 on merged tables. The query is a join of two
merged table with each merge table have 4 base tables. If I flush tables
the query works. I notice that when have about 190 tables in memory this
situation is more likely to happen. I am using 3.23.32.
Using 3.32.35,
I got into trouble the other day trying to delete gobs of rows. Actually
I was selecting 90% of the rows from table1 and inserting them into a
table2, then deleting from table1. It was way too slow! So I stopped all
activity (inserts) from table1 and flipped table1 with table2 using rename
st
in access >>>File Menu >>> Export or Import, depending which
way youre goin' >> Follow on screen inst.
scott
At 03:06 PM 4/3/01, you wrote:
>Ok i'm still a little bit lost. I have a database in MySQL called "irm"
>
>In the ODBC Data Source 32 bit I went in user dsn and added us
Hi,
My problem is specifically concerning syntax for mysqldump.
I can successfully execute the following SQL commands from within MYSQL:
mysql> USE cDatabase
mysql> SELECT * INTO OUTFILE "/root/cTable-data.dump"
-> FIELDS TERMINATED BY ',' ENCLOSED BY '"'
-> FROM cTable WHERE myfield='1';
Q
Apache can be set to run your cgi as you user which means that it could
be set world unreadable I think.
On Wed, 4 Apr 2001, Taing Nguon wrote:
> Date: Wed, 4 Apr 2001 07:14:33 +0700
> From: Taing Nguon <[EMAIL PROTECTED]>
> To: "William R. Mussatto" <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
Dear Sir/Madam,
I am a student and my teacher want's to try to break in into my mysql-database. I
won't give him a change. I know Mysql have serveral options for security and
encryption. But I do not know, how I can use them and which one I can use the best.
Could you help me? The mysql databa
I sincerely hope this is the result of a virus.
# Nathan
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 8:54 AM
Subject: TheCasino.com: Registration Confirmation
TheCasino.com - Serving ''Winners'' Since 1999!!
Dear MySQL Lis
Does anyone know of a good site or reference on database design? That would
be efficient database design. I can make a database but I want to know how
to plan one and make it very good. Any ideas? Thanks in advance.
--
Jonathan Duncan
nacnud.com administrator
Nacnud, Inc.
__
TheCasino.com - Serving "Winners" Since 1999!!
Dear Members of the '[EMAIL PROTECTED]',
I am in receipt of your email regarding an unsolicited email.
>
> STOP SPAMMING THE MAIL LISTS ASSHOLE
>
We have a very strict anti-spam policy, and we take extreme measures to
adhere to thes
No this is not true... a lot of the stability of the database server has
to do with the #1 the load, and #2 the design of the database. But no
MySQL should not be crashing this much.
Scott
At 05:26 PM 4/4/2001 +0200, Gunnar von Boehn wrote:
>Hello
>
>
>My provider 1&1-Puretec (www.puretec.d
We've been running on RedHat distribution (starting with 5.2 or so) and
Slackware before that for the last few years (currently running mysql
3.23.32... that update bug introduced in 3.23.34 really spanked us hard,
we'll be moving to "latest" again soon).
Currently, we've got dual and quad PII an
On Wed, 04 Apr 2001, Gunnar von Boehn wrote:
> Hello
>
>
> My provider 1&1-Puretec (www.puretec.de)
> hosting more than 1.000.000 domains
> runs about 14 Databaseserver with MySQL 3.22.32-log
> on Linux dual Penti-III 500Mhz machines.
>
> In the last 6 month the average uptime of the mysql-serv
I checked my RH6.2 install cd's and found zlib-1.1.3-6.src.rpm, I went to
install the package with the following command and get the following error:
>rpm -ivh zlib-1.1.3-6.src.rpm
Unable to open /usr/lib/rpm/rpmrc for reading: No such file or directory.
When I originally installed the os I se
This is an open plea to the MySQL team. The amount of spam and other noise
on the list has been growing more and more every day. I would like to make
a couple basic plea's. The first, is that you require a poster to the list
have an actual account on the list, that should help cut out some of t
Under the laws of the State of Washington spamming is illegal.
RCW 19.190.040
Violations -- Damages.
(1) Damages to the recipient of a commercial electronic mail message
sent in violation of this chapter are five hundred dollars, or actual
damages, whichever is greater.
(2) Damages to an intera
mysql --username=xxx --password=xxx -e "SELECT * INTO OUTFILE
"/root/cTable-data.dump" FIELDS TERMINATED BY ',' ENCLOSED BY '"' FROM cTable WHERE
myfield='1'" dbname
On Wed, 4 Apr 2001, James
Salinas wrote:
> Hi,
>
> My problem is specifically concerning syntax for mysqldump.
> I can succe
Chris Becker wrote:
>
> I checked my RH6.2 install cd's and found zlib-1.1.3-6.src.rpm, I went to
> install the package with the following command and get the following error:
>
> >rpm -ivh zlib-1.1.3-6.src.rpm
> Unable to open /usr/lib/rpm/rpmrc for reading: No such file or directory.
>
> When
I'm wondering if it is required to name int varibable in PHP any different
then a string variable.
I'm trying to get an ICQ number from my database with an query, but it gives
me a Resource #2 in stead of an ICQ number.
Does anyone know what I'm doing wrong?
Thanks
Guido
-
Unfortunately not it's plain old SPAM!
It's on other lists as well.
Andy Woolley
www.databasewatch.com
- Original Message -
From: "Nathan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 5:19 PM
Subject: Re: TheCasino.com: Registration Confirmation
> I sinc
Hey everyone
Does anyone know of any sites that teach more advanced PHP and MySQL?
Tutorials are the best to learn from, but I'm willing to take anything.
Thanks all
-
Before posting, please check:
http://www.mysql.com/manu
>After further asking I got a personal answer that says:
>"it's normal the mysql-servers die because of heavy load".
>"We can't help that the mysql task keeps crashing if to many users access it.
>That's totally normal for a mysql database"
Running 3.22.32 that's prehistoric (sort of).. I think
At 10:19 4-4-01 -0600, Nathan wrote:
>I sincerely hope this is the result of a virus.
Dunno, one of the PHP lists is also being harrased by this kind of
messages.. Perhaps Billy boy G. has to much time to spend ;-)
Or it might be a programm in a nasty loop.
The PHP list admin has blocked all tr
Hello Listers,
I am using mysql and I am trying to get a SQL statement to work. I have
designed a query in Microsoft Access and I am changing the syntax so that
it will run from Perl against a mysql database. Here is the code:
# from Access
#SELECT DISTINCTROW Query1.licenceNo, Query1.subCCYYM
You could place the code that works in a text file and
feed the text file to mysql from the command line.
If the text file was named 'dothis', the command line
might look like:
'mysql -u username -p cDatabase < dothis'
You will be prompted for username's password after
pressing ENTER. If you w
At 16:25 4-4-01 +, Jonathan Duncan wrote:
>Does anyone know of a good site or reference on database design? That would
>be efficient database design. I can make a database but I want to know how
>to plan one and make it very good. Any ideas? Thanks in advance.
www.devshed.com (database no
Hi!
Alex Baumeister reported a couple of days ago that Innobase is
slow when a big DELETE is concurrent with UPDATES.
The bug can cause slowing down several database operations
on non-Linux platforms.
You have to edit mysql/innobase/os/os0thread.c.
About on line 140 it is now:
.
I've searched manyh places and can't get a good answer .. i hope I can get
help here.
I'm trying to dump all the data in my database to separate files (per table)
and be able to specify a field separator character.
for example, I'd like to use || as my field separator, I did the following:
>m
Hi All,
I have installed PHPTriad V1.0 on my Win98 and it is about the best
programme I have ever used. What I need to know is, when I have created my
site and upload it to my ISP's server (Linux / FreeBSD / MySQL + PHP 4) are
there any pitfalls or code differences I should be aware of?
Kinde
Hi,
I'm facing an issue with my primary mySQL server. It powers a web site,
which loads almost 100% dynamic data. At peak times of the day, it
seems to me that the Database is becomming maxxed. (Thus bogging the
site)
I'm aware that there are simply too many variables to completely answer
thi
Peter Skipworth wrote:
>
> mysql --username=xxx --password=xxx -e "SELECT * INTO OUTFILE
> "/root/cTable-data.dump" FIELDS TERMINATED BY ',' ENCLOSED BY '"' FROM cTable WHERE
> myfield='1'" dbname
>
> On Wed, 4 Apr 2001, James
> Salinas wrote:
>
> > Hi,
> >
> > My problem is specifically conce
> This is an open plea to the MySQL team. The amount of spam and other
noise
> on the list has been growing more and more every day. I would like to
make
> a couple basic plea's. The first, is that you require a poster to the
list
> have an actual account on the list, that should help cut out s
"Eric Fitzgerald" <[EMAIL PROTECTED]> wrote:
> The amount of spam and other noise
> on the list has been growing more and more every day.
Agreed. Same thing's happening with my own email accounts.
> Second, perhaps setup some basic moderation, I'll help if
> need be :)
I think most people aski
Hello,
I have redhat 7.0 with Mysql Ver 8.8 Distrib 3.23.22-beta. This was the
Mysql version that came on the redhat cd's. Perl and the Perl DBI are
installed and working correctly. MySql seems to be working correctly as
well(i.e. no problems with permissions, created db's, tables, etc).
Howe
"Jim Hamer" <[EMAIL PROTECTED]> wrote:
> I am using mysql and I am trying to get a SQL statement to work. I have
> designed a query in Microsoft Access and I am changing the syntax so that
> it will run from Perl against a mysql database. Here is the code:
>
> # from Access
> #SELECT DISTINCTROW Q
Let's say I've got a database on primary server (cluster1) and
periodically I need to purge data from it to a remote archive database.
What's the best way? I thought about replication, but I don't want the
data to stick around in the cluster1 database. Is a dump via SSH the
best/easiest way?
I can understand the concern of longer delays in moderation. My problem
with anti spam filters is simply because they are too much like anti-virus
filters. TOO many false positives.
- Original Message -
From: "Steve Werby" <[EMAIL PROTECTED]>
To: "Eric Fitzgerald" <[EMAIL PROTECTED]>; <[
test
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PR
I agree with the Paul DuBois book on MySQL. Another good one to get if you
are just getting started with databases and is somewhat system-agnostic is
"Database Design For Mere Mortals" by Michael Hernandez.
- Original Message -
From: "B. van Ouwerkerk" <[EMAIL PROTECTED]>
To: <[EMAIL PR
Jim Hamer wrote:
>
> Hello Listers,
>
> I am using mysql and I am trying to get a SQL statement to work. I have
> designed a query in Microsoft Access and I am changing the syntax so that
> it will run from Perl against a mysql database. Here is the code:
>
> # from Access
> #SELECT DISTINCTROW
"Eric Fitzgerald" <[EMAIL PROTECTED]> wrote:
> I can understand the concern of longer delays in moderation. My problem
> with anti spam filters is simply because they are too much like anti-virus
> filters. TOO many false positives.
Since you were volunteering...why not volunteer to moderate th
I actually wouldn't have a problem moderating the false positives and
approving them. Coarse, this is all just theoretical untill we get some
kind of official word from the MySQL team (You guys listening there?) :)
- Original Message -
From: "Steve Werby" <[EMAIL PROTECTED]>
To: "Eric
Paul's book is quite good. I picked it up after it was recommended here.
database design, and other goodies in there.
chris
On Wed, 04 Apr 2001 20:10:41 +0200, B. van Ouwerkerk wrote:
>At 16:25 4-4-01 +, Jonathan Duncan wrote:
>>Does anyone know of a good site or reference on database de
I've searched many places and can't get a good answer .. i hope I can get
help here.
I'm trying to dump all the data in my database to separate files (per table)
and be able to specify a field separator character.
for example, I'd like to use || as my field separator, I did the following:
>my
Two ideas that come immediately to mind--
1) Is the web server on the same machine as MySQL?
2) Have you looked at replication? You could have n slaves/webservers that
display data, and all wrtes go back to the master. There's a rather
detailed analysis in the docs that explain how to figure o
Saludos.
Creo que soy el único hispano y necesito de ustedes.
Construyo la siguiente consulta.
Select * from coniarticulos
left join conpproveedores use index (prov_codigo) on
prov_codigo=arti_proveedor
left join conimarcas use index (marc_codigo) on marc_codigo=arti_marca and
marc_proveedor=ar
Eric,
Download the source tarball for mysql from the website and reinstall
using that - the necessary
include files do not come with the redhat rpm.
regads,
P
On Wed, 4 Apr 2001, Eric Fegraus wrote:
>
> Hello,
>
> I have redhat 7.0 with Mysql Ver 8.8 Distrib 3.23.22-beta. This was the
> M
In the last episode (Apr 04), John Smith said:
> I've searched manyh places and can't get a good answer .. i hope I can get
> help here.
>
> I'm trying to dump all the data in my database to separate files (per table)
> and be able to specify a field separator character.
>
> for example, I'd l
hi.
don't know how much light this will shed on your situation, but mysql.h is
in the include directory under the directory where you installed mysql.
(i.e /opt/mysql/include or /usr/local/mysql/include)
hth. hand.
-ravi
-Original Message-
From: Eric Fegraus [mailto:[EMAIL PROTECTED]]
1 - 100 of 137 matches
Mail list logo
