x27;standard' distribution API, but
if not, how to I modify the API to provide this?
thanks
alan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
;
SELECT * FROM tests WHERE test_id IS NULL
Yes, that works, but I was also trying SELECT * instead of just the
key field (just a typo in the example). The problem was in the equal
sign versus the 'IS' operator. Any reason why MySQL does not honor
=NULL? Seems kind of odd.
alan
for test_id. Is there some trick to finding null valued
records in MySQL? This same sql has always worked on any other dbms
I have used.
thanks
alan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
going wrong?
Alan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
my name is alan madsen.
while i am very well grounded in complex systems and database
management that is archaic by today's standards, i am looking
at a creating a server-side php/mysql environment for a very
simple database application with only the experience of recent
light readin
my name is alan madsen.
while i am very well grounded in complex systems and database
management that is archaic by today's standards, i am looking
at a creating a server-side php/mysql environment for a very
simple database application with only the experience of recent
light readin
All,
Is there a recommended GUI that will administer multiple MySQL 4.x
databases. I need the ability to monitor connections, health, users, etc.
and notify me when there is a problem with an instance.
Regards,
Alan L. Fisher
GPI
--
MySQL General Mailing List
For list archives: http
All,
I would like to knew if anyone knows of a way to automate innoDB Hot Backups
of several databases that can be set to occur at off hours. Also, is it
possible to run several backups at one time. I am using MySQL 4.1.x on a
Solaris system.
Thanks,
Alan Fisher
--
MySQL General Mailing List
All,
I have been tasked with setting up DR between two different sites. Is there
a favorite tool or GUI that someone could recommend for this task?
Regards,
Alan L. Fisher
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
e import
SET AUTOCOMMIT = 1;
SET FOREIGN_KEY_CHECKS=1;
--
Alan Williamson, Technology Evangelist
SpikeSource Inc.
Daily OS News @ http://compiledby.spikesource.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
TER
that has to accept all the INSERT/UPDATE/DELETE (or anything that will
make the data change). All other nodes would be considered SLAVEs and
be READ-ONLY.
Hope this helps.
a
--
Alan Williamson, Technology Evangelist
SpikeSource Inc.
Daily OS News @ http://compiledby.spikesource.com/
abase and therefore not have to bring it down ever.
I wrote a blog entry about this very thing, and had some interesting
comments back on
http://blog.spikesource.com/mysql_hotbackup.htm
Hope this helps,
alan
--
Alan Williamson, Technology Evangelist
SpikeSource Inc.
Daily OS Ne
e any
other character, so will have no problems.
HTML is just string; treat it as such and don't give it anymore credit
than that and you'll be fine.
--
Alan Williamson, Technology Evangelist
SpikeSource Inc.
Daily OS News @ http://compiledby.spikesource.com/
--
MySQL General Mai
gle table (more than one file handle since there is multiple files that
describe a table under MyISAM).
BTW on Linux systems you can check this using:
% lsof
--
Alan Williamson, Technology Evangelist
SpikeSource Inc.
Daily OS News @ http://compiledby.spikesource.com/
--
MySQL General Mai
> I have made a user with the following command:
> GRANT ALL ON *.* TO 'test'@123.123.123.123' IDENTIFIED BY 'h4x0r'
Silly question Morten, and I am sure you have probably done it, but
you are definitely running:
% mysql> FLUSH PRIVILEGES;
--
Alan
mysql_hotbackup.htm
hope this helps,
alan
--
Alan Williamson, Technology Evangelist
SpikeSource Inc.
t: 650 249 4279
b: http://compiledby.spikesource.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Server v4.1.x
Is there a table in any instance of mysql that I write some queries and
insert/update statement against for moving databases between systems?
Any assistance would be appreciated.
Does anyone have a sample of a simple update statement I can run to update a
field in a table to all uppercase values.
Any help or web references are appreciated.
We have 2 distinct groups of developers - Windows vs. Linux. Our production
server is going to run on Solaris.
The issue is that all developers run there own instance of MySQL server Linux
or Windows based and the same version 4.1.7. Also, each developer has the
database for their particular pr
ed to submit it as bug 4893 anyway. The
syntax there should be correct.
--
Regards,
Alan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
WHERE C.B IS NULL
Expected Result:
A3
--
2
Actual Result:
A3
--
1
2
2
Tried in postgresql and it works like the expected result.
>Fix:
none
>Submitter-Id:
>Originator:Alan Tam
>Organization:
>MySQL support: none
>Synopsis: Right join after inner join ha
our
results.
thanks
alan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thank you, a much reasoned and sensible reply.
This is information people can use, as oppose to the posts that 'say
well its okay for me, you must be stupid' types.
;)
Dan Nelson wrote:
In the last episode (Apr 06), Alan Williamson said:
the most popular would have been Red
dan wrote:
the most popular would have been Red Hat, which doesn't have this limit
you speak of, even plain vanilla install (no twiddling needed).
Not to spoil a perfectly good pontification ... but i have to say that
we have a Redhat8 distribution running on a Dell PowerEdge Server and
when A
RTFM!
and what was the reason for this rudeness? Can't you explain yourself
without descending into this sort of language?
I do read the manual, and it is this reason i posted to the list.
Clarity is a wonderful thing, and sadly the manual isn't clear on this
matter.
I stand by my original s
Does CURDATE() support numeric addition like this? Or is the "+0"
purely a casting-hack to get the right format. Its not meant as pure
addition.
Yes, hav a look at http://www.mysql.com/doc/en/Date_and_time_functions.html
for explaination
further for addition, use date_add(curdate(), interval 1
CURDATE() support numeric addition like this? Or is the "+0"
purely a casting-hack to get the right format. Its not meant as pure
addition.
Thoughts?
thanks
alan
--
Alan Williamson, City Planner
w: http://www.BLOG-CITY.com/
e: [EMAIL PROTECTED]
b: http://alan.blog-city.com/
--
MyS
Thanks for that Chris, interesting thoughts.
For clarification, there is *NO* UPDATEs running on this table. Not a
single one! :) Many more SELECTs than INSERTs
Chris Nolan wrote:
Alan Williamson wrote:
A quick question for the hardcore MySQL experts out there.
I have a simple table
table using INNODB?
Should it have been created as a INNODB for better performance?
Any thoughts, insights, would be listened to intensely! :)
thanks
--
Alan Williamson, City Planner
w: http://www.BLOG-CITY.com/
e: [EMAIL PROTECTED]
b: http://alan.blog-city.com/
--
MySQL General Mailing List
For
Can people please just email the list and not the person *AND* the list!!!
i get duplicate emails and its very annoying to what is a great list so
far. kinda puts me off from answering peoples questions!
thanks! :)
- Original Message -
From: "Alan Williamson" <[EMAIL P
huge performance gain.
hope this helps, i'll let the real SQL experts jump in here and give
their response.
--
Alan Williamson, City Planner
w: http://www.BLOG-CITY.com/
e: [EMAIL PROTECTED]
b: http://alan.blog-city.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.
With respect to this problem, I am not running on Windows, but Redhat,
and seeing this problem often.
Which part of:
http://www.mysql.com/documentation/connector-j/index.html#id2803835
should i be looking at?
thanks
alan
--
MySQL General Mailing List
For list archives: http
made error.
Thanks.
- Original Message -
From: Alan
To: [EMAIL PROTECTED]
Sent: Saturday, February 28, 2004 5:07 PM
Subject: procedure entry point question
Hello,
I'm working with MySql 4.0.18 on Windows2000 and have a question about the C API
Hello,
I'm working with MySql 4.0.18 on Windows2000 and
have a question about the C API function mysql_real_escape_string( ).
The program I'm working on compiles and links
flawlessly, but at runtime, I get a system pop-up with the error: "The
procedure entry point mysql_real_escape_stri
t upgrade :)
Sorry for being such a lamer n00b, but it's not my DB and mysql has
always "just worked" for me (though I don't use many 600k row tables :)
Alan
--
Alan <[EMAIL PROTECTED]> - http://arcterex.net
---
e configs, all with the same results.
Many thanks.
alan
--
Alan <[EMAIL PROTECTED]> - http://arcterex.net
"There are only 3 real sports: bull-fighting, car racing and mountain
climbing. All the others are mere games.&quo
e tcp_wrappers compiled source?
[1] http://linuxfromscratch.org/pipermail/blfs-dev/2002-December/001770.html
--
Alan W. Rateliff, II: RATELIFF.NET
Independent Technology Consultant :[EMAIL PROTECTED]
(Office) 850/350-0260
In all probability it's "(x_section.Status & 1) = 0" and
"(x_instance.Status & 255) = 0" that's giving you the problem.
Unfortunately this is a database schema problem not a query fix. By putting
a computation on a field into the WHERE clause, you're forcing the database
to do that computation
ompt";
(sorry if the spacing is weird)
I need to drop the rows returned that have the same part_description field,
like the DISTINCT clause does for rows, i need the same thing for a field
value, how can I do this?
Thanks for the help,
Alan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear sirs,
I have mysql 4.01 installed on my pc (not source,only binary)on win98 (I tried in win
XP too).I downloaded myodbc source (3.51)and tryed compiled release with nmake (using
makefile included in source)but aving a link error "unresolved esternal _aulldvrm in
mysqlclient" (same message
k list.
query, mysql
--
Alan W. Rateliff, II: RATELIFF.NET
Independent Technology Consultant :[EMAIL PROTECTED]
(Office) 850/350-0260: (Mobile) 850/559-0100
-
[System Administration][IT Consul
>
> Nesh Nenad Mijailovic
The crew noted a while back that their Solaris 7 machine died and has yet to
be replaced. Until then, what kind of problems are you having compiling on
Solaris 7?
Alternately, check out SunFreeware < http://sunfreeware.com > as Steve ha
Okay, I've seen just about every question on last_insert_id(), except this
one:
I am running MySQL on Win XP and when I generate a test table (test) with an
AUTO_INCREMENT column (aid) and a second column (a) then use an insert
statement like: INSERT INTO test (a) values (1); then: SELECT
LAST_INS
y.cnf file and remove the # character before the parameter that
starts with innodb_ See section 4.1.2 `my.cnf' Option Files, and
section 7.5.2 InnoDB Startup Options.
Unfortunately, MySQL silently accepts and ignores 'innodb' type tables
when innodb is dis
me type of error log that I
could reference to check for more information?
Thanks for any and all help!! If you need any more information, I would
be more than happy to answer any questions!
Alan
-
Before posting, please che
You need indexes as soon as (or rather just before) they provide a
performance difference.
Alan
-Original Message-
From: Iain Lang [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 22 December 2002 11:15 AM
To: [EMAIL PROTECTED]
Subject: How long is my piece of string?
.
Dear List,
I'm
> Mark Matthews wrote:
>
> > Alan Hodgkinson wrote:
> >
> > I would like to extract the meta data describing foreign key
> > relationships using ODBC (actually in Java using JDBC).
> >
> > My current version of mySQl 3.23.49 does not s
-InnoDB tables), as of version
3.32.50.
I don't want to do an upgrade unless I'm certain that I will
get the feature.
Can anyone enlighten me?
Many thanks in advance,
Alan.
-
Before posting, please chec
> From: David T-G [mailto:[EMAIL PROTECTED]]
> ...I still have to figure
> out how to make sure that our credit card types and skill levels don't
> get corrupted (MC, MasterCard, mastercard, ...), but I guess that gets
> enforced in the software interface, right?
Isn't the card type a piece of der
> From: Michael She [mailto:[EMAIL PROTECTED]]
> ...So are you saying that the Windows ODBC MySQL driver
> doesn't support multiple statements?
So far as I know, *no* drivers support multiple statements.
However, that's not what you want for "bulk inserts". What you want is multiple value
sets
> From: Alex Behrens [mailto:[EMAIL PROTECTED]]
> ...How can I make it so only one form
> selection adds a DESC tag to the query, is this possible?
>
> I'm using this code:
>
> $fetch = mysql_query("SELECT * FROM players ORDER BY $var");
>
>
> Name
> Position
> Number
> Grade
>
> I want only t
> mysql> select sum(trial_signups) from campaign_t where
> datestamp='20021204'\g
> ++
> | sum(trial_signups) |
> ++
> |100 |
> ++
>
>
> mysql> SELECT site_id, sum(raws) As RawHits, sum(uniques) As
> UniqueHits,
> sum(t
it only takes a few minutes to uninstall and install...
> -Original Message-
> From: Amittai Aviram [mailto:[EMAIL PROTECTED]]
> Sent: Monday, 2 December 2002 9:37
> To: Mysql
> Subject: Embarrassing: can't log in
>
>
> I've got an embarrassing problem. I installed MySQL on my WinXP machi
this might give you some ideas
select
CONCAT(DAYOFMONTH(p.DATEGOLIVE),'.',MONTH(p.DATEGOLIVE),'.',YEAR(p.DATEGOLIV
E)) DATEGOLIVEF
from my table p
> -Original Message-
> From: Alex Behrens [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 22 November 2002 13:01
> To: MYSQL
> Subject: date convers
I was wondering if some things can be done with mySQL:
Select rows that have a number in ANY column, without specifying every
column in the select statement.
Perform statistical analysis on the numbers in a column (like regression).
I've only seen simple things like maximum and sum.
---
file, then atlter the
table again to add the ID field
Alan
> -Original Message-
> From: Chris Walcott [mailto:cwalcott@;macromedia.com]
> Sent: Thursday, 14 November 2002 9:42
> To: Mysql-L (E-mail)
> Subject: trouble with LOAD command
>
>
> How do I LOAD a text file i
Ah, yes - sorry
Alan
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:murad@;godel.bioc.columbia.edu]On Behalf Of Murad Nayal
> Sent: Wednesday, 13 November 2002 12:58
> Cc: [EMAIL PROTECTED]
> Subject: Re: Count Rows in two tables
>
>
>
> Ala
You can't count the join?
Alan
> -Original Message-
> From: Rick Baranowski [mailto:rickb@;baranconsulting.com]
> Sent: Wednesday, 13 November 2002 12:10
> To: [EMAIL PROTECTED]
> Subject: Count Rows in two tables
>
>
> Hello all,
>
> Does anybody hav
The .Neta Adapter.. does it make a persistent connection?
If the connection drops between the first insert and the call to select,
then the return would be zero
Alan
> -Original Message-
> From: Cain O'Sullivan [mailto:cos@;iinet.net.au]
> Sent: Wednesday, 13 November 2
MySQLFront will create the tables and pump the data with one button
press
Alan
> -Original Message-
> From: Terry [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 12 November 2002 22:02
> To: [EMAIL PROTECTED]
> Subject: RE: How to port MS Access to MySQL ??
>
>
by it? you can
ignore the obsolete in the main select when it's returned since it will all
be the same value... put it first.
Alan
> -Original Message-
> From: Ed Reed [mailto:ereed@;nearfield.com]
> Sent: Tuesday, 12 November 2002 18:54
> To: [EMAIL PROTECTED]; [EMAIL
I agree mostly,... but why is ASP worthless?
Alan
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:vanboers@;why.dedserius.com]On
> Behalf Of Van
> Sent: Monday, 11 November 2002 6:21
> To: Paul DuBois
> Cc: MySQL
> Subject: Re: PHP bias (Way OT)
>
>
&
Every SQL database requires the ability to locate a record which is unique
in some way. You can't have two records which look the same.
That's why you need to define a primary KEY on a column or coumns.
You need to read a primer on SQL databases
Alan
> -Original Messag
Also
In My Humble Opinion (IMHO)
For What It's Worth (FWIW)
> -Original Message-
> From: Gelu Gogancea [mailto:ggelu@;arctic.ro]
> Sent: Saturday, 9 November 2002 23:37
> To: Jocelyn Fournier; Jack Chen; [EMAIL PROTECTED]
> Subject: Re: mysqld refuse to die
>
>
> Yes.All processes are name
As Far As I Know
> -Original Message-
> From: Gelu Gogancea [mailto:ggelu@;arctic.ro]
> Sent: Saturday, 9 November 2002 23:37
> To: Jocelyn Fournier; Jack Chen; [EMAIL PROTECTED]
> Subject: Re: mysqld refuse to die
>
>
> Yes.All processes are named "mysqld"...less one "mysqld_safe"
> which
maybe it doesn't then in MySQL - it does elsewhere
Alan
> -Original Message-
> From: David Felio [mailto:david@;ark.org]
> Sent: Saturday, 9 November 2002 1:59
> To: MySQL List
> Subject: Re: Copy Records in a table...
>
>
> Is the implementation of thi
MySQLfront does it all
> -Original Message-
> From: tmb [mailto:topmailbox@;yahoo.com]
> Sent: Friday, 8 November 2002 23:18
> To: [EMAIL PROTECTED]
> Subject: How to port MS Access to MySQL ??
>
>
> Is there a tool for doing a quick port from MS Access
> to MySQL?
>
> Or must you manua
insert into mytable(field1, field2, field3) select field1, field2, newvalue
from mytable where productcode=xx
> -Original Message-
> From: Doug Coning [mailto:lists@;coning.com]
> Sent: Friday, 8 November 2002 14:35
> To: [EMAIL PROTECTED]
> Subject: Copy Records in a table...
>
>
> Hi eve
>If the data contains "\", then database will automatically takes "\"
>away and shift 1 byte left.
>My data will mass up. That is why I still need "\"
Does your data actually include backslash characters? If you want to import them as
they are, you definitely don't want to ESCAPE BY them.
Esca
I was under the impression that hotbackup was only available with innodb
tables
where do you get amanda from?
Alan
> -Original Message-
> From: Lewis Watson [mailto:lists@;visionsix.com]
> Sent: Wednesday, 6 November 2002 14:22
> To: mysql
> Subject: MySQL and amanda
>
&
Because a primary key is a table property and the index of the key is a
property of the primary key. If you want ot drop a primary key you alter the
table
> -Original Message-
> From: Eric Frazier [mailto:ef@;kwinternet.com]
> Sent: Tuesday, 5 November 2002 15:26
> To: Paul DuBois
> Cc: Um
> -Original Message-
> From: Jörgen Winqvist [mailto:jorgen@;winqvist.net]
>
> I need to let the values in two columns change place with each other.
> I've tried to "update xxx set a=b, b=a" but that doesn't work
> (b=a uses
> the "new" a).
Here's a cute trick for swapping two numbers w
it executes.
Is there something else at play here?
Alan
' Keywords:
' myODBC, mySQL,
' Error:
' Error: 7 - Error on rename of '.\DBNAME\tablename.MYI' to
'.\DBNAME\#sql2-61-19.MYI'
' (Errcode: 13)
' Environment:
' WkStn - Windows
I use MySQLFront and is creats the tables and imports the data with one
click
never had a problem
Alan
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:Sam4Software@;aol.com]
> Sent: Wednesday, 30 October 2002 9:15
> To: [EMAIL PROTECTED]
> Subject: Access2MyS
Then, why..., if I wait a little longer, does the alter command work? I do
not change the the permissions in the meantime. I just wait.
Alan
> -Original Message-
> From: gerald_clark [mailto:gerald_clark@;suppliersystems.com]
> Sent: Tuesday, 29 October 2002 1:38
> To: Alan M
> -Original Message-
> From: Chris Mason [mailto:masonc@;masonc.com]
> [...]
> The problem is, it is easy to test for one amenity, but I need to test
> that the hotel has all of the amenities. The query above
> returns all the
> hotels that have ANY of the amenities, I need the hotels hav
But after a while it does, cause I only have to wait a while with no
activity on the database, and the command executes. So it's not permissions
Alan
> -Original Message-
> From: gerald_clark [mailto:gerald_clark@;suppliersystems.com]
> Sent: Tuesday, 29 October 2002 1
.. Is there another way?
thanks
Alan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTEC
Is it possible to update a field using SQL with the contents of a text file
previoously written to disk?
I want to update a mediumtext field with the contents of c:\data\mytext.txt
file.
update mytable set mymediumtext= filecontents where id=number... ?
Alan
SQL
The docs say that recordset1.RecordCount will return the correct value if
adUseClient is used as the cursorlocation setting. I find that this is not
correct - is there another setting which needs to be mae to make this return
correctly - my return matching rows setting is also set.
Alan
SQL
ASP
I can't seem to find any examples of saving text area form inputs to TEXT
type fields.
They all seem to be text inputs or strings being saved to varchar fields...
Can someone point me to an example of saving large text quantities to a TEXT
Type field in ASP?
Thanks
Alan McDonald
can someone tell me why I get this error back from postings?
Your message was not delivered for the following reason:
E-mail Account: lists-mysql is over the limit of 31457280 bytes.
Automated Postmaster
Alan McDonald
http://www.meta.com.au
isn't that the month changing?
it's changing from october to january...??
Alan
> -Original Message-
> From: Jay X [mailto:sparqz50@;hotmail.com]
> Sent: Monday, 21 October 2002 12:20
> To: [EMAIL PROTECTED]
> Subject: timestamp bug increments by one day
&g
John,
StudioName?
GenreName?
F_Name?
L_Name?
DatabaseName?
ServerName?
Alan
I can't seem to figure out the select statement to get the name. Do I need
the the StarID or ActorID in Titles table? Thank you.
I am using PHP and MYSQL.
Studios (StudioName, StudioID)
Genres (GenreName, Ge
I think you need to give us the SQL you are using to do the search - we'll
ba ble to see what your are trying to do better
Alan
> -Original Message-
> From: µÑ ¶Ì [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 17 October 2002 15:37
> To: [EMAIL PROTECTED]
> Subje
Sorry your second link makes that claim a little clearer - it's on a
per-connection basis
Alan
> -Original Message-
> From: Roger Baklund [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 16 October 2002 23:58
> To: [EMAIL PROTECTED]
> Cc: Alan McDonald
> Subject: R
? Or
does insert_id() return another connections last insert?
Alan
> -Original Message-
> From: Peter Lovatt [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 17 October 2002 0:59
> To: Alan McDonald; [EMAIL PROTECTED]
> Subject: RE: Inserting Master and Details records
>
&g
to grab a generator ID and using that (guaranteed to
be unique) for both the primary key of the master and the foreign key of the
detail records. Surely there is a good method for use with MySQL....?
Alan McDonald
http://www.m
g
you may have to worry about it deleting /var/lib/mysql when you
uninstall the old package, but I'd hope that package maintainers
wouldn't just nuke a db directory without warning :)
alan
--
Alan "Arcterex" <[EMAIL PROTECTED]> -=][=- http://arcterex.net
"I used to
-cgi?1:mss:116929:200208:ngkbacmgkmgkdbbf
gjdo
The line numbers are different as of the latest MySQL version, but modifying
the configure script as shown (just search for some keyword using your
favorite text editor) works like a charm, promise.
Also, if you have crle configured already, you needn
On Sun, Oct 13, 2002 at 10:58:53PM +, Sergei Golubchik wrote:
> Hi!
>
> On Oct 13, Alan wrote:
> >
> > mysql> select title from content where match
> > (title,center_content,right_content) against ('updates');
> &g
orning, just in case, but when I execute the
query again, I still get the same results.
Any other ideas? This works for others I am guessing. I've tried this
on the binary 4.0.4-beta on a redhat 7.2 system and 4.0.1-alpha compiled
from source on a gentoo system.
--
Alan "Ar
sec)
But when I try to match on 'exi', I get:
mysql> select title from content where match
(title,center_content,right_content) against ('exi');
Empty set (0.00 sec)
As far as I can tell, this *should* be working. Can anyone help please?
Regards and TIA.
alan
--
Alan &qu
I am trying to create a mysql connection pool in Weblogic 6.1 using the
JConnector driver and failing. All I get is "no suitable driver" which
usually means that the URL and properties aren't right for the driver I'm
using. I defined the pool as:
name: MysqlPool
URL: jdbc:mysql//192.168.1.100:330
build and documentation (do I
have
> to submit a bug??).
Worked like a charm. Thanks for all your hard work. Looks like I'll be
updating my aged HOWTO :)
--
Alan W. Rateliff, II: RATELIFF.NET
Independent Technology Consultant :[EMAIL PROTECTED]
sold
> from 13 in table 12 -> then does this with table 13 and finally creates
> table 19 (because new) and inserts like in Cosumter A's way...
>
> now the question: is MySQL aware of being with over 1500 tables ??? - is
> there a better way or more efficent way to do the sa
Never mind, I figured it out by reading a previous question and I understand
how to use Left join to do this.
-Original Message-
From: Alan Coleman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 5:22 AM
To: [EMAIL PROTECTED]
Subject: Internal Select statements using IN and
d then
some. But I've searched the documentation and haven't found anything.
If anyone knows a way to perform an internal select similar to what is shown
above, please let me know.
---
Alan Coleman
[EMAIL PROTECTED]
-
offers version 2.0.4 for download. Should this be updated?
--Alan
-Original Message-
From: Jeff Kilbride [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 6:44 PM
To: Alan Jones; [EMAIL PROTECTED]
Subject: Re: Problem with JDBC2 driver across databases
First, I would recommend upg
Thanks Mark. I've now downloaded 2.0.13 and I'll see if the
problem is still there. Meanwhile I've used a workaround involving
two connections, one to each database, so the insert works.
Not ideal, though.
--Alan
-Original Message-
From: Mark Matthews [mailto:[EMAIL P
1 - 100 of 149 matches
Mail list logo
