RE: Unix time as year in select query -nooby

be 2005 > > > Louise My guess is that you are passing what is already a unix timestamp to the function unix_timestamp, and since that is an invalid datetime it returns zero which then causes from_unixtime to return 1969 (when epoch time started in your time zone). Try using FROM_UNIXTIME(published,'%Y') -- 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: Changing the Prompt for timing purposes

mand in MYSQL command prompt so 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 -- To

RE: CSV storage engine

p://www.upscene.com Perhaps you can convince mysql ab to build a windows package similar to the linux max package which includes support 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

hing over the maximum will be converted 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

Re: [Q] Database design

and users can belong to multiple groups. You will need to look into joins to see how to query these tables effectively. For example to find out what users are in group A. SELECT u.name FROM user as u INNER JOIN usergroup as ug ON (u.id = ug.user_id) INNER JOIN group as g ON (ug.group_id = g.id)

RE: How to group records by using regular expression?

alue that will not exist in the table. This is why I said it is rigged. Maybe if you could explain why you are trying to do this, someone could help you come up with a better solution. > Could somebody help me? > > Thanx -- Tom Crimmins Interface Specialist Pottawattamie County, Io

RE: UNION ALL and GROUP BY

s sumcol from table2) as tmptable group by groupcol; 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 C

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

g spaces (0x20). Refer to the folowing page for further explanation. http://dev.mysql.com/doc/mysql/en/blob.html Quote from page: "There is no trailing-space removal for BLOB and TEXT columns when values are stored or retrieved. Before MySQL 5.0.3, this differs from VARBINARY and VARCHA

RE: mysql not starting at boot

ives an > error stating 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 In

RE: What's up with this syntax?

e: > > You have an error in your SQL syntax. Check the manual 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 sta

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 e

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:5

RE: if statement help

id( > `job_walltime` , 3, 2 ) ), sum( right( job_walltime, '2' ) ) > seconds > FROM `time`) > END > > I know this isn't the only way to do this but this but this is the > first suggestion that comes to mind. Any input would be great. > > Further in

RE: Central UDF project at mysql.com?

unction. I 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 Wedn

RE: upgrading mysql on RH fedora core 3

l.com/doc/mysql/en/old-client.html, specifically the old-password option. To make perl work with the new 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.

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

ql #/usr/sbin/mysqld Run this and see what errors are reported. > thanks > > bruce > [EMAIL PROTECTED] -- 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?

N ALL (SELECT X, Y FROM B WHERE W = 1 LIMIT 1000) ORDER BY X Without 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 > t

RE: MySQL account permissions

; > When I use the 'root' account everything is fine. > > Can 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 archiv

RE: show duplicate entries

gt; 1 row in set (0.00 sec) > > I got this select 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

RE: changing default date format on server

many ways to format date data for > viewing. How you change _what_you_see_ depends entirely on which tool > you are using to get data from the server and present it for viewing > or other operations. Refer to the documentation for the client you > are using for details on how to get

RE: Newbie: Searching for empty fields

ECT * FROM userLog WHERE ipAddress IS NULL 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 P

RE: again on encryption function, with bug 7846 question

g > > http://bugs.mysql.com/bug.php?id=7846 > > has been 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

ion-functions.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: Queries inside UDF

tblfoobar, and you don't have to do anything to make the latter work. Creating the UDF just seems like a lot of extra work. Maybe this is my 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 Interfa

RE: Reg creating log

log the above results 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 Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: CASE statement and version 4.1.x

riting 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 Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Use MySQL with Microsoft Office

om/downloads/connector/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: How do I move the Mysql database files from /var/lib/mysql to someother directory

ge datadir=/var/lib/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 Fo

RE: Partial and inexact matches

t; > I've combed the documentation and used 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

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

RE: backup scripts

and again at around line 745: > > my $dbh = > DBI->connect("dbi:mysql:${db}${dsn};mysql_read_default_group=mysqlhotcopy", > "backup_user", "backup_password", > > then, just to be sure, > > chown root.nobody mysqlhotcopy > chmod 700 mysqlh

RE: MySQL and triggers

t; us? Not in 4.1. 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://li

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

ct gives you your six rows, or 3 groups of 2 with you group by clause. Like I said above, I would suggest showing all of the fields ie. SELECT file_details.*, file_details_1.* FROM ....., so you can get a better idea of what is going on here. Also, there really isn't any reason to do

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

/a | > mp3/mp3s/SeemsIllUnpluggedMixed.mp3 | 2 | > Seems I'll | Song | Wasted Tears| > mp3/mp3s/seemsill.mp3 | 2 | > ++--+-+----- > > The count should be 3, right? What gives? The cnt fi

RE: GROUP BY Clause

e returned without 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

RE: Shell execution of mysql query

following: mysql -vv -D $dbName --vertical -u $DBUSER -p$DBPASS < $queryFile > $opFile The -vv controls sets 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: newbie question

nything, i can grab either > 'state_abbr' or 'state_name' from the states table, properly > associated with the 'state_id' and display the actual state > abbreviation or state name in my web page. > > I'm so close, yet so far. I know

RE: Is there a limit on Auto-increment

ce 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/

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 >>> h

RE: MySQL and DNS problem

using password: YES' > > Our DNS servers have correct forward and reverse entries for all of > our machines. I read 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

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

rison-operators.html, "The number of values in the IN list is only limited 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: Database creation privileges

have a wildcard. If you are connected as that user, then "SHOW GRANTS FOR CURRENT_USER()" will accomplish both of the above in one step. > > If I don't have the create privilege specified, then they > aren't able to > create tables, which I want them to be abl

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: schlub

RE: select last row

14, 2005 08:15 > 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

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, Fe

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:

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@list

RE: Need help with historic aggregation of data

ults for device 1. > My actual tables are pretty huge, and I'll spare you them. I > also am coding > this in PHP, in case I need to split this task up somehow. We > are using > v4.0.18 and can't change. > > I'm hoping there is some magic incantation of MAX(), GROU

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: Thurs

RE: 1 to many query

for each state_flag_name, but it will give you a list of all the state_flag_names associated with each project in a single column. SELECT t1.project_id, t1.project_name, GROUP_CONCAT(t3.state_flag_name) as state_flags FROM t1 INNER JOIN t2 ON (t1.project_id = t2.project_id) INNER JOIN

RE: Importing Tables on Top of Tables

the same name? There are two ways to do this. Issue a DROP 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

RE: Need a New Password & Username

vate_host' IDENTIFIED BY 'superstar'; You can add host restrictions 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. > &

RE: Need a New Password & Username

gt; under "Run SQL query/queries on database XXX_ZZZ:"? > > As I recall, "localhost" is the standard ROOT name and > is presumably already assigned. I've assigned a > database name, so I just need to reassign my username > and password. > > Thanks.

RE: Daily Incremental Backups on Mysql

per > > 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 Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: aborting slipped keys

how do I make sure it is on all > the time? > > thanks > -- > - > Scott HanedaTel: 415.898.2602 > <http://www.newgeo.com> Fax: 313.557.5052 > <[EMAIL PROTECTED]> Novato, CA U.S.A.

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

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 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?)

t the query should be changed. I thought I did that above when I suggested adding the index for the first query, but I obviously did 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: Indexing Questions (Problem?)

x. In the case of priority="notice", the query will benefit from the index. You could add the following index, but I don't know how useful these last queries will be since both return a lot of rows. ALTER TABLE logs ADD UNIQUE (priority,seq); > Why does the select say "

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,

RE: Ignoring username parameter when connecting via ssh tunnel

ied message to see who you are connecting as. What I am trying to say is that connecting from the remote machine with out the tunnel is not the same as connecting with the tunnel as far as permissions 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: 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

RE: Help with a query using multiple LEFT JOINS

want to do the same for tbl4 depending 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

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: SQL syntax error: help a noob

diff() function is new 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: 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: 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: DB recovery

ory for each database you 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 Pottawattami

RE: ERROR 1006: Can't create database

sql) -bash-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: list of error codes

http://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: 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 Cri

RE: Server crached problem

do all 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: ERROR 1006: Can't create database

ve that will give you an access denied 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: Access denied for user - I cant work this out

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.

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 For

RE: GRANT can't grant with a password?

have privs to the mysql.user table 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 gra

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 For

RE: Fulltext search question

e of true word characters (letters, digits, 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: Why DATETIME takes 8 bytes?

1 23:59:59 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: Saturda

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 T

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: Slow queries, need advice on how to improve; key_buffer - zen -cart?

n index 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. --- To

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

ng of slow 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 ---

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

ed 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:

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

ne 1" [/snip] Sorry about this too, in 3.23 leave out 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

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

tart. Try adding 'set-variable = 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

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: 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 Co

RE: Copying table to another server.

_name > dump.sql >mysql -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 In

RE: first time accessing

n change the host in your perl script to localhost, 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 Subjec

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' IDE

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 To

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. --

RE: MySQL Load on server

eries. --- 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 al

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 on

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: 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 Inte

RE: first time accessing

ct($url, $user, $pass) || die "Couldn't connect to database: " . DBI->errstr; Obviously you don't have to make everything a variable, this is just one possibility. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message---

RE: Max connections being used every 10-12 day.

x. This is covered by 1st_2 or 1st_3. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message----- From: Tom Crimmins Sent: Monday, January 03, 2005 2:49 PM To: Donny Simonton; 'Fredrik Carlsson' Cc: mysql@lists.mysql.com Subject: RE: Max connections being

RE: Max connections being used every 10-12 day.

h the explain you have PRIMARY,id,id_2,id_3 [/snip] id_2 and id_3 are composite indexes. As the explain shows, mysql is using id_3 because it is the most specific to the query. --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: Donny Simonton Sent: M

  1   2   >