James,
I took the liberty of forwarding your requests to
[EMAIL PROTECTED]
I hope you don't mind.
For those who are not familiar with poor James's situation, I offer
(again) these links:
http://home.rica.net/alphae/419coal/
http://www.ksu.edu/InfoTech/news/2002/08-20emailscam.htm
Hi,
> I have written previous websites where I used perl or PHP
> to access a Mysql DB wen bith the webserver and the Mysql
> db are on the same server.
>
> My questions is how different is it to access or connect
> to the Mysql database when the database is on a separate
> server(machine)?
Just
I have written previous websites where I used perl or PHP
to access a Mysql DB wen bith the webserver and the Mysql
db are on the same server.
My questions is how different is it to access or connect
to the Mysql database when the database is on a separate
server(machine)?
Thanks,
Nestor A.
On Wed, Aug 28, 2002 at 05:33:57PM -0500, Naushit Sakarvadia wrote:
> Is it possible to limit size of table?
>
> For example I want xyz table to limit 1 GB and once it reaches
> 1 GB it should start overwriting oldest data.
>
> Is it possible to do this in Mysql? or is there any client that ca
> When you say "bystander", are you referring to yourself of me?
Poor grammar, my bad. I am the bystander.
> Indeed Microsoft, Lotus, Word Perfect, Borland, Oracle and every other major
> software manufacturer in the world has missed deadlines, stuff happens.
So we have a software company that
I'm not having much luck using JNDI to connect to MySQL from Tomcat using
MySQL Connector. I was working towards getting connection pooling working.
I get the following error when I try to connect to the data source:
javax.naming.NamingException: Exception creating DataSource:
org.hsql.jdbcDriv
On Wed, Aug 28, 2002 at 01:02:11PM -0400, Will French wrote:
> >> So they gave you all the details they could.
>
> Did they? That was my whole argument. Over the past 6 months I have read
> no fewer than 10 responses from the team which have, in effect, said "we
> don't know, quit bugging us."
Securest? Yes, maybe. But first of all the security of a web site does not
depend on the password encoding system (PASSWORD or MD5) you use in the
MySQL database. (I mean firewalls, good OS, so on.)
At 00:32 2002.08.29. -0400, you wrote:
>so md5 would be the securest way to handle password secu
In the last episode (Aug 29), suresh said:
> I dont really get your point Another thing I would like to highlight
> I thought UNION will be used to join to SQL Queries and will display
> only distinct values unless UNION ALL is used
>
> I don't know why the result is wierd or I do some misunderst
On Tue, Aug 27, 2002 at 10:51:09PM -0400, Will French wrote:
>
> Obviously you don't agree with me and that is something I readily
> accept. I do have difficulty with the fact that you clearly spent
> more time typing your response than considering my points, which
> were intended to be construct
Hi there
looking for some help to run this in a php file mysql -e "drop table
job" test
Cheers
Trevor
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
At 12:02 +0900 8/29/02, suresh wrote:
>Hi
>I changed from mysql 3.23.49 -nt to 4.0.2 max to make use of union
>
>But one problem when trying to join tables is that UNION works
>only for SELECT queries with same number of coulmns.
Well, that's how UNION works.
> Is there any way to join 3 or
At 20:17 -0700 8/28/02, neal wrote:
>Here's an odd one. I am connecting via JDBC using an account that
>apparently has no permissions granted to it ... even select_priv (straight
>Ns across the table). And yet ... I can do select statements with it ...
>no problem.
>
>How could that be?
Probab
At 20:05 -0700 8/28/02, neal wrote:
>Alright ... I figured it out (sort of)...
>
>When I created a user account I put the value '%' in the host field of the
>mysql.user table. I was following the example of the root account that was
>already specified in the table. Apparently if I make that if I
so md5 would be the securest way to handle password security for a website?
Randy
- Original Message -
From: "Daniel Kiss" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 29, 2002 12:19 AM
Subject: Re: mysql password ( )
> Hi,
>
> The password() function is a "one wa
Hi,
The password() function is a "one way encoder". In other words it just
generates some kind of checksum of the input parameter.
So you cannot decrypt them, but it is much safer than encrypting and
decrypting strings, because even the attacker cannot decrypt them. :-)
You can use it this way
did you flush privileges after setting the password? % stands for wildcard
:)
- Original Message -
From: "neal" <[EMAIL PROTECTED]>
To: "mySQL" <[EMAIL PROTECTED]>
Sent: Thursday, August 29, 2002 10:47 AM
Subject: RE: JDBC - Access denied REVISED = simply won't accept passwords
when loggi
In the last episode (Aug 29), suresh said:
> I changed from mysql 3.23.49 -nt to 4.0.2 max to make use of union
>
> But one problem when trying to join tables is that UNION works only
> for SELECT queries with same number of coulmns. Is there any way to
> join 3 or more tables having different
You should be able to acheive all of that via a web interface using
PHP-MySql. It will only be a matter of designing the user interface
correctly (eg: check boxes for all categories a book can belong to).
Bhavin.
- Original Message -
From: "David Powell (PeakCare QLD)" <[EMAIL PROTECTED]>
Let me revise the problem description:
Both mySQL Front *AND* JDBC can connect if I do not specify a password when
logging in...EVEN IF A PASSWORD IS SPECIFIED IN THE ACCOUNT. Yet, if I
specify the password while logging in (a scenario that SHOULD work), I am
declined.
Obviously I am a mySQL ne
Well, it looks like the issue was resolved by changing host from "%" to
"localhost". I don't understand what the "%" is, but that apparently that
fixed it.
I'm pretty sure its not the older driver issue ... this is the first install
of connector/J I've ever put on this machine, and I'm using 3.0
Here's an odd one. I am connecting via JDBC using an account that
apparently has no permissions granted to it ... even select_priv (straight
Ns across the table). And yet ... I can do select statements with it ...
no problem.
How could that be?
Is is possible this could be related to the prev
Alright ... I figured it out (sort of)...
When I created a user account I put the value '%' in the host field of the
mysql.user table. I was following the example of the root account that was
already specified in the table. Apparently if I make that if I change that
'%' to 'localhost' its fine.
neal wrote:
> Thanks for the response.
>
> I am using this (where 'bob' is both the uid and the pwd value):
>
> Connection myConn =
> DriverManager.getConnection("jdbc:mysql:///test?user=bob&password=bob");
>
> That does not work. Dispite having specified a password of 'bob', this DOES
> work:
Hi
I changed from mysql 3.23.49 -nt to 4.0.2 max to make use of union
But one problem when trying to join tables is that UNION works only for
SELECT queries with same number of coulmns. Is there any way to join 3 or
more tables having different columns using UNION? I am writing my query
dur
At 17:51 +0300 8/28/02, Victoria Reznichenko wrote:
>Markus,
>Wednesday, August 28, 2002, 3:48:42 PM, you wrote:
>
>MR> we are using mysql 3.23... for our webservices.=20
>MR> the following question about grant:
>MR> granting grant option to a user has the consequence, that this
>user can grant t
> Binaries for MS Windows as well as "Max" binaries are also under
preparation
> and will be added to the web pages as soon as they are ready
Fine :)
I couldn't find a feature matrix where I can figure out the difference
between standard mysql 4.0.x to the max-version.
InnoDB is part of s
Thanks for the response.
I am using this (where 'bob' is both the uid and the pwd value):
Connection myConn =
DriverManager.getConnection("jdbc:mysql:///test?user=bob&password=bob");
That does not work. Dispite having specified a password of 'bob', this DOES
work:
Connection myConn =
DriverMa
Hello.
On Wed 2002-08-28 at 17:16:59 -0400, [EMAIL PROTECTED] wrote:
> >Do you (all) realize you can only complain about this (falling so far
> >from their prediction), because they happened to give out some
> >estimate in the first place?
> >
> >Sounds only reasonable to me to try to avoid the
Does anyone know why I would recieve this error, when attmepting to connect
to mySQL via JDBC(driver=Connector/J 3.0 beta) I can connect if I provide no
password (even if the account specifies a pwd)? I can connect correctly
using MySQL Front ... but JDBC is giving me this error.
javax.servlet.S
Lastly, we use the .tar.gz file of the linux binary made by MySQL AB.
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
> -Original Message-
> OS is ReadHat Linux 7.3
> Glib is 2.2.5
> Kernel is 2.4.18-10smp
>
> Two Athlon MPs and 1.5Gb RAM.
Sql,query
---
Hi All,
I'm looking towards using MySQL to setup a couple of databases for the
organisation I work for (specifically a Library DB and another for
recording our 'outputs').
Before I get to the question, some background ... We currently use Ms
Access, but my interest in MySQL is that we would be a
Pada Wed, 28 Aug 2002 17:33:57 -0500
"Naushit Sakarvadia" <[EMAIL PROTECTED]> menulis :
> Is it possible to limit size of table?
>
> For example I want xyz table to limit 1 GB and once it reaches
> 1 GB it should start overwriting oldest data.
>
> Is it possible to do this in Mysql? or is the
Hi,
On my side I'm still waiting for a "real" crash.
The server crashed this morning but it's quite odd since even the .err file
seems to be wrong this time.
I can only read :
/usr/local/mysql/libexec/mysqld: ready for connections
mysqld got signal 11;
This could be because you hit a bug. It is
I've been pounding my head against a wall for the last couple of days trying
to make a "simple" program work (to then use as the basis for future
programs, etc. -- in other words, "I'm still just learning this stuff") I'd
really like to "point the finger" at Microsoft & visual basic, but I've bee
Thank you David Lopez and David Robley. That was what I was looking
for. Here is how I used it.
$date=getlastupdatetime(array("team_id" => $team_id,
"season" => $season,
"div_id" => $div_id));
echo "$date";
function getlastupda
Aye Arthur this is a different experince then what I had with Access and
MySQL. I guess my main reason for not using is because I personally dont
really need to. Nothing against you or anyone using it but to me it always
seemed to be a bit cumbersum, just my feelings.
I wish I had some e-mails I'
Is it possible to limit size of table?
For example I want xyz table to limit 1 GB and once it reaches
1 GB it should start overwriting oldest data.
Is it possible to do this in Mysql? or is there any client that can
monitor table and truncate it?
I am basically logging some high volume log to
Hi Mark,
Thanks for the reply. I have got more information.
1. We set only the port, basedir and datadir parameters for mysql on both
Windows and Solaris machines. All other configuration parameters are
default.
2. Setup for Windows Machine :-
OS - Windows 2000 professional SP2
R
neal wrote:
> Does anyone have a preference on whether to use V2 or v3(beta) of
> Connector/J?
>
> I read on the mySQL site that there are some new features that seemed
> significnat (support of prepared statements, and 50-100% faster) ...but I
> couldn't tell if these were new as of v2 or v3. T
I have strange problem - I get Segmentation fault error when I am trying to
execute mysqlhotcopy.
When I remove the [mysqlhotcopy] and [client] sections in my /etc/my.cnf
configuration it works. Meanwhile, on another server it works just fine with
the same configuration file.
There is nothing fa
Hi,
I am researching a paper on architectures and common threads amongst many of
the available RDBMS's. I am including Oracle, DB2, Sql*Server and MySQL. I
am finding it difficult to find good documentation on how MySQL implements
its architecture.
Can anyone point me in the right direction to
sql query
Benjamin Pflugmann wrote:
>Do you (all) realize you can only complain about this (falling so far
>from their prediction), because they happened to give out some
>estimate in the first place?
>
>Sounds only reasonable to me to try to avoid the same situation by not
>giving out estimatio
Hi Mark,
Thanks for the reply. I have got more information.
1. We set only the port, basedir and datadir parameters for mysql on both
Windows and Solaris machines. All other configuration parameters are
default.
2. Setup for Windows Machine :-
OS - Windows 2000 professional SP2
RAM - 196
Matthew,
- Original Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, August 28, 2002 7:36 PM
Subject: incorrect ordering of tables in mysqldump
> >Description:
> innodb table types introduce dependancies on one table by another.
> Thus the
On Wed, 2002-08-28 at 21:17, Keith C. Ivey wrote:
> Not paying attention to case. As you said earlier, the code for NULL
> is \N, not \n.
Oh my! I feel so stupid! I should have known to check the case better by now.
\n is a newline in mysql, right? That's probably why the lines are 'broken' in
Also,
OS is ReadHat Linux 7.3
Glib is 2.2.5
Kernel is 2.4.18-10smp
Two Athlon MPs and 1.5Gb RAM.
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
> -Original Message-
> From: Lenz Grimmer [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 28, 2002 12:49 am
> To: [EMAIL PROTECTED
Hi,
I´m trying to install mysql-3.23.52 on a machine running RedHat 7.0. I´m
using the following procedure:
./configure --prefix=/usr/local/mysql
make
make install
The first two commands run fine, but "run install" gives me the following
error,
make[2]: *** [install-benchSCRIPTS] Error
I have strange problem - I get Segmentation fault error when I am trying to
execute mysqlhotcopy.
When I remove the [mysqlhotcopy] section in my /etc/my.cnf configuration it
works. Meanwhile, on another server it works just fine with the same
configuration file.
There is nothing fancy in the my.
I have two database names that I would like binlog to ignore, how do I
do that?
binlog-ignore-db=db1
works OK for db1, but
binlog-ignore-db=db1 db2
binlog-ignore-db=db1,db2
do not work.
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
sql,query
--
http://www.entropy.ch/software/macosx/mysql/
Haven't tried it yet, but here is a binary release
that was built for 10.2. It's about halfway down the
page. Is that the one you were using Paul? I'm getting
the same error as you, so I'm hoping this will work.
Paolo
running 4.x
MySQL is very slow to return a large result set of about 45,000 records.
The query seems to execute in a few seconds, but then it takes another 90
seconds to return all the data.
The same query only takes 6 seconds to execute and return on MSSQL server,
so I must have something setup
Does anyone have a preference on whether to use V2 or v3(beta) of
Connector/J?
I read on the mySQL site that there are some new features that seemed
significnat (support of prepared statements, and 50-100% faster) ...but I
couldn't tell if these were new as of v2 or v3. There might also be other
In addition to my previous post, if I use the INSERT command like:
mysql> INSERT INTO pet VALUES ('bark',NULL,'dog','m','2000-01-30',NULL);
the NULL values are entered correctly:
mysql> SELECT * FROM pet;
+--++-+--+++
| name | owner | specie
On Wed, 2002-08-28 at 22:19, Keith C. Ivey wrote:
> As it says in the documentation, "If the LOCAL keyword is specified,
> the file is read from the client host. If LOCAL is not specified, the
> file must be located on the server." That means that with LOCAL the
> MySQL *client* must be able t
It did not occur to me under after I sent the last email, that the
binlog does not log every query. For our site, it does not even log
every database. So I'm going to look a bit harder at the other log
file...
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-
I am right now looking over the logs. I had the regular log on and the
binlog on to test it. I'm going over the log right now. The binlog is
helpful -- I'm looking at the last queries in each (since a new one was
created every time MySQL crashed).
The only thing in common is that they are always
On 28 Aug 2002, at 20:07, Mertens Bram wrote:
> Sorry, I don't understand: why would mysql have access to a file when I
> run LOAD DATA LOCAL... and not when I run it without the LOCAL?
As it says in the documentation, "If the LOCAL keyword is specified,
the file is read from the client host. I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
MySQL 4.0.3-beta, the world's most popular Open Source Database, has been
released and is now available in source and binary form for a number of
platforms from our download pages at http://www.mysql.com/downloads/ and
mirror sites.
This is t
I was given the task of finding out what is need it to set a our Mysql DB on
separate server from our webserver.
The OS is will be RH7.3
There will be a lot of transactions accessing this serverMysql.
My questions are:
1) What is the recommended ram and hard Drives for a server that will be
Hello.
On Wed 2002-08-28 at 09:19:46 -0500, [EMAIL PROTECTED] wrote:
[...]
> serious. It becomes harmful to MySQL in general when a release that was
> once predicted in 2001, becomes no where in sight in late 2002.
Do you (all) realize you can only complain about this (falling so far
from their
On 28 Aug 2002, at 19:49, Mertens Bram wrote:
> Here are a few lines from the pet.txt:
> flufyyharold cat f 1993-02-04 \n
> Chirpy\n bird\n \n \n
> [snip]
> What am I doing wrong?
Not paying attention to case. As you said earlier, the code for
You can also use
TRUNCATE TABLE table_name;
this recreates the table, instead if just removing all data from it. To get
to know more about the table structure, you may want to use:
SHOW CREATE TABLE table_name;
It shows you the create table statement of the table.
-Oorspronkelijk berich
>Description:
I am porting MySQL to Linux/Alpha. On some occasions
the CREATE TABLE statement adds ZEROFILL for int(11)
fields. If you don't know this problem, let me know
so I can try to fix it. If you know the problem please
let me know what to do (I don't
That has not been my experience, in fact my experience has been completely
the opposite. As my first test case I ported the Northwind sample database
to MySQL. I had to make a few changes here and there, most notably to some
queries, but also including (and I forgot to mention this in my previous
Thanks to all that reply to my help request.
Yes, mysqld was not running.
Thanks again,
Nestor :-)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
You didn't mention whether they are planning on keeping the NT box, but I
assume that they are, and that what you want to do is leave the Access app
working, but point it to the Linux-MySQL QUBE. I have been there and done
that (well, except for the QUBE part -- I run Mandrake 8 on an old P-233.
I dont know if it helps, but I dont decrypt, instead, I compare the crypted
value on the DB against the output of the function PASSWORD() filled with
the pwd I get from the user... It works for me (and I'm using APACHE and
MySQL all in plain "ANSI C"). Leonardo Javier Belén. AFIP-AR
- Original
Hi,
Using directly libmysql.dll ?How ?
On http://www.a1vbcode.com/app.asp?ID=1764 is gmysql.zip.TypeLibrary for VB
and work with libmysql ver 4.xCan be an alternative.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address :
On Wed, 2002-08-28 at 20:02, Gerald Clark wrote:
> I doubt mysql as access to /home/M8ram/testmysql/pet.txt.
Sorry, I don't understand: why would mysql have access to a file when I
run LOAD DATA LOCAL... and not when I run it without the LOCAL?
If I run it with LOCAL the data is added to the tab
If I understand you correctly, then you are trying to figure out how to
distinguish between an empty result set vs. no result set (i.e. an error if
statement was a SELECT).
In the case of an error (or a not result set returning statement like
INSERT), mysql_store_result will return null.
In the
I doubt mysql as access to /home/M8ram/testmysql/pet.txt.
Mertens Bram wrote:
>On Wed, 2002-08-28 at 16:51, Egor Egorov wrote:
>
>>Put into my.cnf file :
>>[mysql]
>>local-infile=1
>>
>>or start mysql client with --local-infile=1 option.
>>
>
>I tried the first option and it works when use the f
Hi,
I'm using version 3.23.49 on RH7.3.
I'm following the menagerie example and have added some lines to the
"pet" tabel using the LOAD DATA LOCAL INFILE... construction.
I have created a file pet.txt like the manual suggests and have added \N
in some fields to include NULL values.
However whe
HE ALREADY DID FROM PREVIOUS EMAILS TO MY ACCOUNT... I HAVE A WEB PAGE AND
THEY
ARE MINING EMAIL ADDRESSES.. DUH
SAME BACK AT YOU
-Original Message-
From: Kenneth Hylton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 11:29 AM
To: 'Mary Stickney'; John Wards; [EMAIL PR
I wrote >> Ironically, the fact that I pay no license fees to MySQL AB is
based upon...
Dean Ellis wrote >> Ahhh, I see. So, you are _completely irrelevant_.
My relevance stems from the fact that I am a very good prospect to a company
that has a stated interest in growing their community of sa
True you could, but then that way you will loose portability if Jon (for
whatever reason) decides to move to another type of DB. Never used
libmySQL so I dont know how the speed is, but assume its as fast if not
faster then ODBC.
ODBC has the plus of being user friendly and of being an M$ Universa
Hi,
About query_buffer_size, you can find in the changelog :
"- Removed unused variable query_buffer_size. "
Regards,
Jocelyn
- Original Message -
From: "Martin MOKREJŠ" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 28, 2002 5:48 PM
Subject: First thoughts on m
HOW does one use this to confirm a record set? for instance,
if mysql_store_result() = 0 then
do nothing
end if
where mysql_store_result() returns an empty set on a select statement.
any help obtained would be WONDERFUL!!! sorry, i'm new to this, the
syntaxtual information is quite confus
Joel, you obviously put some thought into his response and I very much
appreciate the insight. All in all, I feel you make some good points. I
did find a couple of things that I want to rebut.
>> Well, as a bystander, I think you've shot a little wide.
When you say "bystander", are you referr
At 17:48 +0200 8/28/02, Martin MOKREJ· wrote:
>Hi,
> after upgrading, I had two problems:
>
>/usr/local/mysql/bin/mysqld: ERROR: unknown variable 'query_buffer_size=32M'
>
> I had to comment out this variable, it seems it got renamed. I have to
>figure out what's the new name.
It's no longer
see my message re--- index problem
ok when I do explain in this , it is not using an index for the
AdminCoverage_writingagents table...
SELECT admincoverage_writingagents.WritingAgentID,
admincoverage_writingagents.WritingAgentSlot, ProducerID, TaxID,
(ModalPremium * BillModeID * (PercentOfCa
Hi,
Egor has right and i didn't read very carefully you e-mail.Sorry
You can try this :
SET @a:=0;
SET @b:=0;
SELECT @a:=COUNT(*),@b:=sekce.id FROM odkaz,sekce WHERE odkaz.sekce_id =
sekce.id;
UPDATE sekce SET pocet = @a WHERE id= @b;
Now...i think it's corect...
Regards,
Gelu
_
I have used the mysql password(\"$pass \") function in the past to encrypt
passwords into the db. but can not decrypt them if needed. I know this is
not something new.
Is there a better way to protect passwords in the db and then decrypt them
if needed ?
Thanks
Mark
-
Or you could just use the libmySQL.dll and handle everything yourself
through VB.
>>You will however need to download the MyODBC driver if you wish to access
>>MySQL through VB.
>>
>>-Nick
-
Before posting, please check:
h
Hi,
I can confirm this on Linux i386 with official binaries on MyISAM
tables:
mysql> check table blast;
DELETE FROM ++---+--+--+
| Table | Op| Msg_type | Msg_text |
++---+--+--+
| test_mmo.blast | check | statu
Unfortunately, you may be.
Now he has your e-mail address.
As my father always sez, "smooth move Ex-Lax"
-Original Message-
From: Mary Stickney [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 10:12 AM
To: John Wards; [EMAIL PROTECTED]
Subject: RE: JAMES KADEH mysql !
I
Mary Stickney wrote:
> the join syntax is what is differnt between Access and MYSQL.
>
> in MS-SQL = indexs will be used on tables mentioned in the JOIN clause
> and they will not in MYSQL
This is not true. MySQL uses indexes in joins, if you've put them in the
right columns, just as in MS-SQL
burger17,
Tuesday, August 27, 2002, 7:07:45 PM, you wrote:
b> In dos-prompt, I type at c:\mysql\bin>mysql for testing to see if mysql is
b> connected successful but
b> the error is : Error 2003: Can't connect to MySQL server on 'localhost'
b> <10061>
b> How to solve this problem?
b> Hope to hea
William R. Mussatto wrote:
> Can connector/J coexist with mm.mysql on the same tomcat? I'd like to
> upgrade one site at a time rather than then all the sites at once.
>
No, because there are classname clashes. If you remove the "org"
subdirectory from the .jar file, it might work okay.
On Wed, 2002-08-28 at 16:51, Egor Egorov wrote:
> Put into my.cnf file :
> [mysql]
> local-infile=1
>
> or start mysql client with --local-infile=1 option.
I tried the first option and it works when use the following command to
load the data-file:
mysql> LOAD DATA LOCAL INFILE '/home/M8ram/testm
Other companies require you to sign up for a Beta program before you can
even look at it.
The public doesn't even hear about it until the Beta is through, and the
product is ready.
You probably will never know how long the Beta cycle lasted.
You are privileded to be given such early access to Be
Can connector/J coexist with mm.mysql on the same tomcat? I'd like to
upgrade one site at a time rather than then all the sites at once.
On Wed, 28 Aug 2002, Mark Matthews wrote:
> Date: Wed, 28 Aug 2002 08:59:33 -0500
> From: Mark Matthews <[EMAIL PROTECTED]>
> To: neal <[EMAIL PROTECTED]>
>
Hi,
after upgrading, I had two problems:
/usr/local/mysql/bin/mysqld: ERROR: unknown variable 'query_buffer_size=32M'
I had to comment out this variable, it seems it got renamed. I have to
figure out what's the new name.
020828 17:30:12 mysqld started
020828 17:30:12 Can't find messagefil
Hi,
>From what i know , embedded MySQL is implemented begin with version 4.0.x.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Messa
Hi,
...adding a new query and using variable:
SET @a:=0; --initialize variable a;
select @:=COUNT(*) from odkaz where odkaz.sekce_id = sekce.id;
update sekce set pocet = @a where odkaz.sekce_id = sekce.id;
Regards,
Gelu
_
G.NET SOFTWARE COMP
Dan,
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Harald Fuchs" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, August 28, 2002 6:10 PM
Subject: Re: MySQL/InnoDB-4.0.3 is released
> In the last episode (Aug 28), Harald Fuchs said:
>
Steve
Try: SELECT MAX(field_timestamp) from table1;
David
> -Original Message-
> From: Steve Buehler [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 27, 2002 5:21 PM
> To: mysql; PHP
> Subject: time stamp
>
>
> I am using PHP with MySQL and have a timestamp field in my db
> table.
>Description:
innodb table types introduce dependancies on one table by another.
Thus the order of table loading is important. If a table is loaded
before one it depends on an error is triggered.
mysqldump will dump tables in the wrong order, it seems to dump
I would strongly urg you not to use Access as the front end. The biggest
problem is that the Jet Engine/Access backend is pretty much completly
different then MySQL and you will run into problems with table structure
and the like. Also, using access as the front end has been extremly slow
when eve
Jakub,
Wednesday, August 28, 2002, 5:15:01 PM, you wrote:
JM> how can I do sql command like this:
JM> update sekce set pocet = count(*) from odkaz where odkaz.sekce_id = sekce.id
First: multi-table updates is supported only since 4.0.2
Second: even on 4.0.2 you can't do it with above query
-
1 - 100 of 151 matches
Mail list logo
