Re: sql to duplicate records with modified value

2010-03-27 Thread Ray Cauchi
Hi Voytek You could try some variation of: INSERT INTO inserttable (user, maildir) SELECT REPLACE(user, '@', 'spam@') as user, CONCAT(maildir,'.spam/') as maildir FROM selecttable [WHERE ..] the where bit is optional of course! let me know how you go - hope

Re: insert random number into table

2009-10-16 Thread Ray
On October 16, 2009 12:29:42 pm Jerry Schwartz wrote: > >-Original Message- > >From: Ray [mailto:r...@stilltech.net] > >Sent: Friday, October 16, 2009 1:10 PM > >To: mysql@lists.mysql.com > >Subject: Re: insert random number into table > > > >On O

Re: insert random number into table

2009-10-16 Thread Ray
gt; > www.the-infoshop.com > > >-Original Message- > >From: Ray [mailto:r...@stilltech.net] > >Sent: Friday, October 16, 2009 11:43 AM > >To: mysql@lists.mysql.com > >Subject: insert random number into table > > > >Hello All, > >I a

insert random number into table

2009-10-16 Thread Ray
Hello All, I am trying to insert a unique random number* with each row when inserting into a table. I can do it in the application layer (php) but just wondering if there is an easier way in the database layer. Thanks Ray * for example, when registering a person for a contest, I want to give

Re: MySQL GUI Tools

2009-07-13 Thread Ray
On July 13, 2009 12:03:49 pm Carlos Williams wrote: > If I am looking for a application that will connect to MySQL and allow > me to make database / table / user / permission modifications via a > graphical tool, is there something specific out there you guys > recommend? I have been doing everythi

[solved]Re: Question about query - can this be done?

2009-06-02 Thread Ray
On June 2, 2009 04:13:31 pm Nathan Sullivan wrote: > Ray, > > You can use the results of a query in a join with something like: > > select tmp.id, t1.id > from (some_query_selecting_id) as tmp > join t1 on t1.id=tmp.id > > > Hope that helps. > > > Regard

Re: Question about query - can this be done?

2009-06-02 Thread Ray
On June 2, 2009 03:14:36 pm Ray wrote: > On June 2, 2009 10:44:48 am Peter Brawley wrote: > > Ray, > > > > >I want a query that will provide one record per event with all times > > > included. feel free to answer RTFM or STFW as long as you provide the

Re: Question about query - can this be done?

2009-06-02 Thread Ray
On June 2, 2009 10:44:48 am Peter Brawley wrote: > Ray, > > >I want a query that will provide one record per event with all times > > included. feel free to answer RTFM or STFW as long as you provide the > > manual section or key words. ;) > > Can be done with

Question about query - can this be done?

2009-06-02 Thread Ray
more than 3. I want a query that will provide one record per event with all times included. feel free to answer RTFM or STFW as long as you provide the manual section or key words. ;) Thanks, Ray chart form follows: id | event_id | start | end --- 1 |

Re: mysqldump: Got error: 1: Can't create/write to file 'dumpdir/tablename.txt'

2009-04-04 Thread Ray Anderson
I wanted to respond with what I found: APPARMOR blocks mysql from writing to any other directory than the data dir and /tmp. I had to edit the /etc/apparmor.d/usr.sbin.mysqld file and add the following: /backups/mysql** rwk, to the bottom. Hope this helps someone. Ray -- MySQL General

Re: avoiding use of Nulls (was: The <=> operator)

2009-03-14 Thread Ray
> > I agree with most everything you said, as far as the use of a RDBMS, and > especially: quoting you, > > "theoretically you break up your data into tables so that there is never a > non-applicable field for any given row." > > Here is where I disagree with you, and please DON'T take this as an

avoiding use of Nulls (was: The <=> operator)

2009-03-13 Thread Ray
his can lead to a lot of complexity, so many people usually cheat and have a few "does not apply" fields for some records. Now, what I've been doing is using NULL for "does not apply" as it seems to be more true to the data model than using some sort of fake da

Re: speedup mysql restore

2007-05-20 Thread Ray Cauchi
Have you tried using the > use db > source /path/to/dumpfile.sql command via the mysql command line client? At 08:28 AM 5/20/2007, Vitaliy Okulov wrote: Çäðàâñòâóéòå, mysql. How i can speedup restore of mysql DB from file created by mysqldump? MySQL is quite fast at reloading data, but if

Re: how to enable logging, MySQL 5.0.37 FreeBSD 6.2

2007-05-02 Thread Ray
I seem to have problems receiving from this list. I hadn't seen this answer come through until I was searching google again today. :) I just can't get my head around the mysql config system. If you can provide me with instructions, It would be greatly appreciated. Ray >There

how to enable logging, MySQL 5.0.37 FreeBSD 6.2

2007-04-24 Thread Ray
Hello, I am trying to debug another application and I need to enable logging of all queries (temporary only) to MySQL (5.0.37). OS is FreeBSD 6.2. MySQL installed from ports. any Instructions, or pointers to documentation would be appreciated. Thanks, Ray -- MySQL General Mailing List For

Problem with upgrade

2006-11-22 Thread Tom Ray [Lists]
I upgraded a server from 4.0 to 4.1 and then to 5.0 but I've been running into a problem. When I was running 4.0 the passwords with the password('password') command where being created like this: 2a287c002f9773dc now after I upgraded to 4.1 when I add a new user the passwords end up being like

Results Order Question

2006-09-28 Thread Tom Ray [Lists]
I'm running into a problem with a ratings script I'm writing. The overview is that a user can rate an item from 1-10. What I want it to do is display the highest rated item, with 10 being the highest rating. In case there are multiple items sharing the same score, the item that has been rated t

Re: Autoindexing

2006-06-23 Thread Tom Ray [Lists]
hould find and edit table where it sotres index/counter data.. Tom Ray [Lists] wrote: Hey, I have a really simple question (I hope)..I have a database that has a field in it that autoindexes the number. I screwed up and imported a bunch of wrong data. Up to row 200 it's right, beyond that

Autoindexing

2006-06-22 Thread Tom Ray [Lists]
Hey, I have a really simple question (I hope)..I have a database that has a field in it that autoindexes the number. I screwed up and imported a bunch of wrong data. Up to row 200 it's right, beyond that it was wrong so I had delete it all. The problem now is the autoindexing is set to 1105, I

Re: my.cnf / mysqld logging

2006-06-16 Thread Tom Ray [Lists]
How would I do that? I'm still a novice when it comes to many aspects of mysql. [EMAIL PROTECTED] wrote: Hi, Try to enable query log. Thanks & Regards Dilipkumar [EMAIL PROTECTED]: Hey there, I inherited a couple of servers that are in production but I noticed that there\'s not activ

my.cnf / mysqld logging

2006-06-16 Thread Tom Ray [Lists]
Hey there, I inherited a couple of servers that are in production but I noticed that there's not active logging for mysql on any of them. I looked and they don't have an active my.cnf file any where on the machines. One machine is running mysql 4.1.5 and the other is running mysql 5.0.18 When

Re: denormalization/E-T-L help

2005-03-24 Thread Mathew Ray
is increasing quite drastically as I pile on more variable comparisons... I am guessing because I am increasing that number of comparisons that must be done... Thanks, Mathew [EMAIL PROTECTED] wrote: Mathew Ray <[EMAIL PROTECTED]> wrote on 03/24/2005 10:42:51 AM: Been searching for a while a

denormalization/E-T-L help

2005-03-24 Thread Mathew Ray
Been searching for a while and can't seem to come up with any good answers to this - I have a normalized structure of about 5 tables that I need to denormalize into one big representation of the entire structure. Anyone know of a good tool or resource to 'flatten' my tables easily? I've got a

Re: select where multiple joined records match

2005-02-17 Thread Mathew Ray
I am guessing the long duration is caused by having to do complete table scans. How big is your dataset? What about creating another index in resource_goals that includes GoalNumber and ResourceID? Perhaps even Subject, Grade, and NumericGrade As I learned just a couple days ago, making sur

Re: mysql heartbeat

2005-02-17 Thread Mathew Ray
is zabbix (http://www.zabbix.com), its very easy to setup and personally I think its excellent. It may be overkill if you just want to check a db is up though -Original Message- From: Mathew Ray [mailto:[EMAIL PROTECTED] Sent: Thursday, 17 February 2005 2:35 AM To: mysql

Re: mysql heartbeat

2005-02-16 Thread Mathew Ray
though... ~mathew Michael Dykman wrote: On Wed, 2005-02-16 at 10:35, Mathew Ray wrote: Has anyone used or built a db monitoring tool for MySQL? I have come across various system-level heartbeat tools, but I am specifically looking for a solution that will work on Win2K Server and RedHat boxes

mysql heartbeat

2005-02-16 Thread Mathew Ray
Has anyone used or built a db monitoring tool for MySQL? I have come across various system-level heartbeat tools, but I am specifically looking for a solution that will work on Win2K Server and RedHat boxes, as we have several servers that each run different instances of mysql. No replication o

Re: join speed vs. 2 queries

2005-02-15 Thread Mathew Ray
M data INNER JOIN names ON data.name_id=names.id INNER JOIN values ON data.value_id=values.id WHERE data.campaign_id = 22 AND names.name = 'content' AND values.value = 'index' PB - Mathew Ray wrote: Newbie on the list here having a bit of confusion at the moment

join speed vs. 2 queries

2005-02-14 Thread Mathew Ray
e to be done with similar speed without having to use a temp table... Is there any way to optimize the performance of the join query without having to go with the two-query option? -- Thanks, Mathew ...... Mathew J. Ray Sr. Interactive Developer IQ Television Group

Re: GUID storage

2004-06-28 Thread Ray Kiddy
number, usable as a UUID, would be better. - ray On May 12, 2004, at 3:07 PM, Jeremy Zawodny wrote: On Wed, May 12, 2004 at 02:50:55PM -0700, Larry Lowry wrote: Well I'm trying to move to MySQL from the MS SQL Server world. Most data elements are easy except for the uniqueidentifier. In the

LOAD DATA from memory?

2004-05-08 Thread ray spence
. My environment: MySQL 4.0.18 perl 5.6 FreeBSD 5.1 Thanks for any help, Ray Spence __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover -- MySQL General Mailing List

no create/update time for InnoDB from SHOW TABLE STATUS?

2004-03-18 Thread Ray Kiddy
ot;Update_time" data is NULL. Any reason? thanx - ray -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ORDER BY RAND() performance

2004-03-08 Thread Ray
On Monday 08 March 2004 14:14, Neil Gunton wrote: > [EMAIL PROTECTED] wrote: > > If your infact (sounds like) storing the pictures meta-data > > (name, size, owner, etc) and the data (blob of some kind) .. I > > would definately break up the design into 2 tables. That way > > when dealing with the

Re: PgSQL vs MySQL

2004-03-03 Thread Ray
from the manual it appears that "char(0) null default null" can be used as a boolean, will the values of either null or "". haven't tried it myself, but its documented. http://www.mysql.com/documentation/mysql/bychapter/manual_Column_types.html#Column_types [NATIONAL] CHAR(M) [BINARY | ASCII |

Mac: Trouble linking library

2004-02-15 Thread Marty Ray
ton and picking different types such as "compiled" and "archive", but I still get errors. Anybody have any suggestions?" Thanks. Marty Ray -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Another beginner question

2004-02-12 Thread Marty Ray
Brace yourself for another beginner question... When I try to use the SHOW command (logged in as root) , I get an error: mysql> show databases; ERROR: No query specified Any suggestions? Thanks! Marty Ray -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Trouble starting mysql 4.1.1 on Mac

2004-02-12 Thread Marty Ray
appreciate that! Regards and thanks to all, Marty Ray On Feb 12, 2004, at 4:43 PM, j.e.b. wrote: Marty Ray This should help you out - http://www.entropy.ch/software/macosx/mysql/ I just downloaded and installed mysql 4.1.1 on a Macintosh G5, but I cannot get it to start up. I first tried manu

Re: Trouble starting mysql 4.1.1 on Mac

2004-02-12 Thread Marty Ray
line 274: 397 Broken pipe cat $fill_help_tables Installation of grant tables failed! I'm sure all this is boring and routine for all of you, but unix is still mostly Greek to me, although I am learning! Thanks Again, Marty Ray On Feb 12, 2004, at 5:37 PM, J.R. Bullington wrote:

Re: Trouble starting mysql 4.1.1 on Mac

2004-02-12 Thread Marty Ray
n key constraint system tables created 040212 15:54:39 InnoDB: Started; log sequence number 0 0 040212 15:54:39 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040212 15:54:39 mysqld ended Hmmm... Marty Ray On Feb 12, 2004, at 4:56 PM, Michael Stasse

Re: Trouble starting mysql 4.1.1 on Mac

2004-02-12 Thread Marty Ray
uter:/usr/local/mysql martyray$ --- Hope I didn't screw up too bad... 8) Thanks for your help. Marty Ray On Feb 12, 2004, at 4:35 PM, Brent Baisley wrote: I assume when you tried to start MySQL from the command line you used saf

Trouble starting mysql 4.1.1 on Mac

2004-02-12 Thread Marty Ray
: "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" I then tried installing the automatic startup routine, restarted the computer and running mysql and I get the same message. Any suggestions? Thanks! Marty Ray -- MySQL Gene

Macintosh: Trouble with grant tables?

2004-02-07 Thread Marty Ray
gure out what else to do. Any suggestions? (take it easy on me, I'm fairly new to Unix) Thanks! Marty Ray -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Bug in WinMySQLadmin 1.4

2003-12-09 Thread Ray Ragan
My SQL Team, When launching WinMySQLadmin 1.4 on multi-displayed systems, the admin application launches center between both displays, not display 1, as it should. Thanks, Ray -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Check for data before inserting

2003-10-16 Thread Ray
actually it will act like insert in eather case. if its there, delete it first, if not just insert. http://www.mysql.com/doc/en/REPLACE.html as far as using shell to do the insert/update, you could look at command line php, that way you get the logic and you don't have to learn a new language

Re: some connector/j tests fail

2003-09-27 Thread Ray Tayek
At 07:31 PM 9/27/03 -0500, Mark Matthews wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ray Tayek wrote: > hi, just donwloaded mysql and connector/j. the driver seems to work fine > for simple stuff. but i can not get all of the tests to run ... I actually get all of the tests to r

some connector/j tests fail

2003-09-26 Thread Ray Tayek
PROTECTED]:/usr/src/mysql-connector-java-3.0.8-stable$ Script done on Fri Sep 26 20:46:01 2003 --- ray tayek http://tayek.com/ actively seeking mentoring or telecommuting work vice chair orange county java users group http://www.ocjug.org/ hate spam? http://samspade.org/ssw/ -- MySQL General Mailing

Re: Problem compiling a small C program on Redhat-7.3

2003-09-25 Thread Ray Tayek
e the mysql.h and other .h files are in this directory. i am not familiar with red had rpm, but he or someone may not have put the right include files in the right place or may have left some old ones hanging around . hth --- ray tayek http://tayek.com/ actively seeking mentoring or telecommuting

Re: newbie gets access denied/invalid authorization (answered)

2003-09-22 Thread Ray Tayek
At 06:04 PM 9/21/03 -0700, Ray Tayek wrote: hi, trying out opnecms. so i installed mysql on slak 8.0. added a root password (something like ... root password opencms) like the doc says, so i can do a: use mysql and create databases and tables if am root on the slak box. but only if i am root

newbie gets access denied/invalid authorization

2003-09-21 Thread Ray Tayek
opencms up, but i need to get mysql up in a usable state. i do not care about security at this point. does anyone have any clues about how to fix this? or should i reinstall and not supply a root password? any pointers would be appreciated. thanks --- ray tayek http://tayek.com/ actively seeki

Re: mysql_info not very informative?

2003-08-03 Thread Ray Kiddy
p the information to itself? - ray On Saturday, August 2, 2003, at 5:24AM, Adam Fortuno wrote: Actually, MySQL doesn't normally give overrun cut-off information (best I know). Use MySQL 4.0.x on 10.2.6, and MySQL has always performed that way. Regards, A$ On Friday, August 1, 2003, at 05:37 PM,

mysql_info not very informative?

2003-08-01 Thread Ray Kiddy
| GGG | HHH| III | +-+---++---+ 3 rows in set (0.00 sec) So, why is mysql_info not giving me any information about the data loss that is going on here? Is that not information that might be of interest? Is there some other call I have to make that will "prepare&

RE: Could someone please help in choosing a manual...

2003-07-22 Thread Ray Thompson
O'Reilly's "Managing & Using MySQL" is a good intro. -- Ray Thompson > > > > As a true novice starting out, can someone tell me which of the two > > would be best suited for a true newbie > > -- MySQL General Mailing List For list archi

RE: Newbie question -- PHP document

2003-07-21 Thread Ray Thompson
( Apache 2 is the web > > server the file > > is in the htdocs folder. ) But when I try to run any > command I get no > > results. > > -- Ray Thompson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: doskey feature in mysql !!

2003-07-21 Thread Ray Thompson
Hmmm. Do F1 or F3 produce the last command given? -- Ray Thompson > > > >I remember in WIN NT 4 if we type cmd at the run prompt, then > >command prompt use to come up > >and we can repeat the commands i.e. doskey feature is available. > > -- MySQL General Mailin

auto_incement foobar

2003-07-11 Thread Ray
have a table CREATE TABLE `pics2003` ( `ID` int(11) NOT NULL auto_increment, `Title` varchar(255) NOT NULL default '', `ShortDesc` text, `LongDesc` text, `Image` varchar(255) default NULL, PRIMARY KEY (`ID`) ) TYPE=MyISAM; and after a while someone wanted something that would always be

Re: ORDER BY with Date Format

2003-07-11 Thread Ray
probably one of the many replys you'll get on this, but ORDER BY month(start_date) assuming the column that has the date is start_date On Thursday 10 July 2003 14:51, Mike At Spy wrote: > I am trying to create an order by in a select statement that takes a > standard 'date' column in a table an

User Variables on Startup

2003-06-30 Thread Ray Elenteny
t I'd give the list a try to see if could get some input on this. We are currently running version 4.0.7 in production. Thanks, Ray Elenteny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: wierd sort query, how do you do it? (sort by ip proximity guess)

2003-06-20 Thread Ray
select 8 ^ 5; ERROR 1064: You have an error in your SQL syntax near '^ 5' at line 1 i'm guessing that this means mysql 3.23 doesn't have the xor. On Thursday 19 June 2003 11:52, Nicholas Elliott wrote: > Remember that this is a binary XOR, not a logical XOR. Mysql does have a > binary XOR operat

Re: wierd sort query, how do you do it? (sort by ip proximity guess)

2003-06-19 Thread Ray
^ ipAddress2 > > (order does not matter) where they are both integers (mysql will use 64bit > integer arithmetic). > > You just need to ORDER BY this value. > > > > > > Regards > > > Matthew > > > -Original Message- > From: Ray [mail

Re: wierd sort query, how do you do it? (sort by ip proximity guess)

2003-06-19 Thread Ray
ill use 64bit > integer arithmetic). > > You just need to ORDER BY this value. > > > > > > Regards > > > Matthew > > > -Original Message- > From: Ray [mailto:[EMAIL PROTECTED] > Sent: 19 June 2003 15:33 > To: [EMAIL PROTECTED] >

wierd sort query, how do you do it? (sort by ip proximity guess)

2003-06-19 Thread Ray
currently i have a table with an ip coloumn in text 123.45.67.89 though it shouldn't be a big deal to convert it to binary, but was wondering if there is an easy way to sort by closeness to a given ip address? ie records that come out sorted as same class sub-c same class c same class c same cla

Reply-All (RE: mySQL GUIs)

2003-06-12 Thread Ray Thompson
I've noticed that some messages from the list have a reply-to of just [EMAIL PROTECTED] and others have both the MySQL list and the address of the sender. When I hit reply-all on this message three addresses are in the To field. Nils, Jim, and the list. Delete the redundant ones... -- Ra

Re: mysql under unix in batch mode

2003-03-26 Thread Ray
the other thing is make sure you don't have a space after -p and before your password mysql -h localhost -u root -p mysql < did.query > did.out says ask for the password and start in the database mysql mysql -h localhost -u root -pmysql < did.query > did.out says the password is mysql and don't s

DATE function question

2003-03-26 Thread Tom Ray
I have a small question about the DATE function. This is what I want to do: - User enters information into form and submits it to database - When info is added to database the current date is stored ala 2003-03-26 - Now I want to take that date 2003-03-26 and tack on either 15 or 30 days on to it

Re: Autoincrement/last_insert_id race safe?

2003-03-26 Thread Ray
On Wednesday 26 March 2003 08:25, you wrote: > > A programmer just asked me about a possible race condition, > > and I didn't know what to answer: > > > > If I insert a line using autoincrement, then ask for last_insert_id() > > am I guaranteed to get the same ID I just inserted? > > Yes > > > It s

Column comment

2003-03-19 Thread Ruvinskiy, Ray
m the column field. Is there any way this can be accomplished with MySQL 4.0.12? Thanks, Ray - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar

Re: Warning suppression?

2003-03-04 Thread Ray
this is more a php question then mysql, but if you put a @ before the commands that are giving you warnings, it should cause it to not show them @mysql_connect(...) and you might also be looking for the php function error_reporting( [ int level ] ) On Tuesday 04 March 2003 13:55, you wrote: >

Re: Selecting from mySql database regarding dates

2003-03-03 Thread Ray
try 's arround the dates $query = "SELECT * FROM designs, appliquetable, puffyfoamtable WHERE designs.puffyfoam = puffyfoamtable.puffyfoam AND designs.applique = appliquetable.applique AND >(designs.designadddate <= '$today' AND > designs.designa

Little help please

2003-02-27 Thread Tom Ray
I'm looking for a webbased interface that will allow me to managae mysql databases. However, phpmyadmin has been ruled out due to the fact it requires the username and password to be stored in the config file and that it doesn't have any security to protect the average joe from stumbling across it.

Re: Column Type help

2003-02-26 Thread Tom Ray
considerations would kick in for anything > beyond TEXT (max 65535). > > So I'd probably go with the LONGTEXT, too. > > HTH, > Tore. > > - Original Message - > From: "Tom Ray" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: W

Column Type help

2003-02-26 Thread Tom Ray
Hey there, I'm kinda new to using mysql to its full potential and I was wondering something. I want to store resume information, but I just want the user to cut and paste the resume in the "Resume" field and then store all that in one column in the table. Which table type should I use for this? Lo

additions to mysqlimport?

2003-02-23 Thread Ray Kiddy
appen, as -n does for make. --lines-commented-out-by=... : pretty obvious --terminate-on= : deleted, skipped, or warning, for example, if you want to stop if there is even one warning. Any other ideas? I am thinking of trying to extend it myself and am open to suggestions. thanx

Re: insert after delete is not atomic

2003-02-07 Thread Ray
> You are inserting 6 values into 7 fields, so it fails. looks like a 6 field table to me create table if not exists MSFT (date DATE not null, close DECIMAL(10,2), high DECIMAL(10,2), low DECIMAL(10,2), volume MEDIUMINT, yest DECIMAL(10,2), PRIMARY KEY date (date)); 1) date 2) close 3) high 4) l

mysqldump, exclude table?

2003-01-29 Thread Ray
is they a way to have mysqldump ignore a list of tables, but get everything else? something like: mysqldump -ume -psecret -hserver --all-databases --exclude-tables=server.acctlog mysql 3.23.49-8.2 debian -- mysql, sql, query, sql, sql, sql --

datetime field question

2003-01-29 Thread Ray
is there a way to use the date part of a datetime field that still uses the index on the datetime field? i've tried a few different things and it keeps saying in the explain it says that its a possible_key, but NULL for the key -- mysql, sql, query, sql, sql, sql --

can someone help me optimize this?

2003-01-29 Thread Ray
i have a select that seem to be taking too long for what it is, and after looking over the documents i can't seem to find a better way. probably some things that would help: -on a datetime field, is there a way to look at everything from a month that still uses the index. -is there a way to caus

Re: simple problem, no tcp port openning - Solved

2003-01-28 Thread Ray
after digging around more, i found Debian's MySQL has 'skip-networking' in the /etc/mysql/my.cnf further down On Monday 27 January 2003 17:08, you wrote: > installed mysql onto debian using a deb file. it is running locally fine, > but it isn't openning a TCP port for remote connections to it. >

simple problem, no tcp port openning

2003-01-27 Thread Ray
-- this is a resend, its been over an hour, and the 1st hasn't shown up on the list yet. i'm assuming my mail server dropped it -- installed mysql onto debian using a deb file. it is running locally fine, but it isn't openning a TCP port for remote connections to it. >a few lines from /etc/mysq

simple problem, no tcp port openning

2003-01-27 Thread Ray
installed mysql onto debian using a deb file. it is running locally fine, but it isn't openning a TCP port for remote connections to it. >a few lines from /etc/mysql/my.cnf [mysqld] user= mysql pid-file= /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock

Re: MySQL 4.0.7 is released

2002-12-29 Thread Ray Kiddy
include the release which you are announcing? For example, since http://www.mysql.com/downloads/ does not point to the 4.0.7 version, which page does? thanx - ray On Friday, December 27, 2002, at 12:10 PM, Lenz Grimmer wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 4.0.7,

read-only... even after myisamchk -ru

2002-12-22 Thread Ray Kiddy
can backup and re-create the table, but that seems unnecessary, if the documentation on myisamchk is correct.... thanx - ray - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://

backing up

2002-12-10 Thread Ray
is there a way to remotely grab the databases (ie mysqldump) and have it place everything in a different file for every database? or has anyone written a script to do something like this? dbserver having databases mysql, db1, db2 and creating backup files mysql.sql db1.sql db2.sql and at differ

Re: take one database offline

2002-12-05 Thread Ray
another trick that might work is just to deny access to everyone to the database. if no one has access to it, then its as good as gone. i don't know if MySQL would allow just grant blah on *.* to user; revoke all on disabled_db.* from user; and alot of it depends on how the security is setup a

tools for characterizing performance?

2002-11-29 Thread Ray Kiddy
to defend the current approach? thanx - ray - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTEC

Re: Difference between 4.0.5 and 4.0.5a

2002-11-27 Thread Ray Elenteny
.0.5 and 4.0.5a. > > Regards, > Jocelyn > > > - Original Message - > From: "Ray Elenteny" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, November 27, 2002 2:47 PM > Subject: Difference between 4.0.5 and 4.0.5a > > &

Difference between 4.0.5 and 4.0.5a

2002-11-27 Thread Ray Elenteny
Hi, I've been trying to determine the difference between MySQL 4.0.5 and 4.0.5a. I can't seem to find any documentation relating to the change. Can someone point me to the documentation or tell me what has changed? T

Re: LIMIT in MySQL

2002-11-26 Thread Ray
its not LIMIT from, to, its LIMIT start, count SELECT * FROM table ORDER BY somefield LIMIT 30,30 On Tuesday 26 November 2002 11:56, you wrote: > I must not be awake yet. Why is this query sending me back 60 records? > Shouldn't it only send back records 30 through 60 (i.e. 30 records)? > > SELE

Re: SELECT Statement Question

2002-11-20 Thread Ray
> When I run SELECT * FROM POSTCODE; in mysql prompt I get garbled display of > data and some of my data is not shown. the garbled display is probably due to the results being wider then the screen/terminal, and since the mysql client doesn't implement a horizontal scrollbar like a gui/web mysql

Re: Time comparisons

2002-11-14 Thread Ray
your probably looking for curtime() CURTIME() CURRENT_TIME Returns the current time as a value in 'HH:MM:SS' or HHMMSS format, depending on whether the function is used in a string or numeric context: mysql> select CURTIME(); -> '23:50:26' mysql> select

Load (messy) data file

2002-11-08 Thread Ray
is there a way to have mysql skip columns from the data file when loading the data? i am getting a text delimited data file from an outside source that is updated daily. however the data is defined as having 10 blank fields in it, and in the first 9000 records 7 more fields are just not used,

Q about replication & timing

2002-11-04 Thread Ray Zimmerman
pdate. Or to put it negatively, it must be impossible for a client to update the master and subsequently read an old (pre-update) value from the slave. Am I correct in assuming that replication can not make this guarantee? -- Ray Zimmerman / e-mail: [EMAIL PROTECTED] / 428-B Phillips Hall

mysqladmin question

2002-10-30 Thread Tom Ray
I just got a Red Hat 7.3 box up and running and have mysql on it...I've noticed that when using mysqladmin it doesn't prompt me for a password like other boxes that I've been on(ones I didn't build) have...is there a way to set this? TIA ---

why so late with Mac OS X versions?

2002-10-20 Thread Ray Kiddy
. Is it a technical, resource or a personnel problem? thanx - ray - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

[Bug] compile problem on Mac OS X 10.2

2002-09-06 Thread Ray Kiddy
oila! Note, this is for Mac OS X 10.2, and not earlier Mac OS X systems. thanx - ray - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) T

Re: Won't compile on Mac OS X 10.2

2002-08-25 Thread Ray Kiddy
installing, can pick the ball up and move it along... thanx - ray On Sunday, August 25, 2002, at 05:39 PM, Mitch Leung wrote: > Dear Sir, > > MySQL 3.23.52 won't compile on Mac OS X 10.2 based on Darwin 6.0 which > comes pre-installed with gcc 3.1 > > I don't want to u

New to mySQL

2002-08-25 Thread Ray Healy \(Data Net Services\)
with another booking. I am not sure whether I should be in list list of the PHP list so sorry if I have got it wrong. Any advice or places to visit would be greatly appreciated. Thanks for all your help Ray Details of what i have done already: mysql> use matrix Database changed mysq

To share with MySql friends in net?

2002-08-21 Thread Ray da Costa
Oi, for gentility! Could inform which the procedure to share the MySql that is in my machine with the escritorio friends. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysq

Mysql database of Net

2002-08-16 Thread Ray da Costa
. Ass.: RaydaCosta -Mensagem original- De: Ray da Costa Enviada em: Sexta-feira, 16 de Agosto de 2002 09:18 Para: 'Paras pradhan'; [EMAIL PROTECTED] Assunto: RES: Mysql database permissions questions Expensive colleagues, all good! I am here in the Brazil! I need an aid to h

RES: Mysql database permissions questions

2002-08-16 Thread Ray da Costa
Expensive colleagues, all good! I am here in the Brazil! I need an aid to have access the MySql saw net local! Or either, I have the MySql in a machine and want to share the bank with my fellow workers, Has that to be he saw MyOdbc? Command of line? I am making in Java and using the JDBC.

problem creating table with default date

2002-08-04 Thread Eric Ray
); This second option is not really what I want. I want the let the database create the current date when I insert a row. Is this possible and if so, how can it be done? Thanks. Eric Ray [EMAIL PROTECTED] - Before

  1   2   >