Hi all,
It is possible supports mysql 3.23.40, scrollability and updatability width JDBC2?
In what terms?
Regards
Hi!
Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes:
Sinisa Adam Douglas writes:
Sinisa cut
Alright, but is there no way then to decrease my query time of 14 seconds
(includes 3 queries) to something more reasonable for use on-line? 10
seconds according to stats is the maximum
Hi!
Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes:
Sinisa Adam Douglas writes:
cut
Another thing that happens is when I tried to ALTER PostalCodeInfo and
PostalCodeReps table schemas MySQL seemed to be hung and put the CPU usage
at 99.0% to 99.02% (never ending it seems). Both
Hi1
Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes:
Sinisa Liz Marlow writes:
We've upgraded from 3.22.27 to 3.23.39 to utilise replication but have found
that this version is significantly slower that our old version (we haven't
switched replication on yet either). Has anyone else
Hi!
miguel == miguel Angel =?iso-8859-1?Q?Sol=F3rzano?= [EMAIL PROTECTED]
writes:
miguel At 10:08 01/08/2001 +0200, Cynic wrote:
miguel Hi Cynic,
Hi Miguel,
I'm forwarding you this as suggested by John Dean. Can you comment?
miguel First I agree with you that is necessary to introduce
Hi!
Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes:
Sinisa Mark Tully writes:
From: Mark Tully [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: mySQLd won't die under Darwin (Mac OS X 10.0.4)
Description:
Downloaded source archive, compiled as of instructions.
The mySQLd server
Hi,
Agent Smith wrote:
Hi everybody,
I got a problem with the mysqldump function.
I connect to mySql trough phpMyAdmin, select the database xyz, which
is the only database on the server.
Then I enter the following string into the text field Run SQL
query/queries on database xyz::
Vladimir Zidar writes:
Description:
mysql refuses connection [local/unix-socket] when client is ran under GDB,
and linked with pthread library. It doesn't need to call any pthread_*()
function, it just fails when linked with it.
How-To-Repeat:
#include stdio.h
At 17:04 8/4/2001, Michael Widenius wrote the following:
--
What's the vcpp.exe package ? Is this VC++ 6.0 ?
I guess that's the Processor Pack. It's a free download from
Microsoft that contains a free version of MASM 6.xx.
For
hi...
i have a table as follows:
refsmallint(5)
product_refsmallint(5)
ratingsmallint(1)
is there any way i can get the average rating for each product_ref?
for example...
refp_refrating
114
21
Jamie Burns wrote:
hi...
i have a table as follows:
refsmallint(5)
product_refsmallint(5)
ratingsmallint(1)
is there any way i can get the average rating for each product_ref?
for example...
refp_refrating
Dear Agent Smith,
as said, mysqldump is a command line program, not an SQL command.
In PhpMyAdmin, use the CSV or SQL dump function built in. To dump a
database, select the database (left frame), then click dump database
(right frame), best with options structure and data, with drop table
Hi
A few weeks back someone was kind enough to mail me the settings to change the
command.com statement so that I didn't have to work out of the /mysql/bin directory.
I have since had a fatal pc crash, and have managed to lost the email, and the hard
copy.
If anyone would be so kind as to
Hi All.
Strange thing.The query below:
select concat(domain,path,file) as url, title, '' as blank1, docdate, size,
date as lastmod, 'keywords' as keyw, description as descr, a.ID, sum((word
like 'acc')) as r, ( sum(word like 'acc')) as qu, f.ID, author,
class,charset,lang,'content' as content,
Hi,
i get the following error when trying to compile MYSQL 3.23.40 with only
the --prefix option set:
complete.c: In funtion `filename_completion_function´:
complete.c:1467: syntax error before `*´
complete.c:1481: `directory´ undeclared (first use in this function)
complete.c:1484: `DIR´
Sara ...
Not sure what you're looking for, but I would put MYSQL\BIN in the DOS path
...
PATH=%PATH%;C:\MYSQL\BIN
There are a number of command-line optiosn with COMMAND.COM, but I'm not
sure how any might relate to MySQL ...
COMMAND [[drive:]path] [device] [/E:n] [/L:] [/U:nnn] [/P]
The command is path=c:\mysql\bin
*
Earn a dime every time you receive email!
Sign up FREE at:
http://www.MintMail.com/?m=666501
*
- Original Message -
From: Sara [EMAIL PROTECTED]
To: [EMAIL
Hi,
I'd like to add a function MD5() to mysql with CREATE FUNCTION
Someone can help me ? I know nothing in C
Philippe
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Lets say i have 10.000 rows in a table and im searching for only one record(one row).
Which one is faster:
SELECT ... LIMIT 1
or just
SELECT ..
?
On Sun, 5 Aug 2001, SOHM Philippe wrote:
Hi,
I'd like to add a function MD5() to mysql with CREATE FUNCTION
Someone can help me ? I know nothing in C
Philippe
That might be a problem if you wnat to compile in your own function.
You might want to try a UDF instead. I don't use them
On 05-Aug-2001 SOHM Philippe wrote:
Hi,
I'd like to add a function MD5() to mysql with CREATE FUNCTION
Someone can help me ? I know nothing in C
Creating a user defined function (UDF) means compiling a shared library;
most any language can be used if it supports C call/return conventions.
hi..
can someone tell me how i get the data from two tables, where table1 will have one
row, and table2 will have many rows?
eg:
table1:
idname
1barney
2fred
3wilma
table2:
idstudent_id subject
11
Are you looking for:
SELECT table1.name, table2.subject
FROM table1, table2
WHERE table1.id=table2.student_id
Good Luck,
Dennis
**
Beridney Computer Services
http://www.beridney.com
- Original Message -
From: Jamie Burns [EMAIL PROTECTED]
Description:
When compiling with gcc-3.0 there are problems with
libstdc++, which is not linked to the executables
There also seems to be a problem with libwrap, who is
complaining about functions being called with wrong number
of arguments (this is not a
that is the answer, but i think i was looking for something different.
because i am using php, i am used to results being returned in an array, and
was hoping to get this sort of thing out...
$results[0]['id']// table1.id
$results[0]['name']// table1.name
Dear Sara,
was it PATH c:\mysql\bin ? This will set the DOS search path to the
specified directory, so you can type mysql for instance and DOS will
find mysql.exe, without changing to the specified directory with cd
To permanently save the path settings, write them in c:\autoexec.bat. If
Dear Ivan,
I am full of admiration for your huge number of left joins in this
query! :-)
Looks quite funny to me how a SELECT can produce an error that you would
expect from an INSERT query. Anyway, try to type this query into a
multi-line command line (MySQL Monitor, the command line tool),
Dear Jamie,
try a JOIN (LEFT JOIN I would suppose for your problem). Read the MySQL
manual chapter 7 (look for the join syntax there). It is something like
SELECT * FROM table1 LEFT JOIN table2 ON (table1.id = table2.id)
Regards,
Stefan Hinz (Geschäftsleitung)
iConnect e-commerce
Dear Jamie,
in PHP, the mysql_query(SELECT ... LEFT JOIN ...) will return exactly
what you need. Try something like
WHILE ($i mysql_num_rows) {
for ($j = 0; $j mysql_num_fields; $j++){
$i[$j];
}
$i++;
}
Regards,
Stefan Hinz (Geschäftsleitung)
Lets say i have 10.000 rows in a table and im searching for only
one record(one row).
Which one is faster:
SELECT ... LIMIT 1
or just
SELECT ..
The former, since MySQL stops after finding the first row. In the second
query, MySQL prepares the entire result set even if you only
I am trying to GRANT access to user [EMAIL PROTECTED] MYSQL has a
problem with the white-home portion of the domain name. I have tried
several ways to get around this including quoting the string. So I used the
'%' to grant access but then the mm.mysql JDBC API uses xyz.white-home.com
and not
On Sun, Aug 05, 2001 at 06:07:36PM -0600, Mike White wrote:
I am trying to GRANT access to user [EMAIL PROTECTED] MYSQL has a
problem with the white-home portion of the domain name. I have tried
several ways to get around this including quoting the string. So I used the
'%' to grant access
That's it! Thanks so much for the help.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 05, 2001 6:27 PM
To: Mike White
Cc: [EMAIL PROTECTED]
Subject: Re: Problem with Domain name
On Sun, Aug 05, 2001 at 06:07:36PM -0600, Mike White wrote:
I am
I am getting link error when I try to compile with the mysqlclient library.
I tried adding -lgz at the end of my link line as the documentation
suggests. It cannot find -lgz
What can I do to fix this?
Thanks,
Caryl Rahn
Senior Operations Programmer
Siemens Building Technologies, Inc.
Security
Hello:-)
A few days ago, I saw a lot of questions (and solutions) to backing up Mysql
Databases and tables. One question kind of struck me and I did come up with
a little python script if anyone is interested that is able to backup and/or
restore the entire Mysql set of Databases. This is
In the past few weeks, I tried to install the below development platform in
order for me to do MYSQL and PERL and PHP web applicaton offline.
1. Linux 6.0
2. Mysql (Binary Version)
3. DBI 1.68
4. gcc 2.81
5. msql-mysyql perl module
However, I still can't get No.5 to install on that system. I
Hi !
-Original Message-
From: razvan [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 05, 2001 12:18 PM
To: [EMAIL PROTECTED]
Subject: mysql updatability +JDBC2
Hi all,
It is possible supports mysql 3.23.40, scrollability and
updatability width JDBC2?
In what terms?
Yes.
37 matches
Mail list logo