Range of timestamp(14)

I can not seem to select a range of timestamp(14) data, something like Select * from foo where added is in the range of 01/01/2004 to 01/25/2004 -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com

Re: Merging of 2 selects

on 07/01/2004 05:43 PM, Scott Haneda at [EMAIL PROTECTED] wrote: I am not entirely sure what I am after is possible, if someone could help me I sure would appreciate it. Mysql 4.0.18-standard I have 2 basic selects I am doing: SELECT id, image_title, 'images' FROM newsletter_images

Merging of 2 selects

] ] -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http

Cant grant lock to root

. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Duplicate selection with change

. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Duplicate selection with change

on 06/27/2004 11:31 PM, Scott Haneda at [EMAIL PROTECTED] wrote: So, I need to basically: SELECT iamge_title, image_filename, image_url, image_width, image_height from images where user_id = '123'; Then, take that result and insert all those rows in the same table, setting type='2

Re: question on auto increment field

you reach that limit and try to insert a record, a error would be generated, no new records would be able to be inserted until this was resolved. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com

Re: AUTO_INCREMENT problem... ER_DUP_ENTRY? (No, it's not a one byte index :)

lot faster than the alter. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General

Re: Duplicate does not exist

to answer your question. Print out the error message, it will tell you the key, then lookup that key and compare, I would bet they are the same. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com

Re: Mysql Scenario

and replication to achieve what you are after. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A

Defaul of NOW()

()'; Query OK, 2 rows affected (0.01 sec) Records: 2 Duplicates: 0 Warnings: 0 It tells me it worked, but then it reverts back to the zero's. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com

Determine table type and comments

I can not find this in the docs. I can see in phpmyadmin what a table comment is and what type of table it is, such as MyISAM etc. From the mysql shell, how do I get to this info? -- - Scott HanedaTel

Repeat loops in mysql, large data issue, suggestions wanted

on one line. In order to check for this I am back to repeating through each line server side and testing the line for integrity. Any ideas and thoughts? MySql 4 -- - Scott HanedaTel: 415.898.2602 http

Re: Repeat loops in mysql, large data issue, suggestions wanted

- it should work on the format of the file as you specified below. Can import data be used on MySql if the data is not on the same machine as MySql? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com

Re: Repeat loops in mysql, large data issue, suggestions wanted

to? Perhaps someone can show me a example ala php on this one? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato

Re: Please help me optimize a MySQL server.

to: someuser on every page. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General

Re: basic mysql setup

config file and create what they call a control user with control username and password. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED

Re: basic mysql setup

in general. and what the h*^* are you doing up at this time of night!! Its only 1 :-) -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED

Database design.. Asking again

and suggestions on this? If anyone thinks I should just allow one table to store all this, with that table having 70 million records in it, then I can of course go that road as well. -- - Scott HanedaTel

Database design.. Asking again

. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Database design

and suggestions on this? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List

Database design

and suggestions on this? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List

Re: how to uninstall mysql 4.0.18 from OS X...i am so stuck :(

...but at the moment i've hit a brick wall. please tell me how to uninstall it. shell sudo rm -r /usr/local/mysql shell sudo rm -r /Library/StartupItems/MySQL -- - Scott HanedaTel: 415.898.2602 http

Re: how to uninstall mysql 4.0.18 from OS X...i am so stuck :(

a ls -la /usr/local/mysql If that shows you nothing, then it is removed. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED

OS X 10.3 install step by step

point others to this link http://newgeo.com/mysql/ -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A

Re: Mac Installation

, when I check the /tmp folder I see that there is no file by that name 'mysql.sock'. Has anyone faced a similar problem? Look in your mysql directory for a .err file, what does it say in there? -- - Scott Haneda

Killing overactive mysql selects

altogether and I have to log back in again. Also, sometimes I am able to use the tab key to auto-complete field and table names, this is really handy, sometimes it works and sometimes not, how do I get this all the time? -- - Scott Haneda

Re: Load data infile or import

if everyone looked in the manual. Mellow out. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A

Tricky date formatting issue

based on the tmp_date as the input. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL

Importing data to existing system

|| +--+---+--+-+-++ -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A

Importing data to existing system

|| +--+---+--+-+-++ -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A

Load data infile or import

that in? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Getting around 2 queries

queries and do this as one? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General

Unique from this point forward

. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Limiting the data returned to just what I need

numbers for a list of users. If the query returns 20 serial numbers, I am going to get back 19 name, address, state, zip etc rows that I don't need, I can easily discard them, but this seems less than efficient. -- - Scott Haneda

Re: just the list please!

a rule in your email application to nuke the messages that you do not want. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED

OS X 10.3.3 and byte ordering update

data on this, or is it safe to update to 10.3.3 on a OS X client machine? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED

A join I can not wrap my head around...

, cant seem to get this one. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL

Jumping to prev and next records

the next id and prev id in a mysql query based on id being sorted? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED

Aliases and bookmarks

There are some things I do in mysql often, is there some way to alias or otherwise bookmark a a sql statement for simple rapid use in the future? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com

List of fields

describe table; almost does what I need, how would I get a nice clean unformed list back, perhaps \r\n separated. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax

Re: Uninstall MySQL for Panther?

it. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com

Mysql timed actions... Confused

, 77556 bytes1 seconds 2004/03/09 14:35:00OK, 77556 bytes2 seconds 2004/03/09 14:40:00OK, 77556 bytes2 seconds 2004/03/09 14:45:00OK, 77556 bytes1 seconds -- - Scott HanedaTel

Why would this statement slow down over time

, 9005, 9010) AND t.topic_poster = u.user_id AND f.forum_id = t.forum_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id -- - Scott HanedaTel

Can my.cnf actually lessen performance?

? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list

Doing a LIKE search on a ENCODE type

? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com

My.cnf and other start options I do not get

? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http

My.cnf and other start options I do not get

? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http

Can my.cnf actually lessen performance?

? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list

Doing a LIKE search on a ENCODE type

? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com

Limit connections from same host

How can I limit the connections from the same host in mysql. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED

Update from 3 to 4 and some privs don't make sense

user able to LOCK tables, these are global so I assume all databases are able to be locked by all users. Whats the best way to udpate all these back to the USAGE they were at before. -- - Scott HanedaTel

Remove Russ Myrick ceadawg@cox.net

Can someone remove this guy and his challenge response system. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED

Re: Limit connections from same host

on 02/28/2004 07:08 PM, Paul DuBois at [EMAIL PROTECTED] wrote: At 17:22 -0800 2/28/04, Scott Haneda wrote: How can I limit the connections from the same host in mysql. You can put a limit on the number of connections per hour from a given account (WITH MAX_CONNECTIONS_PER_HOUR

Re: A question about mysql database backup.

fields, blob fields etc? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General

Re: My backup scripts and how reliable are they?

on 02/27/2004 09:53 AM, Adam Hardy at [EMAIL PROTECTED] wrote: On 02/26/2004 09:02 AM Scott Haneda wrote: As per the reco of someone on this list, I created a bash script that runs once a day to do the following: # set path to final destination location=/Volumes/foo/sql_dumps/ # set

My backup scripts and how reliable are they?

is of the type password, phpmyadmin outputs it as 0x6ad6600d88afb42e5bef276c039330cc and my script above yields something like this (×-‰€ì ¶3…?$¡ How do I made sure I have a fully restorable backup? -- - Scott Haneda

My backup scripts and how reliable are they?

is of the type password, phpmyadmin outputs it as 0x6ad6600d88afb42e5bef276c039330cc and my script above yields something like this (?-ì ¶3?$¡ How do I made sure I have a fully restorable backup? -- - Scott Haneda

Re: Where is my typo?

on 02/18/2004 02:43 AM, Steenveld, A. at [EMAIL PROTECTED] wrote: mysql GRAND ALL ON *.* TO [EMAIL PROTECTED]; I think you mean GRANT - notice the 'T' not 'D' ? -- - Scott HanedaTel: 415.898.2602 http

Random and string splitting

(data, \r)) from something; -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General

Load data infile

they are in. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

iterating through a month

it to that month and year. Basically, I am trying to provide a month at a glance report of total posts by various users to a table. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax

Re: Bash script to MySql

into this. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Bash script to MySql

? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Monthly reporting

a count() in SQL for each day of the month. It is this ~30 days in script I bet I can get rid of, any suggestions how to do this in MySql in one go and get a report of a month at a glance... -- - Scott HanedaTel

Re: Bash script to MySql

this ? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

My.cnf

I have copied my-large.cnf to /etc/my.conf Mysql 4 on OS X server How can I tell these new settings are in effect? What settings were run prior to this file being in place as there was no my.cnf? -- - Scott Haneda

Multiple values in the host field

. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

New install, hostname and other lookup isues

are the ramifications of not running /usr/local/mysql/bin/mysqladmin -u root -h `hostname` password password Thanks. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax

Re: Select older than minutes

on 01/28/2004 12:03 AM, Duncan Hill at [EMAIL PROTECTED] wrote: On Wednesday 28 January 2004 06:00, Scott Haneda wrote: I have done this so many times.. SELECT * FROM `support_start` WHERE TO_DAYS(NOW()) - TO_DAYS(date) 7 I have scoured (more like glanced :-)) at the docs on http

Select older than minutes

I have done this so many times.. SELECT * FROM `support_start` WHERE TO_DAYS(NOW()) - TO_DAYS(date) 7 I have scoured (more like glanced :-)) at the docs on http://www.mysql.com/doc/en/Date_and_time_functions.html and can not seem to find how to get all records where a timestamp(14) is older than

New grant tables

? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http

Re: Subtracting date fields

/Date_and_time_functions.html for the DATEDIFF() function. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA

Order by a number not leading in zero

in it as varchar() where there are some without a leading zero. Rsults end up like 10U 11U 12U 5U 6U 7U I would like to order those as 5U 6U 7U 10U 11U 12U Thanks for the help. -- - Scott HanedaTel: 415.898.2602

Selecting on timestamp(14)

= -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Selecting on timestamp(14)

it is INSERT, I dont know - try. I hope this is not the case, I have been update table set updated = NOW() for most all my datbases, seems to insert a 14 character timestamp reliably. -- - Scott HanedaTel

Sort order

it to 9 to force those records to the end? I could not seem to alter the field to get it to change them all to null, so I was unable to test if null is sorted first or last, or ignored altogether. thanks -- - Scott Haneda

Categorizing records

with this. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Sort order

NULL to be input on new record creation. I don't really want to do this. Is there any way to have a ASC sort order that sends 0 to the end, and sorts on 1-9? I know a strange request, but this would be simplest in my case. -- - Scott

Re: Sort order

limit 5' at line 1 Any ideas? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General

Mysql list admin

PROTECTED]; Sun, 14 Sep 2003 18:35:28 -0700 Message-id: [EMAIL PROTECTED] Date: Sun, 14 Sep 2003 21:37:21 + Subject: NDN: Re: Sort order X-FC-Icon-ID: 2031 X-FC-MachineGenerated: true To: Scott Haneda [EMAIL PROTECTED] From: [EMAIL PROTECTED] MIME-Version: 1.0 Content-type: text/plain; charset=ISO

Cleaning up a messy mysql

these out and then optionally clean it all up? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A

Getting data from multiple databases

. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http

How to tell

in my.conf, where are they coming from? What commands do I look to issue to be able to see if I should give more memory to mysql, and how would I do this. -- - Scott HanedaTel: 415.898.2602 http

Re: How to tell

on 8/26/03 1:40 AM, Roger Baklund at [EMAIL PROTECTED] wrote: * Scott Haneda I have mysql 3.23.51-entropy.ch I have never used a my.conf file other than to tell it one thing which is datadir=/usr/local/mysql/data I have a gig of memory and only apache runs on this machine. It is OS X

Re: How to tell

on 8/26/03 2:05 AM, Roger Baklund at [EMAIL PROTECTED] wrote: * Scott Haneda [...] * Roger Baklund For information on the options files: URL: http://www.mysql.com/doc/en/Option_files.html [...] Where do all my defaults come from if my.cnf only has datadir=/usr/local/mysql/data

Why does the oracle listen on this list

] Subject: The Oracle is ignoring you! To: Scott Haneda [EMAIL PROTECTED] X-Face: )/f9dPk\!g-'b`Sn!jD[[Y(T^=/)v/CG-fO%mE+$oq#6H1kAX/dU$1Z!U(/?A [EMAIL PROTECTED]f)H6,2OKd.T#S7b*{feRg*p/sQ)#~7tLC*8$G}W0Ve$eZ; Wig5LM9ec;[EMAIL PROTECTED]f.Kns23^P9.Ak{GdWWv]0*1E}RJ)_idU:(5VkN*_+bB kyrnLfC12BV

Telemobile auto-reply

); 26 Aug 2003 09:43:33 - Message-ID: [EMAIL PROTECTED] From: Telemobile Inc. [EMAIL PROTECTED] To: Scott Haneda [EMAIL PROTECTED] Date: 26 Aug 2003 05:43:33 EDT Precedence: junk Subject: Re: Re: How to tell Reply-To: Autoresponder [EMAIL PROTECTED] X-Loop: [EMAIL PROTECTED] Telemobile Inc

Seeking advice on best table structure

are appreciated. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list

marking all records based on a text file

(my_return_sep_file) -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list

month by month count

? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

load data

want to skip the id field and let that auto populate with the auto increment value. What is the syntax for this? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax

Just a test

I don¹t seem to be getting any messages, this is just a test, mysql query -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED

Re: upgrading to v 4.1

it. What is the heck is $1 anyway? And why is it a literally quoted value? - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED

mysql_fix_privilege_tables behaves odd, explain this

is it a literally quoted value? - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General

Select name, email where birthday = ??

this? - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A. -- MySQL General Mailing List For list

Re: More OS X install fun

privileges does this indicate a fatal install error? Is there a way to roll this file by hand? Thanks Seriously puzzled newbie Any particular reason you are using max? Just use the normal version it runs fine. - Scott Haneda

Deleting a large group of numbered records

old_id = one of the above numbers and then repeat on, is there a easy way to construct this statement, perhaps reading the data from a infile. Mysql - Scott HanedaTel: 415.898.2602 http://www.newgeo.com

Output data to file

I want to send the results of Select name, email from messages To a plain text file, how can I do this? Once I am in the mysql prompt, I can not issue normal shell commands, thanks - Scott HanedaTel

Off topic help, SSL and form posts

, thanks. Robotic foo Mysql query - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED]Novato, CA U.S.A

<    1   2   3   4   >