code, PHP is only looking for an
array element called '$wk', which 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
---
believe CIPE comes as standard with
RedHat 7.x and above.
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
(filter bait: sql, query, queries, smallint)
--
o protect against data loss in the event of a server crash) and a UPS
option.
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
(Filter bait: SQL, query, MySQL)
--
ta luck. May I
quote from the manual:
"The TIMESTAMP column type provides a type that you can use to automatically
mark INSERT or UPDATE operations with the current date and time. If you have
multiple TIMESTAMP columns, only the first one is updated automatically."
That last sentence may b
LECT dob FROM yourtable WHERE 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.
e.
So, you need to specify a source port of 'any' instead of 3306.
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
-
Before posting, p
h ` when you use it"
So, your query would become:
SELECT * FROM `purge` LIMIT 0,50
Hope that helps.
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
---
e keys."
I agree that this section of the manual could do with some clarification. It
only seems to talk about re-creating indexes...
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
--
*** 2. row ***
category_code: 0
agent_code: 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 Hus
u go for replication you should make sure you're running at least 100Mbps
between your MySQL servers. (BTW, if in a closed environment, running
100Mbps to the clients might help also.)
Looking at option #8, you may see quite a large performance boost if you go
for InnoDB tables and your query l
that particular table to consolidate empty gaps.
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysq
ld make sense. All your read/write clients
could also read in a distributed fashion but would write only to the master.
If, however, you employed a '2-way' or 'many-masters' topology then the
issue of distributing updates occurs. However, '2-way' replication has whole
load of i
can get a good idea
of how much space is being wasted. In this case, it's:
(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.
install MyODBC on to the MS-SQL NT server then I'm
sure MS-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
---
Interne
rguments (including alternative output
formatting) consult the application's help, by entering:
$ mysql --help
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
field in Outlook you're referring to, but as far I can
tell, all the fields that are present in the Contacts store are exported to
the text file.
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
--
"Changes 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-
for a resolution of only
whole seconds, by using time() instead.
Regards,
--------
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the
options like this (such as paging, outputting to a file, etc.). Just type
"help" for details of all available commands.
Regards,
----
Basil Hussain ([EMAIL PROTECTED])
-
Bef
ial bit of info?
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 re
in/
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
client to
set up the forwarding without logging in for a command session. This is how
I do it:
ssh -2 -l username -N -L 12345:server.foo.com:3306 server.foo.com
Regards,
Basil Hussain ([EMAIL PROTECTED])
---
so, rather than giving a terse
syntax error.
Regards,
--------
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:/
rong!
Do I have a bug here? 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])
-
able 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,
Basil Hussain ([EMAIL PROTECTED])
-
Before
s 'set' has a limit on
> how big the set can get.I would like to have the possibility of data
> expansion as needed.
Enum column types are only ever useful for fields that will only ever
contain one of a fixed set of values - like "Yes" and "No", for examp
of passwords that are
planned to be used.
The only likely limit I can think of would be that of any buffers in the
MySQL query parsing routines or those in the code for the PASSWORD()
function. Any MySQL developers care to comment on this, just out of
interest?
Regards,
--
e fly, within the SELECT statement that retrieves 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,
-------
al:
http://www.mysql.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 l
e or zero
and for it to be displayed as true/false, then you won't be able to do that.
MySQL will only return the actual value stored in the field - it doesn't
interpret anything for you. However, you could resort to some trickery with
IF() statements in the SELECT query to get this, b
You just need to start the client with a certain parameter.
The '--skip-column-headers' argument (or something like it - I forget the
exact name) should do what you want. Type 'mysql --help' for more exact
information.
Regards,
----------
an efficient thread 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,
-
ng that could be worked 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,
--------
B
Type 'help' within the client for details on this and other handy
commands.
However, 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
)
Regards,
--------
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 vulne
increase the
key_buffer size, if you're processing large amounts of records in your
tables though (I'm talking about millions of records here, though).
Regards,
Basil Hussain ([EMAIL PROTECTED])
-
UNIX too) and import the
file using the LOAD DATA statement in the MySQL command-line client.
Regards,
----
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http
and (mainly) insert records in a timely manner.
Can anyone offer a precise explanation of what DELETE LOW_PRIORITY
facilitates?
Regards,
--------
Basil Hussain ([EMAIL PROTECTED])
---
t;, $www_domain_Array['Email']);
if($a < $www_domain_rows - 1) {
$inlist .= ", ";
}
This will seperate all of them by commas (missing, of course, the last one).
Hope this gets you going. Also, if you have any more queries about your
r spec
servers (P3-1Ghz dual-cpu, 512Mb RAM, 3x36Gb SCSI RAID5). Maybe I should try
out mysql-super-smack and see what kind of numbers it turns up. :-)
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
ead the comment about
gcc in the INSTALL 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,
p_table_size=64M
set-variable = table_cache=256
set-variable = 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
always down, or always towards zero."
So, 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]
---
esh table, with no wasted space from previously deleted rows. So, you
are not re-using any deleted rows at all.
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
--
er at over 1,000 queries/sec.
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
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.mysq
my server too?
I still think the mapped tables should be shown in SHOW TABLE STATUS,
though...
Regards,
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http:/
e tell me what this message
means?
Regards,
--------
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql
d NOT NULL,
impression datetime NOT NULL,
click datetime,
ipaddr int unsigned NOT NULL,
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
UNION=(...)
Notice the equals sign between "UNION" and the accompanying brackets. I
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
l
ndows, then I think this
counts as a bug, yes?
Regards,
----
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
lt;..lots of tables...>,
> eventlog_88);
> ERROR 1031: Table handler for '#sql-1f1_ea6d9' doesn't have this option
My MERGE table seems to be completely screwed! Could you explain what's
going on here? Is it because I'm running only version 3.23.32
the actual size
taken 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,
--------
en looking at the
changelog again and I notice there are some 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])
d to make sure 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 ([E
g problem.
Any help or explanations are very gratefully accepted.
Regards,
----
Basil Hussain ([EMAIL PROTECTED])
corrupt_banner_indexes.txt
+--+---+--+---
y present in PHP 4.0.5 and above).
What you'll need to do is to issue an SQL query of "SHOW STATUS" and/or
"SHOW VARIABLES" (depending on which pieces of info you require) and use the
relevant records from the result set given back.
Regards,
---
ething along
the lines of this should do the trick:
SELECT * FROM users_table WHERE username = 'johndoe' AND passwd =
ENCRYPT('secretpasswd', LEFT(passwd, 2));
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
--
ript would
perform a query like above when it first connects and then uses the saved
user-variable in all subsequent queries where a unique ID is required.)
Regards,
Basil Hussain
---
Internet Devel
o answer, is it mentions nothing about limits in the manual.
Regards,
Basil Hussain
---
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
-
Before posting, please check:
ht
ght want to take a read of section 7.4.12, '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
ng a PHP/Perl script - but I've come up 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
tten (or to see if you have unknowingly), check this out:
http://service1.symantec.com/sarc/sarc.nsf/html/W32.Navidad.html
There is also a fix provided by Symantec here:
http://service1.symantec.com/sarc/sarc.nsf/info/html/W32.Navidad.Fix.html
Regards,
---------
+
>> | foo|
>> ++
>> 1 row in set (0.00 sec)
If all you want to do is remove any occurance of 'foo' in a string or column
value then I'd recommend you look at the REPLACE() function in the manual.
Reg
tion.
Regards,
--------
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
T
rtical
mode by terminating with '\G', rather than ';' or '\g'. But then again, this
poses it's own problems with scrolling (but you could probably use the new
pager command in the most recent 3.23 clients).
Regards,
-------
this value?
Any answers gratefully accepted!
Regards,
----
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (th
right.
> You didn't mention the key_buffer. If configured well, you can get a
> great performance boost from it.
My key_buffer is currently at 128Mb, but I'm considering upping that to
192Mb or maybe even 256Mb. Probably the former, as I don't have tables with
hundereds of
en, you probably already know this...
Regards,
--------
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://li
o research everything (and of
course, learn some C/C++).
Regards,
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the lis
like this, you simply do:
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,
-
sage. After it has
made changes, it would (for while, at least) go 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 e
ment'. There's also lots of other extremely useful
information 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
led RAID (i.e. by the
Linux kernel), then you could go for one of the plethora of recent
motherboards sporting hardware IDE RAID controllers, or one of the Promise
or Adaptec PCI adapters if you don't want to change motherboards.
Regards,
Basil
74 matches
Mail list logo
