MySQLdb and DateTime objects

2002-04-26 Thread Nick Arnett
inelegant that MySQLdb converts timestamps into a DateTime object on the way out, but doesn't do the reverse? Thanks in advance. Nick -- [EMAIL PROTECTED] (408) 904-7198 - Before posting, please check: http://www.mysql.com

RE: MySQLdb and DateTime objects

2002-04-26 Thread Nick Arnett
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Nick Arnett [snip] What seemed to be the obvious solution was to use MySQLdb.times.format_TIMESTAMP() or MySQLdb.times.format_DATE()-- but that doesn't work, it returns an error: File C

Re: Unable to get lock on tables for 4.0.1

2002-04-25 Thread Nick Gilliam
Egor Egorov wrote: Nick, Wednesday, April 24, 2002, 10:52:28 PM, you wrote: NG Nick Gilliam wrote: Egor Egorov wrote: NG I have encountered a problem with MySQL 4.0.0 and 4.0.1 in which I am NG unable to bet a lock on a table with any userid except root. NG Here is my environment: NG Sun

Unable to get lock on tables for 4.0.1

2002-04-24 Thread Nick Gilliam
I have encountered a problem with MySQL 4.0.0 and 4.0.1 in which I am unable to bet a lock on a table with any userid except root. Here is my environment: Sun 450 Solaris 2.8 MyISAM tables Any ideas on how this problem could be solved? Thanks, Nick Gilliam

Re: Unable to get lock on tables for 4.0.1

2002-04-24 Thread Nick Gilliam
Egor Egorov wrote: Nick, Wednesday, April 24, 2002, 3:59:26 PM, you wrote: NG I have encountered a problem with MySQL 4.0.0 and 4.0.1 in which I am NG unable to bet a lock on a table with any userid except root. NG Here is my environment: NG Sun 450 NG Solaris 2.8 NG MyISAM tables NG Any

How to speed up mods to large table?

2002-04-21 Thread Nick Arnett
be a much lower-performance system, though (IDE v. SCSI-160). Thanks in advance... And now, to get past the (not-very-smart) spam filter... sql, query. Nick -- [EMAIL PROTECTED] (408) 904-7198 - Before posting, please check

RE: How to speed up mods to large table?

2002-04-21 Thread Nick Arnett
-Original Message- From: Nick Arnett [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 21, 2002 3:39 PM To: [EMAIL PROTECTED] Subject: How to speed up mods to large table? I haven't been able to dig up any specific information about how to get maximum performance when making

Re: mysqldump doesn't write data on subsequent calls (MySql 4.0.1)

2002-04-19 Thread Nick Pasich
On Fri, Apr 19, 2002 at 04:12:35AM -0700, Jeremy Zawodny wrote: On Wed, Apr 10, 2002 at 08:48:01AM -0700, Nick Pasich wrote: [snip] Any subsequent executions do not. This is because of query caching. I can run -- mysql -e reset query cache -- which will enable the next

Re: gunk in mysqldump output

2002-04-15 Thread Nick Pasich
Use option -K or --no-disable-keys with myqldump. Date: Mon, 15 Apr 2002 09:37:43 -0400 To: [EMAIL PROTECTED] From: Bill Marrs [EMAIL PROTECTED] Subject: gunk in mysqldump output In some recent release of MySQL, lines like this: /*!4 ALTER TABLE States DISABLE KEYS */;

SBS and MySQL

2002-04-11 Thread Nick Stuart
as a service and doesn't particularly mess with anywindows settings. Thanks for the help! -Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

PHP Question

2002-04-11 Thread Nick Stuart
! Anyways, has anyone come up against a similar problem and found a way around it? Thanks in advance. -Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

RE:PHP Question

2002-04-11 Thread Nick Stuart
of that, but generating and passing that around could become a hassel, and Iknew there must have been a better way. Thanks again, -Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

mysqldump doesn't write data on subsequent calls (MySql 4.0.1)

2002-04-10 Thread Nick Pasich
. Fix: Submitter-Id: submitter ID Originator:Nick Pasich Organization: MySQL support: email support Synopsis: Problem with mysqldump when using query caching Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.1-alpha (Source

Problem with mysqldump when using query caching

2002-04-10 Thread Nick Pasich
. Fix: Submitter-Id: submitter ID Originator:Nick Pasich Organization: MySQL support: email support Synopsis: Problem with mysqldump when using query caching Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.1-alpha (Source

Re: Problem with mysqldump when using query caching (4.01)

2002-04-10 Thread Nick Pasich
Ken, On Wed, Apr 10, 2002 at 01:24:46PM -0400, Ken Menzel wrote: Hi Nick, I am seeing some rather strange problem here with mysqldump, after trying very hard to reproduce the problem on a test server, I gave up. Do the options make any difference when you run it? Can you send

storing files...

2002-04-09 Thread Nick Stuart
Is there a way to store files in MySQL? Looking to store somthing like a zip file in the databaseand be able to retrieve/download it from something like ASP. Thanks -Nick - Before posting, please check: http

RE: PERL/SQL, again? - Re: Procedures

2002-04-03 Thread Nick Arnett
haven't touched Java much in the last few years, so I don't even know what the state of its relationship with MySQL is. Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Text Field Inserts

2002-04-03 Thread Nick Stuart
out for would be nice as well. Thanks for the help in advance. -Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

RE: Table statistics

2002-04-03 Thread Nick Arnett
for the blasted printf type formatting, whose syntax was driving me batty yesterday until... well, I could go on, but I won't. Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: Database Design Question

2002-03-28 Thread Nick Arnett
will probably win. Nick - 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 PROTECTED] To unsubscribe, e-mail

RE: Database Design Question

2002-03-28 Thread Nick Arnett
don't want to get any further into the various issues around this research here unless it has something to do directly with MySQL. Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: Warnings after LOAD DATA statement

2002-03-24 Thread Nick Arnett
mystified by where the warnings are coming from on my inserts. I need a better file comparison tool... Of course, the alternative way to figure out what's going on is to do individual INSERT statements and look at the actual warnings. See http://www.mysql.com/doc/L/O/LOAD_DATA.html Nick

Full Text Multicolumn search bug

2002-03-24 Thread nick
: Unknown Submitter-Id: Nick Kralevich Originator:Nick Kralevich Organization: Nick Kralevich MySQL support: none Synopsis: Full Text Multicolumn search bug Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.1-alpha (Official

Extra return in last field in LOAD DATA INFILE?

2002-03-21 Thread Nick Arnett
having flashbacks to CR/LF problems when moving Macintosh files to DOS! This is on Windows 2000, using Python 2.2 and MySQL 3.23.46-nt. That last field also seems to be truncated on the last record inserted. I'm mystified. Suggestions appreciated. Nick

RE: Extra return in last field in LOAD DATA INFILE?

2002-03-21 Thread Nick Arnett
your file in binary mode to disable this feature: f = open('datafile.sql','wb') Indeed I should have checked again -- that did it. Perhaps I should have asked on the Python list, after all. Still getting used to Python's idiosyncracies. Thanks much! Nick

Re: ADO API ODBC Alternative help

2002-03-13 Thread Nick Gorham
with our interbase driver, but I can't for the life of me see what the problem is. It works to SQL Server, but not Interbase. For what its worth Microsofts Access ODBC driver also generates this error, so we are not alone. Nick Gorham

synopsis of the problem (one line)

2002-02-25 Thread nick hoffman
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:nick hoffman Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class

gross database lockup

2002-02-19 Thread Nick Starai
I've upgraded a database server from: 2 x pIII 700MHZ 784Mb to 2 x pIII 1ghz 2gig ecc reg and have been having some sick database lockups since. 9:10pm up 6:11, 3 users, load average: 167.29, 108.42, 49.33 - unbelieveable load average. top shows 137 mysql 'threads?' CPU0

Re: MySQL off-the-shelf product

2002-02-19 Thread Nick Wilson
and +Articles for website owners - -- Nick Wilson -- |and designers. -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8c029HpvrrTa6L5oRAv0KAKCHcho4UkbYNGUEYEwz7A+4WGrDEwCffSRe Xe8bDDQbSkUwyJn5a6m7RHs= =m5b9 -END PGP SIGNATURE

Re: visualizing my queries

2002-02-12 Thread Nick Wilson
in the content table), and then you'll know if the author exists or not. Hope someone gives a better solution! No, I think you're right, Query the 'author' table first and eiter insert into both or just 'content' using the authors id. Cheers... - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325

permissions problem

2002-02-12 Thread Nick Wilson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm having a spot of bother with permissions (i think) I just set up MySQL for private developement at home with PHP and created a db 'mydb' and granted all privs to nick@localhost Now, I can 'USE mydb' from the command line but if I try

Re: permissions problem

2002-02-12 Thread Nick Wilson
What next Paul? Much thanks BTW -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: permissions problem

2002-02-12 Thread Nick Wilson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sql * and then Paul DuBois declared Do you have an entry for user apache, host localhost in the user No just entries for 'nick' and 'root' table, and have you deleted the entries for user='' and run FLUSH PRIVILEGES? Certainly have

visualizing my queries

2002-02-12 Thread Nick Wilson
be using PHP for the front end. I don't need tecnical help (yet) just a hand seeing how I might plan the code. Many thanks in advance - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux

Re: visualizing my queries

2002-02-12 Thread Nick Wilson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Diana Soares declared On Wed, 2002-02-06 at 11:22, Nick Wilson wrote: 2 tables content TipId | AuthId | title | keywords | desc | section | text author AuthId | name | email | bio My question is: If I enter

Re: permissions problem

2002-02-12 Thread Nick Wilson
, $pass); Is that what you mean? BTW er... I have your book here :) - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8ZaNXHpvrrTa6L5oRAiPrAJ435aYGm+c3twUrFMzLHfVB+qMkeQCfXGHM

Access denied to apache@localhost

2002-02-12 Thread Nick Wilson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sql Hi all I've just set up and the latest problem I have getting started is that 'Access denied for user: apache@localhost' msg. How can I put that right? - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com

Access denied to apache@localhost

2002-02-10 Thread Nick Wilson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sql Hi all I've just set up and the latest problem I have getting started is that 'Access denied for user: apache@localhost' msg. How can I put that right? - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com

permissions problem

2002-02-09 Thread Nick Wilson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm having a spot of bother with permissions (i think) I just set up MySQL for private developement at home with PHP and created a db 'mydb' and granted all privs to nick@localhost Now, I can 'USE mydb' from the command line but if I try

Re: permissions problem

2002-02-09 Thread Nick Wilson
, $pass); Is that what you mean? BTW er... I have your book here :) - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8ZaNXHpvrrTa6L5oRAiPrAJ435aYGm+c3twUrFMzLHfVB+qMkeQCfXGHM

Re: permissions problem

2002-02-09 Thread Nick Wilson
What next Paul? Much thanks BTW -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: permissions problem

2002-02-09 Thread Nick Wilson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sql * and then Paul DuBois declared Do you have an entry for user apache, host localhost in the user No just entries for 'nick' and 'root' table, and have you deleted the entries for user='' and run FLUSH PRIVILEGES? Certainly have

visualizing my queries

2002-02-06 Thread Nick Wilson
be using PHP for the front end. I don't need tecnical help (yet) just a hand seeing how I might plan the code. Many thanks in advance - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325 0677 Web:www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux

Re: visualizing my queries

2002-02-06 Thread Nick Wilson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Diana Soares declared On Wed, 2002-02-06 at 11:22, Nick Wilson wrote: 2 tables content TipId | AuthId | title | keywords | desc | section | text author AuthId | name | email | bio My question is: If I enter

Re: visualizing my queries

2002-02-06 Thread Nick Wilson
in the content table), and then you'll know if the author exists or not. Hope someone gives a better solution! No, I think you're right, Query the 'author' table first and eiter insert into both or just 'content' using the authors id. Cheers... - -- Nick Wilson Tel:+45 3325 0688 Fax:+45 3325

Re: Re: visualizing my queries

2002-02-06 Thread Nick Wilson
wasn't sure that my DB design wasn't flawed, I was expecting someone to say 'well if you want to do that you need to design like this..' No matter. I'm not sure I understand you recommendation, would kindly explain a little more? Much thanks... - -- Nick Wilson Tel: +45 3325 0688

Re: visualizing my queries

2002-02-06 Thread Nick Wilson
the AuthId is known, 'part two' can take place, and the tip written to the content tbl. Thus two tasks: (1) deal with the author 'issue', and (2) save the tip. Fantastic, thanks for taking time out to help me, very much appreciated and you're right of course. - -- Nick Wilson Tel:+45 3325

Edit a MySQL Record

2002-02-03 Thread Nick McBride
How would I go about editing a certain record in a MySQL database; Items? I want to be able to change a value that was already inserted into the table. -Nick McBride __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http

Quick SQL querie on count and embedded SELECT

2002-01-31 Thread Nick Stewart
Hi all, I want to do this, SELECT COUNT (a.artID) AS LCNT FROM (SELECT DISTINCT a.artID FROM pages p WHERE p.siteID = 1) Any ideas how to make this MySQL friendly? Cheers, Nick _ Chat with friends online, try MSN Messenger

delayed inserts never inserting

2001-12-27 Thread J. Nick Koston
can be more then 6 hours. Does anybody know of a way to force them to insert? -Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Viewing table data in a webpage using ASP

2001-12-03 Thread Nick Boldt
Hi, I'm trying to view the records of a table in on a webpage, but nothing is showing up. I can add records to the table from the page but cannot view, update or delete them. I'm using Windows 2000 and IIS 5.0 I'm new to MySql and would greatly appreciate any help anyone can give me. Nick

RE: Viewing table data in a webpage using ASP

2001-12-03 Thread Nick Boldt
Repeat1__index Repeat1__index = 0 ship_address_numRows = ship_address_numRows + Repeat1__numRows % Nick Boldt Computer Network Administrator Track of the Wolf Elk River, MN 55330 Tel: 763-633-2500 Fax: 763-633-2550 [EMAIL PROTECTED] -Original Message- From: Christopher R. Jones [mailto:[EMAIL

Re: about MySQL

2001-11-17 Thread Nick Ooka
Hi guys, Just curious... Can't he use the ODBC driver with Access to use MySQL? I think it *might* be possible. Pretty sure I read about it somewhere... Correct me if I'm wrong. Thx. On Sat, 17 Nov 2001 19:13:10 -0800 Nguyen Trong Phuc [EMAIL PROTECTED] wrote: hi Yang ! You have to control

Re: about MySQL

2001-11-17 Thread Nick Ooka
Hi, Wouldn't you have to set up a web server with PHP support to use that? I thought he just wanted a simple GUI client... What's the best thing to use? Nick On Sat, 17 Nov 2001 07:11:22 -0800 (PST) Deepanshu Shukla [EMAIL PROTECTED] wrote: Hello, you can use phpMyAdmin script

Re: about MySQL

2001-11-17 Thread Nick Ooka
the command line. :) Nick On Sat, 17 Nov 2001 09:42:01 -0800 (PST) Deepanshu Shukla [EMAIL PROTECTED] wrote: Yeah i almost forgot to mention it.you would have to configure Apache and install php module...well its an easy step if he wants some easy to use graphical interfacei

Re: newbie need help -- safe_mysql

2001-11-17 Thread Nick Ooka
I'm not sure, but isn't it supposed to be safe_mysqld (notice the extra d at the end). Not sure, just curious... (^^;;; Nick On Sat, 17 Nov 2001 13:12:14 -0800 (PST) a a [EMAIL PROTECTED] wrote: Following the instructions in the INSTALL-SOURCE file I can get to the last instruction

Same table aliased twice causes infinite loop

2001-11-13 Thread Nick de Voil
not support aliasing the same table twice in one SQL statement? Thanks Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

BUG: Update Log does not re-open file when filename specified

2001-10-29 Thread Nick Brandon
Description: To make myself clear, I am talking about the binary update log file. When specifing a fixed filename in my.cnf and running the flush-logs command (via mysqladmin) MySQL does not close the file and open the new file when run by a logrotate script. This does work correctly if no log

Backups and flush logs

2001-10-18 Thread Nick Brandon
the server does not continue to log to update-bin.log after the logrotate script has run? Any ideas would be greatly appreciated. Thanks Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: copy tables to another db

2001-09-25 Thread Nick Willey
Hi, Just dump the tables from the original database: % mysqldump -h yourhost -u root -p yourpass existing_dbname dbname.sql Then import the dump into your new database: % mysql -h yourhost -u root -p yourpass new_dbname dbname.sql Should get you started. Nick

Re: mysql to oracle

2001-09-13 Thread Nick Willey
It's amazing what a search on google will turn up. First result when searching on convert mysql to oracle came up with: http://freshmeat.net/projects/m2o.pl/?highlight=m2o Nick - Original Message - From: g g [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 13, 2001

mysql.sock error

2001-09-13 Thread Nick Torenvliet
I'm trying to start my first ever installation of mysql, so I've installed the tar.gz (3.23.42 on Linux) and I've run ./configure from /mysqlhome when I try to star the server I get the following message Can't connect ot local MySQL server through socket '/tmp/mysql.sock' When I do a find I

--log-update to tape drive?

2001-09-04 Thread Nick Willey
: Could not use tar -czvf /dev/ht0/mysql-update.log for logging (error 2) Any comments are appreciated. Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: installation and configuration!

2001-09-04 Thread Nick Willey
- Original Message - From: chrish shea [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 04, 2001 5:05 PM Subject: installation and configuration! Hi I am new to this group.I want to install MySQL on win 2000.Let me know from where we can get more information on

Re: Thinking of switching from MyISAM to InnoDB

2001-08-04 Thread Nick Seidenman
On Saturday 04 August 2001 09:25, Sinisa Milivojevic wrote: Nick Seidenman writes: Apparentlly there's a 4 GB limit to a MyISAM file when the table it contains has VARCHAR, TEXT, or BLOB columns. In order to get around this There is no 4 Gb limit in MyISAM with later 3.23 versions. I

Thinking of switching from MyISAM to InnoDB

2001-08-03 Thread Nick Seidenman
for production systems, or is it still too new (and too feature-prone.) I'd appreciate hearing feedback on this. If I do wind up switching, it won't be for at least a month. TiA, nick Nick Seidenman, CISSP Director of Software Development

problems with temp tables

2001-07-27 Thread Nick Seidenman
. Nick Seidenman, CISSP Director of Software Development Hyperon, Inc. www.hyperon.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

UPDATEing values in SET columns

2001-07-19 Thread Nick Brandon
of ways with no success!! For example UPDATE users SET user_flags = CONCAT(user_flags,'pass_renew') WHERE user_id = 1 Any help or pointers would be greatly appreciated. Thanks Nick Brandon P.S. Please cc my email address as I'm not subscribe to the list - Thanks

Joins.

2001-07-16 Thread Nick Davies
. Thanks. Nick. - 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 PROTECTED

many to many join on 2 tables.

2001-07-16 Thread Nick Davies
. table1.attb1= table2.attb1AND table1.attb2= table2.attb1; Thanks. Nick. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Unlock tables when process has killed.

2001-07-05 Thread Nick Kostirya
Hello, All. Help me. One process locks a table. Then it has been killed. The table remains locked. How unlock the table if the process is not exist? Thanks in advance. Nick. - Before posting, please check: http

Re: Unlock tables when process has killed.

2001-07-05 Thread Nick Kostirya
Sorry. It's possibly a bug under WinNT (version 3.23.39). For Linux (debian) is OK (version 3.23.39).! Now KILL id_process executed and executed hitherto. - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Nick Kostirya [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent

Re: Unlock tables when process has killed.

2001-07-05 Thread Nick Kostirya
mysql.exe executed. Sorry for my English. Nick. At 12:26 05/07/2001 +0300, Nick Kostirya wrote: Hi! Nick I have interest how you did the lock and how the table remains locked on NT. Below I show you a sequence on Win2k machine and how you see after a kill I was able to insert a new row

Re: Unlock tables when process has killed.

2001-07-05 Thread Nick Kostirya
locally and MyISAM - Original Message - From: Miguel Angel Solórzano [EMAIL PROTECTED] To: Nick Kostirya [EMAIL PROTECTED]; [EMAIL PROTECTED]; Miguel Angel Solórzano [EMAIL PROTECTED] Sent: Thursday, July 05, 2001 3:35 PM Subject: Re: Unlock tables when process has killed. At 14:09 05

Join mysticism

2001-06-26 Thread Nick Kostirya
.date_time_visit) = 3600 GROUP BY dt LIMIT 0,50 Best Regards. Nick.

sorry, it's a test

2001-06-13 Thread Nick Kostirya
sorry, it's a test database,sql,query,table - 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

I have problem With mysqlGUI

2001-04-08 Thread Nick Tze
Hi! i use mysql for windown version and i have this problem, as i know the mysqlGUI is a graphical tool to help you to make tables fields and other thinks for your database. I can change the password ,give sql commands but from the menu commands-tables it doesn't work create table, edit table

Win 2000 apache module

2001-04-02 Thread Nick
Can someone tell me where / how to get the Windows 2000 equivalent of the mod_auth_mysql.so in Linux. Thanks Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

FP exception in sql/sql_select.cc on osf1/4.0f + gcc 2.95.2

2001-04-02 Thread nick
ing/running the demo code given above. Fix: Add "-mieee" to CXXFLAGS and CFLAGS. Submitter-Id: submitter ID Originator:Nick Hilliard Organization: MySQL support: none Synopsis: FP problems on alpha / gcc Severity: serious Priority: high Category: mysql

Problem Setting up MyODBC Driver

2001-03-20 Thread Nick
and Password I did this as a machine data source When I try to connect I get the error message S1000[TCX][MYODBC] Host " is not allowed to connect to this MySQL Server. Any Ideas why this may be happening? Thanks Nick S

3.23.35 mysqlimport Doesn't Report Stats (resent)

2001-03-20 Thread Nick Pasich
y.asc into blockedHistory traffic.blockedHistory: ^^ ^^ ^^^ Disconnecting from localhost -----( Nick Pasich )- - Before posting, please

Re: why 3 processes?

2001-03-20 Thread Nick Taylor
Thank you, very much. Just glad to know nothing wrong. Nick - Original Message - From: "Jeremy D. Zawodny" [EMAIL PROTECTED] To: "Nick Taylor" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 12:20 PM Subject: Re: why 3 processes? On Tue, M

3.23.35 mysqlimport Doesn't Report Stats

2001-03-18 Thread Nick Pasich
lhost -----( Nick Pasich )- -- _ __ _ __ __ _ ___(_) ___| |__ | '_ \| '_ \ / _` / __| |/ __| '_ \ http://www.users.cts.com/sd/n/npasich | | | | |_) | (_| \__ \ | (__| | | | |_| |_| .__/ \__,_|___/_|\___|_| |_|@sd.ct

problem installing MyODBC. Please Help Me.

2001-03-07 Thread Nice Nick
Hi friends, I am a beginner for mysql. finally i was able to set it up. now i have problems to set myodbc upthe error is like "An error occured while copying C:\WINDOWS\SYSTEM\MFC30.DLL the computer asks me to restart the computer and try install again. but it does not work, so i am looking

UNIQUE multiple-column index

2001-03-02 Thread Nick Kostirya
Hi, All! Please, give me an opinion about multiple-column index. May I create the UNIQUE multiple-column index, which the index of each column is not UNIQUE in? If yes than how do it? Best. Nick. - Before posting, please

need help to set mysql up(error 105)

2001-02-27 Thread Nice Nick
Dear our mailing list friends, i am very new and i tried to install mysql to my computer(windows based ,i downloaded the software for windows ) but i failed. the error is: setup is unable to find installation languages in C:\PROGRA~1\ALZIP_HZTMP_\SETUP.LID file Error 105 i am looking for your

setup problems under windows.(error 102)

2001-02-27 Thread Nice Nick
i am trying to set mysql up but i have lots of problems the last of them was: setup requires a different version of windows. Check to make sure that you are running Setup on the windows platform for wich it is intended. Error 102 i downloaded the version for win95/98/nt/2000 and my computer

Comparing dates

2001-02-19 Thread Nick Didkovsky
(myDateField) TO_DATE('1997-10-04') You get the idea... thoughts? Best, Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: SV: Comparing dates

2001-02-19 Thread Nick Didkovsky
Thanks, Pal, I tried that and got an error, which led my down the road to using TO_DAYS() etc... Will try again, and post the error if it reoccurs. Best, Nick Pal Wester wrote: Actually, there should be a function which does the oposite of the DATE_FORMAT function, ie. converting a string

SELECT help

2001-02-14 Thread nick
that gets both of these statments into one? Thanks! Nick - 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

Who is quicker: CHAR(*), VARCHAR(*) or TINYTEXT.

2001-01-26 Thread Nick Kostirya
Hi. You would tell me who is quicker: CHAR(*), VARCHAR(*) or TINYTEXT. I need to quicken DB to the maximum and to keep minimum size of the DB. Thanks. Nick. - Before posting, please check: http://www.mysql.com/manual.php

Re: AW: mySQL vs Oracle

2001-01-23 Thread Nick Kostirya
for it: MySQL, PostgreSQL or Oracle. Help us!!! Sinks in advance. Nick. - Original Message - From: Christian Rabe [EMAIL PROTECTED] To: Eric Anderson [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, January 23, 2001 2:27 AM Subject: Re: AW: mySQL vs Oracle Sorry, but our

RE: LOAD DATA INFILE has LINES TERMINATED BY problem?

2001-01-14 Thread Nick Gianakas
fault LINES TERMINATED BY is '\n', as you don't need '\r' Regards, Nick G. -Original Message- From: Richard Creech - DreamRiver.com [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 14, 2001 4:23 AM To: [EMAIL PROTECTED] Subject: LOAD DATA INFILE has LINES TERMINATED BY problem? Hell

RE: I am really puzzled

2001-01-14 Thread Nick Gianakas
Edd, Sounds like a javascript verification. Open the source to the web page and look around (usually at the top) for a routine that's called when the form is submitted to confirm validity of form fields. Regards, Nick G. -Original Message- From: Texscene_Support [mailto:[EMAIL

<    1   2   3