You're welcome. I did suggest some (not very elegant) SQL in my first
note. I take it that didn't turn out to be useful. It's possible that
if you were to describe why not, someone could make a better suggestion.
Of course, I suppose you may have already solved this in Delphi.
mos wrote:
C
Chris & Michael,
Thanks for the feedback. I was hoping it could be done in SQL without
using Perl since I don't have any experience with it. But I can use some
of the ideas you gave me to create a Delphi program quick enough. Thanks
again. :)
Mike
--
MySQL General Mailing List
For list ar
Hi there. I heave heared that mysql doesnot support
foreign keys? What funcionallity provides and what
not? Inner Join what provides?
Thx
__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
--
MySQL General Mailing List
For
> Angus,
>
> On Fri, Dec 26, 2003 at 08:26:38PM -0500, Angus March wrote:
> > I'm trying to use the API to write to a MEDIUMBLOB, but I'm getting a
very
> > vague error: something about a problem "near '' on line 1". I'm
forumating
> > the query string w/
> >
> > sprintf(query, "INSERT INTO support
Angus,
On Fri, Dec 26, 2003 at 08:26:38PM -0500, Angus March wrote:
> I'm trying to use the API to write to a MEDIUMBLOB, but I'm getting a very
> vague error: something about a problem "near '' on line 1". I'm forumating
> the query string w/
>
> sprintf(query, "INSERT INTO support_files (sessio
I'm trying to use the API to write to a MEDIUMBLOB, but I'm getting a very
vague error: something about a problem "near '' on line 1". I'm forumating
the query string w/
sprintf(query, "INSERT INTO support_files (session_id,file_type,file_body)
VALUES (%ld,%ld,", sessionID,fileType);
Then w/calls
Hello Terence,
Terence wrote:
> Just do a check and repair: (or just repair to fix it)
>
> CHECK TABLE your_table
> REPAIR TABLE your_table
I´ve got the same error like Jacob, but this error appears over and over
at my database files. Do you know WHY this error occurs ?
Markus
--
MySQL
Hello mysql list, I have recently incurred an unusual error. Attempts to startup
mysqld-max fail with the following error:
031226 17:02:08 Error message file 'e:\mysql\share\english\errmsg.sys' had only 192
error messages,
but it should contain at least 237 error messages.
Check that the above
The following query does not work. It fits the exact format of DELETE in
the documentation.
DELETE from price WHERE ticker ='MSFT' ORDER BY date DESC LIMIT 3;
I am trying to delete the most recent 3 records. I get an error "You
have an error in your SQL syntax near 'ORDER BY date LIMIT 3' at li
I'm having a strange problem with trying to delete records with MySQL.
System: Win XP home, Mysql 4.0.15. Implementation with this version
since 10/01/2003 with no problems.
Normal access: MySQL JDBC driver (used to be the MM driver, now obtained
from MySQL), Java SDK 1.4.2_01. Problem has been
That's a good workaround, but I'd definately like to see that get fixed
at some point.
-Greg G
[EMAIL PROTECTED] wrote:
I shouldn't need to make a symlink in /usr/local/include.
That may be the case, but the only way you will satisfy the #include
in the my_global.h file is to either pull t
This is 4.0.1.7 and it happens on both Solaris and Mandrake. This is
just after finishing a make. Should this work at this stage, even?
-Greg G
# make test
cd mysql-test ; ./mysql-test-run
Installing Test Databases
Removing Stale Files
Installing Master Databases
running ../sql/mysqld --no-de
can you show the actual code for php that does this.
- Original Message -
From: "Reza Milan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 26, 2003 1:55 PM
Subject: SQL Support
> Dear sirs,
>
> I installed PHP and MYSQL on my XP system.
> All commands supported excep
>I shouldn't need to make a symlink in /usr/local/include.
That may be the case, but the only way you will satisfy the #include
in the my_global.h file is to either pull the 'openssl/' from in
front of opensslv.h, or to have a symlink in the openssl include
directory for openssl to '.'.
Dear sirs,
I installed PHP and MYSQL on my XP system.
All commands supported except sql and database commands.
When I run this command:
mysql> create table title (isbn varchar (13) not null);
the following error appeared:
Parse error: parse error, unexpected T_STRING in c:\inetpub\wwwroot\z.p
I should have posted this, but I did this:
$ ./configure --with-openssl
--with-openssl-includes=/usr/local/ssl/include
--with-openssl-libs=/usr/local/ssl/lib --with-vio
--prefix=/usr/local/mysql4017
I shouldn't need to make a symlink in /usr/local/include.
-Greg G
[EMAIL PROTECTED] wrote:
Greg G <[EMAIL PROTECTED]> writes:
>gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I../include-O3
>-DDBUG_OFF -c `test -f strxmov.c || echo './'`strxmov.c
>In file included from strxmov.c:33:
>../include/my_global.h:1127: openssl/opensslv.h: No such file or directory
This indicates to me
Michael Stassen wrote:
> You are right that perl can do the search and replace in one line, but
> you'll need some more code to read and write the data, either from <
> > mysql or from a source file before importing into mysql. That's
why I > said "almost" a one-liner.
>
> You are also right th
Rather than RCS, have you looked at Subversion. It's open source code and
pretty mature (although not yet 1.0).
http://www.linuxjournal.com/article.php?sid=4768
http://subversion.tigris.org/
What is your selection criteria? Is it all Perl code (Ruby?), is it
flexibility (code changes will occur
I'm still having the same old problem with compiling mysql with SSL
support in 4.0.17. I'm definately getting the #define HAVE_SSL 1 in my
config.h, so that's working. However, it looks like it's not getting
added to the list of directories in the components. I take this to be a
bug in confi
Hello,
I am running MySQL Ver 12.22 Distrib 4.0.17 for intel-linux (i686)
on RedHat 7.3 kernel 2.4.20-20.9smp
We use apache+php with persistant connections.
Everything worked fine until we implemented transactions
We go this way:
BEGIN;
select order.state from order where id=100 for update
With what little info you presented allow me to try and answer this one:
$db_server: I am assuming that the script you are using is a premade one
that can handle different types of database backends, if this is the case,
you will need to look at the documentation that came with the script to see
w
Hi,
I'm not sure if that subject made any sense!? What I'm looking to do is
take an existing product we have (a software defect tracker) that uses
flat files to store defect entries. Modifications to each defect are
recorded as diffs using the perl module RCSLite (like your standard
RCS, but
Howdy Gang,
I am trying to install an image gallery utilizing mysql. It needs the
following info: Where do i find this?
$db_servertype, $db_host, $db_name, $db_user.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
"Kostyantyn Zuzik" <[EMAIL PROTECTED]> wrote:
> I've installed 5.0.0 (from 24dec04) on WinXP. I connect with the following string
>
> mysql --user=root
>
> when I try to create a stored procedure with the following command:
>
> create procedure xxx() select * from pet;
>
> I get the following e
Hi all,
if I try to defrag an InnoDB table (using "alter table ...
type=innodb;") I see the size of ibdata1 growing to almost double its
size, and again it doubles if I try it again ... there's only 1 innodb
table in my setup, so no other table can be causing this.
Is this intentional/normal o
26 matches
Mail list logo
