At 11:24 PM +0100 8/25/01, Carlos Pereira wrote:
>Hi,
>
>You are missing the ; at the end of the SQL statement
>try $query = "SELECT * FROM question WHERE answer<>'1' AND id>250 ORDER BY
>id;";
>instead of $query = "SELECT * FROM question WHERE answer<>'1' AND id>250
>ORDER BY id";
No. A semicol
On Thu, Aug 23, 2001 at 11:11:38AM -0700, Steven Roussey wrote:
> >
> > mysql> explain select * from dominf.domip order by ip desc;
> >
> > 'ORDER BY something DESC' does not use an index. It must
> > be ascending. See the manual.
>
> Also, I forgot, if you do this often and it needs to be in DES
Hi !!
)-Original Message-
)From: Paul Schreiber [mailto:[EMAIL PROTECTED]]
)Sent: Friday, August 24, 2001 1:21 PM
)To: Web Objects admin; Web Objects newsiest; Web Objects dev; MySQL List
)Subject: MySQL, Web Objects 5: job connection problems
)
)
)Comfit:
)* Mac: Mac OS X 10.0.4; java
On Fri, Aug 24, 2001 at 10:07:59AM -0700, Katherine Porter wrote:
> For single values I usually use this DBI function and query:
>
> my $val =3D $dbh->selectrow_array("SELECT value FROM tab1 WHERE test=3D=
> 2");
>
> However, what if I want to store a bunch of values into an array?
>
> my @
(in case you're wondering, yes, i did get mysql working argh.)
info: WO5, Mac OS X 10.0.4, MySQL 3.23.32, mm.mysql JDBC adaptor 2.0.6.1
I get this error:
>java.lang.IllegalStateException: Adaptor
>com.webobjects.jdbcadaptor.JDBCAdaptor@b7ad3 failed to provide new primary
>keys for entity
I don't know if this just a shoot in the wind but heres my configuration.
Everyting to be posted to and from the db is done first threw https: then
I have a VPN set from the actual db to http. From inside the VPN I have it
setup for IPsec. This is about as secure as I possibly know from my
hi
> I would also strongly suggest not storing your images in the database but
> rather a link to the image.
even that - why?
if you're using an ultrafast webserver like Tux in combination with
Apache/php-perl
the Tux webserver serves the images incredibly fast (see specweb tests)
what advantage
I read a few messages about people that were having problems backing them
up. If you only have a link to the image, it is no prob to back up.
I've never tried to mysqldump an BLOB. Don't think I'd want to read that
printout!
Also, it seems to be a waste of database space.
Robert Dayton
Unconven
Hi,
You are missing the ; at the end of the SQL statement
try $query = "SELECT * FROM question WHERE answer<>'1' AND id>250 ORDER BY
id;";
instead of $query = "SELECT * FROM question WHERE answer<>'1' AND id>250
ORDER BY id";
CPereira
- Original Message -
From: "Martin Kampherbeek" <[EM
On Sat, Aug 25, 2001 at 09:42:33AM +0800, aDragon wrote:
>I think this mail list is very helpful to me. But several
>hundred letters one day may bomb my mailbox up, > and it is a
>great problem to manage all the letter. I have an advice to the
>friends who manage this list.
>
>
At 10:07 AM -0700 8/24/01, Katherine Porter wrote:
>For single values I usually use this DBI function and query:
>
> my $val =3D $dbh->selectrow_array("SELECT value FROM tab1 WHERE test=3D=
>2");
>
>However, what if I want to store a bunch of values into an array?
>
> my @vals =3D $dbh->?(
Hello Hans,
a few weeks ago i had a similar task to accomplish, porting a mySQL
DB over to IBM's DB2 for S/390, so i can relate to this kind of
*most exciting* job.
Anyway, from my experience I wouldn't recommend anything like a bulk
copy or mass import/export. Because when you are switching
On Sat, Aug 25, 2001 at 08:32:00AM -0500, Steve Suehring wrote:
> Hello-
>
> I poked around on the site but didn't find any definite answer.
> Roughly when is version 4.0 of MySQL expected out? I saw the
> information on the todo in regards to version 4.0 and the subsequent
> 4.1 but didn't see
On 24-Aug-2001 [EMAIL PROTECTED] wrote:
>
> Can anyone give an example of how to use the
> where option in mysqldump to get a dump of only those
> records whose values of field fieldx are larger than
> something?
> For example
>
> "for all database tables of db mydatabase
> which possess
As stated on the bugs and fixes page on http://www.innodb.com/bugfixes.html
there is a problem with the latest innodb code that causes corruption when
doing updates... I believe I have run into that problem... First mysql would
hang.. and do nothing. After killing it and restarting it the error lo
At 10:39 AM -0700 8/25/01, Hans Zaunere wrote:
>We have about 300,000 records currently in a MySQL
>database. A new system has been built on Oracle, and
>now we must migrate the data from MySQL to Oracle (I
>know, it's not something I wanted to do.) What is the
>best way to do this? Import into
On Fri, Aug 24, 2001 at 09:37:43AM -0700, Bryan Coon wrote:
>
> The other solution is rsync. I dont know much about this guy yet,
> but I have some concerns with using it to copy over large remote
> files. For example, if I have a 1.2 gig table that has been heavily
> modified over a weeks work
On Sat, Aug 25, 2001 at 06:37:26PM +0200, Chris Chabot wrote:
> I have been looking at this mysql.com/org dispute for a while now,
> and i must say i am getting more and more wurried.
Many of us have.
> I have been a faithfull user of MySql for some years now. Not
> because it is the 'best
MySQL does have a program mysqlimport. I, myself, being a scripting gal would most
probably dump my Oracle DB into a comma delimited file or straight out raw SQL and
make the text substitions to match the INSERT and CREATE TABLE syntax. Post a sample
of your dump file and I can help you forge
Also, I'm seeing this in the logfile:
java.lang.NullPointerException
: Exception occurred while handling request:
com.webobjects.foundation.NSForwardException
[com.webobjects.jdbcadaptor.JDBCAdaptorException] null
Paul
>(in case you're wondering, yes, i did get mysql working argh.)
>
>
On Sat, Aug 25, 2001 at 09:42:33AM +0800, aDragon wrote:
> hi,
>I think this mail list is very helpful to me.
>But several hundred letters one day may bomb my mailbox up,
> and it is a great problem to manage all the letter.
>I have an advice to the friends who manage this list.
>
>
Hello Hans,
a few weeks ago i had a similar task to accomplish, porting a mySQL
DB over to IBM's DB2 for S/390, so i can relate to this kind of
*most exciting* job.
Anyway, from my experience I wouldn't recommend anything like a bulk
copy or mass import/export. Because when you are switching
> The last thing that wurries me is the lack of updates on the issue,
> when i, as a wurried client & customer go to the mysql.com website, the
> only thing i find is a 'open inventation for 2001/07/18'. Being
> deep-august i presume that has come and gone, and no results or
> communications c
> DROP TABLE Track
> Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13)
>
> Anyone know what that means? As you can see, it came from tryign to do a
> DROP on a table.
"Permission denied".
Maybe the dir permissions aren't correctly set up?
/ Carsten
--
Carsten H. Pedersen
keeper
Well, I've been a die-hard mysql fan for two years now and have been using
it with php for a web-based app. It has never crashed on me and has
performed perfectly.
As our app has grown, we have found a need for subselects and complex
queries and the work-arounds were ok until our databases starte
We have about 300,000 records currently in a MySQL
database. A new system has been built on Oracle, and
now we must migrate the data from MySQL to Oracle (I
know, it's not something I wanted to do.) What is the
best way to do this? Import into another database
(something like Access) then expo
Dear Everyone,
I have been looking at this mysql.com/org dispute for a while now,
and i must say i am getting more and more wurried. I have been a
faithfull user of MySql for some years now. Not because it is the 'best
full features database out there', but because it serves my specific
needs
Hi
I'd also like to know the answer to this. I also had a thought that it
might be nice to have a site to post answers that come through this email
list. I know there are archives but they can be difficult to use to find
the "answer" to peoples questions. What does everyone think about havi
Hi !!!
)-Original Message-
)From: Werner Stürenburg [mailto:[EMAIL PROTECTED]]
)Sent: Friday, August 24, 2001 5:59 AM
)To: Wen Tien
)Cc: [EMAIL PROTECTED]
)Subject: Re: myODBC?
)
)
)In my understanding, myODBC is a middleware for programs which
)don't know how to deal directly with mySQL.
Hi !!!
Can anyone has the answer for him ? How we can have a secure data transfer
over the web using MySQL and its APIs ? He is desperately needed some idea
in order to take further steps with MySQL ?
Regards
Venu
)-Original Message-
)From: A. Chris Nichols [mailto:[EMAIL PROTECTED]]
)S
Hi !!
)-Original Message-
)From: Wen Tien [mailto:[EMAIL PROTECTED]]
)Sent: Friday, August 24, 2001 1:58 PM
)To: [EMAIL PROTECTED]; Werner Stürenburg
)Cc: [EMAIL PROTECTED]
)Subject: RE: myODBC?
)
)
)Hi, maybe I didn't phrase my question correctly. I'm using a SGI machine
)running Irix a
For single values I usually use this DBI function and query:
my $val =3D $dbh->selectrow_array("SELECT value FROM tab1 WHERE test=3D=
2");
However, what if I want to store a bunch of values into an array?
my @vals =3D $dbh->?("SELECT value FROM tab1 WHERE test > 10");
What's the syntax
> The other solution is rsync. I dont know much about this guy yet, but I
> have some concerns with using it to copy over large remote files. For
> example, if I have a 1.2 gig table that has been heavily modified over a
> weeks work, how reliable is the remote file after rsync? I guess Im jus
Hi,
I was trying to install mysql on Linux Redhat 7.1, after following all the
steps on the website, I tried to start mysql server using the mysql.server
start command, and I got this error message saying that mysql.server is not
found evern though it's under support-files folder and I cd-ed i
What is the maximum table size allowed by MySQL and Redhat 7.0 be default?
Benjamin Arai
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Hi Rich,
i haven't heard about an AS/400-Client so far.
As long you might don't want to start writing an asynchronus
dataque server on the AS/400 and a client on the mySQL-Server
to handle the data mirroring, i would suggest to try IBM's
JDBC-API. Together with Sun's JDBC 2.0 Optional Package A
Hi Rich,
i haven't heard about an AS/400-Client so far.
As long you might don't want to start writing an asynchronus
dataque server on the AS/400 and a client on the mySQL-Server
to handle the data mirroring, i would suggest to try IBM's
JDBC-API. Together with Sun's JDBC 2.0 Optional Package A
Hello-
I poked around on the site but didn't find any definite answer. Roughly
when is version 4.0 of MySQL expected out? I saw the information on the
todo in
regards to version 4.0 and the subsequent 4.1 but didn't see any dates.
Thanks for any help.
Steve
Trond Eivind Glomsrød writes:
> On Fri, 24 Aug 2001, Sinisa Milivojevic wrote:
>
> > You know better then me that 2.2.4 should NOT be built with gcc 3 !
>
> Which was why I asked :) - 2.2.4 wants 2.96RH or 2.95.3 (2.95.2 should
> work on IA32, though)
>
> --
> Trond Eivind Glomsrød
> Red Hat,
>Description:
'mysqldump --allow-keywords' seems not to work using
mysql-3.23.38-1.alpha.rpm or mysql-3.23.41-1.alpha.rpm, i.e.
keyword-permissive column names are not produced. The same
command works properly on MySQL 3.23.22 on Linux on Intel hardware.
Rudy,
there is an explanation to this behaviour:
on escaped data you could un-escape almost everything, one can escape almost any
character if wanted.. .. so \\ gets \ and \* gets *, \% gets % and \N gets... N.
mysql> select "\A\B\C\J\N";
+-+
|ABCJN|
+-+
|ABCJN|
+-+
1 row in set (0
This is an Official WebStream Press Release
Release date: August 23, 2001
For more information contact:
Gary Lee at 888-932-2333
WebStream Internet Solutions Signs Contract With Broward Alliance
FOR IMMEDIATE RELEASE
Fort Lauderdale, FL - August 23, 2001 - WebStream Internet Solutions has sig
On Friday 24 August 2001 00:09, Jeremy Zawodny wrote:
> On Thu, Aug 23, 2001 at 01:15:25PM -0400, Robinson, Mike wrote:
> >
> > I just set up a master/slave replication scheme and all is well, but
> > through the procedure did get bit on the tail.
> >
> > After the setup, and after the master and
> table a has ak1 and ak2 as primary key
> table b has bk1 and bk2 as primary key
> how do I join these tables?
>
> if i write
> where a.ak1 = b.bk1 and a.ak2 = b.bk2
> data are returned multiple times.
AnneMarie,
When you say "data are returned multiple times" please clarify what you mean:
a)
Hi Armando, I think you probably need to notify the mainter of the
port for freebsd (from ports)
Port: mysql-server-3.23.40
Path: /usr/ports/databases/mysql323-server
Info: Multithreaded SQL database (server)
Maint: [EMAIL PROTECTED]
It's probably something in the port install script.
Ken
hi,
I think this mail list is very helpful to me.
But several hundred letters one day may bomb my mailbox up,
and it is a great problem to manage all the letter.
I have an advice to the friends who manage this list.
Please add a label to every letter from this mail list in order
for
I still get this error. Can someone help me to solve this?
MySQL Query Failed. Error 1030: Got error -1 from table handler
$query = "SELECT * FROM question WHERE answer<>'1' AND id>250 ORDER BY id";
$result = mysql_query($query) or die('MySQL Query Failed. Error
'.mysql_errno().':
'.mysql_error
- Original Message -
From: "muruganandam" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 4:04 PM
Subject: selection from multiple tables;
>
> for a particular query i have to select data from five tables.
> can any one suggest me a best way to do that in
DROP TABLE Track
Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13)
Anyone know what that means? As you can see, it came from tryign to do a
DROP on a table.
Thanks,
Tyler Longren
-
Before posting, please check:
> table a has ak1 and ak2 as primary key
> table b has bk1 and bk2 as primary key
> how do I join these tables?
>
> if i write
> where a.ak1 = b.bk1 and a.ak2 = b.bk2
> data are returned multiple times.
AnneMarie,
When you say "data are returned multiple times" please clarify what you mean:
a)
Can anyone give an example of how to use the
where option in mysqldump to get a dump of only those
records whose values of field fieldx are larger than
something?
For example
"for all database tables of db mydatabase
which possess a field named fieldx store in
the dump only those records
Jeremy Falcon writes:
> To be honest, I'm not sure if you can just transport the db files. I'm sure
> it won't work it you're using different versions of MySQL on the machines.
>
> What I do when going from Win2K to FreeBSD is a mysqldump to extract the SQL
> statements to recreate the table. I
Hi group,
Im using the latest mySQL 3.23.41, ever since I installed the new
version I've been getting "Lost connection to MySQL server during query"
50% of the time on my mySQL server. I have a load average of 247 queries
per second accordig to mysqladmin status.
Anyone experienced the same p
Hello,
I have tried MySQL Front and it works very nicely I've used it for
importing data and data modification. I just have a few questions I hope
you can answer...
Firstly I imported some MS Access 2000 tables. The import see to go fine,
but when I went back to check some of the data that
Do a SQLDUMP using a program like MySQLFront in NT then connect to the Linux MySQL
using the same from NT. Run the SQL script you made and your off to the races.
Just did this for my move from NT to Linux.
There might be even a better way to do this but that's how I did mine and it worked.
Ch
for a particular query i have to select data from five tables.
can any one suggest me a best way to do that in terms of performace..
thanks in advance
muruganandam
-
Before posting, please check:
http://www.mysql.com/manua
George:
Suggest you use mysqldump, including the option to automagically create the
database and table schema.
On the WinNT machine:
mysqldump -u{username} -p -c --databases {databasename}>{databasename}.sql
Copy the file(s) across the network to the LinuxPPC box
On the LinuxPPC box:
mysql -u{
Config:
* Mac: Mac OS X 10.0.4; java 1.3.1; mysql 3.23.32
* Linux: Linux 2.2.19/debian testing; java 1.3.1; mysql 3.23.36
I *really* could use some help here. I need to get MySQL up and running;
I've been at it for 2 days and can't get my WO app to see it, whether I
try on Linux or OS X.
Her
To be honest, I'm not sure if you can just transport the db files. I'm sure
it won't work it you're using different versions of MySQL on the machines.
What I do when going from Win2K to FreeBSD is a mysqldump to extract the SQL
statements to recreate the table. I'll use SELECT ... INTO OUTFILE
Rich Duzenbury writes:
> I have need to replicate some data from an AS/400 to a MySQL server.
>
> Has anyone ported a client?
>
> Regards,
> Rich
>
You can make a client on AIX, but OS/400 ... sorry no.
Best way to accomplish what you need is to save table create scripts
and to use SELECT ...
Hi, maybe I didn't phrase my question correctly. I'm using a SGI machine
running Irix and going to be using a mySQL db on a Linux box behind a
firewall. Since I will set up a tunnel with ssh2 to forward port 3306, it
will appear to the Irix system that the db exists locally. Now here is what
I'
Hi
I'm wondering is MySQL is Cluster aware?
Can it work in an Active/Passive or Active/Active Configuration of a
cluster?
thanks
berber
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:
Hi
I have a table with a filed that is unique (used unique() in the
creation).
how do I undo this unique()?
thanks
berber
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
** Virus Warning Message (on steiner.cc.vt.edu)
Found virus TROJ_SIRCAM.A in file religous studies intro.doc.com
The uncleanable file was deleted.
*
Hi! How are you?
I send you this file in order to have your advice
See
This is kind of an open letter and request for help.
Also would apply to our pgSQL friends as well.
What would be a major benefit is
Guides/FAQs etc on converting from Oracle or MSSQL to MySQL and pgSQL
Easy data conversion and export from Oracle & MSSQL to MySQL and pgSQL
And so on ..
Today
I hate when my dumbness shows on world-wide tv
Please nullify my last query= Subject: "not regexp"
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the lis
I have a large (>40 million rows) table that currently consists of a few
integers and a varchar. I need to add a memo (text > 255 chars) field to
about 2% of the rows. Originally I was going to create another table with a
key and the memo field, but this method is complicating the programming
lo
On Fri, 24 Aug 2001, Sinisa Milivojevic wrote:
> Trond Eivind Glomsrød writes:
> > Peter Zaitsev <[EMAIL PROTECTED]> writes:
> >
> > > I'm trying to compile mysql 3.23.41 with recent glibc 2.2.4 but this
> > > somehow does not work with the following diagnose:
> >
> > It builds just fine wi
Has anyone ported a MySQL client to IBM AS/400?
I have a customer (on AS/400) that would like to mirror some data to a
MySQL server.
Thank you for any help you can offer.
Regards,
Rich
-
Before posting, please check:
http
69 matches
Mail list logo
