Re: autoincrement

2001-08-28 Thread Grigory Bakunov
Date |Tue, 28 Aug 2001 12:49:52 +0100 >From |[EMAIL PROTECTED] Hello! S> When you have just inserted a record into a table that autoincrements the S> primary key, S> is there a way of retrieving the id assigned at the same time? I'm using ASP S> to write the S> code in question , and I'm trying

Re: reports? from MySQL (oops, on a Mac)

2001-08-28 Thread get86
i untarred the siag app (very cool, hope it'll work) and dropped in my home dir. then i ran ./configure, make and make install... i got: checking host system type... configure: error: can not guess host type; you must specify one configure: error: ./configure failed for XawM [ichi:~/apps/siag-

Re: Deleted mysql.host Table!

2001-08-28 Thread Grigory Bakunov
Date |Tue, 28 Aug 2001 14:16:23 +0200 >From |Steffen Hainke <[EMAIL PROTECTED]> Hello! SH> Hallo, SH> i'm new to mysql. I delete a mysal.host table. Does it means i can't SH> access the rest of my tables in the database? If so, can i rebuild this SH> table or is there another way, to access the

Re: SQL syntax near 'IDENTIFIED BY'...

2001-08-28 Thread Grigory Bakunov
Date |Tue, 28 Aug 2001 15:14:54 +0500 >From |Alexander Barkov <[EMAIL PROTECTED]> Hello! AB> Hello! AB> These query produces an SQL syntax error AB> in 3.23.29a-gamma: AB> GRANT ALL PRIVILEGES ON databases.* AB> TO 'foo'@'localhost' IDENTIFIED BY 'bar'; AB> SHOW TABLES FROM databases; AB

Re: Need info

2001-08-28 Thread Grigory Bakunov
Date |28 Aug 2001 08:05:19 - >From |"Nilesh Keshavji Parmar" <[EMAIL PROTECTED]> Hello! NKP> Hello Everybody :-) NKP> Well, I just suscribed to the mailing lists and would like to know a few more things about mysql. I have heard a lot about it and i think i will enjoy learning it a lot. I

Re: reports? from MySQL (oops, on a Mac)

2001-08-28 Thread Grigory Bakunov
Date |Wed, 29 Aug 2001 00:24:25 -0400 >From |[EMAIL PROTECTED] Hello! >>i'd like to ask... >>if any of you are familar with (File Maker Pro, most recent >>versions)... how does one go about using MySQL to create a printable >>report? e.g., where you select the fields you wanted in the report

Re: iASP Engine...

2001-08-28 Thread Grigory Bakunov
Date |Mon, 27 Aug 2001 18:20:01 +0100 >From |"Neil Tompkins" <[EMAIL PROTECTED]> Hello! NT> Hello, NT> My ISP suppports iASP. I've moved my site from running on Windows 2000 NT> Server to a linux zeus web server. Everything runs fine from querying the NT> mySQL database and returning records

compiling mysql with InnoDB for AMD Athlon cpu

2001-08-28 Thread Stanislav Dmitrenko
G'day, Is it possible to compile mysql with InnoDB for AMD Athlon processor ? Error produced during compilation follows: make[4]: Entering directory `/usr/local/src/mysql-3.23.41/innobase/sync' gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include -DDBUG_OFF -O3 -DDBUG_OFF-DDEBUG_OFF

Re: query

2001-08-28 Thread Grigory Bakunov
Date |Tue, 28 Aug 2001 16:32:49 +0530 >From |"muruganandam" <[EMAIL PROTECTED]> Hello! M> for a particular query i have to select data from five tables. M> can any one suggest me a best way to do that in terms of performace.. M> thanks in advance M> muruganandam Please give more details. Lik

reports? from MySQL (oops, on a Mac)

2001-08-28 Thread get86
>i'd like to ask... >if any of you are familar with (File Maker Pro, most recent >versions)... how does one go about using MySQL to create a printable >report? e.g., where you select the fields you wanted in the report >and then create a layout and page setup for the report, (then print >it)?

New MySQL Site

2001-08-28 Thread Mike
Just a kudos to those that redid the MySQL site. DAMMM IT LOOKS GOOD Excellent job!!! Cheers M;) Quote from The Young Ones: I suppose you think it's pretty weird, don't you Mike? Well, you'd be right. Because THAT's the kind of guy I am, right! WEIRD! Which is why I go over

Re: how to import a text file into the mysql database

2001-08-28 Thread Daniel Woods
> shell # mysqlimport -u root -p webcalendar tables-mysql.sql > > where, 'webcalendar' is the database that i have created for this > purpose. after entering the password at the password prompt it is > displaying the following error: > > mysqlimport: Error: You have an error in your SQL syntax n

binary bin problems on HPUX 11.0

2001-08-28 Thread William Chi
Hi, we are using mysql 3.23.33 on HPUX11 and every time we reboot the machine, it overwrites the binary log and starts from 001 again. This is only happening on a couple of machines. It doesn't do this if i manually restart mysql, only when the machine is rebooted. On one of the machines, mysql

Re: RE: FULLTEXT exact match queries?

2001-08-28 Thread Ed Carp
Alok K. Dhir ([EMAIL PROTECTED]) writes: > > > select * from Laws WHERE MATCH(Line) AGAINST ('growth > > hormone') AND Line like '%growth hormone%' ORDER BY ID; > > This defeats the purpose of the fulltext index, don't you think? Not really - since the WHERE clause is executed left to right,

Re: Root password revisited

2001-08-28 Thread Gregg Baker
Hi all, I got a "No Database Chosen". What's the syntax for adding the database? I tried *.*, mysql, and test between UPDATE and user but all returned syntax error. Thanks much, Gregg UPDATE user SET Password=PASSWORD("desiredpasswordhere") WHERE User="root"; -

Re: Solaris 2.8 configure problem...

2001-08-28 Thread Michael Widenius
Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Jeremy Zawodny writes: >> I have a fairly new Solaris 2.8 (Ultra Sparc) machine on which I'm >> trying to build the MySQL client libraries. According to the >> INSTALL-SOURCE file, I need to use a command-line like th

Error Install MySQL Binary on AIX

2001-08-28 Thread Michael Widenius
Hi! > "ajgrif" == ajgrif <[EMAIL PROTECTED]> writes: >> Description: ajgrif> I downloaded the lated AIX binary from mysql.com, and unpacked it to /usr/local/mysql. I then cd'd to /usr/local/mysql and ran scripts/mysql_install_db per the INSTALL-BINARY file. This is the error I

Root password revisited

2001-08-28 Thread Gregg Baker
Hi all, I just joined list. I spent a couple hours in the archive and decided MySQL better improve their install message regarding setting the root password! Half the posts are about it going badly. ;) I believe I found the answer in the archives, but they all aren't the same answer. So is the co

mysqladmin is missing from RPM distribution

2001-08-28 Thread root
>Description: I downloaded, via ftp, and installed MySQL-3.23.41-1.i386.rpm. The user instructions at the end of the rpm -i ./*.rpm command proscripbed the use of /usr/bin/mysqladmin -u root -p password 'new-password' and /usr/bin/mysqladmin -u root -h 'my-dns-name' -p password 'new-password'. Unf

Re: ERROR 1044: Access denied

2001-08-28 Thread Dana Powers
The way mysql access tables work, if it cant find a user named 'user2', it will default to the blank user ( '' ). dpk - Original Message - From: "Pierre-Yves" <[EMAIL PROTECTED]> To: "Dana Powers" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, August 28, 2001 4:39 PM Subject:

how to import a text file into the mysql database

2001-08-28 Thread Chakravarthy K Sannedhi
hello all, i am trying to install web calendar software on my machine, which is available at sourceforge.net website. to run that software first of all a textfile named tables-mysql.sql needs to imported into the mysql database. for doing that i typed the following command at the shell prompt sh

Re: ERROR 1044: Access denied

2001-08-28 Thread Pierre-Yves
- Original Message - From: "Dana Powers" <[EMAIL PROTECTED]> To: "Pierre-Yves" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 1:22 AM Subject: Re: ERROR 1044: Access denied > > ERROR 1044: Access denied for user: '@localhost' to database 'hello' > This says

Re: ERROR 1044: Access denied

2001-08-28 Thread Dana Powers
> ERROR 1044: Access denied for user: '@localhost' to database 'hello' This says that you are connected as user '' ( blank ) from localhost. Make sure you're logging on correctly and try again. dpk - Before posting, please check

Re: cannot get mysqld to start

2001-08-28 Thread Dana Powers
This is covered in the mysql manual here: http://www.mysql.com/doc/P/o/Post-installation.html First, you need to install the default databases ( installs mysql/host.frm ): bash> mysql_install_db Then tell mysql not to use InnoDB: put this in your /etc/my.cnf file: [mysqld] skip-innodb

ERROR 1044: Access denied

2001-08-28 Thread Pierre-Yves
Hello, I have a problem with the access : I have created 2 users with no privileges in the user table (privileges are set in the db table, so those users can only access one particular db). the first user has all the privileges set to Y for the db "hello", this user works fine. the second user

RE: FULLTEXT exact match queries?

2001-08-28 Thread Ed Carp
> On Aug 28, Ed Carp wrote: > > How do I do exact phrase matches using FULLTEXT? > > > > I have this 2 million row table, full of text data, that I want > to search > > for an exact phrase. When I say: > > > > select * from Laws WHERE MATCH(Line) AGAINST ('MDMA') ORDER BY ID; > > > > It works cor

Re: FULLTEXT exact match queries?

2001-08-28 Thread Sergei Golubchik
Hi! On Aug 28, Ed Carp wrote: > How do I do exact phrase matches using FULLTEXT? > > I have this 2 million row table, full of text data, that I want to search > for an exact phrase. When I say: > > select * from Laws WHERE MATCH(Line) AGAINST ('MDMA') ORDER BY ID; > > It works correctly, retu

FULLTEXT exact match queries?

2001-08-28 Thread Ed Carp
How do I do exact phrase matches using FULLTEXT? I have this 2 million row table, full of text data, that I want to search for an exact phrase. When I say: select * from Laws WHERE MATCH(Line) AGAINST ('MDMA') ORDER BY ID; It works correctly, returning 1 row, MUCH faster than doing a "select .

cannot get mysqld to start

2001-08-28 Thread Sheena Sidhu
Hello, I just installed mysql-max-3.23.41 on Linux. All went smooth but alas cannot get myqld to start. here is the log from the .err file in mysql/data directory: 010828 14:26:30 mysqld started Can't initialize InnoDB as 'innodb_data_file_path' is not set 010828 14:26:30 /usr/local/

show create table URGENT

2001-08-28 Thread Martin Jeremic
This is really stupid, but I can remember how to save results of "SHOW CREATE TABLE tbl_name" and "SHOW COLUMNS FROM tbl_name" in to text file. I'm running mysql 23.41 on Win2k. Thanks in advance -- Martin Jeremic mailto:[EMAIL PROTECTED] http://solair

Re: fwd: What is "Pupport" ? :)

2001-08-28 Thread Matt Wagner
Hi, Damn you guys are fast! :) Fixed. But the udmsearch is busted right now for unknown reasons. I will fix shortly. Matt Jeremy Zawodny writes: > FYI... > > - Forwarded message from Sam Masiello <[EMAIL PROTECTED]> - > > From: "Sam Masiello" <[EMAIL PROTECTED]> > To: "MySQL G

Re: What is "Pupport" ? :)

2001-08-28 Thread Jeremy Zawodny
On Tue, Aug 28, 2001 at 05:10:17PM -0400, Sam Masiello wrote: > > Not really a MySQL question, but it is related to the MySQL web site I forwarded it to [EMAIL PROTECTED], which is where that sort of thing should go... Few folks on this list have any control of MySQL's web site. Jeremy --

What is "Pupport" ? :)

2001-08-28 Thread Sam Masiello
Not really a MySQL question, but it is related to the MySQL web site If I go to: http://www.mysql.com/udmsearch/search.php the "Support" link is spelled "Pupport" (on other pages it is spelled correctly, however)whoops :) --Sam Sam Masiello Software Quality Assurance Engineer (provid

Progress indicator in a query

2001-08-28 Thread Pires Claudio
Hi guys, could anybody help me? I have a very big database. When I make querys to my database, depends on the type of query, it takes a lot of time. I want to implement a progress indicator. Is there any way to implement something like this? Thanks Claudio P. --

RE: dbf2mysql problem please help

2001-08-28 Thread Venu
Hi !!! )-Original Message- )From: Armando Cerna [mailto:[EMAIL PROTECTED]] )Sent: Tuesday, August 28, 2001 1:27 PM )To: [EMAIL PROTECTED] )Subject: dbf2mysql problem please help ) ) )I have problems only converting certain DBF files to mysql with )dbf2mysql. )Some work but some don't and

dbf2mysql problem please help

2001-08-28 Thread Armando Cerna
I have problems only converting certain DBF files to mysql with dbf2mysql. Some work but some don't and when they dont' I get the following error bash-2.05$ dbf2mysql -d maria -t cusine -c -P pass -U user CUSINE.DBF Error creating table! Detailed report: You have an error in your SQL syntax ne

BDB questions

2001-08-28 Thread Sheena Sidhu
Greetings everyone! I had 2 questions related to using BDB and mysql. I don't see any startup options for BDB, so can I safely assume that there are'nt any , so don't need a my.cnf file? Also, how do I specify 'autocommit off' every time BDB starts, instead of specifying it exp

Re: MySQL Error Codes

2001-08-28 Thread Gerald Clark
Check the source. include/mysqld_error.h A. Clausen wrote: > I'm developing some MySQL applications using VB6 and ADO, and need to do some work >on error handling. I can get the error code easily enough from ADO's Error >collection, but is there a list of error codes and their descriptions.

Re: reports? from MySQL

2001-08-28 Thread j.urban
If you're accessing via Windows, you can use MyODBC and a reporting package such as Crystal Reports or Quick Reports or just about any ODBC-compliant reporting package. You should also be able to link MS Access to your MySQL database... For simple reports where you just want to print some data,

MySQL Error Codes

2001-08-28 Thread A. Clausen
I'm developing some MySQL applications using VB6 and ADO, and need to do some work on error handling. I can get the error code easily enough from ADO's Error collection, but is there a list of error codes and their descriptions. I've been doing this by generating errors and seeing what codes

Re: Drop Down Boxes

2001-08-28 Thread Jeremy Zawodny
On Tue, Aug 28, 2001 at 02:56:13PM -0700, Webmaster Odell wrote: > > We are trying to populate a form drop down box (HTML) with a column > from our database. What is the query that will get us that without > repeating the items (in the 500 or so records this column has only > 12 non-repeated items

Re: Drop Down Boxes

2001-08-28 Thread Cal Evans
Select Distinct. Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: "Webmaster Odell" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Tuesday, August 28, 2001 04:56 Subject: Drop Down Boxes > HI > We are trying to populate a form

Drop Down Boxes

2001-08-28 Thread Webmaster Odell
HI We are trying to populate a form drop down box (HTML) with a column from our database. What is the query that will get us that without repeating the items (in the 500 or so records this column has only 12 non-repeated items) Thanks. Kevin Pottie Internet Designer O'Dell Web Design http://ww

Re: reports? from MySQL

2001-08-28 Thread Dana Powers
linking tables via MyODBC + MS Access works great for me. dpk - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 28, 2001 12:06 AM Subject: reports? from MySQL > hello. > > with a lot of help from many of you and some very nice folks, i have > b

Re: problems compiling on FreeBSD 3.3 (mysql-3.23.41)

2001-08-28 Thread Angel Behar
I just update the gcc version and still the same problem : absa# gcc -v Reading specs from /usr/local/lib/gcc-lib/i386-unknown-freebsd3.3/3.0.1/specs Configured with: ../configure --enable-languages=c++ Thread model: posix gcc version 3.0.1 Any Ideas ? thanks - Original Message - From:

Re: Roles

2001-08-28 Thread John Meyer
At 09:57 AM 8/28/01 -0700, you wrote: > > In Oracle, I remember working with roles that I could assign to a user. >Is > > there such a mechanism, or are there plans to implement such a mechanism, > > in MySQL. > >This sounds a lot link granting a user certain privileges. Here's the part >of the do

Re: Roles

2001-08-28 Thread Kurt Hansen
> In Oracle, I remember working with roles that I could assign to a user. Is > there such a mechanism, or are there plans to implement such a mechanism, > in MySQL. This sounds a lot link granting a user certain privileges. Here's the part of the documentation that talks about this: http://www.m

mySQL

2001-08-28 Thread Thomas Ekegren Christensen
Hi mySQL, I have a huge problem and unfortunately my Domain Hosting Services has no interest in helping me. I am running mySQL with ASP and use a DSN-less call to connect to mySQL. The problem is a little bit weird because running the query using phpmyadmin gives me a perfect recordset. Runnin

Please..Desperate for Help |||||||

2001-08-28 Thread nrwalker
I am trying to install the "dbf2mysql" converter and really getting a headache. Someone told me that I need to install the "Include files and libraries for MySQL" and I have been searching frantically all over the web for the source for this. All I have been able to find is the RPM's. I am on

Roles

2001-08-28 Thread John Meyer
In Oracle, I remember working with roles that I could assign to a user. Is there such a mechanism, or are there plans to implement such a mechanism, in MySQL. - Before posting, please check: http://www.mysql.com/manual.php

Trying to build MySQL 3.23.39 on LynxOS 3.1.0

2001-08-28 Thread Mott Brian-P28702
Hello, I'm trying to build MySQL 3.23.39 for a LynxOS 3.1.0 platform. I believe that I only need the client, and have selected the no-server options. However, when trying to run make it bombs out in the client directory due to the sql_string.cc file which has declared an include for floating

Maximum number of keys

2001-08-28 Thread joseph . bueno
Hello, According to MySQL documentation (Chap. 7.1 "MyISAM Tables"): "Maximum number of keys/table is 32 as default." However when I try to create more than 16 keys, I get: ERROR 1069 at line 1: Too many keys specified. Max 16 keys allowed This table is of MyISAM type. I am currently running

RE: Updating auto_increment ID Column/Selecting Duplicate Rows

2001-08-28 Thread Daniel Von Fange
This would give you a list of all users that have entered things more than once; However, it would not give you all the rows that are duplicated. SELECT Count(User) from mail_form2 GROUP BY User HAVING Count(User) > 1 Hope this helps! Daniel Von Fange -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Re: limits to volume handled by MySQL

2001-08-28 Thread Sergei Golubchik
Hi! On Aug 28, Bernard-Olivier Clist wrote: > Hi there > We are switching to a MySQL 3.23.38 on a PIII 933 MHz machine running with > a FreeBSD and a web Apache server 1.3.19 . > The hosting company has just argued MySQL cannot handle more than 1Go in > database files opened per session. > Is i

MySQLGUI Version 1.7.5 Question and Comment

2001-08-28 Thread Marion Berryman
I've been trying out MySQLGUI Version 1.7.5, and it seems to work fine on my Win 98SE client. I do have a question about the menu entries under Commands, Tables for "Edit table" and "Create tables". I've searched through the help file and didn't find any mention of these two menu entries, and

design

2001-08-28 Thread Mallikarjuna Rao N
Hi Is there any design document available of the complete architecture of the mysql database. I wanted to try out small changes . I want to make sure that it does not effect any transactions or anythings like that in any way. mallik -- ---

Re: Updating auto_increment ID Column/Selecting Duplicate Rows

2001-08-28 Thread Gerald Clark
Tom Churm wrote: > hi, > > i have 2 questions that i badly need answered. i use phpmyadmin, but > any answers containing SQL syntax should work in this app... > > 1) > this should be simple but i don't know it. i use the following mysql > table field as the Key for my tables: > > "id int(

Re: MySQLgui problems

2001-08-28 Thread Stefan Murariu
[EMAIL PROTECTED] wrote: >Your message cannot be posted because it appears to be either spam or >simply off topic to our filter. To bypass the filter you must include >one of the following words in your message: > >database,sql,query,table > >If you just reply to this message, and include the e

limits to volume handled by MySQL

2001-08-28 Thread Bernard-Olivier Clist
Hi there We are switching to a MySQL 3.23.38 on a PIII 933 MHz machine running with a FreeBSD and a web Apache server 1.3.19 . The hosting company has just argued MySQL cannot handle more than 1Go in database files opened per session. Is it true ? If so how to go over that 1Go limit ? ( :-) yes

Re: strange problems with MySQL db

2001-08-28 Thread Gerald Clark
When the temp directory runs out of space, the thread executing will wait for space to become free. If you kill the server, this client has not closed the table properly. How do you determine that the server "crashed" ? If it stopped responding, maybe it is just waiting for space to become availa

MYSQL Stops for no reason

2001-08-28 Thread Michael Fontbin
Hello all Please if could someone help, I am running MYSQL to record print transactions at my company..the way I have set this up is by after a print job has completeda bat file is run whih basically says...go and insert into the table the following values Now on more than 1 occasion the MYS

RE: Feature suggestion

2001-08-28 Thread Simon Green
See V 4 -Original Message- From: Alexander Barkov [mailto:[EMAIL PROTECTED]] Sent: 28 August 2001 14:13 To: [EMAIL PROTECTED] Subject: Feature suggestion Hello! Currently replication is implemented between two mysqld. I would like to suggest new feature. Make it possible for two mysq

Re: Error: 6 (Errcode: 13)

2001-08-28 Thread Gerald Clark
It means mysql does not have write permission on the sports directory. Grigory Bakunov wrote: > Date |Fri, 24 Aug 2001 14:09:20 -0500 >>From |"Tyler Longren" <[EMAIL PROTECTED]> > > Hello! > > TL> DROP TABLE Track > TL> Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13) > > TL>

Feature suggestion

2001-08-28 Thread Alexander Barkov
Hello! Currently replication is implemented between two mysqld. I would like to suggest new feature. Make it possible for two mysqld to exchange data between each other. For example, MERGE tables distributed between two machines. Question to authors. How do you think, will it ever be implemen

autoincrement

2001-08-28 Thread sean . odonnell
When you have just inserted a record into a table that autoincrements the primary key, is there a way of retrieving the id assigned at the same time? I'm using ASP to write the code in question , and I'm trying to find a better solution that looking at the max key value just before/after in code,

Re: autoincrement

2001-08-28 Thread Ian Barwick
On Tuesday 28 August 2001 13:55, Harald Fuchs wrote: > In article <01082813314101.11299@redgrave>, > > Ian Barwick <[EMAIL PROTECTED]> writes: > > You mean using SELECT LAST_INSERT_ID() ? > > > >> and praying no other query was run at the same > >> time. > > > > Try locking the table for writes ju

Deleted mysql.host Table!

2001-08-28 Thread Steffen Hainke
Hallo, i'm new to mysql. I delete a mysal.host table. Does it means i can't access the rest of my tables in the database? If so, can i rebuild this table or is there another way, to access the rest of the tables? I'am running MySQL under Linux. Thank's for Comment's, Help ... Steffen

Re: autoincrement

2001-08-28 Thread Ian Barwick
On Tuesday 28 August 2001 12:36, [EMAIL PROTECTED] wrote: > When you have just inserted a record into a table that autoincrements the > primary key, > is there a way of retrieving the id assigned at the same time? I'm using > ASP to write the > code in question , and I'm trying to find a better so

query

2001-08-28 Thread muruganandam
for a particular query i have to select data from five tables. can any one suggest me a best way to do that in terms of performace.. thanks in advance muruganandam - Before posting, please check: http://www.mysql.com/manual

Re: MySQL Still a wise choice for developers?

2001-08-28 Thread Ilya Martynov
Let me add my $.02 CHP> A) There's no *point* in keeping the image in the database. CHP> A DBMS is all about searching, comparing, relations, etc. You CHP> get *none* of these by storing the image data in the DB. Sometimes it just easier to store all things in same place. Right now I working on

strange problems with MySQL db

2001-08-28 Thread Wintercom New Media
Hello list. I am having strange problems with my Tables since the partition had been running out of space and mysql crashed. I repaired all the tables and thought it was a success (no errors were detected anymore) but some days later there was an error in another table and I fixed it but the

Problem: MERGE tables for different databases

2001-08-28 Thread Alexander Barkov
HEllo! Is it possible to create a merge table for tables from different databases. I wrote this script for database "collection": CREATE TABLE dict ( url_id int(11) DEFAULT '0' NOT NULL,

autoincrement

2001-08-28 Thread sean . odonnell
When you have just inserted a record into a table that autoincrements the primary key, is there a way of retrieving the id assigned at the same time? I'm using ASP to write the code in question , and I'm trying to find a better solution that looking at the max key value just before/after in code,

Re: Equivalent as UNION (Oracle)

2001-08-28 Thread Rafal Jank
Järkeborn Joacim wrote: > > Hi, > > We have Oracle SQL statements that uses UNION is there an equivalent for this in >mySQL? Not yet. It should be in version 4.0 -- _/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://

More info

2001-08-28 Thread Alexander Barkov
Sorry, It was a little mistake in my previous letter. "mysqladmin create databases" does not output any error messages, however it does not create database "databases". However, "mysqladmin drop databases" produce this: /usr/local/mysql/etc/ access.grant > mysqladmin drop databases Dropping

SQL syntax near 'IDENTIFIED BY'...

2001-08-28 Thread Alexander Barkov
Hello! These query produces an SQL syntax error in 3.23.29a-gamma: GRANT ALL PRIVILEGES ON databases.* TO 'foo'@'localhost' IDENTIFIED BY 'bar'; SHOW TABLES FROM databases; Probably this is because of "databases" is a keyword. However, mysqladmin does allow to create database 'database

Re: ezmlm response

2001-08-28 Thread Ute Hoffmann
>Hi all, >I work with mysql 3.23.40 on Mac Os X 10.0.x and have created a Database. >This Database has to move to another mysql server 3.23.40 on a Mac OS X >Server. In older versions (up to 3.23.39 I think) it was sufficient to >create an empty database on the destination machine and just copy a

Equivalent as UNION (Oracle)

2001-08-28 Thread Järkeborn Joacim
Hi, We have Oracle SQL statements that uses UNION is there an equivalent for this in mySQL? // Jocke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the li

Re: MySQL and GPL license: questions and discussion

2001-08-28 Thread Sinisa Milivojevic
Neil Zanella writes: > > > 1. What was the name of the first GPL file release of MySQL? 3.23.xx > 2. Which portions are not distributed by mysql.com as part of MySQL? All are. > 3. Which portions of the Windows MySQL release >are not released under the GPL if any? For instance is the >

Re: Max table size in MySQL on Redhat 7.0 be default

2001-08-28 Thread Grigory Bakunov
Date |Fri, 24 Aug 2001 10:29:53 -0700 >From |"Benjamin Arai" <[EMAIL PROTECTED]> Hello! BA> What is the maximum table size allowed by MySQL and Redhat 7.0 be default? BA> Benjamin Arai Read about it here: http://www.mysql.com/doc/T/a/Table_size.html

Re: Error: 6 (Errcode: 13)

2001-08-28 Thread Grigory Bakunov
Date |Fri, 24 Aug 2001 14:09:20 -0500 >From |"Tyler Longren" <[EMAIL PROTECTED]> Hello! TL> DROP TABLE Track TL> Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13) TL> Anyone know what that means? As you can see, it came from tryign to do a TL> DROP on a table. TL> Thanks, TL> T

Re: ERROR: Lost connection to MySQL server during query

2001-08-28 Thread Grigory Bakunov
Date |Fri, 24 Aug 2001 14:08:43 -0400 (EDT) >From |boulat <[EMAIL PROTECTED]> Hello! B> Hi group, B> Im using the latest mySQL 3.23.41, ever since I installed the new B> version I've been getting "Lost connection to MySQL server during query" B> 50% of the time on my mySQL server. I have a lo

Re: unique()

2001-08-28 Thread Grigory Bakunov
Date |Sat, 25 Aug 2001 00:24:07 +0200 >From |"Boaz Yahav" <[EMAIL PROTECTED]> Hello! BY> Hi BY> I have a table with a filed that is unique (used unique() in the BY> creation). BY> how do I undo this unique()? unique is an index property. Just remove them by ALTER TABLE command http://www.mysql

RE: Need info

2001-08-28 Thread Simon Green
Hi Nilesh MySQL is very fast but has not got all the things SQL can have (this is for speed). So we use it for web sites and for authenticating users over radius. Simon -Original Message- From: Nilesh Keshavji Parmar [mailto:[EMAIL PROTECTED]] Sent: 28 August 2001 09:05 To: [EMAIL PROTEC

Need info

2001-08-28 Thread Nilesh Keshavji Parmar
Hello Everybody :-) Well, I just suscribed to the mailing lists and would like to know a few more things about mysql. I have heard a lot about it and i think i will enjoy learning it a lot. I would be glad if anyone could care answering to my query. what is mysql most usefull for ,i mean

Help with blobs

2001-08-28 Thread Doug
Hi All, can someone point me in the right direction for saving formatted RichEdit Text to a blob field and then loading the RichEdit field with the data from the blob. I am using Borland Builder 5 odbc to MySQL database. Regards Doug [EMAIL PROTECTED] --

Re: Need Help Setting Up MySQL on Win98

2001-08-28 Thread Grigory Bakunov
Date |Mon, 27 Aug 2001 12:54:25 -0700 (PDT) >From |S K Bryan <[EMAIL PROTECTED]> Hello! SKB> Hello - SKB> I'm very new at this, so please pardon the very beginner questions... SKB> I'm attemtping to install MySQL to my local machine running Win98. The SKB> install seems to go alright, but when

Updating auto_increment ID Column/Selecting Duplicate Rows

2001-08-28 Thread Tom Churm
hi, i have 2 questions that i badly need answered. i use phpmyadmin, but any answers containing SQL syntax should work in this app... 1) this should be simple but i don't know it. i use the following mysql table field as the Key for my tables: "id int(10) unsigned NOT NULL auto_increment,"