>Hi,
>
>I having trouble working out how to get a result set similar to the
>following where I select from a table with Date & Sales column.
>
>My specific question is can I have a column that accumulates values,
>if so could I have some guidance on how to express this in a select
>statement pl
Sir, look up Rand and ORDER BY in the documentation. I believe
there's an example of using Rand and ORDER BY to do this.
Bob Hall
>Thanks for the answer. but actually I'm not saying that mysql is doing
>wrong, I just want to know HOW can I group by codigo and then get 10 random
>rows of the gro
>When you delete somthing... is there any way to recover the data??
>
>mvh:
>Pål Wester, programmerer
>never.no as, stortingsgt 30, 0161 Oslo
>direkte: 22 01 66 34, 906 900 62
>tlf: 22 01 66 34, fax: 22 01 66 21
>http://never.no - icq:103476059
>~ innhold for internett ~
Yes sir. Retype it.
mvh:
I am trying to build mysql++, I am doing something wrong but I don't know what.
I have downloaded and untar'd ungzipped mysql++-1.7.8.tar.gz into mysql++-1.7.8, run
configure and then make, make install. I set my LD_LIBRARY_PATH to include the new
library and then I try to run the resetdb progra
Greetings,
I have a table that has a column where search keywords are entered.
column searchwords
word1 word2 word3 ..etc
Now when this column is queried for a search, I'm wonder how is the best way to
evaluate
matching the keywords. In the SELECT query, would I get better results if I use:
Dear Adam,
I have faced the same problem a while ago and I didn't receive any kind of
answer regarding doing this with MySQL in any discussion list at all. I had
to create a function using PHP to do the hard job and the ranking position
was created on the fly (using your example, I wouln't need t
At 13:29 03/03/2001 +, Lucy wrote:
Hi,
>Hi
>I had pored for ages over the Manual prior to posting my problem. I've
>solved it - all the methods given in the Manual dont apply to 2000. Manual
The above it isn't correct, I use Win2kPro and Win2k Server on my
work machine and all applies to NT
Hi
I'm designing a site where people can vote for their favourite albums using
PHP3 to query the database.
It's the first database I've 'designed', and I'm sure that there are
improvements I could make to the way I have organised the data.
For example, I'm looking for a way to make the 'album_ra
Thank you all. I installed and seems working fine.
- Original Message -
From: "Paulus" <[EMAIL PROTECTED]>
To: "N Sikkandar Dulkarnai" <[EMAIL PROTECTED]>
Sent: Saturday, March 03, 2001 8:04 PM
Subject: Re: Can't locate DBI.pm in
> You haven't propably installed DBI.
> Find it at CPAN a
Hello all,
I am brand new to MySQL. I have very limited experience with SQL type
databases. MySQL appears to be a very elaborate product capable of many
things. I've glanced at the documentation before writing this. I have 2
very general question to all you 'experienced' MySQL users.
Question #1
Hi
By saying "mysql -u root mysql" you are telling mysql that you are going to use
the database mysql which you have to use to add new users. Another way of doing
it is type "mysql -u root" to log in and type "use mysql" in mysql command
line. "test" is a database created by mysql by default when
I just trying to run the below perl script and got the following error. Any
suggesstion pls.
# more training1.pl
#!/usr/bin/perl
use DBI;
$mysocket="/var/mysql.sock";
$dsn="dbi:mysql:training;mysql_socket=$mysocket";
$user="demo";
$password="demo";
$dbh=DBI->connect($dsn,$user,$pa
I have problem at compilation run MyODBC.
./configure --with-unixODBC=/usr/local/odbc \
--with-mysql-libs=/usr/lib/mysql \
--with-mysql-includes=/usr/include \
--prefix=/usr/local/odbc/lib
make
cd . && autoheader
/bin/sh ./libtool --mode=compile gcc -DHAVE_CON
Hi!
Sorry for the late reply, but I was away for a one week work/vacation
trip to Rio.
> "Richard" == Richard Reina <[EMAIL PROTECTED]> writes:
Richard> Steve,
Richard> I never received Mr. Van Engen's response. I appreciate your response.
Richard> However, my question remains unanswered
>Description:
When running ./configure it can't find LinuxThreads.
Environment: Linux 2.0.35
downloaded and expanded LinuxThreads-2.1.3.tar.gz.
It seems the tarball do not include pthread.h which
"configure" looks for.
>How-To-Repeat:
L
Hello there,
I just installed "mysql Ver 11.12 Distrib 3.23.33, for sun-solaris2.6 (sparc)". How
do I insert rows into mysql database.tablevia PERL ?. It would be appreciated if some
one can send some basic structure of connecting into sql using perl and some useful
links.
Thanks in advance.
Hi
I had pored for ages over the Manual prior to posting my problem. I've
solved it - all the methods given in the Manual dont apply to 2000. Manual
states the various start
methods etc apply to both NT and 2000. They don't, at least not for
Professional. Forget the --standalone, the skip- etc
hey,
replication was ruled out coz the writes are very very frequent. and consistency
of data is a very important issue.
tx.
vinod
- Original Message --
"Jason Landry" <[EMAIL PROTECTED]> wrote:
To:<[EMAIL PROTECTED]>,
"vinod panicker" <[EMAIL PROTECTED]>
From:"Jas
I'm assuming you're using PHP... this example is rather simplistic; you can
create a whole routine for building a select statment. You could have a
checkbox on the form that allows for AND/OR comparison (the name on the form
would be 'operator' in this example):
$query = "select * from $database
Have you considered replication? There's a pretty good chapter in the MySQL
manual on how to objectively determine the benefit to a master/slave setup
with n slaves (it depends on how often writes happen to the database).
- Original Message -
From: "vinod panicker" <[EMAIL PROTECTED]>
To
thanks a million... i've got another problem that i've been struggling with for a long
time now. It needs to be fixed fast.. running out of time... the problem is this -
i'm using PHP to connect to mysql using mysql_connect(). The script runs fine till a
certain number of users. This 'certai
Hi,
If you want to have 1000+ connections, you will need to modify and recompile
LinuxThreads. Afterwards, you'll need to recompile MySQL while linking with
the new libpthread.a library.
Check the following section from the manual:
http://www.mysql.com/doc/L/i/Linux.html
Regards,
Jorge
MySQL
aply logic in the app. i. e. build the where clause from the
filled in fields only:
$where = array() ;
foreach( $HTTP_GET_VARS as $v ) {
if( '' != $v ) {
$where[] = "'%$v%'" ;
}
}
$where = implode( ' OR ' , $where ) ;
$query = "select blah $where" ;
This is total
The following query
SELECT * from $database WHERE title LIKE '%$title%' OR quotation LIKE '%$quotation%'
does not work as desired, if one of the two query fields in the HTML form stays empty.
How do I do this query properly, leaving the user the opportunity to narrow the search
by filling in a
Hi,
We have been using MyODBC 2.50.36 and we are connected to MySQL server at Linux
(Red Hat 7.0 2.2.16-22) under MS Win98.
But we can't get a result from Win98-ODBC Linux's MySQL clients -q parameter.
-q parameter supplies "don't cache result, print it row by row".
How can w
hey,
i'm having a problem with scaling a mysql server. This is the situation... i have
a database with 5 tables containing user data. Except one, all the other tables have
only 2 fields. This data is queried often and needs to be accessed by multiple web
servers. Each table would contai
hey,
thanks for replying so soon. the max limit of files and inodes have been
increased on the system. So that is not a problem. But what i really meant to ask
was if mysql scales well over 1000 connections (assuming that i'm not having any
external problems like the OS for instance).
T
27 matches
Mail list logo
