RE: Changing the Prompt for timing purposes

that I can see the command I issued or a log file that I can write to.sorry about the basic questions but I'm a newbe. George Read the following for prompt modification: http://dev.mysql.com/doc/mysql/en/mysql-commands.html -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa

RE: Unix time as year in select query -nooby

') -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: CSV storage engine

for the csv engine along with many other things. -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Changed Number

to the maximum, and anything under the minimun will be converted to the minimun. This makes no sense. Any solutions? Ken -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: [Q] Database design

usergroup as ug ON (u.id = ug.user_id) INNER JOIN group as g ON (ug.group_id = g.id) WHERE g.name = 'A' -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

RE: Hex data in VARBINARY fields -- Is it me, or MySQL?

when values are stored or retrieved. Before MySQL 5.0.3, this differs from VARBINARY and VARCHAR, for which trailing spaces are removed when values are stored. -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http

RE: UNION ALL and GROUP BY

; Obviously you can add in your where clause. This is messy but it should work. This is basically using a temp table without 2-stepping it. If you look at the explain it will say using temporary. -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list

RE: How to group records by using regular expression?

this, someone could help you come up with a better solution. Could somebody help me? Thanx -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Central UDF project at mysql.com?

think that the community list may be the appropriate list for disscussion on how to get this going. I believe it is run by Arjen Lentz. I have CC'd him on this message. Maybe he can give some input. Regards, -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa On Wednesday, March 30

RE: if statement help

this but this but this is the first suggestion that comes to mind. Any input would be great. Further info MySQL 3.23.58 running on RedHat 9 -Chris Vaughan -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com

RE: if statement help

On Wednesday, March 30, 2005 10:24, Christopher Vaughan wrote: Tom Crimmins on Wednesday, March 30, 2005 at 11:10 AM -0500 wrote: If you convert it to a time field you can use mysql built-in functions to do what you want. You are limited to the range -838:59:59 to 838:59:59 though. http

FW: if statement help

Just forwarding this to the list. On Wednesday, March 30, 2005 10:43, Christopher Vaughan wrote: Tom Crimmins on Wednesday, March 30, 2005 at 11:31 AM -0500 wrote: Look at the functions HOUR(time), MINUTE(time), SECOND(time). These will give you interger output for each part of the time

RE: What's up with this syntax?

that corresponds to your MySQL server version for the right syntax to use near 'group by TLP.Line' Looks right to me... Remove the group by. A group by is used to group rows returned by a select statement. -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List

RE: mysql not starting at boot

it can't connect. Cheers. Mark Sargent. I assume you are able to start it after boot using 'service mysql start'. Run: chkconfig --list mysql This should show a list of runlevels with on and off. If not run: chkconfig --add mysql -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa

RE: upgrading mysql on RH fedora core 3

passwords, all you need to do is build DBD::mysql from source. To do this, uninstall the dbd-mysql rpm if you have it installed. I can't remember the exact name because I don't use it. Then as root run: #perl -e shell -MCPAN cpaninstall DBD::mysql Regards, -- Tom Crimmins Interface Specialist

RE: MySQL account permissions

you guys help? Cheers Phil The user needs the FILE priv. This is a global priv. -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Is there a way to use LIMIT in both UNION ALL statement and t hen ORDER?

the parens, this looks like an order by on just the second query, and since this is after the LIMIT clause that is invalid. It should work fine with the parens. Any way to let sort the result other than a temp table? Thanks, Homam -- Tom Crimmins Interface Specialist Pottawattamie

RE: 'Can't connect to local MySQL server....' error

the command line to see what errors you get. The following will work assuming you installed using the rpm's. Otherwise the location of mysqld and the user may differ. #su - mysql #/usr/sbin/mysqld Run this and see what errors are reported. thanks bruce [EMAIL PROTECTED] -- Tom Crimmins

RE: show duplicate entries

syntax to count how many duplicate entries i have. But i dont know how to show the duplicate entries i have on that table. SELECT username, email, COUNT(*) as n FROM users GROUP BY username, email HAVING n 1 Pls help! -- Louie Miranda http://www.axishift.com -- Tom Crimmins Interface

RE: changing default date format on server

or other operations. Refer to the documentation for the client you are using for details on how to get it to show you dates in the format you want to see. Shawn Green Database Administrator Unimin Corporation - Spruce Pine -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa

RE: Newbie: Searching for empty fields

Searching for empty string -- SELECT * FROM userLog WHERE ipAddress = '' Or either -- SELECT * FROM userLog WHERE ipAddress IS NULL OR ipAddress = '' There is no space between the single quotes. -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List

RE: again on encryption function, with bug 7846 question

fixed. -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: functions md5, crypt

On Monday, March 21, 2005 09:27, symbulos partners wrote: Dear friends, where is the description of the functions md5 in the manual? where is the description of the function crypt()? are there are good alternatives? http://dev.mysql.com/doc/mysql/en/encryption-functions.html -- Tom

RE: Queries inside UDF

ignorance, but I don't see much use for executing a query within a UDF esspecially if you are using 4.1 with subqueries. -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

RE: Reg creating log

into a log file, to do the same what option I have to use here with mysql command. PS: Input file contains some sql statements. Please help me in this. This is very urgent. Thanks, Narasimha -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General

RE: CASE statement and version 4.1.x

it to use nothing but case statements ( no | operators ). http://dev.mysql.com/doc/mysql/en/logical-operators.html it's || not | (not sure about bit-operation...) The | is a bitwise OR. http://dev.mysql.com/doc/mysql/en/bit-functions.html -- Tom Crimmins Interface Specialist

RE: How do I move the Mysql database files from /var/lib/mysql to someother directory

/mysql to datadir=/my/new/path -Start mysql Here is some info on symbolic links and databases from the manual: http://dev.mysql.com/doc/mysql/en/symbolic-links-to-databases.html -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http

RE: Use MySQL with Microsoft Office

/odbc/3.51.html -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Partial and inexact matches

Google but haven't found any such thing. -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: backup scripts

mysqlhotcopy Any ideas would be greatly appreciated. I would really like to add this to a cronjob to have it run automatically. Thanks in advance! -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http

RE: backup scripts

it in for mysql in the first command. -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa On Thursday, March 03, 2005 13:58, [EMAIL PROTECTED] wrote: Tom, I seem to be having difficulty allowing the mysqld user wx privs on the /backup folder. I read the following, but I don't see how

RE: ODD COUNT(*) Results on Self-Join (Bug?)

there will always be a match. By the way this is a horrible explaination, maybe someone else can do a better job of it. Tom Crimmins wrote: On Sunday, February 27, 2005 19:20, Van wrote: Hi Van, Greetings: I've got a table that has the following fields that are relevant to my self-join

RE: MySQL and triggers

. Triggers aren't supported until 5.0.2. http://dev.mysql.com/doc/mysql/en/using-triggers.html -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: ODD COUNT(*) Results on Self-Join (Bug?)

not the total number of rows returned. If you remove the group by clause from your query, you should see 6 rows returned (2 of each). -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: GROUP BY Clause

the GROUP BY. Without knowing your query and some of the data in your table, I can't really tell you anything else. -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

RE: Shell execution of mysql query

the verbosity of the output from the client. Thanks, Nupur -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Is there a limit on Auto-increment

the positive values for your column. An unsigned bigint gives you the ability to have 2^64 - 1 unique values. -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

RE: newbie question

in advance for any help with this. Sincerely, Joshua -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL and DNS problem

the docs about MySQL and DNS, but I still can't figure this out. I know you said you have correct reverse entries, but just as a test if you run 'host 192.168.2.103' on the mysql host, does it give back the hostname you used in your grant? Thanks, Ian -- Tom Crimmins Interface Specialist

RE: MySQL and DNS problem

On Thursday, February 17, 2005 10:26, Ian Meyer wrote: Tom Crimmins wrote: On Thursday, February 17, 2005 09:41, Ian Meyer wrote: Hello everyone, We have a few MySQL servers (4.1.8) running on RedHat ES3. We're having problems when trying to use hostnames in the grant command. Example

RE: What is the max length of IN() function?

by the max_allowed_packet value. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: one hour is/is not 60 minutes, that's the question...

The minute part of a time expression only has a valid range of 0 to 59. http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html http://dev.mysql.com/doc/mysql/en/time.html --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: schlubediwup

RE: Database creation privileges

tables, which I want them to be able to do... Is there a way to assign a user to a database, and give them the ability to do anything within that database, but not create another database Thanks, Tim. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL

RE: select last row

To: mysql@lists.mysql.com Subject: select last row Hi All, I have a table which is being continuosly updated, I just wanted to know how to output only the last row with the select statement. can anyone please tell me howto. thanks, Nikhil --- Tom Crimmins Interface Specialist

RE: Need help with historic aggregation of data

BY, DISTINCT, that will harvest this info for me. Thanks in advance, Daevid. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Remove spaces

Please post the error because this looks correct. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: John Berman [mailto:[EMAIL PROTECTED] Sent: Friday, February 11, 2005 16:05 To: 'Homam S.A.' Cc: mysql@lists.mysql.com Subject: RE: Remove

RE: Remove spaces

-Original Message- From: John Berman [mailto:[EMAIL PROTECTED] Sent: Friday, February 11, 2005 16:22 To: 'Tom Crimmins' Cc: mysql@lists.mysql.com Subject: RE: Remove spaces The error is simply: [JGSGB 4.1 Host] ERROR 1064: You have an error in your SQL syntax; check

RE: Innodb auto increment - reset itself automatically?

You may want to read this section of the manual: http://dev.mysql.com/doc/mysql/en/innodb-auto-increment-column.html --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: Rishi Daryanani [mailto:[EMAIL PROTECTED] Sent: Friday, February 11, 2005

RE: aborting slipped keys

Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa office 712.328.4808 mobile 402.677.1592 -- MySQL General

RE: Daily Incremental Backups on Mysql

logs. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au --- Tom Crimmins Interface Specialist

RE: Need a New Password Username

and is presumably already assigned. I've assigned a database name, so I just need to reassign my username and password. Thanks. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

RE: Need a New Password Username

to by adding @'hostname' after the username. It's all there in the manual. Anyway, I haven't used phpMyAdmin, but if you can just enter queries, which I assume you can, then this will work. Thanks. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List

RE: Importing Tables on Top of Tables

TABLE IF EXISTS my_table, before the CREATE TABLE my_table, or you can issue TRUNCATE TABLE my_table and ditch the CREATE TABLE statement. Thanks. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

RE: 1 to many query

, GROUP_CONCAT(t3.state_flag_name) as state_flags FROM t1 INNER JOIN t2 ON (t1.project_id = t2.project_id) INNER JOIN t3 ON (t2.project_state_flag = t3.state_flag) GROUP BY t1.project_id regards, -ljb --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing

RE: 1 to many query

-Original Message- From: Tom Crimmins Sent: Thursday, February 10, 2005 17:08 To: livejavabean Cc: mysql@lists.mysql.com Subject: RE: 1 to many query -Original Message- From: livejavabean Sent: Thursday, February 10, 2005 16:47 To: mysql@lists.mysql.com

RE: Syntax diagram, where is it located in the doc?

| 0 | false 1 | 0 | true 1 | 1 | false -1| 12| false 12| 0 | true would have been extremely simple if the syntax diagram started just above the quote you supplied us with had been completed and not ended when things got a bit interesting. /Thomas --- Tom Crimmins Interface Specialist

RE: Indexing Questions (Problem?)

, BMG --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Indexing Questions (Problem?)

not. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: List of connection error

Is there any documentation where I can find a list of all connection related error/error codes returned by MySQL? OS error codes : http://dev.mysql.com/doc/mysql/en/operating-system-error-codes.html Server error messages : http://dev.mysql.com/doc/mysql/en/error-handling.html --- Tom

RE: Ignoring username parameter when connecting via ssh tunnel

are concerned. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Why does dropping indexes takes such a long time?

I guess this should be a reminder to everyone that your out of office replies should not go to mailing lists :) --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: Homam S.A. [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 02, 2005 2:56 PM

RE: How-to copy a column

[snip] Does anyone know the easiest way to copy a column in mysql? I have a table (table1) which has 4 columns, I want to copy all the contents of col1 into col2. Col3 is the primary unique key, so the copy has to keep the data matched with col3. [/snip] UPDATE table1 SET col2=col1; --- Tom

RE: SQL syntax error: help a noob

to version 4.1. What version of mysql are you running? --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: SQL syntax error: help a noob

I think datediff only takes two arguments and you have three listed. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: Chris Kavanagh Sent: Monday, January 31, 2005 5:33 PM To: mysql@lists.mysql.com Subject: Re: SQL syntax error: help a noob

RE: Help with a query using multiple LEFT JOINS

on the behavior you are looking for. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: Graham Cossey Sent: Monday, January 31, 2005 5:48 PM To: mysql@lists.mysql.com Subject: Help with a query using multiple LEFT JOINS I'm hoping someone can help with a little

RE: add auto-increment field to fix table with no primary key - h elp

; --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: ERROR 1006: Can't create database

-2.05b$ --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: DB recovery

need to recover into the mysql datadir on the new host. You may have to use myisamchk to repair the indexes. http://dev.mysql.com/doc/mysql/en/myisamchk-syntax.html You will want to do all of this with mysqld stopped. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL

RE: ERROR 1006: Can't create database

error. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Server crached problem

of this with mysql stopped. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: list of error codes

[snip] I looked around and didn't see documentation of MySQL error codes. I did find a short list of INNODB codes but nothing comprehensive. Is there such a page? [/snip] You can use perror to find out want a mysql errno means. http://dev.mysql.com/doc/mysql/en/perror.html --- Tom Crimmins

RE: list of error codes

://dev.mysql.com/doc/mysql/en/error-handling.html (this page also tells what files to find these in) --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Access denied for user - I cant work this out

or explicitly state that they are global. Since these are all blank, it is using the defaults, which on windows are localhost, ODBC, and no password. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: Christian Biggins Sent: Wednesday, January 26, 2005 7:30 AM

RE: How to re-use InnoDB tablespace

[snip] I assume that the space of InnoDB free: 201787392 kB was resulted from the dropping of DB_B. Will this chunk be re-used when new data is inserted? [/snip] InnoDB tablespace will not shrink when data is removed. The space the you have from the dropped database will be reused. --- Tom

RE: Locked myself out of the mysql database!

can then log in as root with no password and then reset the password. Then stop mysql and restart it normally. In linux: mysqld --skip-grant-tables In windows: mysqld-nt --skip-grant-tables --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List

RE: GRANT can't grant with a password?

you definitely should not be able to do that. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: Joshua J. Kugler Sent: Tuesday, January 11, 2005 1:09 AM To: mysql@lists.mysql.com Subject: Re: GRANT can't grant with a password? Right, I understand

RE: Fulltext search question

, and underscores), optionally separated by no more than one sequential `'` character. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Quick query for multiple fields?

this without having to write all the field names out? [/snip] If the columns are in the same order you can use the following: INSERT INTO mail_inbox (SELECT * FROM mail_inboxold WHERE userid=10); --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List

RE: lock the tables

Unless your form is changing the same rows and order of operations is important (which is probably not the case), there is no need to lock the tables. So if each time the form is submitted it inserts a new row, there is no reason to lock the tables. --- Tom Crimmins Interface Specialist

RE: lock the tables

Correct, if the form generates independent insert statements then they will not bump into each other, even with an auto_increment. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: leegold Sent: Saturday, January 08, 2005 4:46 AM To: No name

RE: Why DATETIME takes 8 bytes?

because it is a combination of a date and a time field as Neculai wrote. You may be thinking of a timestamp, which is tored as a 4 byte int. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: Frank Bax [mailto:[EMAIL PROTECTED] Sent: Saturday, January

RE: creating first table

[snip] How can I list the rows and columns. [/snip] http://dev.mysql.com/doc/mysql/en/SELECT.html --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

RE: Slow queries, need advice on how to improve; key_buffer?

= key_buffer = 64M' to your my.cnf. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: BD Sent: Friday, January 07, 2005 9:07 AM To: mysql@lists.mysql.com Subject: Slow queries, need advice on how to improve; key_buffer? Hi, I'm having a problem

RE: Slow queries, need advice on how to improve; key_buffer?

the word global. If you can restart without a problem though, I would jest add the 'set-variable = key_buffer = 64M' line to your my.cnf file and restart mysql. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: BD Sent: Friday, January 07, 2005 9:07

RE: Slow queries, need advice on how to improve; key_buffer?

to not having proper indexes on your tables. If you post the query, and a 'SHOW CREATE TABLE [tablename]' for each table involved, someone maybe able to help you speed it up. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: BD Sent: Friday, January

RE: Slow queries, need advice on how to improve; key_buffer - zen -cart?

queries. [mysqld] set-variable = long_query_time=2 log-long-format log-slow-queries = /var/log/mysqld.slow.log (or whatever file you want, just make sure the user mysqld is running as has write permissions to it.) --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original

RE: Slow queries, need advice on how to improve; key_buffer - zen -cart?

on (manufacturers_id, products_status), and zen_manufacturers could use an index on (manufacturers_id,manufacturers_name). You can try to add these indexes and run the query to see if it helps. You may want to do an EXPLAIN after adding the indexes to make see if it is using them. --- Tom Crimmins

RE: first time accessing

, and you should be ready to go. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: Gerald Preston Sent: Thursday, January 06, 2005 5:25 AM To: 'Tom Crimmins' Cc: mysql@lists.mysql.com Subject: RE: first time accessing Tom, I tried the following

RE: Copying table to another server.

-h 'other_hostname' -D db_name dump.sql Running the commands separately will allow you to see what is going on more easily. You may need to specify a username and a password with each command i.e. 'mysql -u user -p'. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original

RE: first time accessing

If you are using a fresh install of mysql, you need to connect with 'mysql -u root' from the local machine and then configure access for other users with the GRANT command. See http://dev.mysql.com/doc/mysql/en/GRANT.html. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa

RE: Cannot create Windows service for MySql. Error: 0

I had this problem once. My fix was to delete the innodb files from the mysql datadir (log and data files), then run mysqld-nt from a command prompt. After it starts normally, you can stop it and then install it as a service. I don't know if this will work for you, but it did for me. --- Tom

RE: MyODBC 3.5.9 and MySQL 4.1.8

Try MyODBC 3.51.10. It supports 4.1 auth. Here is a link to a mirror that has it: http://mysql.netvisao.pt/downloads/connector/odbc/3.51.html --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: nikos Sent: Wednesday, January 05, 2005 3:09 AM

RE: Grant question

[snip] Is it possible to grant all these databases in just one GRANT instruction such as: GRANT SELECT,INSERT,UPDATE,DELETE ON dbexample*.* TO 'user'@'localhost' BY 'password'; [/snip] GRANT [privs] ON `dbexample%`.* TO 'user'@'localhost' IDENTIFIED BY 'password'; --- Tom Crimmins Interface

RE: MyODBC 3.51.10

4.1 auth is not supported until MyODBC 3.51.10. I don't know why the win binaries are not on the download page anymore, though the source is there. Here is a mirror with the windows binaries. http://mysql.netvisao.pt/Downloads/MyODBC3/MyODBC-3.51.10-x86-win-32bit.exe --- Tom Crimmins Interface

RE: distinctSelection(veryUrgent)

SELECT s.* FROM Second s LEFT JOIN First f USING (Flower,Color) WHERE f.Flower IS NULL; --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: N. Kavithashree Sent: Tuesday, January 04, 2005 11:17 PM To: mysql@lists.mysql.com Subject

RE: MySQL Load on server

If I understand correctly, this is what you want: SHOW PROCESSLIST --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: Sheni R. Meledath [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 04, 2005 11:40 PM To: MySQL Masters Subject: MySQL Load

RE: MySQL Load on server

. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: Sheni R. Meledath Sent: Wednesday, January 05, 2005 12:18 AM To: Tom Crimmins Cc: mysql@lists.mysql.com Subject: RE: MySQL Load on server Dear Tom, Thank you very much. Is there a way to log all

RE: backup/restore

to provide more help. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- Hi, Thank you for your reply. Even though I used the --add-drop-table option, I am getting the error messages. Actually I am taking the backup for a group of tables as following D:\Code

RE: changing data dir

the link. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: doing SELECTS and keeping the array intact with php

http://us2.php.net/manual/en/function.mysql-data-seek.php This lets you set the internal row pointer of the mysql result. In your case you would want mysql_data_seek($result,0). --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: julian haffegee

  1   2   >