with
RedHat 7.x and above.
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
(filter bait: sql, query, queries, smallint)
-
Before posting, please check
doesn't exist!
In future, may I suggest you that post questions like this to the PHP
mailing list, as this is nothing to do with MySQL.
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED
.
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
' instead of 3306.
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
MONTH(dob) = MONTH(NOW()) AND
DAYOFMONTH(dob) = DAYOFMONTH(NOW());
And, to see how old a person is, given their date of birth, you would do
something like this:
SELECT YEAR(NOW() - YEAR(dob) AS age FROM yourtable;
Hope this helps.
Regards,
Basil Hussain
, this isn't a bug. It's MySQL just following the features of your
system's C library.
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
-
Before posting
and see what kind of numbers it turns up. :-)
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com
file, but I thought making sure that I have the latest
version of gcc (gcc-2.96-85), rather than downgrading to 2.95, would
suffice. Is this the problem, or something else?
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED
= thread_cache_size=16
set-variable = thread_concurrency=4
set-variable = back_log=100
set-variable = max_allowed_packet=2M
set-variable = wait_timeout=240
skip-locking
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED
in release 3.23.15 there is this:
* Added functions INET_NTOA() and INET_ATON().
So, you need to upgrade your MySQL before you can use these functions.
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED
in the Contacts store are exported to
the text file.
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com
output
formatting) consult the application's help, by entering:
$ mysql --help
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
-
Before posting
-SQL will be able to export any data required via this ODBC
connection to your MySQL server.
Check out MyODBC here:
http://www.mysql.com/downloads/api-myodbc.html
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED
:
(234 / 97128) * 100 = 0.24%
This is way less than one percent, so in this case it's no problem. But, I
reckon that if you have more than several percent free space (say 10%) then
you definitely need to optimise.
Regards,
Basil Hussain
---
Internet Developer
query load consists of large quantities of small
queries, as this is where row-level locking, etc. will help most.
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED
table to consolidate empty gaps.
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php
' replication has whole
load of issues that you need to tip-toe around carefully (such as
auto-increment fields clashing values). Unless your environment has a high
update load too, then you probably don't need to worry about distributing
updates.
Regards,
Basil Hussain
clarification. It
only seems to talk about re-creating indexes...
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
-
Before posting, please check:
http
: 14562
*** 3. row ***
category_code: 0
agent_code: 44114
3 rows in set (0.00 sec)
This has the benefit of long text fields being wrapped on your display.
Regards,
Basil Hussain
---
Internet Developer, Kodak
, 'Miscellaneous
Functions', in the current MySQL manual:
http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
I assume you must also be using an old version of MySQL, as these functions
were only added in version 3.23.15, so you should upgrade your installation
of MySQL.
Regards,
Basil Hussain
));
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
.
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
that the access privileges on your MySQL
server allow you to connect from the IP of the firewall.
Other than that, there is nothing else you need to do.
Regards,
Basil Hussain ([EMAIL PROTECTED
entries for 3.23.38 - is there a
new release imminent? Should I wait for this, or just upgrade to 3.23.37
now?
Regards,
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please
timestamp if called without arguments. According to the manual,
anyway:
If called with no argument, returns a Unix timestamp...
So, if it's not working as documented under Windows, then I think this
counts as a bug, yes?
Regards,
Basil Hussain
? Is it because I'm running only version 3.23.32 of MySQL? Do I
need to upgrade? Any assistance would be appreciated, as no-one else seems
to be able to help.
Regards,
Basil Hussain ([EMAIL PROTECTED
up on disk, because you have your index file and table definition file
too. I think the 'Index_length' field will tell you how big your indexes are
too, though.
Regards,
Basil Hussain ([EMAIL PROTECTED
would've made a comment in the manual, but the new account registration
seems to be broken - you just get an Unknown column 'country_id' in 'field
list' SQL error.
Regards,
Basil Hussain ([EMAIL PROTECTED
,
browser char(255) NOT NULL,
KEY (bannerid),
KEY (impression)
)
TYPE=MERGE
UNION=(eventlog_11, ...many other tables..., eventlog_81);
Can anyone help me figure out what's going on here?
Regards,
Basil Hussain ([EMAIL PROTECTED
?
Regards,
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
if there is any particular reason why this can't
be shown, or is it just an oversight?
Regards,
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com
,
though...
Regards,
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
/fullpapers/1921/com1921.htm
Anyway, 405 queries per second is not so much if you have monster hardware.
I seem to remember one of the MySQL developers mentioning one time that they
had benchmarked a MySQL server at over 1,000 queries/sec.
Regards,
Basil
(missing, of course, the last one).
Hope this gets you going. Also, if you have any more queries about your
code, you'd be better off asking on the PHP mailing list, as this problem
really isn't much to do with MySQL itself.
Regards,
in the MySQL command-line client.
Regards,
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
,
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
,
Basil Hussain ([EMAIL PROTECTED])
--
From: "Pavlov, Lesha" [EMAIL PROTECTED]
Organization: NN.ru
Reply-To: [EMAIL PROTECTED]
Date: Sun, 18 Mar 2001 21:32:37 +0300
To: [EMAIL PROTECTED]
Subject: potential vulnerability of mysq
, if you're talking about a third-party client application or about
trying to do this from a PHP script (via the mysql_query() function) then I
doubt it will be possible - definitely not possible in the case of PHP.
Regards,
Basil Hussain ([EMAIL
on for
forthcoming revisions of MySQL - making sure that all currently present
date/time functions have an equal function for converting back to a date or
time data type.
Regards,
Basil Hussain ([EMAIL PROTECTED
read cache?
* Should I be aiming to get my new threads per connections figure as low as
possible?
* What effect on memory usage would having a larger thread cache make?
This is all on a RedHat Linux 6.2 server with 512Mb RAM and MySQL 3.23.32.
Regards,
----
com/doc/E/N/ENUM.html
Regards,
--------
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To requ
developers care to comment on this, just out of
interest?
Regards,
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php
your data. You
don't need to add any fields to your table to do this.
Here's an example:
SELECT ROUND((SessionTime + 30) / 60) AS Minutes FROM YourTable
Regards,
Basil Hussain ([EMAIL PROTECTED
only ever useful for fields that will only ever
contain one of a fixed set of values - like "Yes" and "No", for example.
I never use Sets - they're evil. ;)
Regards,
Basil Hussain ([EMAIL PROTECTED])
-
? Or is this not how I should be subtracting/adding
dates? I'm using version 3.23.32-log, intstalled from official MySQL RPMs.
Regards,
Basil Hussain ([EMAIL PROTECTED])
-
Before posting
t;95" supposed to represent? Can anyone explain the
rational behind this?
Anyway, this is clearly not gonna be suitable for subtracting/adding dates,
so I suppose I'll have to resort to something ugly like converting each date
to a timestamp before subtracting.
Regards,
--
ntax error.
Regards,
--------
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the li
, etc.). Just type
"help" for details of all available commands.
Regards,
--------
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/
,
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
,
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
using time() instead.
Regards,
--------
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this t
RAID controllers, or one of the Promise
or Adaptec PCI adapters if you don't want to change motherboards.
Regards,
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check
into 'sit-back-and-watch'
mode, in order to compare performance after the event to what it was before.
If it's worse, it dynamically restores the previous config - this might
partially avoid the scenario I described earlier.
Regards,
Basil Hussain ([EMAIL
mation to be gleaned from SHOW TABLE STATUS, such as the type of table
and date/time of creation of last update, etc.
Unfortunately, you can't tag columns with comments, though.
Regards,
--------
B
,
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED
:
SELECT field FROM table WHERE something = 'foo' INTO OUTFILE
'/path/to/whatever.txt' LINES TERMINATED BY 0x1d
Then just transfer it to your Mac/PC and import this text file into the
repeating field of the record you desire. Et voila!
Regards,
Basil
Regards,
--------
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-m
,
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
blank.
Can anyone offer any ideas (or maybe solutions) for my problem?
Regards,
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.co
59 matches
Mail list logo