On Sun, Aug 05, 2001 at 11:42:53PM -0700, Schajee Achmad wrote:
>
> Hi, Sorry to bother you people but I've just locked myself out of my
> own DB. I was installing some stupid program which required me to do
> some changes in the permissions and now I get this error "Access
> Denied for user: 'roo
On 05 August 2001 23:42 -0700 Schajee Achmad wrote,
> now I get this error "Access Denied
> for user: 'root@localhost' (Using password: NO).
>
> I've tried several ways o get out of this mess, even
> the documentation of MySQL but there is no mention of
> this error.
Run up mysql with the '--ski
Hi, Sorry to bother you people but I've just locked
myself out of my own DB. I was installing some stupid
program which required me to do some changes in the
permissions and now I get this error "Access Denied
for user: 'root@localhost' (Using password: NO).
I've tried several ways o get out of t
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?
>
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 sus
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 of
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 Sy
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 try
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 acc
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 l
> 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 on
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)
Dennis,
>From what I've read on the KDE Home page (www.kde.org), they
seem to have trouble with the inheritance implementation in gcc3.0.
I wouldn't bet money on a gcc3.0 compiled production system yet.
Although I don't know much about the implementation of MySQL,
I suspect they might run into
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 solutions
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), and
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.
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
$results[0][
>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 p
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]>
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
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 convention
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 the
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 ..
?
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/
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: <[E
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] [
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´ un
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, co
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 set
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
s
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_ref
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
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 norm
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
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 datab
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 instruct
Hi!
> "miguel" == miguel >
>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 in our
miguel> literature the inst
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).
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Adam Douglas writes:
>> 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 see
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Adam Douglas writes:
Sinisa>
>>
>> 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 t
Hi all,
It is possible supports mysql 3.23.40, scrollability and updatability width JDBC2?
In what terms?
Regards
41 matches
Mail list logo
