Well MySQL will see all the changes coming from a single user (the user who
the web site connects to the database as). You'll have to add your own
routines to log that info to a table or something...
Unless ofcourse, I'm missing something, which I doubt :)
Regards,
Chris.
- Original Mes
Hi,
I got 4 relatively big (for me at least) queries. At the moment, the data
in the tables are merely test data, but once the system goes into
production, I'm expecting millions of records in most of the tables. I'm
trying very hard thus to optimise my queries and tables to ensure I get a
http://dev.mysql.com/doc/mysql/en/old-client.html
Regards,
Chris.
- Original Message -
From: "Odhiambo Washington" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, August 22, 2006 7:38 PM
Subject: MySQL 4.0.27-client and MySQL-4.1.21 server
hi
Why is it that I cannot connect to mysql-4.1
We are using an NOW() function in our database and occasionally it
produces odd results. There are entries where it states: -00-00
00:00:00 instead of the current time. Is this a bug, or are we using the
function incorrectly?
After patiently injecting at about 400 queries per seconds, a coup
INSERT INTO a VALUES (NOW()) ?
Regards,
Chris.
- Original Message -
From: "Renato Golin" <[EMAIL PROTECTED]>
To: "Nicholas Vettese" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, August 25, 2006 4:31 PM
Subject: Re: Testing Email
Nicholas Vettese wrote:
I have been having problems with my
Doh.. Wrong email ;)
INSERT INTO a VALUES (NOW()) ?
Regards,
Chris.
- Original Message -
From: "Renato Golin" <[EMAIL PROTECTED]>
To: "Chris Knipe" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>;
Sent: Friday, August 25, 2006 4:30 PM
Subject: Re:
Hi,
I need to make *allot* of queries from a application dealing with IP
Addresses. At the moment, I'm storing IP addresses as a VARCHAR(16). I
would *like* to store them as Integers by converting the IP to it's
numerical equivalent. I believe this would also save a enormous amount of
tabl
RTFM! Let that be a good lesson for me now :)
INET_ATON() and INET_NTOA() Brilliant!!!
Regards,
Chris.
- Original Message -
From: "Chris Knipe" <[EMAIL PROTECTED]>
To:
Sent: Saturday, August 26, 2006 9:03 PM
Subject: IP Address Function?
Hi,
I need to make *a
PS: I already tried with "myisamchk -r -o *.MY*", but then all datasets
are gone and the table is empty. :-(
man myisamchk
I tried myisamchk already. But after running the above rescue attempt, the
tables are empty.
Then I hope you made backups You, do keep backups right?
--
Chris
-
On filesystem level I made all rescue trials. My problem is, that only the
MYD
file is still available. I tried reconstructing it with "myisamchk -r -o
table_name.MYD", but as I said without the wanted result.
MYD is your data, MYI is your indexes (Indexes are easy to rebuild, you
should not w
Hi all,
The moral of the story, is don't run out of disk space, but it's a bit to
late for that now.
A quick scenario One master server, two backups replicating from the
master. Our data and bin logs are on two different partitions, and the
partition holding the bin logs, ran out of disk spa
Put a index on col3 and it will be faster. That's the only way as far as I
know.
--
Chris.
- Original Message -
From: "Michael Monashev" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, July 20, 2005 3:04 PM
Subject: random rows selection
Hello,
How to select 5 random rows from big tabl
Lo everyone,
Small issue.. MySQL 4.1.12...
PURGE MASTER LOGS BEFORE DATE_SUB(NOW(), INTERVAL 10 DAY);
Absolutely nothing happens
PURGE MASTER LOGS TO 'blah-bin.00030';
Logs are cleared immediately.
Any reason why LOGS BEFORE is not working???
Thanks,
Chris.
--
MySQL General Ma
Quoting cars...@bitbybit.dk:
Of course you can have ID=0.
Definately agree
mysql> DESCRIBE test;
+-+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+-+---
#x27;t see / use the FULL TEXT that has already been created.
Thanks for the assistance.
--
Regards,
Chris Knipe
--++---+-+--++--++-+
8 rows in set (0.00 sec)
mysql> SELECT COUNT(FlightID) FROM FlightRoutes; ## Grows by a few houndred
records per day.
+---------+
| COUNT(FlightID) |
+-+
| 106216 |
+-+
1 row in set (0.00 sec)
mysql> SELECT COUNT(EntryID) FROM IVAOData; ## Grows by a few thousand
records per day.
++
| COUNT(EntryID) |
++
| 13130747 |
++
1 row in set (0.00 sec)
--
Regards,
Chris Knipe
re also the requisites for helping optimizing your query if
> required...
>
> Thanks.
>
> Anirudh Sundar
>
>
> On Fri, May 7, 2010 at 12:14 PM, Chris Knipe wrote:
>
>> Hi All,
>>
>> I have a huge issue with a query - it copies the entire table to a tmp
way to do it.
I'll rethink this a bit more and come up with something better.
PS - Started the query before my first email was even posted, it's still
running... 3948 Seconds the last time I checked...
--
Regards,
Chris Knipe
os. All the databases use MyISAM
> exclusively.
>
> Given the above, can anyone suggest any possible causes?
>
> Thanks
>
> Mark
> --
> http://mark.goodge.co.uk
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=sav...@savage.za.org
>
>
--
Regards,
Chris Knipe
Hi all,
We run an VERY io intensive file application service. Currently, our
problem is that our disk spindles are being completely killed due to
insufficient SEEK time on the hard drives (NOT physical read/write speeds).
We have an directory structure where the files are stored based on the MD5
eded to benchmark for seek
> times myself. We're using IBM's commercial GPFS here, which is good with
> enormous amounts of huge files (media farm here), not sure how it'd fare with
> smaller files.
>
> Hope that helps,
> Johan
>
> - Original Messa
will have seeks.
>>
>>No, adding more RAM won't help much. Here's an argument:
>>Suppose your data is 20 times as big as the buffer pool and you are
>>doing random fetches (MD5, etc). Then 1/20 of fetches are cached; 95%
>>cache miss. Estimated time: 0.95
Hi All,
I have a couple of *huge* tables, they're still busy populating, but once
done I suspect it will hold well over 3 billion records (and that's more
than likely the start of the problem).
The mysql server is a highly optimized, powerful server with some 128GB ram,
data + binlogs on RAID10 S
On Thu, Jul 24, 2014 at 11:47 AM, Johan De Meersman wrote:
> - Original Message -
>> From: "Chris Knipe"
>> To: mysql@lists.mysql.com
>> Sent: Thursday, 24 July, 2014 11:17:50 AM
>> Subject: Avoiding table scans...
>>
>> mysql>
>
>
> Try this
>
> SELECT ArtNumber, MessageID FROM 78168ea0a9b3b513a1f2d39b559b406e WHERE
> ArtNumber=(SELECT MIN(ArtNumber) FROM 78168ea0a9b3b513a1f2d39b559b406e
> WHERE ArtNumber>2118806)
>
>
+---+---+
| ArtNumber | MessageID
|
Hi,
I have a "not so" busy MySQL server (+- 150 Selects/sec, 180 Deletes/Sec,
320 Updates/Sec, 90 Inserts/Sec and 200 Replace/Sec), max 512 concurrent
connections.
The server is running on a Dell R720 with 64GB Ram, Xeon E5-2620. Data is
on a 4 x 3TB (RAID10) SATA3 array, and binlogs on a 4 x
s from the mysql client running on the same host as the mysql server,
connected to localhost via TCP. Current connections to the DB was at about
200 out of 500
--
Chris.
-Original Message-
From: Chris Knipe [mailto:sav...@savage.za.org]
Sent: Sunday, December 07, 2014 11:34 PM
To:
On Mon, Dec 8, 2014 at 3:02 PM, Wagner Bianchi
wrote:
> Hello Chris,
>
> Can pls you share the below command output...
>
> SHOW STATUS LIKE 'Threads%';
> SELECT @@thread_cache_size, @@net_buffer_length, @@max_allowed_packet;
mysql> SHOW STATUS LIKE 'Threads%';
+---+---+
| Vari
L | NULL | | BTREE | |
|
+--++--+--+--+---+-+--++--++-+---+
2 rows in set (0.00 sec)
--
Regards,
Chris Knipe
already exist), how is this query logged in the statistics?
When the ON DUPLICATE KEY UPDATE runs (i.e. it's updating a record), is it
still logged as a INSERT query, or is it logged as a UPDATE query?
Thnx.
--
Regards,
Chris Knipe
nx.
--
Regards,
Chris Knipe
;
> Stick your domain in http://mxtoolbox.com to see if there's any problems
> that might be worth solving. If the mailserver classifies you as spam,
> that's usually caused by something on your side :-)
>
> - Original Message -
> > From: "Chris Knipe"
ough :-p
>>>
>>> Stick your domain in http://mxtoolbox.com to see if there's any
>>> problems that
>>> might be worth solving. If the mailserver classifies you as spam, that's
>>> usually caused by something on your side :-)
>>>
On Fri, Mar 18, 2016 at 3:43 PM, Lentes, Bernd <
bernd.len...@helmholtz-muenchen.de> wrote:
> i need your help. I'm trying to write an e-Mail to the list for already
> one week. I always get it back because it's classified as spam.
>
Ditto. I've pretty much given up on this list...
Hi all,
Can someone explain to me why this is happening please:
mysql> SELECT * FROM CustomerDetails WHERE Username=âblahâ\G
*** 1. row ***
EntryID: F83D4109-DCA8-426F-98B1-00B4AF117ACB
Username: blah
AccountVolume: 0
1 row i
Hi,
Is two-way replication possible with MySQL 5.x? Any good sites / docs
describing this type of setup?
--
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Chris Knipe" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, February 28, 2005 7:11 PM
Subject: Re: two-way replication
"Chris Knipe" <[EMAIL PROTECTED]> wrote on 02/28/2005 11:53:14 AM:
Hi,
Is two-way rep
Lo all,
Just wondering... Would the below be considered a "safe" way to do
replication...
MasterBD: One Database (most Critical)
SlaveDB: Replicating all databases from MasterBD as well as hosting allot of
other 3rd party, or customer DBs.
Basically, the MasterBD holds a single critical databa
aving those
problem.
I'll stop replicating mysql tables then... Thanks ;)
--
Chris.
- Original Message -
From: "Gary Richardson" <[EMAIL PROTECTED]>
To: "Chris Knipe" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, March 09, 2005 6:23 PM
Subject: Re: safe way
Lo again,
Master and Slave server, both running 5.0.2-LOG (Exactly the same versions).
On the master, everything is working fine. Data that gets inserted /
updated / deleted etc goes into the bin log, and gets replicated to the
slave.
HOWEVER
On the slave, I am getting syntax errors from the qu
Chris Knipe wrote:
[..]
Sure, there is a syntax error in the query - yes. But why does the
master not put the complete query in the bin log? This is the
second time in 3 days that it has happened now. Whilst we are on this,
how do I tell the slave to skip the query and proceed with
Chris Knipe wrote:
[..]
Sure, there is a syntax error in the query - yes. But why does the
master not put the complete query in the bin log? This is the
second time in 3 days that it has happened now. Whilst we are on this,
how do I tell the slave to skip the query and proceed with
- Original Message -
From: "Richard Lynch" <[EMAIL PROTECTED]>
To: "Chris Knipe" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, March 11, 2005 12:08 AM
Subject: Re: replication errors
mysql> SELECT COUNT(RadAcctId) FROM RadiusAccounting;
+--
So there's already data missing on the slave *shrugs*
Yep, you told it to SKIP ERRORS. That means that if any query generates
an error, for any reason, it's just going to skip over it and move on. So
data was missing on your slave the moment you restarted replication -- it
skipped the UPDATE
AUTO_INCREMENT is not the same as newid().
Frankly, something like newid() would be very useful in MySQL.
--
Chris.
- Original Message -
From: "Gleb Paharenko" <[EMAIL PROTECTED]>
To:
Sent: Thursday, March 17, 2005 5:53 PM
Subject: Re: Ms Sql unique identifier field
Hello.
You should
Hi,
Is it possible to left join the same data twice?
TBL ONE:
LocationID
Location, varchar(100)
TBL TWO:
DepartureID,
ArrivalID,
Time
SELECT tlb1.DepartureLocation AS Departure, tbl1.DepartureLocation AS
Destination LEFT JOIN DepartureLocation ON tlb2.DepartureID=tlb1.LocationID
LEFT JOIN Departu
It's official. I need help ;)
Let's do the table structures quickly.
mysql> DESCRIBE FlightData;
+---+--+--+-+-++
| Field | Type | Null | Key | Default
| Extra |
+-
I use = 0. It works for me.
--
Chris.
I love deadlines. I especially love the whooshing sound they make as they
fly by..." - Douglas Adams, 'Hitchhiker's Guide to the Galaxy'
- Original Message -
From: "Emil Wilmanski" <[EMAIL PROTECTED]>
To:
Sent: Thursday, April 14, 2005 11:19 AM
Sub
SELECT tlb1.DepartureLocation AS Departure, tbl1.DepartureLocation AS
Destination LEFT JOIN DepartureLocation ON
tlb2.DepartureID=tlb1.LocationID LEFT JOIN DepartureLocation ON
tbl2.ArrivalID=tbl1.LocationID ORDER BY tbl2.Time etc etc etc
I get
ERROR 1066 (42000): Not unique table/alias: 'tbl1'
I eliminated your GROUP BY clause because you weren't actually GROUPing
anything. You weren't looking for a MIN(), a MAX(), an AVG(), or anything
else that GROUP BY was intended to be used for. That method of
de-duplicating results will return potentially misleading information as
it will randomly
Hi,
I have a P4 system with 1GB Ram and 512MB Swap (a little low I know).
I'm running a multi threaded MySQL installation on it. With a bit of shock,
I realised today that I ran completely out of swap space!!! Each MySQL
thread is consuming about 160MB of ram, and I had close to 40 threads
run
the whooshing sound they make as they
fly by..." - Douglas Adams, 'Hitchhiker's Guide to the Galaxy'
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Chris Knipe" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, May 03, 2005 7:34 P
PID USERNAME PRI NICE SIZERES STATETIME WCPUCPU COMMAND
55651 mysql 8 12 138M 33524K nanslp 0:21 0.00% 0.00% mysqld
55649 mysql 20 14 138M 33524K pause0:21 0.00% 0.00% mysqld
55866 mysql 4 14 138M 33524K sbwait 0:12 0.00% 0.00% mysqld
Ya, sin
Hi,
I used sql-bench, but that is testing things we already know. We want to
establish how many concurrent connections / queries our database server can
handle before it starts getting into trouble (no, a different one from the
email of last night). This system is a dual proc with 4GB ram and
Hi,
I dont think it's needed to go into to much details here but the query:
SELECT CONCAT(Airports.IATA, ' - ', Airports.Name) AS ArrivingFrom,
ADDTIME(FlightData.TimeStamp,
SUBTIME(FlightData.Enroute,DATE_FORMAT(SUBTIME(FlightData.TimeStamp,FlightData.ActDepTime),'%H:%i:%s')))
AS Ar
Found my problem...
Thanks anyways :)
--
Chris.
I love deadlines. I especially love the whooshing sound they make as they
fly by..." - Douglas Adams, 'Hitchhiker's Guide to the Galaxy'
- Original Message -
From: "Chris Knipe" <[EMAIL PROTECTED]>
To:
Temporary replication comes to mind fs hot copy as well (maybe)
--
Chris.
I love deadlines. I especially love the whooshing sound they make as they
fly by..." - Douglas Adams, 'Hitchhiker's Guide to the Galaxy'
- Original Message -
From: "Brian Erickson" <[EMAIL PROTECTED]>
To:
We will try our best to scrape up some info that will hopefully help
diagnose
the problem, but since we have already crashed, something is definitely
wrong
and this may fail.
key_buffer_size=536870912
read_buffer_size=2093056
max_used_connections=418
max_connections=2048
threads_connected=404
It
Hi,
We've just upgraded (via FreeBSD Ports) our one database from 4.1.11 to
4.1.12, and we are being hit by http://bugs.mysql.com/bug.php?id=10674 -
only on certain queries, using rather large temp tables.
Now, from what I understand, there is a 4.1.12-1 available? Where is the
source? It
Lo all,
What's the format for a sub query in MySQL??
I've tried the below with a few variants but I can't seem to get it
sorted...
SELECT songlist.ID AS ID,
songlist.duration AS Duration,
songlist.artist AS Artist,
songlist.title AS Title,
songlist.filename AS FileNam
Have a look on sourceforge.
I think it's called mylogd or something similar. It's syslogd with sql support in it.
Alternatively, a simple perl script will be able to parse the data and insert it
manually into a db.
--
me
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL
> Jun 02 08:07:17 mod_sql/4.10[1108]: message: 'Unknown column 'password' in
> 'field list''
>
> mysql> SELECT * FROM users WHERE userid = "test"
> -> ;
>
++-+--+--+-+--+---+-
---+-+---+--+-
+--+
| BENCHMARK(100,ENCODE("hello","goodbye")) |
+--+
|0 |
+--+
1 row in set (1.91 sec)
PIII 850, with 1GB Ram.
---
Hi,
I know this might be a little silly, but can anyone give me a example on how
to get the date of the first day of a week and month?
--
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Lo everyone,
I'm *baffled* completely I've never seen something like this before.
: I tried this exact query from PHP, Perl, as well as the MySQL
thingy... They ALL give the same result - it must therefore be my table
mysql> SELECT VERSION();
++
| VERSION() |
+-
> insert into table (username, password) values ('username', 'password')
>
> Skip out the "username=" and "password=" part. What you are ending up
> doing here is that the values portion of the insert statement, these two
You may kick my ass... Royally.
Sorry, I feel like a phrick to say the le
MySQL-Front is quite good for this...
- Original Message -
From: "Steve Jackson" <[EMAIL PROTECTED]>
To: "MySQL General Mailing list" <[EMAIL PROTECTED]>
Sent: Tuesday, November 26, 2002 4:37 PM
Subject: Is it possible to export data from access to MySQL?
> Is it possible to export data
where member='me ' is not the same as where member='me' ('me ' != 'me')
I've noticed this as well with just about any mysql version, on any
platform.
The tables / columns really isn't important here IMHO... From what I can
see, trailing spaces are always droped, which shouldn't be.
- O
Lo all,
If I have a database with various tables, and I want to upgrade the tables
and the data in the tables, will it screw up the permissions assigned to
users if I use DROP TABLE / CREATE TABLE (to recreate the changed tables),
and then just populate them with the data again?
I'm doing it this
LOOL! This *IS* a joke right? ;)
- Original Message -
From: "lateef ayinla" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 22, 2002 2:13 AM
Subject: request
> Dear sir,
> i come across yourmanual [mySQL Reference] when browsing
through the i
lo everyone,
I have two tables Both have a DebtCode VARCHAR(6) in them, and both has
UNIQUE Indexes on them. How can I select DebtCode as being unique in both
tables?
DebtCode in both tables, will be three alphabetical characters, followed by
three numbers, like ABC001 ... ABC999, etc etc et
++
| table1 | table2 |
+++
| 3 | 79 |
+++
1 row in set (0.02 sec)
mysql> SELECT COUNT(DISTINCT DebtCode) AS table2 FROM table2 WHERE DebtCode
LIKE 'CHR%';
+--+
| table2 |
+--+
|0 |
+--+
1 row in set (0.00 sec)
--
me
- Original Message --
Kind Regards,
Chris Knipe
MegaLAN Corporate InterNetworking Services
Tel: +27 21 854 7064
Cell: +27 72 434 7582
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Chris Knipe" <[EMAIL PROTECTED]>
Sent: Monday, May 13, 2002 9:10 PM
Subject: Re: auto_increments
Hi all,
What's the best way to store a numeric IP address into a table with the
least possible size and overhead on the mysql server?
I'm talking millions of records here With not one single duplicate IP
address (unique index)..
Currently, the database hosts just over 1.2 million unique add
Multiple subnets :/
columns like this:
octet1, octet2, octet3, octet4
195,196,192,23
232,196,231,11
This would then be seen as a duplicate
Kind Regards,
Chris Knipe
MegaLAN Corporate InterNetworking Services
Tel: +27 21 854 7064
Cell: +27 72 434 7582
- Original Message -
From: &quo
And who said you ever get to old to learn :)
Never knew I could do unique indexes like this.. Definitely what I'm
looking for... Thanks guys :)
--
me
- Original Message -
From: "Ryan Hatch" <[EMAIL PROTECTED]>
To: "Chris Knipe" <[EMAIL PRO
> CREATE TABLE parent(id INT NOT NULL,
> PRIMARY KEY (id)) TYPE=INNODB;
>
> CREATE TABLE child(id INT, parent_id INT,
> INDEX par_ind (parent_id),
> FOREIGN KEY (parent_id) REFERENCES parent(id)
> ON DELETE CASCADE) TYPE=INNODB;
OI!!! I'm goin
Anyone have any ideas on how to get MySQL to work under cygwin?
I'm especially interested in getting a libmysqlclient which is compatible
with cygwin so that I can use it to compile various other program which
require the library...
Currently, I run mysql 3.23.49-max for Win32 (NT 4.0) because I
get to stash it under the contrib sections at
mysql.com... But yeah, let's first wait and see how things turn out.. Maybe
what I intend to do isn't possible in practise
--
me
- Original Message -
From: "Yegor N. Bryukhov" <[EMAIL PROTECTED]>
To: "Chris
hey everyone,
Does anyone have and ideas of wisdom on how to compare arrays (mysql result
sets) and group items based on if they exist in two or more arrays?
For example:
I have a table, with a list of servers:
server1
server2
server3
server4
server5
...
serverX
I have a table that specifies w
headache now as well, which just isn't
helping right now... *shrugs*
Any ideas?
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Chris Knipe" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, June
Only users of the "Administrators" group on NT can start system services by
default.
Have a look in your user manager for domains, policies, user rights
Kind Regards,
Chris Knipe
MegaLAN Corporate Networking Services
Tel: +27 21 854 7064
Cell: +27 72 434 7582
- Origin
> FOR MY ADMIN ACCOUNT
> C:\>netstat -a -p tcp
> TCPdynamic:3306 dynamic:0 LISTENING
> FOR THE REGULAR USER ACCOUNT
> C:\>netstat -a -p tcp
> TCPdynamic:3306 dynamic:0 LISTENING
Lo all,
are sub-queries supported on mysql-max 3.23.49 ??
If they are, what's wrong with the following statement?
SELECT monitorhosts.HostID
FROM monitorhosts
WHERE monitorhosts.HostID NOT IN
(SELECT HostID
FROM monitorhostgroupdetails
WHERE monitorhostgro
-
From: "Kiss Dániel" <[EMAIL PROTECTED]>
To: "Chris Knipe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 06, 2002 9:47 PM
Subject: Re: sub-queries
> I'm sorry to disappoint you, but subqueries are NOT supported int any
MySQL
> vers
*MWAH*!!!
Thanks a million, tested and working beautifully Can't believe in two
days I didn't think of this...
--
me
- Original Message -
From: "Sabine Richter" <[EMAIL PROTECTED]>
To: "Chris Knipe" <[EMAIL PROTECTED]>
Cc: <[EM
s NOT allready in that specific group.
Is this possible, or am I really going to have to use PHP arrays and compare
arrays with hundreds of thousands of values in them?? *deep sigh*
- Original Message -
From: "Chris Knipe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Strange indeed...
Might be worth checking if this can be reproduced... This can perhaps be
something worth mentioning in winmysqladmin (possible bug?)
- Original Message -
From: "Kirk Brannan Babb" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 06,
- Original Message -
From: "Kevin Fries" <[EMAIL PROTECTED]>
To: "'Chris Knipe'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, June 07, 2002 12:38 AM
Subject: RE: sub-queries
> Chris,
>
> sounds like you're looki
All sorted, thanks a million to Kevin Fries
For archives purpose and anyone else that ever want to do anything like
this... The query I was looking for apparently (Tested and working so far -
I will test it a bit more later when I have more data in the tables):
select monitorhosts.HostID, monito
I'm talking under correction here, but
SET('y'.'n') default 'n' NOT NULL - should work. I normally just do all
this stuff via phpmyadmin, it works really great...
--
me
- Original Message -
From: "Jason Soza" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Frida
l save you the hassles to learn a new language.
PHP with all its docs and a comprehensive manual + example code, is
available at http://www.php.net the ASP manuals with example code is
installed with NT Option Pack.
Kind Regards,
Chris Knipe
MegaLAN Corporate Networking Services
Tel: +27 21 854
,
Chris Knipe
MegaLAN Corporate Networking Services
Tel: +27 21 854 7064
Cell: +27 72 434 7582
- Original Message -
From: "Charitha" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 07, 2002 5:46 AM
Subject: Error in shared libraries
>
>
>
> > describe CL0420;
> > +--+-+--+-+-+---+
> > | Field| Type| Null | Key | Default | Extra |
> > +--+-+--+-+-+---+
> > | ID | int(11) | YES | | 0 | |
> > | Producer | char(255)
Doesn't this need to be in ld's path? /etc/ld.conf ?
I'm not to sure Not on *nix at the moment, but I believe the proper way
to add it would be through /etc/ld.conf and running ldconfig to update the
paths.
Kind Regards,
Chris Knipe
MegaLAN Corporate Networking Services
Now, that screwed up allot of MUAs!!!
- Original Message -
From: "Joel Rees" <[EMAIL PROTECTED]>
To: "Dvoracek Michal" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 07, 2002 6:17 AM
Subject: Re: to_asci
> Hello to you too.
>
> > i
-
INSERT INTO (column) VALUES ('path');
I'd recommend you goto www.mysql.com and download the manual - then read it.
Kind Regards,
Chris Knipe
MegaLAN Corporate Networking Services
Tel: +27 21 854 7064
Cell: +27 72 434 7582
- Original Message -
From: "Silmara Cri
> Escape the \
>
> like so:
>
> 'c:\\temp\\calc.exe'
>
> It's all in the manuals.
>
> Kind Regards,
>
> Chris Knipe
> MegaLAN Corporate Networking Services
> Tel: +27 21 854 7064
> Cell: +27 72 434 7582
>
> - Original Messag
ging them via the pgp binaries?
I'm intending to use PGP keys to establish authentication (trusts) from
incoming email messages to register items in a database...
Kind Regards,
Chris Knipe
MegaLAN Corporate Networking Services
Tel: +27 21 854 7064
Cell: +27 72
Hi again,
Not to long ago, I had a query regarding the best way to store IP addresses
in a DB, and make sure that they are unique.
It was pointed out to me that I could use four smallint columns instead of a
varchar to store these numbers, and just implement a UNIQUE index across all
four column
1 - 100 of 122 matches
Mail list logo
