On Sun, Jul 15, 2001 at 04:26:50PM -0700, Tom Gao wrote:
> Hi guys
>
> could someone tell me how I could force people to their enter
> password otherwise deny entry.
>
> I've looked through the mysql manual but I can't seem to find
> anything on this.
I'm not sure what you're after. As long as
Hi guys
could someone tell me how I could force people to their enter password otherwise deny
entry.
I've looked through the mysql manual but I can't seem to find anything on this.
your help is greatly appreciated.
Tom
Friends,
Wouldn't it be better if we kept the issues to be taken up by lawyers, once
they have already been hired and keep this discussion forum to serve the
larger purpose for which it was meant to ?
As a simple user of services, I am feeling very disappointed at the sight
of some of my
I guess I've lurked long enough.
I am a relative newbie to MySQL (and to all things SQL, actually.)
I am running MySQL 3.23.37 on my OpenBSD 2.8 server. (I currently support
6 different, non-related databases on the server)
Here is the problem... MySQL seems to open too many threads and die.
On Sat, Jul 14, 2001 at 11:12:21PM -0500, ryc wrote:
> I have a table that were created using innobase compiled with 64kb
> page tables. Now I want to upgrade to the newer version of innobase
> that supports the larger row sizes but as it mentions on the
> innobase .39b download page ( http://www
> C:\>mysql grant all on *.* to administrator@sara identified by "delboy"
Try this:
C:\>mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 463668 to server version: 3.23.39-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> grant a
Hello:
When attempting to perform rpm installation I get:
[root@...]# rpm -i MySQL-3.23.39-1.i386.rpm
error: MySQL-3.23.39-1.i386.rpm cannot be installed
I am running RedHat 7.0 kernel 2.2.16-22 on an i586 (AMD K6-2 to be
exact).
Thank you for your assistance.
Dylan Doxey
[EMAIL PROTECTED]
-
I have a table that were created using innobase compiled with 64kb page
tables. Now I want to upgrade to the newer version of innobase that supports
the larger row sizes but as it mentions on the innobase .39b download page
( http://www.innodb.com/download.html ) I must export the tables, and then
Reposting because of annoying filter.
On 15 Jul 2001 [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> database,sql,query,tabl
Hi,
What kind of Platform, MySQL Version, etc.?
is the mysql daemon running?
Guus
> -Original Message-
> From: Syed Sumair [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 12, 2001 3:12 AM
> To: [EMAIL PROTECTED]
> Subject: I am facing this error [ Urgent ]
>
> Warning: Can
hassan el forkani wrote:
>
> "First: take it to court. Potentially expensive, and probably not good for
> public relations for either party" probably the only sentence that makes
> sense in this "affaire"
>
> from a mysql user point of view, nusphere's move is completely amateur
>
> i can't s
Getting closer:
After fixing the form I get:
Add songs for Record Array
INSERT INTO songs VALUES (' blah', ' ***', ' ', ' 1', ' ')Songname[1]=:
blahblah
INSERT Failed, check the code.
Here is the code:
$vals='';
for ($i=0; $i<= $songsinalbum; $i++) {
$vals .=", ('$songname[$i]', '$rat
What to do do
I am facing this error !!
Warning: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2) in
/web/sites/188/pisps/www.pisps.f2s.com/signup/index.php on line 372
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/tmp/mysql.sock
Date |Sat, 14 Jul 2001 20:38:23 -0500
>From |Hank Marquardt <[EMAIL PROTECTED]>
Hello!
HM> Try RLIKE or REGEXP --
HM> http://www.mysql.com/docs/S/t/String_comparison_functions.html
Little typo.
right url : http://www.mysql.com/docs/S/t/String_comparison_functions.html
___
Hi Tim, lists:
m2o.pl, http://www.pythian.com/papers.shtml
Cheers,
Paul
--
Paul Vallee
The Pythian Group, Inc - Oracle DBA Outsourcing - www.pythian.com
[EMAIL PROTECTED] -- 613-565-8696
- Original Message -
From: "Tim Bunce" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROT
At 6:39 PM -0700 7/14/01, Bob Rea wrote:
>OK, mr newbie here. I'm trying to lern SQL using MySQL. I have a
>general SQL book, Sams Teach Yourself SQL in 10 Minutes, by Ben
>Forta. I also have mSQL and MySQL fromO'Reilly. And of course i have
>the MySQL Manual.
>
>The 10 minute book's syntax somet
"First: take it to court. Potentially expensive, and probably not good for
public relations for either party" probably the only sentence that makes
sense in this "affaire"
from a mysql user point of view, nusphere's move is completely amateur
i can't see any intelligent motivation for it, th
Try RLIKE or REGEXP --
http://www.mysql.com/docs/S/t/String_comparison_functions.html
On Sat, Jul 14, 2001 at 06:39:00PM -0700, Bob Rea wrote:
> OK, mr newbie here. I'm trying to lern SQL using MySQL. I have a
> general SQL book, Sams Teach Yourself SQL in 10 Minutes, by Ben
> Forta. I als
> > -Original Message-
> > From: Marten Mickos [mailto:[EMAIL PROTECTED]]
>
>
>
>
>
>
> > Our interpretation is that even under the interim agreement,
> > the operation
> > by NuSphere of mysql.org would have been a trademark violation.
>
> Then, Marten, tell us what the statu
community,
open source, gpl, tld's..
these are long, long discussions, some pertinent, though not to
this valuable list. i've read many opinions, respect some,
but these are for lawyers, not hackers (in linus' sense of
the word). nevertheless, there is a message for us nerds:
let's keep it open!
OK, mr newbie here. I'm trying to lern SQL using MySQL. I have a
general SQL book, Sams Teach Yourself SQL in 10 Minutes, by Ben
Forta. I also have mSQL and MySQL fromO'Reilly. And of course i have
the MySQL Manual.
The 10 minute book's syntax sometimes doesn't fit MySQL's, so I try
to find
Regarding the recent thread on NuSphere. ( Jeapardy style so you don't have
to read it again)
GPL violation or not, part of my decisions are always based on morals (hard
to find these days). Anyone trying to capture an audience using anothers
name is un-ethical and un-moral. My business decisi
> -Original Message-
> From: Marten Mickos [mailto:[EMAIL PROTECTED]]
> Our interpretation is that even under the interim agreement,
> the operation
> by NuSphere of mysql.org would have been a trademark violation.
Then, Marten, tell us what the status is of the trademark
app
Paul DuBois wrote:
>
> In the interests of stemming some of the flood of invective being
> directed against NuSphere...
[== snip, snip ==]
Paul:
I have a certain sympathy for your personal discomfort. I
feel that you/NuSphere are the "victims" of a kind of natural
aspect of the human condition
Thomas, thanks for your suggestions. A few clarifications below.
Thomas J Keller wrote:
> Marten Mickos wrote:
> > In response to the posting by Thomas J Keller of Britt Johnston's text, I
> > feel I have to come with the following comments.
> > (The quoted text marked with "> >" is by Britt
The more I think about this, the more convinced I am that someone needs to
offer the following observations:
It is unfortunate that so many people within this community are so eager to
assume the worst about a company, simply because they ARE a company. Not all
corporations are Mickey$lu$h (I
>
> This is very interesting, this "Open Source Legal Resolution" ;-)
>
Indeed it is.
The thing I find most interesting, and a bit scary, is the way people
seem to pick sides.
For example - "vermin", "scum", "obscure", are just a few of the words
recently used to describe the likes of Nu
Thanks for the help
I tried your code and received error.
Warning: No ending delimiter '^' found in addsongs.php on line 26
Songname: Array
INSERT Failed, check the code.
The code was: $vals=preg_replace('^,', '', $vals); // chop leading comma
Is the ^ an escape character so you can en
At 6:15 PM -0500 7/14/01, Paul DuBois wrote:
>At 3:15 PM -0700 7/14/01, xris wrote:
>>I have a very simple query that used to work and then recently stopped. It
>>goes something like:
>>
>>SELECT name FROM Items WHERE category RLIKE '^\* new cat \*';
>>
>>Now, I'm pretty familiar with how regex w
Marten Mickos wrote:
> In response to the posting by Thomas J Keller of Britt Johnston's text, I
> feel I have to come with the following comments.
> (The quoted text marked with "> >" is by Britt Johnston)
> >mysql.org has not been publically announced and it will take
> >some time for it to b
In the interests of stemming some of the flood of invective being
directed against NuSphere...
I am an employee of NuSphere.
Those of you who feel it necessary immediately to jump up and denounce
NuSphere for their sins, please ask yourself: Do you think I'd work for
them if I thought they wer
At 3:15 PM -0700 7/14/01, xris wrote:
>I have a very simple query that used to work and then recently stopped. It
>goes something like:
>
>SELECT name FROM Items WHERE category RLIKE '^\* new cat \*';
>
>Now, I'm pretty familiar with how regex works, and I was pretty sure that
>when I put a \ in
I have a very simple query that used to work and then recently stopped. It
goes something like:
SELECT name FROM Items WHERE category RLIKE '^\* new cat \*';
Now, I'm pretty familiar with how regex works, and I was pretty sure that
when I put a \ in front of the * it would interpret it as a * i
On 14-Jul-01 David wrote:
> I need to insert x amount of rows from one form. The form displays x
> amount of rows. I then need to insert the values from the form x amount
> of times. The form loop works fine but how do I INSERT x amount of
> times within a loop from the values of the form? I
In response to the posting by Thomas J Keller of Britt Johnston's text, I
feel I have to come with the following comments.
(The quoted text marked with ">" is by Britt Johnston)
>mysql.org has not been publically announced and it will take
>some time for it to become the thriving community it
While loops are quite dangerous when the stop condition never
occurs. This is the case here. You must increment $i to get a
break condition to step out of the loop! Insert $i++; in your
code and you will be fine.
> This executes when submit is hit:
> $i = 1;
> while ($i <= $songsinalbum) {
> $qu
Or, you could take Grigory's suggestion a step further and make a shell
script ...
#
#!/bin/sh
# $1 - Windows filename with extension (case counts)
# $2 - Unix filename with extension (case as you want it)
cat $1|tr -d '\r' >$2
###
On Tue, Jul 10, 2001 at 10:11:05AM +0200, Wolf Dieter Brandt wrote:
> Hi!
>
> I am currently installing and testing the latest stable version of
> mysql with an sunblade 1000 workstations (2 cpu, 750 MHz, 1 GB RAM).
>
> Does anybody know some hints how to tune the OS (solaris performance
> tunin
I need to insert x amount of rows from one form. The form displays x
amount of rows. I then need to insert the values from the form x amount
of times. The form loop works fine but how do I INSERT x amount of
times within a loop from the values of the form? I think I need to use
some sort of ar
I recall that maybe a month or four ago someone posted a message (on
the [EMAIL PROTECTED] list I think) saying that they'd written a
utility to parse MySQL create table statements and write out equivalent
Oracle create table statements.
I remember replying to the message (possibly privately) and
Alright. I have received Mr. Johnson's permission to share the email response
he made to me. it is included herewith for informational purposes without
comment or prejudice:
cut here
mysql.org has not been publically announced and it will take
some time for it to become the th
> At 05:19 PM 07/13/2001 , you wrote:
> >Hi,
> >
> >I would like to be able to create some tables in a database on an SQL server
> >at my web provider, then access those tables via a client application
> >running on my PC over the Internet (dial-up connection). My understanding is
> >that the clie
At 1:10 PM -0500 7/14/01, Bill Omer wrote:
>I was able to use mysqldump to 'dump' the databases in to a file. However,
>I'm not able to figure out how I can recreate the databases on the new server
>using this file.
>
>Any suggestions?
It contains SQL statements. Feed it to mysql:
mysq
>At 12:25 PM -0500 7/14/01, Paul DuBois wrote:
>>>Any solution I've tried using the LassoMySQL/var/my.cnf or
>>>~/.my.cnf files affect both the special installation as well as
>>>the standard MySQL installation. I find I will always get the
>>>standard port.
>>
>>Settings in the [client] group
Jorge,
I am spending considerable time working with
MySQL...DB2...Sybase..PostgreSQL
I am deciding on Project development tools..
Each RDBMS has some short coming for me..
Addressing MySQL which I like very much..
I use v. 3.22.32 because there is not a binary RPM
for Caldera 2.3 and 2
using mysqlimport
Usage: mysqlimport [OPTIONS] database textfile...
HTH
--
Bill Omer wrote:
>
> I was able to use mysqldump to 'dump' the databases in to a file. However,
> I'm not able to figure out how I can recreate the databases on the new server
> using this file.
>
> Any suggestions?
>
At 05:19 PM 07/13/2001 , you wrote:
>Hi,
>
>I would like to be able to create some tables in a database on an SQL server
>at my web provider, then access those tables via a client application
>running on my PC over the Internet (dial-up connection). My understanding is
>that the client application
At 12:51 PM -0500 7/14/01, MikeBlezien wrote:
>is this the default location it looks for a 'my.cnf' file or can
>this be defined
>some where?
Straight from the manual:
4.16.5 Option Files
MySQL Version 3.22 can read default startup options for the server
and for clients from option files. MyS
Date |Sat, 14 Jul 2001 13:34:40 -0400
>From |"Fred Dinkler" <[EMAIL PROTECTED]>
Hello!
FD> Creating and editing dbdump SQL files from local dev in Win2k, moving to
FD> Linux for QA and production.
FD> Text files edited using Wordpad and Notepad have extraneous line-end chars
FD> (bold M).
FD>
Date |Sat, 14 Jul 2001 13:34:40 -0400
>From |"Fred Dinkler" <[EMAIL PROTECTED]>
Hello!
FD> Creating and editing dbdump SQL files from local dev in Win2k, moving to
FD> Linux for QA and production.
FD> Text files edited using Wordpad and Notepad have extraneous line-end chars
FD> (bold M).
FD>
I was able to use mysqldump to 'dump' the databases in to a file. However,
I'm not able to figure out how I can recreate the databases on the new server
using this file.
Any suggestions?
Thanks,
Bill Omer
On Friday 13 July 2001 16:04, Tillema, Glenn wrote:
> Bill,
>
>
> I think you want to u
At 12:51 PM -0500 7/14/01, MikeBlezien wrote:
> >>On Sat, 14 Jul 2001 11:46:15 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote:
>
>>>
Also if a /etc/my.cnf is going to be used, once it's
been created does the MySQL server need to be shutdown and restarted to
recognize the new my.cnf
At 12:25 PM -0500 7/14/01, Paul DuBois wrote:
>>Any solution I've tried using the LassoMySQL/var/my.cnf or
>>~/.my.cnf files affect both the special installation as well as the
>>standard MySQL installation. I find I will always get the standard
>>port.
>
>Settings in the [client] group of your
Britt Johnston wrote:
>
> As far as mysql.org goes, what NuSphere would like to see is a
> non-profit organization running that site - we have been consistent
> in this desire for over a year, but it has been opposed by Monty
> and David. I discussed this with Monty as recently as a few weeks
>
>>On Sat, 14 Jul 2001 11:46:15 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote:
>>
>>> Also if a /etc/my.cnf is going to be used, once it's
>>>been created does the MySQL server need to be shutdown and restarted to
>>>recognize the new my.cnf file??
>>
>>Yes.
is this the default location it look
On 14-Jul-01 Fred Dinkler wrote:
> Creating and editing dbdump SQL files from local dev in Win2k, moving to
> Linux for QA and production.
>
> Text files edited using Wordpad and Notepad have extraneous line-end chars
> (bold M).
>
> Any suggestions on configuration of any Win editor to save te
Creating and editing dbdump SQL files from local dev in Win2k, moving to
Linux for QA and production.
Text files edited using Wordpad and Notepad have extraneous line-end chars
(bold M).
Any suggestions on configuration of any Win editor to save text without
garbage chars showing up on Liux side
At 10:11 AM -0700 7/14/01, Michael Collins wrote:
>At 11:46 AM -0500 7/14/01, Paul DuBois wrote:
>>At 11:32 AM -0500 7/14/01, MikeBlezien wrote:
>>>when you do a mysqladmin variables, where exactly are these
>>>variables stored,
>>>and can they be changed.
>>
>>They can be changed by placing set-
At 11:46 AM -0500 7/14/01, Paul DuBois wrote:
>At 11:32 AM -0500 7/14/01, MikeBlezien wrote:
>>when you do a mysqladmin variables, where exactly are these variables stored,
>>and can they be changed.
>
>They can be changed by placing set-variable= var_name=var_value lines
>in the [mysqld] group of
At 11:32 AM -0500 7/14/01, MikeBlezien wrote:
>when you do a mysqladmin variables, where exactly are these variables stored,
>and can they be changed.
They can be changed by placing set-variable= var_name=var_value lines
in the [mysqld] group of the /etc/my.cnf option file (or any other option
fi
Thanks Mr. Sinisa, but Mr. Miguel Angel could reproduce it, maybe you may ask him
about details, since he is a mysql developer he can tell you about the problem.
I am sure there are more mysql (3.23.39) bugs specially related to the wrapper support.
Any away i am really curious about the facts
when you do a mysqladmin variables, where exactly are these variables stored,
and can they be changed. Also if a /etc/my.cnf is going to be used, once it's
been created does the MySQL server need to be shutdown and restarted to
recognize the new my.cnf file??
Again, Thx for the help :)
Mike(mick
I have a customer who needs to have a very secure site, more secure than
usual, he thinks that having a secure server is not enough so what kind
of security for his transactions can I offer him? we are not talking
about money transfers, his bussines is not about money is about
information, I n
Sorry for the last post with no response. In my anger, I hit reply by accident.
I usually resist the urge to flame publicly.
When I first posted about this topic I thought that the domain name
issue was the only transgression, I did not realize how deep it went.
Now I feel truly disgusted by the
Shouldn't you say localhost instead This is what I do. If you
want to connect to a server not on your machine, you must have
extra right. Most ISPs won't do that for security reasons.
Sie schrieben am Samstag, 14. Juli 2001, 16:10:52:
> Thanks for all who responded. Here is the error message
Hi,
I crash one table, and some datas are completely corrupted. However, myisamchk doesn't
seem to see any errors (I try -e, -o and -r option)...
Here is an extract of the table :
mysql> SELECT * FROM forumconthardwarefr6 order by date desc limit 0,20;
+---
David Axmark wrote:
>
> > "Britt" == Britt Johnston <[EMAIL PROTECTED]> writes:
>
> Since Monty is travelling for 30 hours or so (from Australia) I will
> answer this.
[== snip, snip ==]
WOW!
Does everyone realize what is going on here? I don't know,
I consider this stuff historic. Perha
At 3:10 AM -0400 7/14/01, Britt Johnston wrote:
>Well, what a mess. It is regretable that this legal issue
>needs to be aired so publically that was certainly not my
>preference. I also will not get into a flame war, it is
>not in the best interest of mysql. I appreciate all the
>email I've rece
Sinisa,
SM> It is the same. Replication works already with all table handlers,
SM> but all that remains to be solved is ROLLBACK.
What could be the problem is servers are recording in their
binary log only committed transactions ?
Why should ROLLBACK be implemented in replication
I have this message and I don't understand, plase help me.
[root@cyril guest]# rpm -U
/home/guest/Desktop/MySQL/MySQL-DBI-perl-bin-1.825-1.i386.rpm
error: failed dependencies:
DBI-perl-bin >= 0.93 is needed by mysql-DBI-perl-bin-1.825-1
[root@cyril guest]#
--
mysql --version
mysql Ver 11.15 Distrib 3.23.39, for pc-linux-gnu (i586)
mysql wont start and mysql error log says
/usr/local/mysql/bin/mysqld: unrecognized option
`--defaults-extra-file=/usr/local/mysql/data/my.cnf'
I tracked that down to the "/usr/local/mysql/bin/safe_mysqld" scr
Thanks for all who responded. Here is the error message I get when I try to
connect to my current WSP:
MySQL Error Code: (1130)
"Host '63:160.226.3' is not allowed to connect to this MySQL server"
It looks like I need to find a new WSP. My current WSP is WebSiteSource
(www.websitesource.com), an
SM> I am sending a patch straight to you
Do someone see improvements compiling Mysql with Gcc 3.0 ?
Regards,
Alex.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.my
"David" <[EMAIL PROTECTED]> wrote:
> I have two tables under the one database. What is the best way to
> INSERT data into both tables at once. Can I use one INSERT statement or
> do I have to use two?
Two inserts are required. You can insert multiple rows into a table via a
single insert, but
> "Britt" == Britt Johnston <[EMAIL PROTECTED]> writes:
Since Monty is travelling for 30 hours or so (from Australia) I will
answer this.
Britt> Well, what a mess. It is regretable that this legal issue
Britt> needs to be aired so publically that was certainly not my
Britt> preference. I
Hi
Ok, having sorted out my scripts, I'm understanding the concepts of Mqsql quite well,
however, before i got too far into creating and manipulating data I want to understand
the security issues. I run the mysql server on a win2K box and use the client from
the same machine, therefore I can
Michael,
MW> What NuSphere seems to be trying to do is to get people to approve
MW> of their fork, get more people to work on it, and cause confusion
MW> among MySQL users as to where the origin of the MySQL(tm) source
MW> and documentation is. What NuSphere has done indicates that they
MW>
Hello All,
We just installed MySQL 3.23.39 on a Redhat/Linux6.2 system,..so far so good. We
have about 30 customers who are currently using various dbs and was wondering if
someone could recommend or has setup some sort of automated back up system for
the db's. We use the mysqldump utility do bac
("sql", to make the mail go through ;)
On Fri, 13 Jul 2001, Colin Faber wrote:
> This has been discussed to death on the freebsd mailing lists, The over
> all feeling was to add such a system would `break' most of the clients
> that subscribe and would eliminate the open mailing list we have now
Justin,
I very much agree with your compliment to Jeremy for his posting.
Some notes on your posting follow.
At 14/07/01 14:03 +0200, Justin wrote:
>Personally, I could care less about the mysql.org
>domain issue. I, more or less, see it just as another
>kind of ex-officio site supporting some
At 23:21 13/07/2001 -0300, Gustavo Vieira Gonçalves Coelho Rios wrote:
Hi,
Thanks for the bug report. I was be able to repeat and the issue
should be fixed in the next release.
Regards,
Miguel
> >Description:
> MySQL Daemon crashes when a user with the necessary privileges
> issue a qu
Will the following be in version 4 as well?
UPDATE table1
SET cola = SELECT [colb]
FROM table2
WHERE table1.id = table2.id
And sub-selects as well?
Thanks,
Kevin
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: S
> when you run myisamchk it try to find the .MYI file.
> If you try to run myisamchk on the MYD file, it says that the key definition
> is incorrect (which seems to be normal ;))
The key definition should be part of the .frm file, in my
understanding. Oh, I see, myisamchk is invoked on that very
Hi!
Unions will soon come in 4.0.
Meanwhile, your query can utilize indices if you have a composite
index on seller and buyer.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Dev
Gustavo Vieira Gonçalves Coelho Rios writes:
> >Description:
> MySQL Daemon crashes when a user with the necessary privileges issue a query
>"show logs"
> >How-To-Repeat:
> Start your daemon with the option --skip-bdb:
> your-shell> safe_mysqld --skip-bdb
>
> Then, issue
Christian Jaeger writes:
> At 16:17 Uhr +0300 13.7.2001, Sinisa Milivojevic wrote:
> Hi!
>
> We have been planning to use mysql/innodb with replication soon
> (mid/end of august). http://www.mysql.com/doc/B/i/Binary_log.html
> suggests that replication should work with "transactional table(s)
Lance Lovette writes:
> I recently upgraded from MySQL 3.23.36 to 3.23.39 and now the following
> query fails.
>
> > SELECT DISTINCT Ring.*, Question.DefaultRingID, COUNT(RingMember.UserID)
> AS MemberCount FROM Ring, Question, QuestionXQuestionCategory,
> BrandXQuestionCategory LEFT JOIN RingMem
[EMAIL PROTECTED] writes:
> The patch below syncs AC_SYS_LARGEFILE with the version shipping with
> autoconf 2.50. This is against MySQL 3.23.39.
>
> --
> albert chin ([EMAIL PROTECTED])
>
Thank you for your contribution.>
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /
Thank you for your bug report.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
-
I have two tables under the one database. What is the best way to
INSERT data into both tables at once. Can I use one INSERT statement or
do I have to use two?
-
Before posting, please check:
http://www.mysql.com/manual.php
Colin Faber writes:
> Michael, Interesting idea but I think it would problematic over all,
> The mysql manual changes almost everyday (anyone that syncs the bk
> tree's knows) I would suggest a better solution would be to provide the
> manual as a localized application (possibly even ported to
Venu Anuganti writes:
> Hi Kevin
>
> Can you please send us the ODBC trace generated by MyODBC as well as ODBC DM
> ?
>
> Thank you
> Venu Anuganti
Hi!
This was simply a case that Access table did not have auto-increment
and timestamp columns in it.
Unfortunately, there are some restrictions
Hi,
I am taking some value from a html form which has one text area filed
and inserting this
value into the table along some other values.
I am using this in servlets and the value is getting from
request.getParameter("test");
When i am trying to insert the following value into the text field
Jeremy Zawodny wrote:
>
[== snip, snip ==]
Jeremy:
You should be complimented for giving us a measured and
rational posting on this potentially emotional issue.
And also, it is good that Britt has clearly stated his
understanding, though perhaps a bit too late to have
prevented one of those com
On Fri, Jul 13, 2001 at 09:40:55AM -0200, Mario Witte wrote:
> I'm searching for a tool which will provide statistics about the
> usage of a mysql-server like avg queries/minute, cpu load etc.
Other folks have made good suggestions.
If you want something quick and interactive, mytop may give yo
On Sat, Jul 14, 2001 at 01:04:41AM +0200, Fournier Jocelyn [Presence-PC] wrote:
> Hi,
>
> I'm administrating a machine which has just badly crashed, and a MYI
> file has disappeared for one table. Is this possible to repair this
> table?
Try to touch the file (to create an empty one), and see i
On Sat, Jul 14, 2001 at 03:10:34AM -0400, Britt Johnston wrote:
> Well, what a mess. It is regretable that this legal issue needs to
> be aired so publically that was certainly not my preference. I also
> will not get into a flame war, it is not in the best interest of
> mysql. I appreciate all
On Sat, Jul 14, 2001 at 12:09:13AM +0400, Ilya Martynov wrote:
>
> After some thinking I've came up with next solution. When both
> servers are up theirs mysqld are setup to have two-way
> replication. Since both servers serve completely independent
> projects and these projects use different set
On Fri, Jul 13, 2001 at 08:44:54PM -0700, William M. Shubert wrote:
> Ugh, I couldn't find the mailing list archives until I looked at the
> bottom of my own message that got mailed back to me! I searched,
> found out about the temporary table workaround for no unions, sorry
> for bothering you a
On Sat, Jul 14, 2001 at 01:27:36AM -0700, Jim Matzdorff wrote:
> Hello all,
>
> I was wondering, is it possible to have different log files for
> different databases somehow?
RedBack? You're just down the street... Sort of.
Anyway, right now there's not an easy solution that I know of. But
havi
1 - 100 of 103 matches
Mail list logo