I have searched the whole wide world (www) for months and have not found a
converter that properly convert a MS Access image (gif, jpeg etc) to MySQL blob.
How do I solve the problem, please? I am now frustrated.
I am using Java with MySQL.
Ant
How can change the syntax of the query below to a
"LIKE" criteria query?
SELECT ORGANIZATION_ID, ORGANIZATION_NAME,
MATCH (ORGANIZATION_NAME) AGAINST ("houston") AS score
FROM ORGANIZATION
WHERE MATCH (ORGANIZATION_NAME) AGAINST ("houston")
ORDER BY score DESC, ORGANIZATION_NAME ASC
_
Thank you everybody for the info.
I am considering switching to linux, do you think it is worth it? Does MySql
perform better on linux than on a freebsd box overall?
Much appreciated
Toni Vall
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "
tarts and keeps using all my resources.
Aparently there isn't any other active process on the machine.
I have checked at mysql.com but I couldn't find any related information.
¿Where could this problem come from?
¿Any solution?
Thank you very much in adv
aster.m = pick.p
where pick.q = 'y' and pick.p is null
but it doesn't work. oh ya, I use MySQL 3.23.45
thank you so much
Toni
< finish > ---
Toni wrote :
> i have a problem to compare data inside two tables. i have tw
dear all,
i have a problem to compare data inside two tables. i have two tables let
say: "Master" and "Pick". For example the content of these two tables are:
Table "Master" Table "Pick"
aa
bb
cc
d
n 1st Sept 2002. can i
give a single query to finish this job? i can select this with
$ select h.nof, h.tgl, d.code, d.qty from hinvoice h, dinvoice d where
h.nof=d.nof where h.tgl < '2002-09-01';
query. but how can i delete them ?
thank you for your att
You can use the auto increment column. However, you have to add it to
the table.
http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#example-AUTO_INCREMENT
On Thu, 12 Sep 2002, Fam. Tarniceru wrote:
> Dear Sirs,
>
> How can I handle with this situation?
> I need a speci
while adding a new
alias.
Toni
On Wed, 11 Sep 2002, Kristian Koehntopp wrote:
>
> I am using
>
> mysql> select version() as version;
> +-+
> | version |
> +-+
> | 3.23.48-log |
> +-+
> 1 row in set (0.00 sec)
>
&g
specially what
> > > indexes are available. If you just put "explain" in front of your query
> > > you will be able to see how mysql will execute your query.
> > >
> > > On Tuesday, September 10, 2002, at 09:45 AM, Toni Strandell wrote:
> > >
>
ure and especially what
> indexes are available. If you just put "explain" in front of your query
> you will be able to see how mysql will execute your query.
>
> On Tuesday, September 10, 2002, at 09:45 AM, Toni Strandell wrote:
>
>
>> How does MySQL process
How does MySQL process a join between tables? Does it always use
nested-loop join, or does it use sort-merge join if the table is sorted
before joining it? Is the join algorithm merge if the tables are already
sorted on the join attributes (through an index)?
Sincerely,
Toni Strandell
e alternative without having to make 'such many queries (or
looping thru' my interface prog language)' as implied in first possibility, or is
there no other option than moving to MySQL 4?
Thanks!
--
Toni Hermoso Pulido
-
t to this MySQL
server
would you please give me an explanation to solve this problem? i believe the
problem is in the networking.
regard
toni
-
Before posting, please check:
http://www.mysql.com/manual.php (the
data base
engines together, so that importing or re-exporting the
data from/to the AS/400 goes smooth. Perl would be the
language of choice here ;)
Regards,
--Toni++
-
Before posting, please check:
http://www.mysql.co
15 matches
Mail list logo
