Hi All
Actually I am Oracle Prgrammer novice to mysql
We have installed Linux RH 6.2 in which we have installd mysql. Now he want me to
create 3 tables
in that. He has given me mysql> prompt. However I dont
know how exactly to go further. When I issue a select
statement it says you have to c
hi there,
my data directory is /var/lib/mysql . i have created a .my.cnf file
here. i have restarted mysql and now i am not sure whether the entries are
being read from the cnf file. can you tell me how to confirm this ?? thanks
in advance
bye
Mathew
-
I figure since there are various ways to sort information in SQL, there must
be some way to sort the most frequent bit of information. Example:
SELECT term FROM table ORDER BY mostfrequent(term)
And say you had this as the table
ID TERM
1 a
2 a
3 f
4 z
5 a
6
> > First I gzip and tar the mysql-3.23.36-sun-solaris2.7-sparc.tar.A error
> > echoed "tar:directory checksum error."Then I goto the /mysql/bin/ and excute
> > ./configure,the prompt is configure not found.I don't know what is the
> > reason.I think maybe the tar of Solaris is not work in good
The information contained in this email is privileged
and confidential and intended for the addressee only. If you are not the
intended recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error you are asked
to destro
I believe it states on the download page (or maybe it is on the mysql
download page, in any case, I have seen it a lot) that gzip is broken on
solaris and you MUST use gunzip? Just a guess. Don't know for sure. No
solaris to play with :|
On 4/4/01 8:33 PM, "php_mysql" <[EMAIL PROTECTED]> wrote
Db -> table1, table2 and table3
SELECT table1.task, table2.comment, table2.remarks, table3.history
FROM table1 LEFT JOIN table2 ON table1.id=table2.todoid
LEFT JOIN table3 ON table1.id=table3.todoid WHERE table1.id=10;
Results (roughly) in:
+--++--+-
In the last episode (Apr 05), [EMAIL PROTECTED] said:
> > On Wed, Apr 04, 2001 at 05:35:52PM -0600, Mat Murdock wrote:
> > >If I understand the manual correctly when I do a "select blah
> > >from blah where blah = blah order by blah limit 10" Mysql
> > >finds the first 10 matching rec
Hello!
How do you do!
I meet a problem when I install Mysql at Solaris 2.7 Sun SPARC.Please help me.
First I gzip and tar the mysql-3.23.36-sun-solaris2.7-sparc.tar.A error echoed
"tar:directory checksum error."Then I goto the /mysql/bin/ and excute ./configure,the
prompt is c
> Does anyone know why no matter what user I log into my database undr, the
> only history file that is being written to is root's :
>
> /root/.mysql_history
>
> Why is a history file not created in the users home directory?
Mysql' user account is not related to user's account on Linux System.Whi
"MikeBlezien" <[EMAIL PROTECTED]> wrote:
> ROUND((tally / votes),2) AS Rating
>
> which I believe should give me 4...correct?? or would it better to do the
> calculations within the script after extracting the column data ??
I think that you'll find that it is faster to do the calculation within
>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 Ali
In the last episode (Apr 04), Mat Murdock said:
>If I understand the manual correctly when I do a "select blah
>from blah where blah = blah order by blah limit 10" Mysql finds
>the first 10 matching records and then sorts those records. How
>do I have it first sort the database a
I am having a problem installing mysql++ on a freebsd 4.2 install.. I am
wondering if there is anyone who has got it to work? thanks
Kevin
ps if I am in the wrong place please tell me where I should be. :)
-
Before posting,
> On Wed, Apr 04, 2001 at 05:35:52PM -0600, Mat Murdock wrote:
> >If I understand the manual correctly when I do a "select blah from blah where
>blah = blah order by blah limit 10" Mysql finds the first 10 matching records and
>then sorts those records. How do I have it first sort the dat
Gary Huntress wrote:
> I had a similar problem after I installed a driver set, I don't think it was
> the MyODBC drivers, but the outcome was the same, a very generic windows
> error that was not even associated with an attempted connection.
>
> I had to reinstall the Microsoft MDAC components, a
I had a similar problem after I installed a driver set, I don't think it was
the MyODBC drivers, but the outcome was the same, a very generic windows
error that was not even associated with an attempted connection.
I had to reinstall the Microsoft MDAC components, available here
http://www.micros
Remite: Guillermo Guzman Ramirez
Ibague - Colombia - Sur America
Would you please help to repair/Corrige an error that
occured with mySQL and Delphi;
The error is like this ; error 127 from table
handler
We noticed that the table, which we do SELECT is out
of order and I named the original
- Original Message -
From: "Luis" <[EMAIL PROTECTED]>
To: "Steve Ruby" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 9:59 PM
Subject: Help with ODBC
> Thank you for all the help on MyODBC but I can't connect to mysql server
> threw access.
>
> Here are the st
On Wed, Apr 04, 2001 at 05:35:52PM -0600, Mat Murdock wrote:
>
>If I understand the manual correctly when I do a "select blah
>from blah where blah = blah order by blah limit 10" Mysql finds
>the first 10 matching records and then sorts those records. How
>do I have it first sort
I try to connect to MySQL database throw ODBC .
All i Ok except ... when i'am trying to add new
record in the form of access (linked) table i got
that record is deleted immidiatly after i hit Enter ...
All begins when i try to set one of fields as AUTO_INCREMENT and UNIQUE :
ALTER TABLE upd DROP
On Wed, Apr 04, 2001 at 05:35:52PM -0600, Mat Murdock wrote:
>If I understand the manual correctly when I do a "select blah from blah where
>blah = blah order by blah limit 10" Mysql finds the first 10 matching records and
>then sorts those records. How do I have it first sort the databas
Hi Matt,
Probably worth checking the archives for 'restartable' - there are a few
messages there.
Quentin
-Original Message-
From: Matt Mueller [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 5 April 2001 9:53 a.m.
To: [EMAIL PROTECTED]
Subject: Problems with Mysql on Sol7 i386
Hello,
I a
Hi all,
We are modifying one of our db tables to include two fields, 'votes' and
'tally' for allowing to display a "rating" system. The 'votes' column will be a
running total of all votes, the 'tally' will be a column to hold the 'votes'
values. Example, if a person submits a vote of 3(with a ra
Thank you for all the help on MyODBC but I can't connect to mysql server
threw access.
Here are the steps on how I start.
1. I download the MyODBC setup file for windows. I ran the setup everything
went fine.
2. Then I went in to my control panel > double click on ODBC Data
3. ODBC Data open ,
At 14:52 4/4/2001 -0700, Kristopher Briscoe wrote:
Hi,
See the sample below:
C:\mysql\bin>mysql test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.23.36
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql> create tabl
Using PHP and MySQL 3.23, I create a temporary table. Then, in the same
page, I join the temporary table to another query.
Most of the time it works. On about 10% of tries, however, I get an error
'temptable does not exist.'
Any help appreciated.
Daniel
-
Look very carefully at the mysql database by typing in
mysql -u root -p mysql
Look at the manunal for how you can INSERT INTO the user table or how you can
use GRANT
On Thu, 05 Apr 2001, J.Heegsma wrote:
> >%_Dear Sir/Madam,
>
> I am a student and my teacher want's to try to break in into
The MySQL manual is one of the best I've seen
1)
http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html
#Commit-rollback
2)
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#JOI
N
Regards,
Gary "SuperID" Huntress
===
If I understand the manual correctly when I do a "select blah from blah where blah
= blah order by blah limit 10" Mysql finds the first 10 matching records and then
sorts those records. How do I have it first sort the database and then take the first
10 records?
Thanks for your help,
Ma
On Wed, Apr 04, 2001 at 02:52:39PM -0700, Kristopher Briscoe wrote:
>
> Doesn't mysql support begin and rollback transactions? If so what
> is the correct procedure to make it happen. I logged in and ran my
> query..
Depends on the table type. Check the manual for details on the
different tabl
Hi all,
We are modifying one of our db tables to include two fields, 'votes' and
'tally' for allowing to display a "rating" system. The 'votes' column will be a
running total of all votes, the 'tally' will be a column to hold the 'votes'
values. Example, if a person submits a vote of 3(with a ra
I was just wondering, I've been using MySQL and while still a beginner,
quite like it.
As MySQL is an db engine, how readily would my skills be translatable to
PostgeSQL.
I have a friend asking me to work on a project with him and he wants to use
PostgeSQL and PHP.
>From what I've seen the the st
have anybody already faced a mysql crashed connection after a 'show
logs' query?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To reques
Hello,
I am trying to install mysql version 3.23.26 on my sun machine running
solaris 7. I have installed gnu make, tar, and gcc-version 2.95.2. I
have also tried doing everything that is reccomended for my error
such as editing config.cache and even using the reccomended configure
line. The
Sorry if this is mundane for some, but I have searched the manual and I
cannot find the answer to itTwo issues here
.
1)
Doesn't mysql support begin and rollback transactions? If so what is the
correct procedure to make it happen. I logged in and ran my query..
>select * from host_info;
>Msql-Mysql-modules-1.2215.tar. For the life of me I can't find the
>mysql.h file that it keeps asking for? Any ideas where this is...is it
>a bug with this version.
Type find -name mysql.h
I found mine (MySQL 3.23.36) in /usr/local/mysql/include
Sometimes it helps to use a very basic method
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]]
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
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
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
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
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
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 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
"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
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
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
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 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]>; <[
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?
"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
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
"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
> 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
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
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
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
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!
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:
.
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
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
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
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
>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
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
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
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
-
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
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
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
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
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
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
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
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
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
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.
__
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
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
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]
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
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
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
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,
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
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
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
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
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'
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 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
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
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
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
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
"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
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 =
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
>"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
1 - 100 of 137 matches
Mail list logo
