Re: How do I use a dynamic filename for an into outfile statement

/refman/5.5/en/sql-syntax-prepared-statements.html -- Paul DuBois Oracle Corporation / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: does the number of column affect performance

A are there any differences in performance when selecting, inserting, updating, and deleting data. Sure. For example, with table A, you can select only those blob columns you're interested in. With B, you have to select all of them if you want *any* of them. -- Paul DuBois Oracle Corporation / MySQL

Re: delete all hosts using a wildcard

| +--+-+ I know I can delete them individually and this is what I am going to do. But I would like to use this as a learning opportunity to help me understand how the wildcard works. Thanks in advance.. Best regards, Tim -- Paul DuBois Oracle Corporation / MySQL Documentation Team

Re: hide server-version at connect?

to localhost. Escape character is '^]'. N 5.5.19-logs+%b?QYO]g��ke8'Xg~e\}!(mysql_native_password -- Paul DuBois Oracle Corporation / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Date and Time

on the fly. LOAD DATA LOCAL INFILE 'data.txt' INTO TABLE t (name,@date,value) SET date = STR_TO_DATE(@date,'%m/%d/%y'); -- Paul DuBois Oracle Corporation / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: 'myisam_use_mmap' unstable like hell

on -- Paul DuBois Oracle Corporation / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: error log rotation problem

reopens a new file with the original file name. For example, you can rename the file and create a new one using the following commands: shell mv host_name.err host_name.err-old shell mysqladmin flush-logs shell mv host_name.err-old backup-directory (Bug #29751) See also Bug #56821. -- Paul

Re: Error Unknown column in 'where clause'

, players_bids.bid_date ASC but the problem I have is that when referencing players_bids.users_id_from within the UNION I get back the following error : Error Code: 1054 Unknown column 'players_bids.users_id_from' in 'where clause' Any ideas how to overcome this problem ? Cheers Neil -- Paul DuBois

Re: SQL book recommendation?

Windeyer Building, 46 Cleveland Street/ \ Against HTML Mail London, W1T 4JF +44 (0)20 7679 9259 (direct), 09259 (internal) -- Paul DuBois Oracle Corporation / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http

Re: Is conversion required?

version of MySQL. That could be a problem, depending on how different the old and new versions are. Consult the upgrading section of the manual to see. http://dev.mysql.com/doc/refman/5.1/en/upgrading.html -- Paul DuBois Oracle Corporation / MySQL Documentation Team Madison, Wisconsin, USA

Re: SHA1 returns binary value

. The same change was made for SHA2() in MySQL 5.5.6. -- Paul DuBois Oracle Corporation / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch

Re: Sequence of Execution in Non-Transactional Script

journal, you compare it with the MySQL server's general query log or binary log. The general query log will show the order in which the server receives the statements. The binary log will show the order in which they finish executing. -- Paul DuBois Oracle Corporation / MySQL Documentation Team

Re: Importing User credentials from mysql.sql file???

include the column names. -- Paul DuBois Oracle Corporation / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: FLUSH LOCAL LOGS

. -- Paul DuBois Oracle Corporation / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Why UTF8 need 24bit in MySQL?

bad performance penalties. Supplemental Unicode characters (4-byte) are supported as of MySQL 5.5.3: http://dev.mysql.com/doc/refman/5.5/en/charset-unicode.html http://dev.mysql.com/doc/refman/5.5/en/charset-unicode-upgrading.html -- Paul DuBois Oracle Corporation / MySQL Documentation Team

Re: declare multiple 'Definer'

with creating a store procedure, that will allow 2 users -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch

Re: set max_allowed_packet

set this value to higher one. By default it is 1 MB. Thank you VIKRAM A -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Help with the World.sql sample database

for the world database. Direct links are: http://downloads.mysql.com/docs/world.sql.gz http://downloads.mysql.com/docs/world.sql.zip -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http

Re: Selecting Dates

BETWEEN. or SELECT * FROM orders WHERE order_date ='2010-01-01' AND = '2010-01-30' ORDER BY order_date; Need order_date =, not just =. Neither of these work. What am I missing? -ML -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com

Re: auto_increment without primary key in innodb?

/mysql?unsub=...@thefsb.org -- Yang Zhang http://www.mit.edu/~y_z/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=paul.dub...@sun.com -- Paul DuBois Sun Microsystems / MySQL Documentation

Re: REGEXP and unicode weirdness

as equal. -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: upgrading mysql

List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=paul.dub...@sun.com -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http

Re: upgrading mysql

://dev.mysql.com/doc/refman/5.1/en/news-5-1-17.html -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: START TRANSACTION COMMIT ROLLBACK

-- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Getting mySQL to ignore case sensitivity of field names

-sensitivity.html You need to set the field format to a non binary one, and case insensitive will be the default. -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Renaming a Database

InnoDB tables, there will be a problem. InnoDB maintains the database name in the shared tablespace, and it will no longer be able to find those tables. -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list

Re: Why is MySQL using /tmp?

on /tmp? Can/should I make the server use a different location instead of /tmp? Thanks, Mike Spreitzer -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: How to execute prepare statement when the placeholder is a specific table name?

/services.html -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: mysql full tutorial download or any book

was about to panic. :-) -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Installing MySQL from source

is created from the result of these tools. The manual should cover that, but I don't have a specific URL handy. It's http://dev.mysql.com/doc/refman/5.1/en/installing-source-tree.html The development tree contains a file BUILD/autorun.sh which runs these tools. HTH, Jörg -- Paul DuBois Sun

Re: Install problem: log file issue

#option_mysqld_pid-file -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: How to get Error Number and Error Message 2nd Try

, SHOW WARNINGS might help. http://dev.mysql.com/doc/refman/5.1/en/show-warnings.html -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Are dates stored as String? Or Integer?

advantage of switching the dates to integer? Dates are stored numerically. See: http://dev.mysql.com/doc/refman/5.1/en/storage-requirements.html Beginning with The storage requirements shown in the table arise from the way that MySQL represents temporal values ... -- Paul DuBois Sun

Re: Setting the value for the EDITOR variable

/local/bin/pico export EDITOR I get no error messages when mysql starts up, but the value of the EDITOR variable does not change. Is there any way I can achieve that from the cnf file? No. MySQL option files are for setting MySQL program options, not environment variables. -- Paul DuBois

Book: MySQL, Fourth Edition, now available

The book MySQL, Fourth Edition (aka Doorstop IV) has been published. More information is available at the book's Web site: http://www.kitebird.com/mysql-book/ -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List

Re: reorder records in database

numbers are missing). is there built in function to reset order_no or I have to create php script for it? Why do you care if there are gaps? Do they really matter? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http

Re: Trigger problem

departement_postcode = 1000; END IF; END| but when i insert a new row i don't get my v_place value set so if there someone who has time to help me with this i would greatly appreciate this :) -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list

Re: Floor Decimal Math

to cast them. Apparently MySQL 5+ introduced some algorithms that helped with these problems, although not with yours. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: CONCAT doesn't work with NULL?

in set (0.07 sec) mysql select CONCAT_WS('','a',NULL,'b'); ++ | CONCAT_WS('','a',NULL,'b') | ++ | ab | ++ 1 row in set (0.00 sec) -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin

Re: connectors: per session persistent connection (PHP)

On May 9, 2008, at 12:17 AM, Sebastian Mendel wrote: Paul DuBois schrieb: On May 7, 2008, at 4:36 AM, Sebastian Mendel wrote: Hi, wouldn't it be very helpful if mysql connectors support some sort of per session persistent connection? this would save a lot of queries in many apps

Re: pls help clarify dox: InnoDB Consistent Non-Locking Read behavior

that change? Thanks for your time! Hopefully we can clarify this for all mysql users! The background for this change is Bug#30184: http://bugs.mysql.com/bug.php?id=30184 -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list

Re: MySQL purge logs

mysql 701 1.1G May 9 09:29 host1-bin.000714 -rw-rw 1 mysql 701 1.1G May 9 19:20 host1-bin.000715 -rw-rw 1 mysql 701 1.1G May 9 21:46 host1-bin.000716 Thanks and Regards Kaushal -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing

Re: connectors: per session persistent connection (PHP)

a persistent connection save any of that? Suppose the script that previously used the connection reset any or all of those things? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: viewing passwords as root

/encryption-functions.html#function_password -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: CHARACTER SET

=MyISAM DEFAULT CHARSET=latin1 1 row in set (0.00 sec) The definition for c1 shows that utf8 is used The definition for c2 shows nothing, so the table character set (latin1) is used. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List

Re: CHARACTER SET

At 8:49 AM -0700 4/16/08, Rob Wultsch wrote: On Wed, Apr 16, 2008 at 7:24 AM, Paul DuBois [EMAIL PROTECTED] wrote: When you create a table, you can specify a character set for a column. How can you tell what character set was used when the column was created? SHOW CREATE TABLE

Re: MySQL 5.0.51a and SHOW ENGINES

when the program exits, and also causes display of result set metadata during execution. As of MySQL 5.1.14, use --column-type-info to display result set metadata. http://dev.mysql.com/doc/refman/5.1/en/mysql-command-options.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA

Re: Create table

' at line 1 Does the problem is with table name. group is a reserved word. See this page: http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html The page also describes how to quote identifiers to avoid this problem. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL

Re: Question about mysql procedures

-restrictions.html For example, in a stored function, you cannot modify a table if the table is referenced by the statement that invokes the function. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: select records to send to another table in another database

table: INSERT INTO db1.mytable SELECT * FROM db2.mytable; -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: select records to send to another table in another database

corresponding table: INSERT INTO db1.mytable SELECT * FROM db2.mytable; And you can do that using the cli mysql app? Yes. You can do this in any interface that enables you to issue SQL statements. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com

Re: We have just moved to a new web server where we are running mysql version: 5.0.45

it here: http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html This is likely the cause of the changes that you're observing. I imagine that you'll either need to upgrade the passwords in your table, or look for them using OLD_PASSWORD() rather than PASSWORD(). -- Paul DuBois, MySQL

Re: Indices in InnoDB/MySQL

://dev.mysql.com/doc/refman/5.0/en/multiple-column-indexes.html http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Security overrides in mysql.cnf

statement to re-enable the grant tables (so that you can use CREATE USER, GRANT, etc.), and then set up the accounts the way you want (new root password and so forth). -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list

Re: the limitaiton of table size

. InnoDB will use the aggregate file size as the tablespace size. But remember that multiple tables share the tablespace. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: 2 mysqld instances

connection, even for localhost, with --protocol=tcp http://dev.mysql.com/doc/refman/5.0/en/invoking-programs.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

MySQL University session on March 13 - canceled

Today's MySQL University session: Checking Threading and Locking With Helgrind http://forge.mysql.com/wiki/Checking_Threading_and_Locking_With_Helgrind has been canceled and will be rescheduled for a later date. I apologize for the short notice. -- Paul DuBois, MySQL Documentation Team

Re: mysql.time_zone_name

to fill these tables in mysql-db? Please see this section of the manual: http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: function/procedure error!

select from the table. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: function/procedure error!

return the result set to the client. So, don't select from the table in the procedure. Use the procedure to populate the table, and then use your original query, with the originally proposed stored function reference replaced with a reference to the table that contains 0 ... n. -- Paul DuBois

Re: MySQL 4 Grant command

and hostname: 'login3'@'%' -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: what is a schema? what is a database?

DATABASE or DATABASES can be replaced with SCHEMA or SCHEMAS wherever it appears. Examples: CREATE DATABASE = CREATE SCHEMA SHOW DATABASES = SHOW SCHEMAS -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http

Re: recursion

, Destination FROM FLIGHT ) SELECT * FROM ReachableFrom WHERE Source = Portland; MySQL does not have WITH RECURSIVE. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: select with table name

row? mysql select 't1', t1.* from t1 union select 't2', t2.* from t2; ++--+ | t1 | i| ++--+ | t1 |1 | | t2 |2 | | t2 |3 | ++--+ -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list

Re: triggers sintax error with IF

to enclose the body within BEGIN/END. http://dev.mysql.com/doc/refman/5.0/en/begin-end.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Is mysql_upgrade *required*?

should be able to read them (if it couldn't, mysql_upgrade, which uses mysqlcheck, a client, couldn't tell the server to repair them!). But until those TEXT indexes are rebuilt, you might get incorrect results for some queries. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB

Re: Is mysql_upgrade *required*?

and reload the table if it is an InnoDB table, or run OPTIMIZE TABLE or REPAIR TABLE if it is a MyISAM table. So if CHECK TABLE doesn't complain, you should be okay. Thanks! On Feb 16, 2008 9:09 PM, Paul DuBois [EMAIL PROTECTED] wrote: At 9:01 PM -0600 2/16/08, Hayden Livingston wrote

Re: 2 cursors in a store procedure

contine handler for not found set y=1; http://dev.mysql.com/doc/refman/5.0/en/cursors.html: Cursors must be declared before declaring handlers. Variables and conditions must be declared before declaring either cursors or handlers. You have a handler declared before a cursor. -- Paul

Re: Decimal - Maximum is 30

At 9:50 PM -0600 1/31/08, Peter Brawley wrote: Postgres has PostGIS Oracle has OracleSpatial MySQL has ? OpenGis. As stated here: http://dev.mysql.com/doc/refman/5.0/en/gis-introduction.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL

Re: ON vs. WHERE

conditional expression of the form that can be used in a WHERE clause. Generally, you should use the ON clause for conditions that specify how to join tables, and the WHERE clause to restrict which rows you want in the result set. See: http://dev.mysql.com/doc/refman/5.0/en/join.html -- Paul DuBois

Re: cache in mysql Windows

the MySQL query cache is disabled. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: What is up with = and trailing spaces?

: Note that all MySQL collations are of type PADSPACE. This means that all CHAR and VARCHAR values in MySQL are compared without regard to any trailing spaces. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives

Re: BUG: DATE_ADD 99999 fails, but 9999 works.

comment system isn't for reporting bugs *and* to let you know the correct place to report them. It's there as extra reinforcement for people who ignore or overlook the statement that I mentioned in the preceding paragraph. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB

Re: BUG: DATE_ADD 99999 fails, but 9999 works.

you let me choose that option then! UGH! ÐÆ5ÏÐ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General

Re: Why is the average of an int column returned as a string

to numeric form. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: looking for a good book for learning mysql

fast, so I don't want something to simple, I need something that can get me going and can also push me alot further. Thanks in advance ! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois

Re: Behaviour of auto_increment

explain it better if you said just what it is you're wondering about. For example, did the things you try not work and you're wondering why? You didn't say what were the results of your actions, nor whether they were what you expected. Please clarify. -- Paul DuBois, MySQL Documentation Team

Re: New error to me...

inserting into. http://dev.mysql.com/doc/refman/5.0/en/insert-select.html (You're not quite using INSERT INTO ... SELECT syntax, but what you're doing appears to be effectively equivalent.) -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General

Re: LOW_PRIORITY_UPDATES

LOW_PRIORITY_UPDATES=1; the same as starting mysql with --low_priority_updates? I think it is but want confirmation. It's the same. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: database cache /

-tuning.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: flush logs vs. mysqladmin

the general query log) isn't created as a numbered sequence of files. You'll need to rotate it yourself. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: how to get Number of rows matched?

Changed: 1 Warnings: 0 -- Cheers, Rajan -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: maximum number of records in a table

5,000,000,000 rows. that's cool but i assume this is distributed over a few machines... No. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Change in behaviour in version 5.0.41

At 12:10 PM -0400 6/18/07, Baron Schwartz wrote: Paul DuBois wrote: At 3:29 PM +0100 6/15/07, Ben Clewett wrote: Dear MySql, I have noticed a change in behaviour in MySql 5.0.41 from 5.0.26 with date comparisons. In 5.0.26:'2007-06-15' = '2007-06-15 00:00:00' is True. In 5.0.41

Re: Change in behaviour in version 5.0.41

'. To mimic the old behavior use the CAST() function in the following way: SELECT date_field = CAST(NOW() as DATE);. http://dev.mysql.com/doc/refman/5.0/en/date-and-time-types.html There is a corresponding change in 5.1.18. See: http://bugs.mysql.com/bug.php?id=28929 -- Paul DuBois, MySQL

Re: perl DBI does not do execute mysql statement

fine). Not sure how crazy this could be. Any clue? No, because you're describing the problem in English without showing any of the code that doesn't work. How can anyone help you? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing

Re: Documentation

at the main documentation page on our web site: http://dev.mysql.com/doc/ -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Trigger OLD question

use a statement something like this: INSERT INTO table_track SELECT * FROM track_table WHERE key_col=OLD.key_col; I admit I have not tested this. :-) -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http

Re: --xml or --html output to file

to stumble on it; better to consult the documentation for your interpreter. For Unix, you can do something like this: Put statements in a file x. Run mysql like this to capture output into y: mysql --xml db_name x y -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB

Re: expire_logs_days

At 9:55 PM -0400 5/3/07, Baron Schwartz wrote: Mark Leith wrote: Paul DuBois wrote: At 8:46 PM -0400 5/2/07, Baron Schwartz wrote: Ofer Inbar wrote: That's a good point, though probably a minor one: At most you would end up with one binary logfile that's old and not deleted. As soon as you

Re: REGEXP Character Classes

*include* the square brackets, so to use them as part of a range, you need another set of square brackets, i.e., [[:upper:]]. What your statement looks for is any values containing :, u, p, e, or r, and that's why you see the values returned that you do. -- Paul DuBois, MySQL Documentation Team Madison

Re: expire_logs_days

that's been up for 100 days. It has expire_logs_days, and I have 7 binlog files. I do flush my logs once a day to force the logs to rotate. So that's one confirmation that it works, at least in 4.1.13. :-) -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com

Re: REGEXP Character Classes

in set (0.00 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives

Re: What is /*!40101 SET @...

number at the beginning of the comment. http://dev.mysql.com/doc/refman/5.0/en/comments.html Basically, it's version-specific code for features that are unavailable in older servers. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing

Re: How to overwrite existing file with SELECT .. INTO?

is created on the server host, so you must have the FILE privilege to use this syntax. file_name cannot be an existing file, which among other things prevents files such as /etc/passwd and database tables from being destroyed. http://dev.mysql.com/doc/refman/5.0/en/select.html -- Paul DuBois, MySQL

Re: Collation Order in MySQL?

the produces the ordering you want. :-) To be conservative, should I set collation order? Yep. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: dumpfile question

of INTO OUTFILE, MySQL writes only one row into the file, without any column or line termination and without performing any escape processing. This is useful if you want to store a BLOB value in a file. http://dev.mysql.com/doc/refman/5.0/en/select.html -- Paul DuBois, MySQL Documentation Team

Re: information_schema not found

At 12:30 PM -0500 3/29/07, Brown, Charles wrote: Hi all. I just finished installing mysql on a new server. I noticed that database information_schema wasn't found. Can someone help me. What version of MySQL? I_S is present only in 5.0 and up. -- Paul DuBois, MySQL Documentation Team Madison

RE: MySQL Daylight Savings Time Patch

to know the correct time. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL Daylight Savings Time Patch

At 4:17 PM -0600 2/20/07, Paul DuBois wrote: At 4:36 PM -0500 2/20/07, Sun, Jennifer wrote: Any answers for the question below ? Is there a DST patch for MySql 4.0.20? Thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, February 09, 2007 9:30

  1   2   3   4   5   6   7   8   9   10   >