Re: Problem renaming table

* Egor Egorov [EMAIL PROTECTED] [030814 03:49]: Tim Johnson [EMAIL PROTECTED] wrote: I would like to rename a table if it exists. The following query IF EXISTS ALTER TABLE gwcc_members RENAME gwcc_members_bak; fails. also ALTER TABLE IF EXISTS gwcc_members RENAME

column default value

Hello: I'm using version 3.23.41. How may I change the default value of an existing table? (type will remain the same) Pointers to docs are welcome and invited. thanks tim -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http

Programmatically building table

that is sufficient for under a thousand records, but next I must rebuild a table of 50-60 thousand records and more with 70 fields or more. I would welcome any helpful hints as to optimise this, as well as pointers to docs or even thoughts on a different solution. TIA and best regards -- Tim Johnson [EMAIL

INTO LOCAL OUTFILE?

(or any other strategy). I've tried using the --tab option but get am getting Errcode: 13 TIA -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com - Before

Re: INTO LOCAL OUTFILE?

Hi Paul: * Paul DuBois [EMAIL PROTECTED] [030316 09:59]: At 9:14 -0900 3/16/03, Tim Johnson wrote: Hello All: I am using Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) I believe that INTO LOCAL OUTFILE is not implemented, but all the same, I would like to save

import 'decimal' data to int(11)

'whole number'. Any help is appreciated. Pointers to documentation is welcome as well. I hope I've provided enough info here. regards -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com

conditional default value

/A' be substituted. Is this possible to do in MySQL? Documentation? Regards -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com - Before posting, please check: http

[mysql] Counting rows

Hello All: Let's suppose I want to count the rows in set for a match to a value in a column. I don't need to read the selection set, I just need to know the number of matches. What is the quickest, most efficient way to do this in mysql? TIA -- Tim Johnson [EMAIL PROTECTED] http

test mysql mailing list

My email does not seem to be getting through. This is a test to confirm whether this problem with the mysql mailing list has been corrected. -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com

Returning an Auto-Increment Field

Hello All: If I am adding a row to a table that has an auto-increment field, is there a way to query MySQL for the value of that field, once the new row is added? TIA -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com

Re: Returning an Auto-Increment Field/Thanks

information. Notice that you should call mysql_insert_id() immediately after the query that generates the value. - Original Message - From: Tim Johnson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 09, 2002 1:04 AM Subject: Returning an Auto-Increment Field

Relating two tables

above. TIA -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: LOAD DATA INFILE problem

thanks to all. -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Storing results from a Query in an existing Table

the following: LOAD DATA SELECT Country,Varietal,Producer,Vineyard,Year,Size FROM EUR INTO TABLE Wines; and MySQL finds me lacking in imagination ... :-( How may I accomplish this? And where is documentation on this topic? TIA -- Tim Johnson [EMAIL PROTECTED] http://www.alaska

LOAD DATA INFILE problem

ERROR 1045 is about might be helpful this is server version: 3.23.51 TIA -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com - Before posting, please check: http

RE: Oracle .dmp to mySQL

There is a application out there that does this called SQLPorter made by Real Soft Studio (http://www.realsoftstudio.com). It might be worth the $$ if it saves you some time and hassle. It worked for me going from SQL Server 6.5 to MySQL 3.23. Hope this helps, Tim - Original Message -

How best to store queries

of test. Does anyone have any thought on this, including creative alternatives and could anyone recommend a data type appropriate for storage? Regards -- Tim Johnson [EMAIL PROTECTED] Partner: http://www.alaska-internet-solutions.com http://www.johnsons-web.com

How to sort on multiple columns?

appropriate documentation as well. Best Regards -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com - Before posting, please check: http://www.mysql.com/manual.php

Creating a table from a query/How to?

correcting syntax 2)Being pointed to documentation would be greatly appreciated 3)I would also like to find list of mysql ERROR codes TIA Regards -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com

Re: Creating a table from a query/How to?.....

? If so, I'd appreciate help correcting syntax 2)Being pointed to documentation would be greatly appreciated 3)I would also like to find list of mysql ERROR codes TIA Regards -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons

Structure of Mysql Error Messages

for a strategy for parsing MySql error messages. I'm using rebol, which has a good retrieval interface, but not a structured error handling scheme readable for non-programmers. Best regards -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com

Can I create a table name 'INT'?

table name than 'INT' -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

MySQLdb Exception Documentation

-- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Handling Memo Fields from MS-Access?

, as an example) Is there a way that I can use a newline substitute for export that can then be converted back to the original newline when mysql loads the text file? TIA Regards -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http

Re: Handling Memo Fields from MS-Access?/\t\n

Forgive me, I should have searched the archives first. Let me rephrase from what I have seen there: Do I understand that I should have my export routine Subsitute '\n' for newline ? Substitute '\t' for TAB? Thanks Again -tim- * Tim Johnson [EMAIL PROTECTED] [020415 15:13]: Hello All

<    1   2