Pada Fri, 23 Aug 2002 16:53:59 -0700
Dave Reinhardt <[EMAIL PROTECTED]> menulis :
> I upgraded my server and seem to have lost some MySql records. Is there a way to
>recover lost records?
> Or could it be a index problem?
how did you upgrade it ? and from what information you notice that you've
Pada Sat, 24 Aug 2002 00:29:40 -0600 (MDT)
[EMAIL PROTECTED] menulis :
> I want to SELECT rows excluding a duplicates on the "name" column.
> I tried to use DISTINCTROW, but it selects unique rows.
>
> Is it possible at all?
select field1,field2,distinct(field3),field4 from tablename;
or
sel
Pada Sun, 25 Aug 2002 15:24:43 +0100
"Ray Healy (Data Net Services)" <[EMAIL PROTECTED]> menulis :
>
> The one thing I cannot get into my head is how can you tell the database
> that all the days between the "start" and "end" dates are booked.
> Also when
> people search for a caravan on a speci
Pada Sun, 25 Aug 2002 16:33:51 +0200
"andy" <[EMAIL PROTECTED]> menulis :
> 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
Config for us :
Linux Red-Hat
Kernel 2.4.7-10smp #1 SMP
Dual intel PIII
1 GB RAM
The problem occurs with these versions :
mysql-3.23.51-pc-linux-gnu-i686.tar.gz
and
mysql-3.23.52-pc-linux-gnu-i686.tar.gz
Cordialement
David BORDAS / JEUXVIDEO.COM
--
Pada Sun, 25 Aug 2002 22:04:13 +0200
David Durham <[EMAIL PROTECTED]> menulis :
> update CompanyContacts
> set ByEmailAddress = '[EMAIL PROTECTED]'
> where Description like '%marve%'
>
> If I say:
> select * from CompanyContacts
> where Description like '%marve%'
What was the error message disp
Pada Mon, 26 Aug 2002 00:47:33 +
"Will K." <[EMAIL PROTECTED]> menulis :
> 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
http:/
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
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 conta
> 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.p
> 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
th
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 va
> 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).
Techn
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
incur
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 CompanyC
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 --with-named-curses-libs=/us
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 sugg
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 you
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
(
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).
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
S
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
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
---
>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(i
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 c
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
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 ) you
can rewrite the query using LEFT OUTER JOIN's. In this case, the
solution would be something like:
SELECT *
FROM ord
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 M
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 or
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 to
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 characters
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
an
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 [mys
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
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 c
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
> 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. (me
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
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 pla
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
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 the
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).
>
42 matches
Mail list logo