MySQL/InnoDB-3.23.44 released: foreign keys now supported

Hi! MySQL/InnoDB-3.23.44 has been released for download at http://www.mysql.com InnoDB is a transactional table type of MySQL which supports row level locking, rollback, and other transactional features. InnoDB is included in the MySQL-Max 3.23.44 binaries. The first binary download is the rpm

RE: Query on Mysql

You have to setup an ODBC connection using the MySQL ODBC Driver (MyODBC), and then you use ASP to create connection and recordset objects. Chris -Original Message- From: murali madhav [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 12:40 AM To: [EMAIL PROTECTED] Subject: Quer

Re: when column contains spaces

On Thu, Nov 01, 2001 at 11:55:40PM -0700, I. TS wrote: > When I create a table, when one column contains a space, how can I > create it > correctly in mysql? > Use backticks (`) like this for column names with spaces in them: CREATE TABLE mytable( name CHAR(60) NOT NULL, `this column` CHAR(60

Fw: Can't connect to new databases

- Original Message - From: "sreedhar" <[EMAIL PROTECTED]> To: "Ryan Booker" <[EMAIL PROTECTED]> Sent: Friday, November 02, 2001 12:24 PM Subject: Re: Can't connect to new databases > hi ryan, > > check the privileges you had given to the users, test and mysql databases > are default dat

when column contains spaces

I am a newbie. When I create a table, when one column contains a space, how can I create it correctly in mysql? for example: CREATE TABLE mytable( name CHAR(60) NOT NULL, this column CHAR(60) ///Here there is a space? ); When I use ' or ", it does not

Re: how to mysql cluster!help!

I feel a little wierd doing this, since I'm a newbie here, but here goes: Do you want to be a paying customer of MySQL AB, or do you want to participate as a member of the volunteer community? If you want MySQL AB to give you a quote on designing a cluster of MySQL servers (or whatever), you nee

Re: Grouping behavior question

Hi Mr. Jerry, Since Mysql does not support sub query, you will have to use temporary table instead. Create temporary table tmptbl1 Select keycol, Max(datetimecol) as maxdate from detailtable group by Keycol; Create temporary table tmptbl2 Select distinct T.Keycol, D.Status from tmptbl1 T, de

Re: Ask for Linux+MySQL installation help

try to copy mysql libraries to /usr/local/lib and /usr/lib cp -a /usr/local/MySQL/lib/MySQL/* /usr/local/lib cp -a /usr/local/MySQL/lib/MySQL/* /usr/lib >From: "YANG" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Ask for Linux+MySQL installation help >Date: Fri, 2 Nov 2001 13:43:46 +0800

Excluding results based on contents of secondary table

Perhaps this is more of a general SQL question than a MySQL specific one, and I may be exposing my ignorance by asking this, but I figure it's worth a shot. I have two tables, 'a' and 'b'. Each contains a value 'c'. I want to select all 'a' rows where a.c is not in the set of b.c. Is this poss

Ask for Linux+MySQL installation help

Dear Sir: I want to ask some questions about Redhat Linux+MySQL installation. 1. At the Redhat Linux 6.2 opration system, I install MySQL database 3.23.43. Commands is as follws: # cd /usr/local # tar ¨Czxvf MySQL-3.23.443.tar.gz # mv MySQL-3.23.43 /usr/local/MySQL # cd /usr/lo

Ask for Linux+MySQL installation help

Dear Sir: I want to ask some questions about Redhat Linux+MySQL installation. 1. At the Redhat Linux 6.2 opration system, I install MySQL database 3.23.43. Commands is as follws: # cd /usr/local # tar ¨Czxvf MySQL-3.23.443.tar.gz # mv MySQL-3.23.43 /usr/local/MySQL # cd /usr/lo

Query on Mysql

Hi ! I would like to use ASP(Active Server Pages) & Mysql as database for my website,can you please tell me the procedure for connecting the same. Pl reply ASAP. Regards, Murali __ Do You Yahoo!? Find a job, post your resume. http://careers.yah

RE: Editing Forms

> BTW, there are open source solutions for the user-interface which don't > require the web browser. I've heard people mention GTK in this context. > There was even a book (about building user interfaces for MySQL with GTK+) Maybe even PHP-GTK (Win or *nix) Example GUIs; http://teak.sourceforge.

RE: ASP with MySQL

Hi, It's extremely favourable to use MySQL with ASP but I can't find a lot of web host support both. Most of them support only one of them, MySQL and PHP is a good pair while ASP and MSSQL is another pair. Any suggestion that support both? Thank you. ST Ooi At 03:48 PM 01/11/2001 +, you

how to mysql cluster!help!

Hi friends, I am a system administrator. I am from China:) We want to build a big system with Mysql for authortication,But we don't know how to establish cluster for Mysql, Could you help me please and tell me what we must to do! Waiting for your answer and thanks very much! WeiMing.Li -

Re: Editing Forms

Robert -- Just in case what Quentin and Rick said isn't clear, the MySQL DLLs/libraries are linkable and usable from Delphi/KYLIX. Quentin's note gives a good hint about one way to do it. I seem to recall from my last job that there are people around using Delphi as a front end to MySQL, so you s

Grouping behavior question

I often find myself in the following situation: I have a master table and a detail table, the detail table contains chronologically ordered items (statuses) that relate to the master record. I now need to display one line for each of the master records with the latest status from the detail t

RE: a bug or intentional? -- problem with multiple table query

Hi, You need to read up on Left Joins, which will insert a 'NULL' row in the results for B where there isn't a real one. Regards Quentin -Original Message- From: Q [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 November 2001 4:40 p.m. To: [EMAIL PROTECTED] Subject: a bug or intentional? --

a bug or intentional? -- problem with multiple table query

I am having a problem with a query and I don't know if it is a bug or intentional. Anyway any input is greatly appreciated. Here is a basic query that is simpler than what I am dealing with but should demonstrate my problem. Lets say: SELECT A.1, A.2 FROM A yeilds: test1 test2 then: SELECT

Need Help with PHP / Apache

Can someone help? Using Linux (Mandrake 8.0), I'm still having great difficulties getting Apache and PHP installed/configured to interface the MySQL database I'm using. I've repeatedly tried compiling PHP and Apache from source, with no luck (I even used newer/older versions the several times

Re: HOW do I return the results of a count to a variable

At 11:34 AM +0100 11/1/01, Harald Fuchs wrote: >In article , >Paul DuBois <[EMAIL PROTECTED]> writes: > >> [snip] >>> Of all the methods suggested I like the look of the one above and will >>> try that one first. >>> >>> $count = $sth->fetchrow_array(); >>

Re: Query speed

At 10:26 AM + 11/1/01, Leon Noble wrote: >Hi All, > >Tried the following three statements and they are wither too slow or do not >give me what I want. Basically what I want is to search for records for a >whole month and display totals for that month for each individual day. The >date field is

Re: VB/MySQL

The better way is use myvbql.dll at http://www.icarz.com/mysql/ . Your code can use both recordset style (ado full syntax only) and sql style (complex but useful). I recommend to use sql style when u need to manipulate data. SF At 14:57 1/11/2001 +0200, M.Ocak wrote: >Yes it is possible, >Cre

no warning if setting "date" to value with all letters

I'm doing experiments with the table "pet" where the field "birth" is of type "date". How come UPDATE pet SET birth = "a2b" WHERE name = "snort"; gives: Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 1 but UPDATE pet SET birth = "ab" WHERE name = "snort"; gives: Q

Some question about establish a Cluster for Mysql,Help!

Hi friends, I am a system administrator. I am from China:) We want to build a big system with Mysql for authortication,But we don't know how to establish cluster for Mysql, Could you help me please and tell me what we must to do! Waiting for your answer and thanks very much! WeiMing.Li -

Some question about establish a Cluster for Mysql,Help!

Hi friends, I am a system administrator. I am from China:) We want to build a big system with Mysql for authortication,But we don't know how to establish cluster for Mysql, Could you help me please and tell me what we must to do! Waiting for your answer and thanks very much! WeiMing.Li -

Re: Binary Keys?

Mark, That does look like a bug, or at least a much-needed feature. I've verified that this still doesn't work with the latest 4.0 code. On Thu, 2001-11-01 at 11:54, Mark Jenison wrote: > Hi all, > > I created a table with the key defined as binary(15), then inserted a > record like this: > >

RE: Can I use the concept of Effective Date with MySQL?

I have had to do this problem and i solved it by having 4 fields, Normalprice (PrPrice), Tempprice (PrTempPrice), Start date (PrStart) End Date (PrStop). In the select IF(((CURDATE() >= PRStart) and (PRStop >= CURDATE())), PrTempPrice, PrPrice) as CurrentPrice hope this helps On Thu, 1 Nov

UNICODE

Hello, is there any UNICODE support for Mysql? Dana - 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

RE: Can I use the concept of Effective Date with MySQL?

SELECT price FROM mytable WHERE price <= theprice DESC LIMIT 1; -Original Message- From: Alejandro Zuzenberg [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 7:53 PM To: [EMAIL PROTECTED] Subject: Can I use the concept of Effective Date with MySQL? I need to select the appro

Can I use the concept of Effective Date with MySQL?

I need to select the appropriate price for a product in a table, and the product has a compund key with 2 fields: product number and date. For every transaction with a certain product, I need to retrieve the price that was 'current' at the specific time when that transaction took place. In joinin

make fails on AIX 4.3.3 using the IBM xlc/xlC compiler

Hi! > "Garry" == Garry Williams <[EMAIL PROTECTED]> writes: >> Description: Garry> Note: Thanks to Mr. Chakarat Skawratananond Technical Consultant, Garry> Rapid Port Team, IBM Server Group in Austin, TX USA for his Garry> invaluable help in diagnosing these problems. Garry> make fai

Re: PHP4 and MySQL

> Now on the download page: > http://www.php.net/downloads.php > Under Windows Binaries: > PHP 4.0.6 zip Package says "MySQL support BUILT-IN" > > Knowing PHP supports every database, why on the download page it > mentions something about MySQL? And why use the words "built-in". I was > assuming M

RE: PHP4 and MySQL

For windows binaries, if you want to enable other databases, you have to uncomment the associated .dll file in the php.ini. Php doesn't have a seperate dll file for mysql, as the module is build right in (you couldn't disable it if you wanted to). When you compile it directly, if you don't speci

Re: PHP4 and MySQL

Benj Arriola writes: > Knowing PHP supports every database, why on the download page it > mentions something about MySQL? And why use the words "built-in". I was > assuming MySQL came with it already. Normally you need to link with the mysql client libraries, but PHP provides a substitute for t

RE: PHP4 and MySQL

Benj, Perhaps because MySQL is not a "native" Windows RDBMS, possibly being perceived by Microsoft fans as a Linux-only thang. Someone unfamiliar with MySQL may incorrectly assume that PHP for Windows doesn't have MySQL support. Cheers, Fred Woolsey -Original Message- From: Benj Arriola

Re: PHP4 and MySQL

At 05:17 2-11-01 +0800, Benj Arriola wrote: >PHP4.0.6 claims to have MySQL with it. > >Is this all installed with one installation file? Is it just one run of >the setup file and you have PHP and MySQL installed together? Nope. I remember a few websites where you can download a easy to install c

RE: PHP4 and MySQL

Being a PHP programmer, I know that PHP supports almost every database invented on earth. Now on the download page: http://www.php.net/downloads.php Under Windows Binaries: PHP 4.0.6 zip Package says "MySQL support BUILT-IN" Knowing PHP supports every database, why on the download page it men

PHP4 and MySQL

PHP4.0.6 claims to have MySQL with it. Is this all installed with one installation file? Is it just one run of the setup file and you have PHP and MySQL installed together? Benj - Before posting, please check: http://www.my

RE: Installing Calendar 0.9.33 on Mac OS X

First pointer - what errors are you getting! -Original Message- From: Greg [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 November 2001 9:32 a.m. To: [EMAIL PROTECTED] Subject: Installing Calendar 0.9.33 on Mac OS X Newbie here who has PHP and MySQL going, but can't figure out how to insta

RE: Editing Forms

Hi, If your Paradox Apps are written in a reasonably DB-independent way using Delphi Components, and not expoiting and Paradox-only features (are there any?), then porting those same applications to MySQL via ODBC should be a manageable task. If you do need to start from scratch, and the functio

RE: no mysqladmin

You don't need the /usr/bin/. Try just: mysqladmin -u root -p password 'new-password'. If your setting this for the first time, you don't even need the -p. Jason > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, November 01, 2001 3:37 PM > To:

RE: Editing Forms

MySQL provides a rich list of APIs with which scripts and programs perform data management. Other than directly entering INSERT and UPDATE commands directly at the mySQL command line, there is not built-in data entry functionality. Data entry (including, verification, validation, limit-checking)

no mysqladmin

>Description: Just installed this release with rpm, which says: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root -p password 'new-password' /usr/bin/mysqladmin -u root -h localhost -p password 'new-password' Unfortunately

MySQL Illegal Instruction

>Description: Install from RPM failed 'Problems running mysql_install_db' Any attempt to start gets illegal instruction.. [root@elmo root]# Starting mysqld-max daemon with databases from /var/lib/mysql /usr/bin/mysqld_safe: line 278: 1381 Illegal instruction $NOHUP_NICENESS $l edir/$MYSQLD $de

Installing Calendar 0.9.33 on Mac OS X

Newbie here who has PHP and MySQL going, but can't figure out how to install calendar. I suspect this is because I don't understand UNIX and permissions and which account I'm in. Here are the instructions edited: Unpack the calendar software in its own directory somewhere where your web server

Re: DB permissions Question

Rick Emery writes: > 2. To hide username and password, use PHP include files.Place this file > in a directory which is NOT where you store your web-pages and scripts. That's an excellent idea. Why haven't I done that? Shame on me for not thinking of that solution. Thanks for the tip. :-)

RE: DB permissions Question

1. GRANT insert,select,delete,update ON mydatabase.* TO myuser@'%' IDENTIFIED BY 'mypassword' When your user access mydatabase via a script (PERL,PHP), access it with this user and password combination. 2. To hide username and password, use PHP include files.Place this file in a directory w

RE: Web Hosting

Hello, Check out: http://keskydee.com/hosting.php - Apache on FreeBSD. - MySQL 3.23 - PHP 4.04pl1 - Perl - Python You can get anything you want, mutiple databases, multiple domains under one account, etc... Gil. -- PGP public key at: keskydee.com/gil.asc ICQ: 3310801 --

DB permissions Question

I"m sorry, this is a very basic question -- but I am new to using SQL via the web. I am on my own server, able to create databases/tables and manipulate them to my heart's content at the command line connecting as root. I cannot connect to the DBs any other way, however (e.g. logging in at regul

Re: Treating multiple records as a single-multiple value

[EMAIL PROTECTED] writes: > database,sql,query,table Fscking piece of crap filter. :-P Why not just forbid posts from people not on the list and have new members approved manually? Nooo... must annoy the users. Blaergh. > > I'd like to be able to get back all of the IDs that don't have 'blue',

Re: Importing fixed-width delimited large text files?

Damned filter. Anything quoted once is my post. Grrr... > database,sql,query,table > Erica Douglass writes: > > > I have a text file that is fixed-width delimited (that is, fields are > > delimited by certain column widths.) > > > > What is the workaround for this? Will importing large files

Treating multiple records as a single-multiple value

I have some hanger data that can be grouped by a common column to get back a list of multiple values. These values are logically one data set belonging to parent data. Nothing strange about that. Now I want to make an exclusionary query over those multi-value sets. For instance, I've got data

Binary Keys?

Hi all, I created a table with the key defined as binary(15), then inserted a record like this: insert into table values (0x010203040506070809000102030405,...) I can retrieve the row with select * from table and display it via my test program as '123456789012345' (I convert it from bytes to

Editing Forms

I have been looking at MySQL with the assumption that I could move up to an enterprise level database from a desktop database without the prodigious cost normally incurred. I usually work for small business's and my choice of database has been Paradox. I have been using Delphi as a front end too

Re: Trying to Start Two Servers

On Wednesday 31 October 2001 21:42, Gary Huntress wrote: > I'm up to over 1 databases in one data directory and that is > becoming a performance problem as users make their connections. I would > like to begin running multiple servers on the same box.I made my > first attempt tonight and

Re: Q: Using Linux LVM snapshots for replication setup?

On Wednesday 31 October 2001 20:06, you wrote: > On Wed, Oct 31, 2001 at 07:30:12AM -0800, Kyle Hayes wrote: > > Has anyone used LVM to create snapshots on a master in order to set > > up replication? We have specialized scripts that are getting harder > > and harder to maintain as we find weird

Re: Alphabetizing book titles

At 1:09 PM -0500 11/1/01, Ian M. Evans wrote: >Back when I was working with MSSQL I needed to alphabetize movie titles in >the proper library format where 'A' 'An" and 'The" are ignored. > >For MSSQL I was told to use: >select * from titles order by case when title like 'The %' then substring >(ti

Alphabetizing book titles

Back when I was working with MSSQL I needed to alphabetize movie titles in the proper library format where 'A' 'An" and 'The" are ignored. For MSSQL I was told to use: select * from titles order by case when title like 'The %' then substring (title, 5, 255) when title like 'A %' then substring (t

Importing fixed-width delimited large text files?

I have a text file that is fixed-width delimited (that is, fields are delimited by certain column widths.) I have encountered the problem listed in the manual entry for LOAD DATA INFILE as: Fixed-size rows (FIELDS TERMINATED BY and FIELDS ENCLOSED BY both empty) and BLOB or TEXT columns. Basi

Re: Re: Truncated data on spaces..?

>database,sql,query,table At 12:29 PM -0500 11/1/01, Gil G. wrote: >Hello, > >Does the data stored in a VARCHAR field get truncated on spaces? Trailing spaces, yes. >All my fields contain the data up to the first space... >What should I use ? One of the TEXT types. > >Thanks a lot, sincerely,

Re: > mysql < what does the < and > mean?

> i am typing a command C:\apache\mysql\bin> mysql< = > C:\apache\mysql\scripts\temp.sql... which worked by the way thanks to = > Andrew Murphy's help. but i wondered what it meant? i have looked in = > the books.. Barbara, Asking Windows questions here is likely to attract all manner of un

Re: Newsgroups

Try mailing.database.mysql. Unfortunately its one way, postings on the mailing list do make it to the newsgroup but postings on the newsgroup don't make it to the mailing list. Fred Van Andel - Before posting, please check:

Truncated data on spaces..?

Hello, Does the data stored in a VARCHAR field get truncated on spaces? All my fields contain the data up to the first space... What should I use ? Thanks a lot, sincerely, Gil. [ PHP 4.01, MySQL 3.23, FreeBSD 4.2 ] -- PGP public key at: keskydee.com/gil.asc ICQ: 3310801

Re: Web Hosting

I use netmegs.net for my metropets.org site and they have been wonderful - answer questions quickly and accurately, and virtually no down time. Anne - Original Message - From: Tony <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; Joe Fan <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursda

Re: > mysql < what does the < and > mean?

At 11:04 AM -0600 11/1/01, Paul DuBois wrote: >At 11:57 AM -0500 11/1/01, Barbara Ferrell wrote: >>i am typing a command C:\apache\mysql\bin> mysql< = >>C:\apache\mysql\scripts\temp.sql... which worked by the way thanks to = >>Andrew Murphy's help. but i wondered what it meant? i have looked i

RE: Web Hosting

You might also take a look at Z3 Internet (www.z3.com). I've had zero problems dealing with them for several years now without problem. Its easy to get custom packages at affordable rates, and tech support (on the rare occasion its actually needed) is first rate. The sysadmins have even gone so fa

Re: > mysql < what does the < and > mean?

At 11:57 AM -0500 11/1/01, Barbara Ferrell wrote: >i am typing a command C:\apache\mysql\bin> mysql< = >C:\apache\mysql\scripts\temp.sql... which worked by the way thanks to = >Andrew Murphy's help. but i wondered what it meant? i have looked in = >the books.. > is part of the DOS prompt. <

RE: Web Hosting

I use www.ccwebhost.com for about two years... $13/mo for 200mb of space and their tech support is beyond excellent! mySQL support, CGI-BIN, FTP, PHP4, SSI, SSL, etc... Anything and practically everything! Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original M

> mysql < what does the < and > mean?

i am typing a command C:\apache\mysql\bin> mysql< = C:\apache\mysql\scripts\temp.sql... which worked by the way thanks to = Andrew Murphy's help. but i wondered what it meant? i have looked in = the books.. - Before postin

Re: Web Hosting

You might want to try Hurricane Electric, I've been using them for over a year, MySQL, Telent, cgi, email account, DNS support starting at $10/month. http://www.he.net They've been great. Cheers, T On Tuesday 30 October 2001 11:44 pm, Joe Fan wrote: > My current web hosting c

Re: Bug#117819: mysqld 3.23.43 returns no data instead of correct result

Hi I forward this to you from the Debian bug tracking system as it seems to be an upstream problem. Please keep the reply-to. bye, -christian- On Wed, Oct 31, 2001 at 09:42:56PM +, Petr Vandrovec wrote: > Package: mysql-server > Version: 3.23.43-2 > Tags: upstream > > Hi, > I have simp

RE: ODBC Call Fails

Alex, If MyODBC is simply passing the query in this case along to MySQL, the MySQL engine will choke on the subquery IN (SELECT ..., since MySQL doesn't support subqueries. I have had success, however, using subqueries with Access and MySQL by linking the MySQL tables to Access using the Get Ext

RE: (OT) MySQL and foreign keys

I just want to use the default table with MySQL -- InnoDB looks like too much overhead for me. I am a KISS kind of guy. I want to be able to dynamically indicate the relationships for development purposes. Also, I really want the Perl code, database maintenance, and template management separate

RE: ASP with MySQL

Raymond, We run ASP with MySQL constantly using both ADO and a JDBC connections to it and experience great stability with it... this is with ASP on a WinNT/Win2K platform... we've never tried ChiliASP best wishes Chris Dr Christopher Thorpe Information Architect GenomeBiology - biology for th

Some question about establish a Cluster for Mysql,Help!

Hi friends, I am a system administrator. I am from China:) We want to build a big system with Mysql for authortication,But we don't know how to establish cluster for Mysql, Could you help me please and tell me what we must to do! Waiting for your answer and thanks very much! WeiMing.Li ---

RE: ASP with MySQL

Raymond, I would expect so (although I haven't tried it), since both ODBC and OLEDB providers (MyODBC and MyOLEDB, respectively) exist for MySQL on Windows. I have used MyODBC with VBA in an Access 2000 front end to a MySQL database, and it works, albeit with a few minor glitches and less than s

RE: Help - Migration to mysql from a legacy ISAM

Ian Collins writes: > So how do you use the HANDLER command in a C program? > I perused the code for 3.2x for this, and ended up installing mysql-4.0.0. > I found what I believe to be the code for HANDLER in > libmysqld/sql_handler.cc > in the functions, > mysql_ha_open, mysql_ha_close, mysql_ha_r

RE: deadlock - Innodb Monitor

Gisella, At 04:24 PM 10/31/01 -0800, you wrote: >Heikki, > >The output I get from the Monitor does not have the section > >-- >LOCKS HELD BY TRANSACTIONS >-- > >that I see in the manual (www.mysql.com/doc), section 7.5.9.1, The InnoDB >Monitor. sor

Re: Configuring MySQL 4.0.0 with SSL shortens idle timeout horribly

On Wed, 2001-10-31 at 21:53, [EMAIL PROTECTED] wrote: > >Description: > > Configuring MySQL 4.0.0 with --with-ssl causes the server to > act as though interactive_timeout and/or wait_timeout were > set to approximately 6 seconds, although the variables seem > to have

RE: retrieve data from more db

Simply indicate the database name in you query: SELECT cust2000.mytable.*, cust2001.mystable.* FROM cust2000.mytable, cust2001.mystable WHERE cust2000.mytable.cust_ID=cust2001.mystable.cust_ID; -Original Message- From: Sommai Fongnamthip [mailto:[EMAIL PROTECTED]] Sent: Thursday, November

Re: MySQL ignoring writes

Erik G. Burrows writes: > > I'm having a wierd problem with MySQL, that seems to be begging that I > wait for the next release, but I wonder if anyone else is getting this. > > I'm running MySQL 3.23.42, and using the Berkeley DB table type to get > transactional ability. Occasionally, MySQL wi

RE: newby question about datetime fields

select * from my_table order by my_datetime DESC -Original Message- From: brainheap [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 5:16 AM To: MySQL mailing list Subject: newby question about datetime fields Hi ppl! I have a table with datetime type column in it. when I

Re: error starting mysql

Hi! At 01:50 PM 11/1/01 -, you wrote: >i log administrator >i have created the directory c:\ibdata\ibdata1 Ok, that explains the error: ibdata1 should be a file. If you have a directory of the same name 'ibdata1', then Windows tries to open a DIRECTORY for reading, which does not succeed, o

Missing mysql_install_db on Windows binary distribution

I'm totally new to mysql so I may be asking a real dumb question here. Does anyone know whether the running of mysql_install_db necessary for the Windows distribution of mysql? I downloaded the binary mysql-3.23.43-win.zip file yesterday and ran the setup. However, there is no mysql_install_

Re: Update JDBC Driver (gweMysql Driver)

Hi, Michael Widenius wrote: > > Tomohiro, could you be kind and put a copy kind a put a link from the > MySQL software portal to your page ? This way it will be easier for > other MySQL users to find your software! > http://www.mysql.com/portal/software/html/index.html Sure. Thank you so

Re: MySQLGUI?

Henrik Holmberg writes: > Hi > > Can MySQLGUI start and stop the daemon? > > > /Henrik It can stop it if you have root privileges on the server. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ My

Re: error starting mysql

i log administrator i have created the directory c:\ibdata\ibdata1 same error.. Regards, Jean - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, November 01, 2001 10:59 AM Subject: Re: error starting mysql > Hi! >

Re: VB/MySQL

Yes it is possible, Create a System DSN by using Settings--> Control Panel -->32 Bit ODBC data Sources. And use ADO to connect MySQL database. Hope this helps. Mustafa - Original Message - From: "Quan Bang" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 01, 2001

Re: How to make apache webserver on a Linux box connect to a remote mySQLdatabase on a separate Sun box

well for starters you should look into updating your grants table, to allowe the remote server to access the db. Don't forget to properly set the userid, password, and perms for this...Highly encourage to grant this id read only access...but that's your call. Then on the prospective webserver m

VB/MySQL

Hi, Is it possible to work with VB and MySQL directly using dlls, just like working with VB and SQL Server. QB - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

RE: newby question about datetime fields

> Hi ppl! > > I have a table with datetime type column in it. > > > when I make request "select * from my_table order by my_datetime" > > I get the normal sort i.e. first the oldest dates but I want to get > reverse sort to have most recent dates to be the first. > > How can I do this? http:

newby question about datetime fields

Hi ppl! I have a table with datetime type column in it. when I make request "select * from my_table order by my_datetime" I get the normal sort i.e. first the oldest dates but I want to get reverse sort to have most recent dates to be the first. How can I do this? Thanks for any help :0) Al

Re: error starting mysql

Hi! I looked from the MS Developer Studio manual: Code Description Name 2 The system cannot find the file specified. ERROR_FILE_NOT_FOUND 3 The system cannot find the path specified. ERROR_PATH_NOT_FOUND 4 The system cannot open the file. ERROR_TOO_MANY_OPEN_FILES 5 Access is denied. ERRO

Re: Query speed

Leon Noble writes: > select dayofmonth(date) as mydate, count(num) as mycount from table_name > where date='TO_DAYS(2001-08-01) - TO_DAYS(2001-08-31)' and action=1 group by > dayofmonth(date); This query makes no sense at all. I don't think the date will ever be equal to that string constant, u

error starting mysql

i have installed MySQL on W2000 my my.ini is : [mysqld] basedir=C:/MySQL #bind-address=192.168.0.1 datadir=C:/MySQL/data #language=C:/MySQL/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M innodb_data_home_dir = c:/IbData innodb_data_file_path = ib

RE: Query speed

Hi, Check the section about How MySQL Optimizes queries for you version - there is a bit about how indices are not used when calling a function that may be relevant. Hope it helps Quentin -Original Message- From: Leon Noble [mailto:[EMAIL PROTECTED]] Sent: Thursday, 1 November 2001 11:

Query speed

Hi All, Tried the following three statements and they are wither too slow or do not give me what I want. Basically what I want is to search for records for a whole month and display totals for that month for each individual day. The date field is indexed. Tried.. select count(num) as mycoun

libmysqld

Hi, Can anyone tell me how i get a win32 mysql embedded library? Thanks, Jeroen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To req

retrieve data from more db

HI, I have data on more than 1 db to separate in year name like these: cust2000--> contain customer infomation in year 2000 cust2001--> contain customer infomation in year 2001 all db have the same field name. I have put db name and table na

  1   2   >