and suggestions as to this implementation -
particularly if there are any fatal flaws in my theory, or if it has already
been done - Wheel reinvention is not one of my favourite pastimes!!
Many thanks,
Matt.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
.
Leaves a lot to be desired though, since data consistency (and age) can
become issues if updates are frequent... If the data is relatively static,
it's just a bit messy.
Regards,
Matt
-Original Message-
From: Michael J. Pawlowsky [mailto:[EMAIL PROTECTED]
Sent: 29 March 2004 21:58
, col2, col3:
INSERT INTO table (col2, col3)
SELECT col2, col3 FROM table2 WHERE id_col=1;
Regards,
Matt
-Original Message-
From: Eric J. Janus [mailto:[EMAIL PROTECTED]
Sent: 29 March 2004 19:37
To: MySQL
Subject: INSERT ... SELECT question
I have a table with just about 100 columns
the temporary table back
into the original.
I don't like that at all, though. It seems messy. Hopefully someone here can
come up with a better idea!
Cheers,
Matt
-Original Message-
From: Eric J. Janus [mailto:[EMAIL PROTECTED]
Sent: 29 March 2004 20:12
To: Matt Chatterley; 'MySQL'
Subject: RE
. Better check with SHOW INDEX FROM PhoneCalls.
That leaves the DISTINCT clause as the suspect. The EXPLAINs look the
same with ASC/DESC on an equivalent query I just tried. So maybe
something is making DISTINCT + reverse index scan slow even if it's not
packed...
Matt
- Original Message
Hi Joshua,
First thing I'd try is upgrading to 4.1.1! And/or 4.1.2 when it's
released in a couple weeks.
Matt
- Original Message -
From: Joshua Thomas
Sent: Monday, March 29, 2004 10:51 AM
Subject: mysqld keeps crashing
Hello all,
I'm running mysql 4.1.0-alpha-log on FreeBSD 5.1
that
although slightly outdated information may be read, no updates would be
delayed?
Depends on what you're doing, and what you're trying to achieve, really!
Thanks,
Matt.
-Original Message-
From: Jim Richardson [mailto:[EMAIL PROTECTED]
Sent: 25 March 2004 03:17
To: [EMAIL PROTECTED]
Subject
Yes, the clients (appearently) read to the end of the previous file, and
then sit there, while the server is writing to a new file.
I was thinking this had to do with the unclean shutdown of MySQL--
perhapps it's something else.
-Matt-
Matt Sturtz wrote:
Hello--
We're using Red Hat's
an expression or similar, calculating
the value from data already in oldtable.
Is this what you meant? If not, what exactly are you trying to do?
Thanks,
Matt
-Original Message-
From: Vinay [mailto:[EMAIL PROTECTED]
Sent: 24 March 2004 18:09
To: [EMAIL PROTECTED]
Subject: SQL statement
,
but the slaves keep reading from the old file, db-bin.001). The only fix
seems to be CHANGE MASTER TO..., which seems somewhat error prone.
Anybody else running MySQL in this type of environment have any words of
wisdom? Thanks in advance for any info...
-Matt Sturtz-
--
MySQL General Mailing List
) and scalability pov too, to split
it up into multiple databases.
Thanks,
Matt
-Original Message-
From: news [mailto:[EMAIL PROTECTED] On Behalf Of TO
Sent: 21 March 2004 15:14
To: [EMAIL PROTECTED]
Subject: multiple databases: design question
What are the advantages and disadvantages
(mysql_error());
As to the connection problem, you are putting the password into a variable
called '$dbpassword' and passing a different (presumably null) variable
'$dbpasswd' into mysql_connect.
Thanks,
Matt
-Original Message-
From: Lee Zelyck [mailto:[EMAIL PROTECTED]
Sent: 21 March 2004 18
GROUP BYLogin
) Latest ON Latest.Login = S.Login
Or something very similar - using a subquery (and joining to it), to ensure
you only look at the latest records. I've made the assumption that 'Login'
is your way to uniquely identify a user!
Thanks,
Matt
-Original
Had my brain been in gear, I would have typed the 'AND Latest.TimeStamp =
S.TimeStamp' which you will also need on that join..
Cheers,
Matt
-Original Message-
From: Matt Chatterley [mailto:[EMAIL PROTECTED]
Sent: 20 March 2004 19:51
To: 'motorpsychkill'; 'mysql'
Subject: RE
isn't in ANSI mode (specifically, the PIPES_AS_CONCAT
part), which is typical since it's not enabled by default, || is logical
OR. :-(
Matt
- Original Message -
From: Jim McAtee
Sent: Thursday, March 18, 2004 4:29 PM
Subject: String Concatenation Operator?
Does MySQL have a string
(most common) and
BDB table types. MyISAM doesn't.
Hope that helps.
Matt
- Original Message -
From: Laphan
Sent: Thursday, March 18, 2004 5:19 PM
Subject: Stored Procs and Commit/Rollback Transactions
Hi All
OK I admit it I'm a complete MSV (MySQL Virgin), so I might be asking
be called), but this is fine - it's the
first alpha, after all!
Now all I need to be truly content is views
Cheers,
Matt
-Original Message-
From: Matt W [mailto:[EMAIL PROTECTED]
Sent: 20 March 2004 22:57
To: Laphan; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Stored Procs
has already tried this...
Thanks,
Matt
-Original Message-
From: Tariq Murtaza [mailto:[EMAIL PROTECTED]
Sent: 19 March 2004 18:41
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Guru's advice needed [Security: SQL injection]
*Dear Friends!*
Can someone shed some light on how
Hi Michael,
- Original Message -
From: Michael Stassen
Sent: Tuesday, March 16, 2004 9:45 AM
Subject: Re: BETWEEN
Matt W wrote:
The query using 2 BETWEENs with OR is exactly how it should be. It
will
be fast even in MySQL 3.23. OR is not a problem when the OR parts
involve
could remove the range values that
won't be found because they conflict, but it only does that type of
thing with constants, not ranges; at least not yet.
Compare the EXPLAINs for these 2 WHEREs:
... WHERE col=123 AND col 123;
... WHERE col IN (123) and col NOT IN (123);
Matt
--
MySQL General
Hello
Is there a way I can get a MySQL database to authenticate
users against an LDAP database without any 3rd party coding?
I want to store mysql usernames and passwords in ldap.
Thanks
Matt
--
Matt Silva
Empower Software Technologies, LLC
27851 Bradley Rd. Suite 120
Sun City, CA 92586
PH: (909
Hi Michael,
- Original Message -
From: Michael Stassen
Sent: Saturday, March 13, 2004 10:48 AM
Subject: Re: BETWEEN
Keith wrote:
g'day,
i'm looking for a way to do two BETWEEN ranges. Currently I have
sys.sectorID BETWEEN 1 AND 20 but I want it so that I can search
between
Hi Anthony,
You don't need REGEXP for this; LIKE will do. Try something like this:
... WHERE CONCAT(',', Column, ',') LIKE '%,2,%'
to search for rows that contain 2.
Hope that helps.
Matt
- Original Message -
From: award
Sent: Saturday, March 13, 2004 2:16 PM
Subject: query
, then the query I gave will work
fine for that because it adds a comma to the beginning and end of the
column (with CONCAT()) before doing the LIKE comparison.
Matt
- Original Message -
From: award
Sent: Saturday, March 13, 2004 5:10 PM
Subject: RE: query question using REGEXP
Hi thanks
Hi Patrick,
No, you can't get per database statistics in MySQL. :-(
Matt
- Original Message -
From: Patrick Gelin
Sent: Wednesday, March 10, 2004 1:45 AM
Subject: 3 000 000 requests for last 14 days...
Hi,
I've got very astonished to see with phpMyAdmin my MySQL database has
Hi Tom,
You can't. MySQL's own thread ids are sequential. The OS pids are
random. There's no connection between them. Besides, mysqld is really
only running in a single real process, it's just that LinuxThreads
shows each thread as a process.
Matt
- Original Message -
From: Tom
Yeah, and MySQL doesn't yet support FULL OUTER JOIN. :-( It's listed on
the TODO under Features Planned for the Mid-Term Future:
http://www.mysql.com/doc/en/TODO_sometime.html And it's listed for
version 5.1 on the Development Roadmap:
http://www.mysql.com/doc/en/Roadmap.html
Matt
--
MySQL
:
http://bugs.mysql.com/2033
http://bugs.mysql.com/2065
Hopefully any problems are ironed out in 4.1.2! :-)
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
apologies if this message should only have gone to the Win32 list.
Sincerely,
Matt Solnit [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I was just wondering what the valid range for ports is for the MySQL server
in a Windows environment. Obviously, the server won't connect to a port
already in use, but I know some programs disallow ports under 1024.
Thanks,
Matt
--
MySQL General Mailing List
For list archives: http
Hi Paul,
ALTER TABLE table_name ADD id_column_name INT UNSIGNED NOT NULL
AUTO_INCREMENT PRIMARY KEY FIRST;
The FIRST word at the end just makes it the first column in the table if
that's what you want.
Hope that helps.
Matt
- Original Message -
From: Paul Maine
Sent: Thursday
. :-)
Also, key_len of 0 in EXPLAIN is normal.
It sounded like you are getting some kind of error in your first
message? If so, what is it? Are you SURE that the EXACT word you're
searching for is present in the table (for example, with a space, etc.
on either side of it)?
Matt
- Original Message
in
the Administrator program?
Thanks
Matt
--
Matt Silva
Empower Software Technologies, LLC
27851 Bradley Rd. Suite 120
Sun City, CA 92586
PH: (909) 672-6257
WB: www.storagecommander.com
EM: [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Oh we are using Red Hat Enterprise Linux WS ver 3.0
Thanks
Matt
Thomas Taylor wrote:
what platform are you on?
On Feb 23, 2004, at 4:27 PM, Matt Silva wrote:
I am using the ~new~ MySQL Administrator and i'm trying to load the
Startup Variables and i'm receiving a Could
not find my.cnf error
time it took a couple of seconds before printing the results.
Why is
that? Because data still in the RAM?
Thanks
Yep, that's usually why. :-)
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
in
production. :-)
Here's the 4.1.1 full-text bugs I know of:
http://bugs.mysql.com/1977
http://bugs.mysql.com/2190
http://bugs.mysql.com/2417
And with multi-byte character sets:
http://bugs.mysql.com/2033
http://bugs.mysql.com/2065
Matt
--
MySQL General Mailing List
For list archives: http
?
You're absolutely right. :-) Query contents can be seen in logs.
That's why I do any encryption in the client code and only use the
finished result in queries. Not sure how possible it is if you want to
use AES encrytion, though.
Matt
--
MySQL General Mailing List
For list archives: http
Chris,
The good news is that MySQL 5.0 can finally use multiple indexes per
table. I just noticed this page in the manual a few days ago:
http://www.mysql.com/doc/en/OR_optimizations.html
:-)
Matt
- Original Message -
From: Chris Nolan
Sent: Monday, February 16, 2004 7:13 AM
Subject
Hi Eve,
That error is because the LOCAL part of LOAD DATA is disabled. See
here: http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html
Since your file is probably on the same system as the MySQL server, it
should work if you remove the LOCAL word.
Hope that helps.
Matt
- Original Message
the situation, any other ideas if the sub-6ms access times of the
fastest 15K SCSI drives isn't fast enough? :-)
Thanks,
Matt
on millions of rows,
while possibly reading 10s of thousands of data rows. It takes a lot
more time when those rows aren't cached.
The only thing I've thought of so far is symlinking the data file on a
separate drive, but I'm not sure how much that will actually help.
Matt
- Original Message
if this is something MySQL can do, and if
so, what is the correct syntax? Note that I can't use an
autoincrement column because the IDs aren't being put into
a database.
I've searched through MySQL docs and mailing lists but
couldn't find any mention of this. Any help would be
appreciated.
Matt Fagan
[EMAIL
anything?
Thanks
Matt
--
Matt Silva
Empower Software Technologies, LLC
27851 Bradley Rd. Suite 120
Sun City, CA 92586
PH: (909) 672-6257
WB: www.storagecommander.com
EM: [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Hi James,
Your key_buffer is using tons of memory at 1.5 GB! table_cache is
probably too big, too.
Matt
- Original Message -
From: James Kelty
Sent: Saturday, February 14, 2004 3:03 AM
Subject: Massive memory utiliazation
Hello,
We have currently tuned MySQL for a high rate
.
Matt
- Original Message -
From: [EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 1:23 PM
Subject: mysqldump via tcp/ip memory problem
I've dumped alot of databases before using mysqldump, and am trying to
dump a larger database than normal, about 2.2GB in size.. The largest
table
This will list all the files in the package and where they are located.
rpm -qpl package_name.rpm
or from the rpm database
rpm -ql pachage_name
Matt
Ross O wrote:
I was able to successfully install MySQL server 4
under windows, but am a little confused about doing it
through linux.
My
***
Table: test
Create Table: CREATE TABLE `test` (
`myblob` longtext character set latin1 collate latin1_general_cs
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1 row in set (0.00 sec)
Thanks.
Victoria Reznichenko wrote:
Matt Mastrangelo [EMAIL PROTECTED] wrote:
I'm using mySQL 4.1.1a-alpha on XP
if the slave is a few (or even more) minutes behind, so I'm willing
to sacrafice replication speed for performance.
Any way to throttle updates so that, say, the SQL thread will only do a
certain number of inserts/updates per second? or maybe any other ideas?
-Matt-
--
MySQL General Mailing
be circumvented by
setting a default collation at the database level, in the CREATE
DATABASE statement.
Thanks,
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
shell (in Linux) 2. type mysql and press enter.
Regards,
Matt
-Original Message-
From: Alexander Pfingstl [mailto:[EMAIL PROTECTED]
Sent: Saturday, February 07, 2004 4:29 AM
To: [EMAIL PROTECTED]
Subject: Advice
Hi,
I am a blind user and for me it would be very helpful if I could use
Hi Ian,
What is the problem you are hitting? I have been successfully using MX
with MySQL.
Matt
-Original Message-
From: Ian O'Rourke [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 08, 2004 10:52 AM
To: [EMAIL PROTECTED]
Subject: MySQL and Coldfusion
Is anyone on the list using
is that joins between static tables are faster than
joins between dynamic tables (by about 20% for the int
column join). I guess this is what the MySQL manual is
talking about (and other people who posted the same thing
to this thread).
Matt Fagan
[EMAIL PROTECTED]
http://greetings.yahoo.com.au
only.
...
Matt Fagan
http://greetings.yahoo.com.au - Yahoo! Greetings
Send your love online with Yahoo! Greetings - FREE!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
difference between fixed/variable
length rows, as
oppposed to the relative efficiency of CHAR vs. VARCHAR.
Michael
Matt Fagan wrote:
I'm having the same problem. I did a performance test,
and
CHAR columns are significantly faster than VARCHAR (at
least on my platform - MySQL 4.1.1a
Hi,
You're probably right. All the status variables seem to start over
after hitting 4,294,967,295. :-( I don't get why they're only using 32
bit integers for the variables that they know can go WAY over that
amount. :-/
Matt
- Original Message -
From: Mikhail Entaltsev
Sent: Friday
Hi Sergei!
Great news. Thanks very much! :-)
Matt
- Original Message -
From: Sergei Golubchik
Sent: Tuesday, February 03, 2004 1:54 PM
Subject: Re: query the data of a fulltext index directly from index?
Hi!
On Feb 02, Matt W wrote:
Sergei,
Any chance of getting a ft_dump
the minimum mysqld threads running (they appear as
processes with LinuxThreads). You'd probably see the same thing right
after starting the server. :-)
BTW, the size of the whole process is 12M in your case; NOT 12M for each
thread.
Hope that helps.
Matt
--
MySQL General Mailing List
For list archives
Also sending this to the General list since it isn't a Windows specific
question. :-)
Matt
- Original Message -
From: tooptoosh
Sent: Wednesday, February 04, 2004 1:54 PM
Subject: mySQL autogenerate, update table
Hi all,
I have a mySQL table with 75,000 records in it, but the table
Sergei,
Any chance of getting a ft_dump Windows binary in the distribution? :-)
Regards,
Matt
- Original Message -
From: Sergei Golubchik
Sent: Monday, February 02, 2004 11:33 AM
Subject: Re: query the data of a fulltext index directly from index?
Hi!
On Feb 02, Alexander Bauer
) columns, which won't hold the addresses
either. :-D
So what do you think about the situation? If we want to stick with
INT-based columns and handle IPv6, I guess we could use 2 BIGINT
columns. :-/ I just don't know when we're going to *need to* handle
IPv6...
Matt
--
MySQL General Mailing List
with monetary
data. When declaring a column of one of these types the precision and
scale can be (and usually is) specified; for example:
salary DECIMAL(5,2)
Regards,
Matt
--
That's
the
index. What is the runtime without the index?
Matt
-Original Message-
From: Balazs Rauznitz [mailto:[EMAIL PROTECTED]
Sent: Monday, January 19, 2004 12:53 PM
To: [EMAIL PROTECTED]
Subject: Slow query times
While doing some benchmarks the other day, I saw surprisingly slow
query
table.
MySQL usually detects this and ignores the index, especially if another
index was already used to break down the number of rows.
Matt
-Original Message-
From: Balazs Rauznitz [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 2:46 PM
To: Matt Griffin
Cc: [EMAIL PROTECTED
Ignore that silly equation. I tried to simplify and ended up with something
mathematically ridiculous. I'm sure someone can come up with a more
accurate simplification.
Matt
-Original Message-
From: Matt Griffin [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 20, 2004 3:46 PM
/doc/en/News-4.0.17.html
Fixed optimizer bug, introduced in 4.0.16, when REF access plan was
preferred to more efficient RANGE on another column.
If that's the problem, upgrading will fix it. :-)
Matt
- Original Message -
From: Balazs Rauznitz
Sent: Monday, January 19, 2004 9:39 AM
- Original Message -
From: Peter J Milanese
Sent: Tuesday, January 20, 2004 1:37 PM
Subject: RE: Slow query times
You may also want to try :
count(1)
instead of
count(*)
count(*) pulls back the data while count(1) does not.
Completely untrue...
Matt
--
MySQL
Hi John,
- Original Message -
From: [EMAIL PROTECTED]
Sent: Thursday, January 15, 2004 2:28 AM
Subject: Re: How does key buffer work ?
Matt,
One last question and then I promise to drop the topic ... what would
be
the best way to force a complete load of an index into the key buffer
be fetched from the
query cache. :-)
Thanks and Regards,
John Everitt
PGN MSS
Philips C/IT.
Hope that helps.
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi John,
- Original Message -
From: [EMAIL PROTECTED]
Sent: Wednesday, January 14, 2004 6:37 AM
Subject: Re: How does key buffer work ?
Matt,
Many thanks for the answer. It has helped enormously.
First, I have been getting the odd index corruption that has proved to
be
very
more on nested set models.
Cheers,
Matt
-Original Message-
From: Steve Folly [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 1:59 PM
To: MySQL MySQL
Subject: Re: hierarchical records, I need some help!! ;(
On 13 Jan 2004, at 09:19, Victor Reus wrote:
Hi again,
Second: specify
very curious about ANY coming improvements, besides what I
mentioned. Any more information that you can give us about anything
(and/or put in the manual)? If not, that's OK. :-/
Keep up the good work!
Regards,
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
)building the index be slower with 4.1 for any reason? I
thought maybe it was, but I'd have to try again to be sure.
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
improvement.
Of course, if you have other variable length columns in your table,
MySQL will be stupid and change your CHAR to VARCHAR, thinking it's
helping you. :-(
Matt
- Original Message -
From: Hassan Shaikh
Sent: Sunday, January 11, 2004 7:04 AM
Subject: Which one is better: CHAR
Hi,
- Original Message -
From: Michael Stassen
Sent: Sunday, January 11, 2004 5:10 PM
Subject: Re: Automatic conversion from `char` TO `varchar`
Martijn Tonies wrote:
Hi,
The manual http://www.mysql.com/doc/en/Open_bugs.html says
The following problems are known and will be
a column
in the UPDATE or not.
The only time it could be an issue is if you're setting a column to a
*REALLY* long value. It will take longer to send the query to the
server (especially over a network) and MySQL will take a little more
time to parse it.
Hope that helps.
Matt
- Original
bug. What version of MySQL are you using?
Matt
- Original Message -
From: Keith Bussey
Sent: Monday, January 12, 2004 4:49 PM
Subject: JOIN types
Hey all,
I've read the pages in the MySQL manual that explain the types of
JOINs many
times, but still think I'm missing something.
I
.
Index data can be read from disk a lot faster than rows can -- and the
OS will also cache the index data even when MySQL's key_buffer does.
Hope that helps.
Matt
- Original Message -
From: trevor%tribenetwork.com
Sent: Monday, January 12, 2004 5:20 PM
Subject: Loading the .myd
=
'FIND_ME' will be returned. Thus, every record is being returned. If you
use AND the query will return your intended result, all the records where
machinename != 'FIND_ME' AND machinename != 'OPEN'.
HTH
Matt
At 10:22 AM 1/9/2004, you wrote:
Could someone have a look at this syntax and give me
that designates which job the record is for. We
simply have a connection open to the appropriate database that the user is
working with. There are times that I wonder if this was an appropriate
design, but for the most part, I think its the most simplistic way of
coding it.
Matt
At 11:47 AM 1
or \usr\local, I
believe, in Linux). If you are upgrading, then make sure you back up your
old installation as to not override your data.
HTH,
Matt
At 09:25 AM 1/7/2004, Sharma, Saurabh wrote:
Hi
I am trying to install MySQL for practice on my PC (Windows XP). I have
all the administrative
Quoting DeBug [EMAIL PROTECTED]:
[MySQL]
1: START TRANSACTION
2: WITHDRAW $50 from account 32146.
3: DEPOSIT $50 into account 12345.
4: LOG transfer (date/time/teller/etc...) for auditing.
5: COMMIT TRANSACTION
DK It depends why step 3 failed.
DK If you want to rollback the transaction
As I understand stored procedures:
Stored procedures offer a level of performance that you normally can not
replicate in code. The stored procedure actually has the query stored in the
query parser ready to rumble. You do not have to invoke network or socket
overhead in calling a long query and
Hi Ladd,
How about SELECT DISTINCT?
Hope that helps.
Matt
- Original Message -
From: Ladd J. Epp
Sent: Saturday, January 03, 2004 11:39 AM
Subject: FULLTEXT across two tables
Hello,
I would like to do a FULLTEXT search across two tables. I run an
artist
website, so I need
Hi Fred,
InnoDB does not support AUTO_INCREMENT on secondary columns of a
multi-column index.
`id_registro` int(11) NOT NULL auto_increment,
PRIMARY KEY (`id_formula`,`id_registro`)
There: id_registro is the second column of the index.
Matt
- Original Message -
From: Fred
Sent
, if
you weren't aware of that.
Matt
- Original Message -
From: Chris Nolan
Sent: Saturday, January 03, 2004 10:34 AM
Subject: Default DATE field values
Hi all,
Upon reading the funky manual, I have discovered the following things:
1. TIMESTAMP fields can be set so that their default
Hi Fred,
Also, you may be able to swap the order of those columns in the index.
I think that would work, but don't know if it would cause other
problems -- like for the way your app uses the index, etc.
Matt
- Original Message -
From: Fred
Sent: Saturday, January 03, 2004 6:11 PM
Hi Mike,
It's just part of modifying the column to change the DEFAULT value.
e.g. you might use this (changes to NOT NULL and DEFAULT value of
'new'):
ALTER TABLE table MODIFY type ENUM('new','used') NOT NULL DEFAULT 'new';
Hope that helps.
Matt
- Original Message -
From: Mike
Dan,
DATEDIFF() only works in MySQL 4.1.1+.
RTFM! ;-)
Matt
- Original Message -
From: [EMAIL PROTECTED]
Sent: Wednesday, December 31, 2003 2:10 PM
Subject: RE: Subtracting date fields
Kenneth,
try
SELECT id, DATEDIFF(firstdate, postdate) AS diff FROM
calendar
RTFM
to be portable to
different systems, I suggest using things compatible with 3.23. And
when you have to use something that's not, handle it in your code.
Matt
- Original Message -
From: Bob Terrell [EMAIL PROTECTED]
Sent: Thursday, January 01, 2004 5:35 PM
Subject: Re: Subtracting date fields
again, or it will add too many
slashes! So you need to check for that somehow.
Hope that helps.
Matt
- Original Message -
From: Chris W
Sent: Wednesday, December 31, 2003 4:44 PM
Subject: special characters as field values
I am storing data from an html form and there could be any
gets deleted from the table,
then MySQL will try to re-use the space that once held that row.
Check out the following links:
http://www.mysql.com/doc/en/CREATE_TABLE.html
http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html
HTH
Matt
At 01:14 PM 12/23/2003, you wrote:
Hi, I am a beginner in using
Hi Jeremy,
- Original Message -
From: Jeremy Zawodny
Sent: Monday, December 22, 2003 2:20 PM
Subject: Re: Benefits of MAX_ROWS and AVG_ROW_LENGTH
On Fri, Dec 19, 2003 at 06:40:17PM -0600, Matt W wrote:
Hi Mark,
I'll tell you what I know. :-)
First, AVG_ROW_LENGTH is only
. :-)
More below...
- Original Message -
From: Mark Hawkes
Sent: Saturday, December 20, 2003 3:50 PM
Subject: Re: Benefits of MAX_ROWS and AVG_ROW_LENGTH
Hi Matt,
Thanks very much for your thoughts and advice. I was going to ignore
using
MAX_ROWS, MIN_ROWS and AVG_ROW_LENGTH because
Hi Arthur,
Dbtools is a free product and it will do the conversion for you.
http://www.dbtools.com.br/EN/index.php
We have had success converting from MSAccess to MySQL in the past with
it.
Regards,
Matt
-Original Message-
From: Arthur Klimowicz [mailto:[EMAIL PROTECTED]
Sent
, Matt W wrote:
Hi,
Just have a couple more full-text search inquiries here. :-)
I'm not exactly clear on how matching rows are found when searching
for
2 or more required words: '+word1 +word2'. I understand that it
can't
currently know which word occurs less, so that it can be searched
= 4,294,967,295 or no MAX_ROWS -- 4 byte pointer; max data
size: 4GB
product 4,294,967,295 -- 5 byte pointer; max data size: 1TB (or
4,294,967,295 rows is MySQL's internal limit I *think*)
Hope that helps!
Matt
P.S. You should upgrade MySQL (at least latest 3.23; preferably to
4.0). :-) 3.23.41 is over
Hi,
Does anyone know of a MySQL distribution for the PocketPC?
Thanks,
Matt
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003
--
MySQL General Mailing List
For list
which index to use, if any, when looking up rows in a table.
Now we both know. ;-) Hope that helps.
Matt
- Original Message -
From: Andrius Jakas
Sent: Thursday, December 18, 2003 6:08 AM
Subject: show processlist
Hi,
show processlist displays processes with state statistics, what
('POINT(1 1)') );
Query OK, 1 row affected (0.00 sec)
mysql SELECT AsText(g) FROM geom;
++
| AsText(g) |
++
| POINT(1 1) |
++
1 row in set (0.00 sec)
mysql
Thanks again,
Matt
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent
rows match as
far as I know), but that made it a little slower (I'd expect that, if
anything). Is there any explanation for why adding wild-cards would
make a search faster?
Thanks in advance!
Matt
P.S. Sergei, if you see this, in one of your replies to my full-text
suggestions back in September
201 - 300 of 661 matches
Mail list logo