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
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...
yet, both of those messages made it through :-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 sid
essages made it through :-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 :-)
>
> - Original Message -
> > From:
nx.
--
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
| |
|
+--++--+--+--+---+-+--++--++-+---+
2 rows in set (0.00 sec)
--
Regards,
Chris Knipe
On Mon, Dec 8, 2014 at 3:02 PM, Wagner Bianchi
wagnerbianch...@gmail.com 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%';
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: 'mysql
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
On Thu, Jul 24, 2014 at 11:47 AM, Johan De Meersman vegiv...@tuxera.be wrote:
- Original Message -
From: Chris Knipe sav...@savage.za.org
To: mysql@lists.mysql.com
Sent: Thursday, 24 July, 2014 11:17:50 AM
Subject: Avoiding table scans...
mysql SELECT MIN(ArtNumber) AS ArtNumber
Try this
SELECT ArtNumber, MessageID FROM 78168ea0a9b3b513a1f2d39b559b406e WHERE
ArtNumber=(SELECT MIN(ArtNumber) FROM 78168ea0a9b3b513a1f2d39b559b406e
WHERE ArtNumber2118806)
+---+---+
| ArtNumber | MessageID
|
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 Message -
From: Chris Knipe sav...@savage.za.org
To: mysql@lists.mysql.com
Sent: Thursday, 25 July, 2013 11:53:53 PM
Subject: hypothetical
-
From: ckn...@savage.za.org [mailto:ckn...@savage.za.org] On Behalf Of
Chris Knipe
Sent: Friday, July 26, 2013 12:30 AM
To: Johan De Meersman
Cc: mysql
Subject: Re: hypothetical question about data storage
Hi All,
Thanks for the responces, and I do concur. I was taking a stab in
the
dark
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
://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
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
optimizing your query if
required...
Thanks.
Anirudh Sundar
On Fri, May 7, 2010 at 12:14 PM, Chris Knipe sav...@savage.za.org wrote:
Hi All,
I have a huge issue with a query - it copies the entire table to a tmp
table
when executing the query - and it's a big ass table Any help
running... 3948 Seconds the last time I checked...
--
Regards,
Chris Knipe
been created.
Thanks for the assistance.
--
Regards,
Chris Knipe
Quoting cars...@bitbybit.dk:
Of course you can have ID=0.
Definately agree
mysql DESCRIBE test;
+-+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
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
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
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: mysql@lists.mysql.com
Sent: Saturday, August 26, 2006 9:03 PM
Subject: IP Address Function?
Hi,
I need to make
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
INSERT INTO a VALUES (NOW()) ?
Regards,
Chris.
- Original Message -
From: Renato Golin [EMAIL PROTECTED]
To: Nicholas Vettese [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Friday, August 25, 2006 4:31 PM
Subject: Re: Testing Email
Nicholas Vettese wrote:
I have been having
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]; mysql@lists.mysql.com
Sent: Friday, August 25, 2006 4:30 PM
Subject: Re: MySQL NOW() function
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: mysql@lists.mysql.com
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
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
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
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
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: mysql@lists.mysql.com
Sent: Wednesday, July 20, 2005 3:04 PM
Subject: random rows selection
Hello,
How to select 5 random
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
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
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:
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
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: mysql@lists.mysql.com
Sent: Thursday, May
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 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
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: mysql@lists.mysql.com
Sent: Tuesday, May 03, 2005 7:34 PM
Subject: Re: mysql mem usage
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,
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:
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
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: mysql@lists.mysql.com
Sent: Thursday, April 14,
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
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: mysql@lists.mysql.com
Sent: Thursday, March 17, 2005 5:53 PM
Subject: Re: Ms Sql unique identifier field
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
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
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
- Original Message -
From: Richard Lynch [EMAIL PROTECTED]
To: Chris Knipe [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Friday, March 11, 2005 12:08 AM
Subject: Re: replication errors
mysql SELECT COUNT(RadAcctId) FROM RadiusAccounting;
+--+
| COUNT(RadAcctId
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
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
.
I'll stop replicating mysql tables then... Thanks ;)
--
Chris.
- Original Message -
From: Gary Richardson [EMAIL PROTECTED]
To: Chris Knipe [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Wednesday, March 09, 2005 6:23 PM
Subject: Re: safe way of replication?
I would probably
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: mysql@lists.mysql.com
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 replication possible with MySQL
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 least...
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
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
+--+
| BENCHMARK(100,ENCODE(hello,goodbye)) |
+--+
|0 |
+--+
1 row in set (1.91 sec)
PIII 850, with 1GB Ram.
-
Jun 02 08:07:17 mod_sql/4.10[1108]: message: 'Unknown column 'password' in
'field list''
mysql SELECT * FROM users WHERE userid = test
- ;
++-+--+--+-+--+---+-
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
|
+++
| 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 -
From: Chris Knipe [EMAIL PROTECTED
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
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
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.
-
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 from MS
Lo everyone,
I have a bit of a dilemma. I use MySQL for all my authentication (user
accounts etc, via ftp / mail / radius / http / etc), and currently am using
PureFTPD as my FTPD to allow my clients to upload web sites.
I use the following to authenticate users for their personal web space...
Lo Michael,
I digged a bit more, and while running under debug mode, MySQL doesnt crash,
it does complain about a bad file descriptor on /etc/hosts.allow.
If this is the cause of the failure, there might be a possibly bug in the
code, because I really think it's arb that the entire MySQL needs
...or you have too many open files in the system.You reach the max. number
of files which can be opened by the OS.Try to increase file-max from
/proc/sys/fs.
Highly doubtful. It's a brand new server installation, exactly the same as
all my others, and it's not doing half as much as the
/ and reinstall.
- Original Message -
From: Gelu Gogancea [EMAIL PROTECTED]
To: Chris Knipe [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, August 18, 2002 8:01 PM
Subject: Re: Lost connections on Freebsd
For sure Bad file descriptor error occur because your kernel it's not
able
PHP's more than likely just loosing persistent connections to the DB.
It's a coding thing I think... You need to call mysql_connect() on every
page where you need to use the database, even if you use mysql_pconnect().
If there's a mysql specific error, I think MySQL would most definitely write
the errors now on every single query.
Running under gdb also doesn't return anything (or I'm debugging it
wrong?)
MySQL's error log is empty - nothing logged
--
me
- Original Message -
From: Chris Knipe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; Victoria
Lo Victoria
FreeBSD 4.6-STABLE (Master), MySQL 3.23.51
Windows 2000 Professional (Slave):, MySQL 3.23.49-nt
I've recompiled the master about three times now, and it still crashed.
Eventually, it came to such a extend that the moment I open port 3306 MySQL
would crash. I can just use telnet ip
sqlst = update sfproducts set projectdonations = projectdonations +
testvalue WHERE prodID = ' sProdID '
^^
$sqlst = update sfproducts set projectdonations = projectdomains + .
$testvalue . WHERE prodID = ' . $sProdID . ';
$sqlstr then looks like this:
update sfproducts set
Lo everyone,
I seem to be having a problem with the structuring of my query - more
specifically, with the WHERE clause...
mysql SELECT ZoneName
- FROM CompanyDNSZones
- LEFT JOIN CompanyDetails ON
CompanyDetails.CompanyID=CompanyDNSZones.CompanyID
- WHERE
| ||
| ZoneServices |
set('HasMail','HasMailingList','HasBackupMail','IsMegaDNS','IsSecondary') |
| MUL | ||
- Original Message -
From: Chris Knipe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, August 17, 2002 11:44 PM
Subject: where clause structures
Lo everyone,
I've implemented replication on my MySQL Server... The master is mysql 3.23
(FreeBSD Ports), and my one and only slave is mysql 3.23 (Win32). I added
the slave so that I can have a hardcopy / backup database in the event that
I have a data loss on the master.
This is all very
THe PHP's prob still on the test database.
You can try mysql_select_db(databasename); before you're query.
- Original Message -
From: Cliff [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, August 10, 2002 2:07 AM
Subject: Re: can't use the table. What happen, please!!
Lo all,
Can MySQL bind to two or more IP addresses?
i.e. --bind-address 127.0.0.1 --bind-address x.x.x.x --bind-address y.y.y.y
?
Thanks,
--
me
query
-
Before posting, please check:
http://www.mysql.com/manual.php
Lo all,
I don't know if this can be reproduced, whether it's just general coding
errors, or whether it's simply a Windows thing But I do my development
on a NT 4.0 system, and I've been starting to notice rather weird things
I use various languages (Perl, PHP, Delphi, C, etc), all of
Lo all,
I don't know if this can be reproduced, whether it's just general coding
errors, or whether it's simply a Windows thing But I do my development
on a NT 4.0 system, and I've been starting to notice rather weird things
I use various languages (Perl, PHP, Delphi, C, etc), all of
My PHP code also use persistent connections, and I don't think this is
the
problem, but basically, how more queries I throw at MySQL how more my PC
crawls down to a halt - even after the application with the queries
disconnected from the database. I can understand that my system may
take
Hiya again,
Ok, based on all the info, feedback and help I got the last time, I was able
to construct the following query:
mysql SELECT weather_data.Temp,
-weather_locations.Name
- FROM weather_data
- LEFT JOIN weather_data ON
-
Message -
From: Peter Normann [EMAIL PROTECTED]
To: 'Chris Knipe' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, June 16, 2002 5:44 PM
Subject: RE: LEFT JOIN again... Although, this time I think it's a design
flaw rather than a query one
Sorry, I didn't read the mail through before
know what's missing, I wont
mind finding out :-)
Kind Regards,
Chris Knipe
MegaLAN Corporate Networking Services
Tel: +27 21 854 7064
Cell: +27 72 434 7582
- Original Message -
From: Peter Normann [EMAIL PROTECTED]
To: 'Chris Knipe' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, June
Don't copy the physical files. Use mysqldump and mysqlimport instead.
Kind Regards,
Chris Knipe
MegaLAN Corporate Networking Services
Tel: +27 21 854 7064
Cell: +27 72 434 7582
- Original Message -
From: Francisco Reinaldo [EMAIL PROTECTED]
To: Tonu Samuel [EMAIL PROTECTED]
Cc: MySQL
I have multiple tables on a 166MMX with 64MB ram, all containing more than
250,000 records each Mine takes less than 5 seconds
I think there's something wrong at your side :-)
Kind Regards,
Chris Knipe
MegaLAN Corporate Networking Services
Tel: +27 21 854 7064
Cell: +27 72 434 7582
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 434 7582
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
INSERT INTO table (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 Cristina Basso [EMAIL
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 Message -
From: Silmara Cristina Basso
To: [EMAIL PROTECTED]
Sent: Friday
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
- Original Message -
From
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
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
version, yet.
You can read the MySQL manual about it. You can find there when
1 - 100 of 119 matches
Mail list logo