Hi all,
I am wondering if I can construct a query string inside a stored
procedure and then execute it. I mean, what I want to do is given a set of
IN parameters, be able to construct a huge where statement out of them an
then complete the query string to execute. Is that possible? because if
Hi all,
I would need an oledb provider for MySQL. Do you know where I can found
a good one. Thanks in advance.
Leonardo J. Belén. A-AR
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all,
I am experiencing a fairly bizarre problem: in MySQL 4.1.7 (Windoze
version), when importing data from a file with semicolon-separated data, I
get random default values for the datetime fields. This turns the data
obviosly unusable.
The same import on the same machine but with the
[EMAIL PROTECTED]
To: Leonardo Javier Belén [EMAIL PROTECTED]
Sent: Wednesday, July 28, 2004 9:34 AM
Subject: SV: A possible bug
Hi Leonardo
i had a similar problem, it was with InnoDB tables, so i changed these
values:
# Set buffer pool size to 50-80% of your computer's memory
set-variable
Hi all,
I am using MySQL ver. 4.1.3-beta on Windows 2000 pro and I found that,
whenever i try to export data using the into outfile clause of the select
command the server hangs and i need to restart the service. Has anyone faced
the same problem, and if it is, how have you resolve it?
I
Hi all,
I have a problem with the ODBC Connector since I need to handle very
large resultsets. when I try a simple search on a 5Millon table, it tries to
send all the info to the client hanging it before i can see a simple row.
So is there a way to force the driver to use use_resultset
Hi folks,
Is there a way to make mysql sgml aware or any plan to do it in the near
time?
Leonardo J. Belen
mysql query sql mysql query sql mysql query sql mysql query sql mysql query
sql mysql query sql mysql query sql mysql query sql mysql query sql mysql
query sql mysql query sql mysql
Hi folks!
I am sorry to bother but I need your help. At work I need to upgrade the data
management the place is using (very old FOXPRO DOS) with something more modern. The
use is only to store data and run multiple querys in a post mortem fashion. The data
source is a Ms SQL server so
Hi
I realize that this is may be off topic, but the remote connection times
to MySQL under Windows NT 4.0 is really slow, while under Unix is quite
responsible. Does anyone faced this problem and found a proper solution?
because the project needs to reside on Windows and otherwise management
May be there is an option on the Commercial Market, BasisPlus from OpenText.
I worked quite a lot with it but, sincerely, I prefer a MySQL table with
references to files on the File System. A lot faster, and cheaper
Now there is true that I use to work with sgml files and I still prefer
them.
Hi ALL!
I have a problem with this query, because it keeps failing and I dont
know why (it says that the concat statement is wrong but there is nothing on
the online docs...)
select st.id, concat(st.required), st.name from states st, agenda ag left
outer join ag.id=concat(AGE,st.required)
Actually I think it can be done, but I need some help on the hooks on MySQL
and the approval of Heikki...
The matter is that I can be an interesting mental exercise and I think that
it is missing to be a real 'de facto' world wide product.
Any help?
Leo.
- Original Message -
From:
I think that the thing that really matters here is if we can do an sgml
index (fulltext) on a MYISAM table, and if not how to achieve that goal (a
really big one).
- Original Message -
From: Jay Blanchard [EMAIL PROTECTED]
To: Machiste' N. Quintana [EMAIL PROTECTED];
[EMAIL PROTECTED]
Thanks but actually I'm looking for a way to return all the relations
upwards and downwards of a term. no matter the position (so I need general
query to do that. Any ideas?
Thanks in advance. Leo.
- Original Message -
From: Anthony Richardson
To: Leonardo Javier BelÈn [EMAIL
Thats good but what about a way query up and down only modifying a var,
something like and hierichal search?.
Leo.
- Original Message -
From: CH Tsang [EMAIL PROTECTED]
To: Leonardo Javier Belén [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, January 14, 2003 11:30 AM
Subject: Re
Hi all!
I would like to build a query that I can use to search hierichally from
an char(4) id composed as followed
2positions for the class of plant (for example)
and 2 positions for the type of flower (for example)
if someone give me the id that means red rose tree, and I know there is
Hi all!
I would like to build a query that I can use to search hierichally from
an char(4) id composed as followed
2positions for the class of plant (for example)
and 2 positions for the type of flower (for example)
if someone give me the id that means red rose tree, and I know there is
Hi all!
I would like to build a query that I can use to search hierichally from
an char(4) id composed as followed
2positions for the class of plant (for example)
and 2 positions for the type of flower (for example)
if someone give me the id that means red rose tree, and I know there is
Hi all!
I would like to build a query that I can use to search hierichally from
an char(4) id composed as followed
2positions for the class of plant (for example)
and 2 positions for the type of flower (for example)
if someone give me the id that means red rose tree, and I know there is
Can someone post the piece of News, for the folks that cant get into the
page (I dont have access to web from where I am now...) Thanks, Leo.
- Original Message -
From: Christopher Hicks [EMAIL PROTECTED]
To: Michael Widenius [EMAIL PROTECTED]
Cc: Mysql List [EMAIL PROTECTED]
Sent:
, I need the answer to a few things.
a) am I in the right list?
b) has anyone try to add it?
c) where the hell registered a environmental variable?
d) which is the function that actually build the index?
Cheers,
Leonardo Javier Belén. AFIP-AR
- SQL, SQL, QUERY, MYSQL, SQL, SQL
Try to modify the autoexec.bat if you are using Win9x or the Path User env
in Winnt. Another choice in some systems is to modify DOSTART.bat or
something like that in \windows.
A way to keep the previous setting of the PATH env is to issue a stat like
SET PATH=%PATH%;c:\mysql; ...
I hope this
of indexing
the tags, and allow the developer to add new functionality as RTF support
and TEX. Am I int the good way or I'll need to sleep more?
Leonardo Javier Belén. AFIP-AR.
-
Before posting, please check:
http
I tell you that there is a simple script under whatever/mysql/share/ that is
called mysql.sever and it manages the mysql server in a very fashionable
way: simply type mysql.server start or mysql.server stop. I use the
script to launch the server when my linux box starts.
Another posibility is to
of indexing
the tags, and allow the developer to add new functionality as RTF support
and TEX. Am I int the good way or I'll need to sleep more?
Leonardo Javier Belén. AFIP-AR.
-
Before posting, please check:
http
Well, just that thing. I'm able to search, retrieve and update Mysql tables
(server located on a Linux Box) but I cannot create tables, nor modify its
structures. Does anyone knows why. Leonardo Belen. Afip AR
PS: I tried with the last stable release of Mysql and MyODBC from MYSQL.COM.
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
AIX if you didnt set the Large File System on, and some Linux Kernels.
However, they dont limit anything but any file in the system to that size.
For instance, the same see the OS if you have a 2,5 GB (not allowed - too
big) or a 2,5 db file (the same reason) thats why there are out there some
AIX if you didnt set the Large File System on, and some Linux Kernels.
However, they dont limit anything but any file in the system to that size.
For instance, the same see the OS if you have a 2,5 GB (not allowed - too
big) or a 2,5 db file (the same reason) thats why there are out there some
29 matches
Mail list logo