Recently I have been approached to do a web based reservations database
for hotels. I am thinking highly of using MySQL on Linux(?) with
Apache. I have used Informix SE on SCO Unix for years (due to the
previous platform) and would like to ask you all a few questions I have
not been able to
Do a locate mysql.sock it's there. Do a search on the newsgroup at
http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b
On mysql.sock
M;)
On Sat, 2002-08-24 at 21:34, Roger Young wrote:
I'm trying to install the binary mysql-3.23.52 under Linux (Slackware
8.2 distribution, kernel 2.4.18).
I
Hi.
On Sat 2002-08-24 at 13:29:02 -0600, [EMAIL PROTECTED] wrote:
When I say:
SELECT * FROM product WHERE FIND_IN_SET(1, cat_id);
Does cat_id have to be of SET value.
No. It just has to be a comma-seperated list of values (where values
also may be none or one, i.e. no commas there).
Hello.
(This is more an additional answer to the original mail than to the
one I replied to).
On Sat 2002-08-24 at 19:21:56 -0400, [EMAIL PROTECTED] wrote:
On Sat, 2002-08-24 at 18:38, Van wrote:
Just thought I'd pass it along, since I haven't seen Monty and
crew address it.
I think that
Hello.
On Sun 2002-08-25 at 02:36:35 -0700, [EMAIL PROTECTED] wrote:
Recently I have been approached to do a web based reservations database
for hotels. I am thinking highly of using MySQL on Linux(?) with
Apache. I have used Informix SE on SCO Unix for years (due to the
previous
Subject: Re: New to MySQL
From: Benjamin Pflugmann [EMAIL PROTECTED]
===
Hello.
On Sun 2002-08-25 at 02:36:35 -0700, [EMAIL PROTECTED] wrote:
Recently I have been approached to do a web based reservations database
for hotels. I am thinking highly of using MySQL on Linux(?) with
Apache. I
Are there any mysql books in Latin?
Me sequelae datorum ordinatrum, scribo Paulus ExSilvaticus
- when you write the rest yourself you may find the following
useful/entertaining
Vocabula computatralia
Vocabula computatralia. A. abort 1. vt interrumpere 2. subst. interruptus,us
m. address 1.
Thanks for your reply.
Do a locate mysql.sock it's there.
For some reason on my machine the mysql install procedure
does not create the socket. The locate utility (after updatedb)
does not find mysql.sock and the socket directory /var/run/mysql
is not established.
I must be omitting some
Benjamin Pflugmann wrote:
On Sat 2002-08-24 at 19:21:56 -0400, [EMAIL PROTECTED] wrote:
On Sat, 2002-08-24 at 18:38, Van wrote:
Just thought I'd pass it along, since I haven't seen Monty and
crew address it.
I think that it is a non-issue and that this already has been convered
in
This is deceptively simple, and I very much appreciate your suggestion - but
it doesn't work. Your suggestion still returns records that I should not
see. Once again, there is a one to many relationship between an order_id in
the order_id in the transaction response table. Please see my original
Hi,
MySQL install do not create socket.This socket it's created when MySQL
daemon it's started.
My suggestion :
1.check if you have already mysqld processes.
2.
- Change the owner of directory which is created for mysql.sock from
root to mysql
...or
- Change in /etc/my.cnf(in
Paul,
Based on your original post, I'd have to agree with Brian. That query
should work. In fact, something as simple as this should work too:
select
order.order_id
from
order
,transaction_log
where
order.order_id = transaction_log.order_id
Hi there,
I am trying to write a php script to perform a full text search on a mysql
db. I do a match against... and it digs out some results out of the db.
There are 2 problems:
1. How can I restrict the results to e.g. 100 characters, but to make sure
the keyword is within this 100
Hi all
(details of database at then end of this message)
I hope someone can give me some advice. I am trying to create a database and
access via PHP for a friend of mine that has a caravan park. What I want him
to be able to do is to add bookings for the caravans via a PHP page and for
clients
Ok, I did not make the correlation between what rows you wanted and what the
data was. You are not getting this in one query. It would require a
sub-select. However, simple, but possibly slow queries will get it.
select * from transaction_log where event_log_id=3
get those back and
select
Hi,
Could anyone tell me what are the differences between MySQL 4 and MySQL Max
4, now that MySQL 4 has InnoDB built in as standard? I couldn't find the
answer in the manual or the download section. I'd like to download MySQL
and definitely want InnoDB, but I don't know whether i should go with
Actually, you should be able to get the data in one query: in general,
any time you are doing a restriction on some value being in a set of
values (such as order_id not in some list built from a subselect) you
can rewrite the query using LEFT OUTER JOIN's. In this case, the
solution would be
On Sun, Aug 25, 2002 at 01:11:16PM -0400, Andy Leung wrote:
Hi,
Could anyone tell me what are the differences between MySQL 4 and
MySQL Max 4, now that MySQL 4 has InnoDB built in as standard? I
couldn't find the answer in the manual or the download section. I'd
like to download MySQL and
This may be a truly dumb question, but could someone please tell me why
this sql query/ statement does not work:
update CompanyContacts
set ByEmailAddress = '[EMAIL PROTECTED]'
where Description like '%marve%'
If I say:
select * from CompanyContacts
where Description like '%marve%'
I get the
MySQL install do not create socket.This socket it's created when MySQL
daemon it's started.
My suggestion :
1.check if you have already mysqld processes.
2.
- Change the owner of directory which is created for mysql.sock from
root to mysql
...or
- Change in /etc/my.cnf(in [mysqld]
Hi,
I am trying to have a whole class C access the mysql server on the
network. The class C needs to access many different database names. So
adding an entry for each Ip address wouldn't work. Does anyone know how
I can go about this?
Thanks,
Adam
Hi,
some time ago I submitted the bug report below (see
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:116815:200208:nnjofboiddhkghnpfljl
for the full report). There was no feedback and I now have a better
understanding of the problem:
The bug means that you cannot compile a KDE3 program with
Thank you very much! This was the precise solution I was looking for.
Brian - I'm sure your method would also work. Thank you both sooo much.
-Original Message-
From: Chris Tucker [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 25, 2002 2:18 PM
To: Brian Moon
Cc: Paul Maine; MySQL MySQL
GRANT SELECT ON db.* TO user@'192.168.1.0/255.255.255.0'
should do the trick: you just specify the IP you want to allow and the
netmask to apply to it after the /. You could also use:
GRANT SELECT ON db.* TO user@'192.168.1.%'
as documented in the manual
(http://www.mysql.com/doc/en/GRANT.html).
Dear Sir,
MySQL 3.23.52 won't compile on Mac OS X 10.2 based on Darwin 6.0
which comes pre-installed with gcc 3.1
I don't want to uninstall it as it would probably bring down other
major functions of the new system.
Regards,
Mitch Leung
--
__ __ __ __ _ _ Mitch Leung
(
Hi,
I am learning about MySQL and how to use the CREATE TABLE command, and I was
wondering where I could learn more about MySQL datatypes (cause they seem to
be a big part of this command).
Will
_
Send and receive Hotmail on
Ok,
Have had continuing issues with trying to actually get LOAD LOCAL INFILE
commands working. Even after a MySQL recompile it doesn't appear to be
working. Basically, no matter what I specify with LOCAL LOCAL INFILE mysql
refuses to let my user (setup via Plesk) do a thing.
Anyone have any
I got MySQL 4.0.2-alpha compiled on Mac OS X 10.2 (final version -
Jaguar6C115).
I am having problems with getting any client to connect to it, so
perhaps I am doing something else wrong, which is possible since I am
new to MySQL
First I tried:
./configure
David
[ mysql,query ]
update CompanyContacts
set ByEmailAddress = '[EMAIL PROTECTED]'
where Description like '%marve%'
Can you show us the output of:
describe CompanyContacts
...and also what is the exact error message?
Are you connected as a user who is allowed to update the
I've compiled debugging into the library .. now I figured the library was
getting loaded/unloaded, but it didn't really come to mind until I ran it
with debugging. My atomic tests (A standalone program that init's and
closes) does NOT do this.. So, I'm wondering if the leak is somehow being
Can anyone help me please.
Need more information, I think.
I am a UK lawyer and I have a client accused of concealing theft of cash by
sending invoices to this date (so the accounts software wouldn't report the
sale and discrepancy between stock and receipts would not be noticed).
Hi guys
I would like to have a SQL query to couple five tables to accomplish my need.
This is a search page and the user will be searching using the don_id
Presently I am using a simple equi join which works fine if all the five
tables contain data for user_id
But if any of the tables have no
For some reason my client sub-directory did not get re-named to bin
and, as I said, I cannot connect. Keep getting:
% mysql
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
The one time I got MySQL running under Mac OS X (10.1), I had to mkdir
the
Hello,
Just joined this SQL mailing list a few days ago, and I want to change
my membership to digest mode. Anybody could help me ?
Thanks
Benny
-
Before posting, please check:
http://www.mysql.com/manual.php
If I link the library with '-z nodelete' the leak goes away. The library
doesn't get loaded and unloaded over and over again...
From the Solaris 'ld' man page
-z nodelete
Marks the object as non-deletable at runtime. The run-
time processing of an object that
On 8/25/02 11:36 PM, Joel Rees [EMAIL PROTECTED] wrote:
For some reason my client sub-directory did not get re-named to bin
and, as I said, I cannot connect. Keep getting:
% mysql
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
You might want to take
36 matches
Mail list logo