Re: Select ENUM values

#x27;m doing a "SHOW COLUMNS FROM global_lead LIKE 'greeting'" and then parsing out the response for the enum values (found on mysql site). But I was thinking there might be a more elegant way to do it. Is there? No. -- Paul DuBois, MySQL Documentation Team Madison, Wiscons

Re: Specify which domain to connect from

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: http://lists.mysql.com

Re: max_allowed_packet error (2020) in mysqldump 3.23.54

mysqldump has its own setting for max_allowed_packet. It sounds like you'll need to increase the setting for mysqldump, not just the server: http://dev.mysql.com/doc/mysql/en/mysqldump.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL Genera

Re: Escaped BLOB data in XML

more help if you post your question (which boils down to "how can I write out binary data to an XML file?") on an XML-related list. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mys

Re: C API: mysql_options and mysql_real_connect

At 14:40 -0700 8/12/04, V. M. Brasseur wrote: Paul DuBois wrote: At 8:06 -0700 8/12/04, V. M. Brasseur wrote: Paul DuBois wrote: At 13:03 -0700 8/11/04, V. M. Brasseur wrote: Assuming a my.cnf file which looks like this: [client] port=3306 socket=/path/to/mysql.sock [app] user=appuser

Re: C API: mysql_options and mysql_real_connect

At 8:06 -0700 8/12/04, V. M. Brasseur wrote: Paul DuBois wrote: At 13:03 -0700 8/11/04, V. M. Brasseur wrote: Assuming a my.cnf file which looks like this: [client] port=3306 socket=/path/to/mysql.sock [app] user=appuser password=apppwd host=my.host.com Ignore for now the insecurity

Re: C API: mysql_options and mysql_real_connect

likely) would still need to parse the file separately and grab the parms for passing to mysql_real_connect(). Is this an accurate assessment? No. If you pass NULL in the mysql_real_connect() params, the values from the option file(s) are used. -- Paul DuBois, MySQL Documentation Team Madison, Wis

Re: Creating a New User - What am I doing wrong?

e the anonymous-user accounts, as described here: http://dev.mysql.com/doc/mysql/en/Default_privileges.html The reason for what you are seeing is explained here: http://dev.mysql.com/doc/mysql/en/Connection_access.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mys

RE: type=heap problem...

> ERROR 1164: The used table type doesn't support AUTO_INCREMENT columns -- 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: Running multiple versions of MySQL on 1 machine

makes perfect sense. -- 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: Query Cache

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: http://lists.mysql.com/mys

Re: Why do exists & In fail?

CT * FROM erestbase WHERE erestbase.id in(SELECT distinct idcid.id FROM idcid) This is stupid. Nothig would be wrong here in sqlServer etc. Both ids are integer values. Is your version of MySQL older than 4.1? http://dev.mysql.com/doc/mysql/en/Subqueries.html -- Paul DuBois, MySQL Documentation Tea

Re: Alternate directory for database

symlink in the original location that points to the new location. On Unix, use a regular symlink. On Windows, the procedure is described here: http://dev.mysql.com/doc/mysql/en/Symbolic_links.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General M

Re: Is LOAD DATA INFILE an atomic operation?

be in 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: Purpose of "&" (was Re: mysqld_safe)

e process. Ah, it's not part of the mysqld command itself. Got it. Right. It's a process-control aspect of how the shell itself works. The genesis of this in Unix is described in the "Process Control" section of this document by Dennis Ritchie: http://cm.bell-labs.com/cm/cs

Re: Confusion about various users, starting over from scratch

t's just mysqladmin that doesn't work, because it doesn't exist anywhere. Doesn't mysqladmin work when the daemon is running? (stupid question, I know, but I've been through this troubleshooting guide paragraph by paragraph multiple times and this one isn't covered.) -

Re: mysqlcheck (not myisamchk) harmful?

ould be reasonably quick, though, unless your directory access routines are dreadfully slow. -- 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: where its not a letter

ng to create a simple select query but I want to return records > unless a field contains a C or c so would it be something like > > > where field <> 'c' or 'C' -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL

Re: SHOW TABLE STATUS in MySQL 4.1.latest different from 4.1.1 !?

t; SQL > Server. > Upscene Productions > http://www.upscene.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For

Re: Confusion about various users, starting over from scratch

r as mysql unless you chown/chgrp them later. Use --user=mysql and you won't have to do that. -- 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: How to show comments/annotations in MySQL client output

l that corresp onds to your MySQL server version for the right syntax to use near 'SYSTEM "echo Some comments "' at line 1 mysql> Is the SYSTEM command not supported on Windows? I have been unable to find it documented in the MySQl manual for 4.0.18. Thanks for your help -

Re: daisy-chaining replication

3 times now using the data from server_a and no matter how much replication data server_b has gathered from server_a post-install, the position is always 79 (!). Can anyone lend me a clue? Did you start server b with --log-slave-updates so that it writes the events that it receives from its master to i

Re: set character set on MySQL 4.0.18

upported until 4.1.1: http://dev.mysql.com/doc/mysql/en/SET_OPTION.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: Replication script pb

At 11:54 +0100 7/27/04, Philippe Poelvoorde wrote: Paul DuBois wrote: At 8:20 -0500 7/26/04, Victor Pendleton wrote: Have you tried using the last insert id function instead? SET @backup_id = last_insert_id() That'll give him the same result. I suspect the problem might be that user vari

RE: Replication script pb

FROM param) It works perfectly on the master but the slave stop due to duplicate entries. the @backup_id do not pass the replication... any solution to have that script working ? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing Lis

Re: flush table with read lock

out? Any idea appreciated. Best regards. MaFai [EMAIL PROTECTED] 2004-07-27 -- 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: transferring MySQL db from RedHat to Debian

7;t do something unsupported like change the values to negative numbers or zeros after generating the IDs.) -- 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: mysqld_safe

ssfully. 2. the server startup faild and locked up. I'm hoping it is no. 1 that happened. if so, how do I get a command prompt after I start the server? Did you end the command with a & character? and if the server does work, how do I get it to startup with Debian Linux? -- Paul DuBois,

RE: SQL for detecting if Column/Index already exists?

the ALTER TABLE statement. I assume that you're using some kind of programming API to access MySQL here. If you're asking "is this supported using SQL alone?" the answer is no. Thanks Shishir Ghate -----Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Mond

Re: SQL for detecting if Column/Index already exists?

OLUMNS and SHOW INDEX statements? -- 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: File size limits with mysql 4.1

://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html For existing tables, you can use ALTER TABLE to change the option values. -- 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: Multiple inserts in one statement

to provide an example of this. I'd be interested to see how this is done. -- 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: mysqldump question

sqlhotcopy tells the the server to lock the table files, then it makes copies of those files while they are locked. Windows file-locking semantics prevent this from working, because you cannot copy a file while the server has it locked. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, US

RE: MySQL book

At 1:55 +0200 7/26/04, Schalk Neethling wrote: Can anyone suggest o great book to learn MySQL inside out? I am thinking of getting: *MySQL By* Paul DuBois <http://www.informit.com/safari/author_bio.asp?ISBN=0735709211> - New Riders Publishing That's the first edition. I would sugg

RE: How do I import a .dmp file?

s to determine what it actually contains before you can figure out how to get it into MySQL? -- 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 start with multi processes?!

27;s going on? They're threads of the same process, not multiple processes. This is normal. The number of threads at startup can vary depending on how your server is configured. For example, if you start the server with --skip-innodb, you'll likely see three threads rather than ten.

Re: 2 Questions - DateTime fractional seconds and Transactions

ction could be concluded) be automatically rolled back or automatically committed by the server? Rolled back. -- 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: INSERT DISTINCT?

ql 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: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: a OPS$ equivalent in mysql

ve to type passwords, this procedure would achieve that, and it wouldn't leave the account passwordless. http://dev.mysql.com/doc/mysql/en/Using_MySQL_Programs.html http://dev.mysql.com/doc/mysql/en/Option_files.html http://dev.mysql.com/doc/mysql/en/Connecting.html -- Paul DuBois, MySQL D

Re: Increasing number of sockets

DuBois wrote: At 6:47 -0500 7/7/04, Robert Canary wrote: Unless it the error is referring to the number of simultaneous connections. Which defualts to 90 (max_connection under safe_mysql). I'm sorry, I'm unable to parse those sentences... TCP/IP of course Paul DuBois wrote: At 22:09 -0

Re: Mysql Newbie: Help requested...password hash should be a 16 digit hexadecimal number

ld be a 16-digit hexadecimal number OMIT the word 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: How to query an oracle table from a mysql database

7;t know if this kind of solution is possible, using only MySQL to see a remote Oracle table, not including any programming language. It's not. You must use a program as a bridge, as people have been suggesting. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.c

Re: DBF to MySQL

what it is worth, I am a Mac OSX.3 user. Thanks, John -- 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 Genera

Re: Increasing number of sockets

single Unix socket file. There's no need for more. I'm looking the man pages for safe_mysqld and mysql but I don't see anything that offers to provision this. How does increase the number of sockets on the mysql? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsi

Re: Range of timestamp(14)

year-month-day order. http://dev.mysql.com/doc/mysql/en/Date_and_time_types.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

Re: first record is skipped in select and shows up last

be the very last record. But doing a limit 0,1 will get the 1st rec btw. Is there more info I can give you? I'm I overlooking something? The actual queries and some sample output to demonstrate the problem would be helpful. Otherwise, we're just guessing. -- Paul DuBois, MySQL Document

Re: ERROR 1137: Can't reopen table: 'mj_tmp_diag'

blem? Don't use a TEMPORARY table. :-) The error shows when I execute the whole query under MySql Control Center. Mysql version is 4.1 -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.m

Re: Query last record in table

I've tried "select *,max(acctid) as lastid from subscribers where acctid = 'lastid' group by acctid" but this returns nothing ?? TIA :) -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archiv

RE: Concurrency Question

is approximately 1) -- 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: update problem with mysqlimport (bug/misuse?)

cutes and UPDATE for each one: pretty SLOW. SO I read carefully mysqlimport and think that is THE solution for the speed matter. BUT the fields that I don't include in the mysqlimport field list get EMPTY! mysqlimport is for adding new records (or replacing existing ones). It does not update ex

Re: MySQL 4.0.18 and Unicode

l.com/doc/mysql/en/Charset.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: mysql sql files...

he section on the mysql program in the MySQL Reference Manual. http://dev.mysql.com/doc/mysql/en/mysql.html In particular, this subsection: http://dev.mysql.com/doc/mysql/en/Batch_Commands.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mai

Re: mysql sql question

iple sql statements.. but i'm trying to see how to do it in a single statement... You can't, for the reason noted above. If you happen to have a unique index on the owner.name column, then what you might want to try is the INSERT INTO ... SELECT FROM form of INSERT. http://dev.mysql.co

Re: Is this a New Discovery?

ate(concat('#',ProductSerNo,'#'),'#12#10#1#9#'))!=0 order by @pos "); (@pos is a user variable, ProductSerNo is an auto_increment column of Products table, '#12#10#1#9#' represents stored serial Nos of certain Products) -- Paul DuBois, MySQL Documentation Team M

Re: Training and certification in Kansas City

t centers" link and you'll get to a page where you can find test centers. -- 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: Production release of MySql 4.1

e date when 4.1 will go into beta? Cheers > Jon -- 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: mysqld_safe in 4.1.2

://dev.mysql.com/doc/mysql/en/Server_options.html See the descripion of --user in the option list. This is counter intuitive if nothing else, and I really don't see why user should be parsed any differently than any other options. Am I missing something or is this a bug? It's by inten

Re: MySQL and Macs

I need to know about how to set it up? Can anyone point me to a setup procedure? Jim You need Mac OS X, not Mac OS. http://dev.mysql.com/doc/mysql/en/Installing.html http://dev.mysql.com/doc/mysql/en/Mac_OS_X_installation.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsi

Re: Where is the utf8_general_ci collation in sources?

At 7:53 +0300 6/29/04, Dainis Polis wrote: Hi All! Where to find subj.? strings/ctype-utf8.c, I believe. -- 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: REGEXP and word boundary match

riting my own boundary check with limited success. The easiest way to find out the correct syntax is to look in the MySQL manual. :-) http://dev.mysql.com/doc/mysql/en/Regexp.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List F

Re: MySQL from Python Error

mysku = row[0] print mysku print "%d rows were returned" % cursor.rowcount result = test_iopus.Scrape(mysku) price = result.split(" ") tmpprice = str(price[0]) conversion = string.maketrans("$"," ") myprice = tmpprice.translate(conversion) print myprice curso

Re: INDEX DESC

At 15:30 -0400 6/23/04, Michael Stassen wrote: Alejandro Heyworth wrote: Does anyone know when INDEX DESC will be implemented? I'm storing time values and want to access the data from the most recent time value without sorting the result set. Paul DuBois wrote: I don't see any re

Re: INDEX DESC

this is clearer. So, does anyone know when it will be implemented? -- 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: INDEX DESC

r the help by the way! We are rapidly migrating our experiments to MySQL and trying to dump SQL Server forever! -- 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: INDEX DESC

At 11:36 -0400 6/23/04, Alejandro Heyworth wrote: Does anyone know when INDEX DESC will be implemented? I'm storing time values and want to access the data from the most recent time value without sorting the result set. I don't see any relationship between your two sentences? -- P

Re: question on auto increment field

that limit and try to insert a > record, a error would be generated, no new records would be able to be > inserted until this was resolved. It will not work, because if you insert dummy row and set auto_increment value to , the next generated auto_increment value will be 1. -

RE: New to Dates - Plain English Please

2002-05--- The manual can help you here. See: http://dev.mysql.com/doc/mysql/en/Date_and_time_types.html Second paragraph. -- 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

Re: New to Dates - Plain English Please

ect format for these dates in a MySQL table would be like this: 03-02-2003 07-07-2004 Am I right? No. Which part of the manual leads you to believe that this is the correct format for dates? Dates should be entered in -MM-DD format, not MM-DD-YYYY. -- Paul DuBois, MySQL Documentation Te

Re: Default accounts and custom installtion directory

ould specify the new values for basedir and datadir in the [mysqld] section of an option file. The allowable option files on Windows are described in the Reference Manual as well. http://dev.mysql.com/doc/mysql/en/Option_files.html -- Paul DuBois, MySQL Documentation Team Madison, Wis

Re: PHP RPM + 3 binary install of Mysql-4.0.20

to rebuild PHP yourself, with support for MySQL included. -- 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: IS NULL works, but IN (NULL) doesn't

rds, it would make sense to me that I should be able to say "wifi_list IS 3" instead of an = sign. Yes, IS is only for IS NULL comparisons. You might want to take a look at this section: http://dev.mysql.com/doc/mysql/en/Problems_with_NULL.html -Original Message- From: Paul D

Re: Err 2002 socks suck noway to start

6.0.693 / Virus Database: 454 - Release Date: 31/05/2004 -- 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 -- M

Re: Err 2002 socks suck noway to start

8-0 MySQL-shared-4.0.18-0 -- 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: question

At 22:54 -0700 6/4/04, jerome greene wrote: Where do you run the verify programs from? Are they ran from the command prompt? Do I copy the keys? Thanks What is the context of these questions? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL

Re: update SQL

_log.completed is null; Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0 Perhaps nothing. If the statement WHERE clause selects a row to update, but the column assignments do not actually change any values (e.g., they set the columns to the values they already have), the Ch

Re: IS NULL works, but IN (NULL) doesn't

ver true. SELECT wifi_list, IFNULL(wifi_list, 0) as wifi_list_new, FROM wifi_table LEFT JOIN Swordfish.scanner ON scanner.scanner_id = wifi_table.scanner_id LEFT JOIN wifi_wlist_table ON wifi_table_mac = mac WHERE last_seen >= CURRENT_DATE AND wifi_list IN (NULL); -- Paul DuBois, MySQL Document

Re: Can you rename or copy a database?

ide your other databases? Not sure what that means. What does it mean? SQL LaTeX CSV for Ms Excel data CSV data XML What does this list signify? You've presented it without explanation. Please explain. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.co

Re: Granting privileges to other users

on every table for each user that I add. I am looking for the SQL command to do this. Thanks, Rob Paul DuBois <[EMAIL PROTECTED]> wrote: At 9:15 -0700 6/2/04, Robert Frame wrote: This is probably something simple that I am just not seeing, but I would appreciate your help. As root, I have

Re: INTO OUTFILE error

chives: 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: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Short Passwords in 4.1.2

--old-passwords? -- greg willits -- 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: RV: Select data from two different databases

something you have to take care of. Ugly. -- 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: getting mysql working

alled the mysql with the suse 9.1 pro cd. I am thinking that I should reinstall my mysql. But I don't know how to do that. Can someone please tell me how to fix this or how to reinstall it? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL

Re: Granting privileges to other users

o this as root? If so, what is the syntax to do so? -- 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: Username/Password Basics

your conceptual model is backwards. It might serve you best to toss out that model and read through the sections of the manual noted above. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists

Re: RES: Is possible Autocommit within my.ini?

is in 4.1.2. See the description for the init_connect variable here: http://dev.mysql.com/doc/mysql/en/Server_system_variables.html Thanks, Renato. -Mensagem original- De: Paul DuBois [mailto:[EMAIL PROTECTED] Enviada em: sexta-feira, 21 de maio de 2004 15:03 Para: Renato Cramer; Lista MySQL (E-m

Re: passwords...

c/mysql/en/Security_against_attack.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: Is possible Autocommit within my.ini?

At 14:34 -0300 5/21/04, Renato Cramer wrote: Hi All, I already looking for Autocommit within my.ini at documentation and archives of the list, and not found. Anybody can help me? What is it that you want to accomplish? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB

Re: Running more than one level of MySQL

nvolved in the set-up). It's perfectly possible. I have dozens of versions installed, though not all necessarily running at the same time. :-) http://dev.mysql.com/doc/mysql/en/Multiple_servers.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -

Re: Change ft_min_word_len require fulltext index rebuild

the manual that suggests otherwise? If so, where was it? -- 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: setting default value based on another field value

the number when you issue a retrieval statement. -- 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: Problem with like wildcard syntax

e any applicable bugfix item in the 4.1.2 change notes: http://dev.mysql.com/doc/mysql/en/News-4.1.2.html However, so many problems are fixed that I may have missed it. -- 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: Counting multiple tables

+--++ |3 | f | |6 | f1 | |7 | ft1| +--++ 3 rows in set (0.00 sec) Once the bug gets fixed, you would not need to pad. It's fixed in 4.1.1: http://dev.mysql.com/doc/mysql/en/UNION.html -- Paul DuBois, MySQ

Re: e: Select distinct year from unix timestamp

At 17:50 -0500 5/16/04, Paul DuBois wrote: At 0:38 +0200 5/17/04, John Fawcett wrote: From: "Paul DuBois" You're right. You'd have to apply YEAR() to FROM_UNIXTIME(UNIX_TIMESTAMP(arg)). and you can avoid YEAR() altogether by using a format string. in FROM_UNIXTIME() Ri

Re: e: Select distinct year from unix timestamp

At 0:38 +0200 5/17/04, John Fawcett wrote: From: "Paul DuBois" You're right. You'd have to apply YEAR() to FROM_UNIXTIME(UNIX_TIMESTAMP(arg)). and you can avoid YEAR() altogether by using a format string. in FROM_UNIXTIME() Right again. :-) -- Paul DuBois, MySQL Docume

Re: [SPAM]Re: Select distinct year from unix timestamp

At 0:25 +0200 5/17/04, John Fawcett wrote: From: "Paul DuBois"> At 22:27 +0200 5/16/04, John Fawcett wrote: >Year does not operate on a unix timestamp. Sure it does: mysql> select t, year(t) from tsdemo1; ++-+ | t

Re: 4.0.18 vs 4.1.1

o to 4.1.1 is for sub-selects, otherwise I'd stick to 4.0.18. What I would really like is go to 5.0 (for stored procedures), is 5.0 stable enough for casual use? Well, if you want to use stored procedures, then the answer is "yes," because 5.0 is your only choice. :-) -- Paul Du

Re: Select distinct year from unix timestamp

22133241 |2001 | | 20010822133241 |2001 | ++-+ The problem lies elsewhere. Where that might be is difficult to say, because no PHP code has been shown yet. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List

Re: Default search directory for SOURCE command?

At 15:05 -0500 5/15/04, Josh Trutwin wrote: On Sat, 15 May 2004 14:38:52 -0500 Paul DuBois <[EMAIL PROTECTED]> wrote: >Is there something similar in MySQL? No. Dang - oh well. :) >Also, any idea why SOURCE filename.sql; works in MySQL 5.0.0 and \. > >filename.sql; does n

Re: Default search directory for SOURCE command?

why SOURCE filename.sql; works in MySQL 5.0.0 and \. filename.sql; does not? Leave out the trailing semicolon for short-form commands. -- 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 u

Re: --default_table_type

At 15:57 -0400 5/14/04, Lou Olsten wrote: Is there a way to set this dynamically? The associated system variable is table_type, not default_table_type. SET table_type = xxx; SET SESSION table_type = xxx; SET GLOBAL table_type = xxx; Thanks, Lou -- Paul DuBois, MySQL Documentation Team Madison

<    1   2   3   4   5   6   7   8   9   10   >