I think it's better to pick one database and try to design and code
to its strengths and weaknesses.
I've worked on several projects in which the overall architectural
plan involved writing a database abstraction layer to keep options
open as to the specific relational db - MySQL, Oracle,
hi all...
i can't see the mysql 5 version for freebsd 6.0 on the mysql developer
site?
am i blind or it's on purpose?!?!
curious... and actually need it...
thanks...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
That's a pretty difficult request:
1) What versions? MySQL 4.0 has no stored procedures, functions, views, subselects. 4.1 added subselects. 5.0 added the rest.
Oracle 8i doesn't support ANSI-style outer joins (they use a proprietary format).
2) Different engines; MySQL supports federated, arc
Does anyone know of a resource ( on the web perhaps ) that discusses the
core differences between the different database's sql. I'm trying to write
code that produces the correct sql for a variety of databases. Such things
as Oracle's SEQUENCES versus mysql's AUTO_INCREMENT are of interest. Mayb
In the last episode (Mar 22), Kyle Johnson said:
> I'm new to the lists, but I had a question about authenticating a
> MySQL database; I wondered if anybody knew how to authenticate off of
> an LDAP instead of the default mysql table? Or if it's even possible?
> So far we have had no success browsi
Hey everybody,
I'm new to the lists, but I had a question about authenticating a MySQL
database; I wondered if anybody knew how to authenticate off of an LDAP
instead of the default mysql table? Or if it's even possible? So far we have
had no success browsing the docs or anywhere else online. I kn
Hi.
I've got mysql 4.0.18 installed on a sun X4100 running solaris.
This is just a 32 bit version of mysql.
I've reverted back to this version after trying mysql 5, 4.0.26 and
4.0.18 64bit.
Those versions were all unstable on 64bit, that is, the server would
just go away for no apparent reason
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Bill Adams wrote:
> http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
> I recommend "LEFT( )".
>
> If you are looking to do it in PHP then this is the wrong email list.
>
> Good luck.
Sorry about that I realized I picked the wrong mailing
"wait_timeout" setting would leave the connection/thread open for the
defined time even after the query has been executed..
Kishore Jalleda
On 3/22/06, Cory at SkyVantage <[EMAIL PROTECTED]> wrote:
>
> Is there anything I can put into the my.cnf file to buffer connection
> (leave it open) to
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
I recommend "LEFT( )".
If you are looking to do it in PHP then this is the wrong email list.
Good luck.
b.
CodeHeads wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello all,
Have a question:
I would like to limit the amou
I think you are asking for mysql_pconnect("localhost","root")
-Original Message-
From: Cory at SkyVantage [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 22, 2006 2:20 PM
To: MySQL-List
Subject: Connection Buffer
Is there anything I can put into the my.cnf file to buffer
connection
(le
Just figured it out without a UDF(not documented anywhere that I found).
SELECT conv(hex(fdata),16,10) INTO fdata_bigint;
So a double conversion seems to work for me.
You solution looks like it will work, but since I was able to get it to
work without a UDF, I'm not going to test it out. Thanks.
Is there anything I can put into the my.cnf file to buffer connection
(leave it open) to give a similar effect as connection pooling?
Thanks in advance!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello all,
Have a question:
I would like to limit the amount of data viewed. I searched but did not
find anything.
Here is my code:
$get_c = "select * from $table ORDER BY news_id DESC LIMIT 5";
$get_c_res = mysql_query($get_c) or die(mysql_error());
"David Godsey" <[EMAIL PROTECTED]> wrote on 03/22/2006 01:21:07 PM:
> I'm in the process of writing my first UDF and would appreciate some
help.
>
> I am pulling data from a table like:
>
> SELECT payload_time,
> SUBSTR(BINARY(frame_data),
> FLOOR(foffset/8)+1,
>
I'm in the process of writing my first UDF and would appreciate some help.
I am pulling data from a table like:
SELECT payload_time,
SUBSTR(BINARY(frame_data),
FLOOR(foffset/8)+1,
CEIL((flength + (foff
"Ing. Edwin Cruz" <[EMAIL PROTECTED]> wrote on 03/22/2006 11:38:53 AM:
> Ok, and sorry for my poor explanation and my "spanglish"
>
> The ofac list is a database with thousands of names of persons who are
> forbidden to do transactions like change of dollars to mexican pesos,
they
> are trying t
Ok, and sorry for my poor explanation and my "spanglish"
The ofac list is a database with thousands of names of persons who are
forbidden to do transactions like change of dollars to mexican pesos, they
are trying to avoid "money laundering", so if somebody try to do a
transaction he have to be se
Yesmin Patwary <[EMAIL PROTECTED]> wrote on 03/22/2006 09:56:20 AM:
> Dear All,
>
> First of all, I would like to thank Shawn Green, Peter Brawley and
> Josh for their kind help in my previous issue.
>
> I have a table named master_list with two field customer_id and
> list_code. I need to
Dear All,
First of all, I would like to thank Shawn Green, Peter Brawley and Josh for
their kind help in my previous issue.
I have a table named master_list with two field customer_id and list_code. I
need to insert only non existent records in master_list from a child_list. Both
ma
Gregory
>I thought about that but I'm worried about the users getting the rite data
>if multiple users make the same requests at the same time ... i supose the
>easiest would be to name the temp tables after the user making the request
>??
A temp table is visible only in the thread where it's be
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
what is the best way to match german umlauts like 'ä' also their
alternative writing 'ae'?
For example I'm searching for "übersee" and I also want to find the word
"uebersee" in the database. The "words" are actually names of persons.
One possib
repost your question, this time giving an explanation (complete with
MySQL version, platform, queries and results) as to how it "doesn't
work".
-Sheeri
On 3/15/06, Ing. Edwin Cruz <[EMAIL PROTECTED]> wrote:
> Hi folks! I'm asking in a web form for clients, those clients I have to
> search them in
Try Using " Select into outfile "
More Info : http://dev.mysql.com/doc/refman/5.0/en/select.html
--Praj
On Wed, 22 Mar 2006 12:59:44 +0530
Mohammed Abdul Azeem <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Can we any use bcp to perform bulk copy for MYSQL as in SYBASE ? If not,
> is there any other too
Yes, that was the problem, the my.cnf file was missing, replace it, restarted
and all is well :)
thx's
Mike
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, March 22, 2006 2:10 AM
Subject: Re: Problem restarting server
Mike,
- Original Message
You don't need to drop a TEMPORARY table... it is dropped at
connection-close !
You don't need to wory about different names for TEMPORARY tables...
Manual says:
> A TEMPORARY table is visible only to the current connection, and is
> dropped automatically when the connection is closed. This mean
Bill Adams wrote:
InnoDB always needs the shared tablespace because it puts its
internal data dictionary and undo logs there. The .ibd files are
not sufficient for InnoDB to operate.
well, thats what I found before. But it doesn't explain why InnoDB
does need a logfile even when all tra
hi all,
I read
http://dev.mysql.com/doc/refman/5.0/en/symbolic-links-to-databases.html
but on MySQL 4.0.24_Debian-10ubuntu2 server , in my my.conf file:
datadir = /var/lib/mysql
"ls" show as:
lrwxrwxrwx 1 mysql mysql 67 2006-03-12 22:42 mnogosearch3235 ->
/home/username/mnt/cobd/temp_mysql_da
It's working ok ..
But I have one problem ..
I'm getting the following error "Table 'max_bids3' already exists";
but I get the following ...
mysql> DROP TABLE max_bids3;
ERROR 1051 (42S02): Unknown table 'max_bids3'
What do I do to fix this, and how can I see the temp tables ?
On 3/21/06, Addis
Mike,
- Original Message -
From: ""Mike Blezien"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, March 22, 2006 3:42 AM
Subject: Problem restarting server
Hello,
we had to reboot our server and now we can't get MySQL started, in the
error log
it states:
30 matches
Mail list logo