MyODBC on AIX 4.3.3

I was wondering whether somebody on this list has successfully installed MyODBC on AIX 4.3.3. I tried it today using the 3.51 binaries and could not get it to work with either the latest iODBC or unixODBC driver manager. I someone has experience I happy to post more detailed error messages. Thanks

Locks on Heap tables

hing. Even googling didn't bring anything useful up. Hopefully someone got some ideas to solve this problem :-) Thank you in advance Hannes Rohde ¯ incoWEB.de - agentur für neue medien Stapenhorststr. 10 D-45329 Essen [EMAIL PROTECTED] <mailto:[EMAI

AW: Locks on Heap tables

-------- -+ Herzliche Grüße Hannes Rohde ¯ incoWEB.de - agentur für neue medien Stapenhorststr. 10 D-45329 Essen [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> http://www.incoWEB.de Phone & Fax 0700-0-4626932 0700-0-INCO

Slow Replication

= 1M query_cache_type = 2 max_connections=900 innodb_data_file_path=ibdata1:2G:autoextend innodb_buffer_pool_size=1200M innodb_additional_mem_pool_size=20M P.S.: I hope I have given you enough information - it's my post on the list...;-) I appreciate your help, Hannes Rohde --

AW: Slow Replication

nk it wouldn't speed up the SQL thread on the slave a whole lot. It would be excellent if you could run two or more SQL threads on the slave you priories them somehow. Anyway I will try your last paragraph's suggestion. Thanks, Hannes -Ursprüngliche Nachricht- Von: Marc

AW: Slow Replication

s the master is? In this case we are talking about one replicated database on a dedicated slave system. Thanks, Hannes -Ursprüngliche Nachricht- Von: Mechain Marc [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 10. Februar 2005 12:04 An: Hannes Rohde; Marc Slemko Cc: mysql@lists.mysql.com Be

AW: AW: Slow Replication

Master or slave status information basically showed that the I/O Thread has been up to date and the SQL Thread of the slave lagged. Thank you, Hannes Rohde -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 10. Februar 2005 13:15 An: [EMAIL PROTE

Remote connection: "Lost connection to MySQL server during query"

When I run the "mysql" command locally on the server I'd like to connect to, everythings fine. MySQL seems to be able to connect to the other machine and the query is started, but the error says it failed "during query"... Thanks a lot for any hints! Cheers, Hannes. -

Re: HELP NEEDED: Problems with SELECT in combination with HAVING

air. If I got this wrong forgive me it was first thing in the morning. Hannes On 6/26/01 4:05 AM, "Thomas Michael Koch" <[EMAIL PROTECTED]> wrote: > Hello there - I have this weird problem using MySql (version 3.23.39). > > It seems that MySql interpretation of a SELE

Re: Odd problem issueing commands at the console

Could it be that you have two mysql client binaries accessing two different config files - some remainders of a previous MySQL installation? Hannes On 6/26/01 9:02 AM, "Peter Matulis" <[EMAIL PROTECTED]> wrote: > Just installed 3.23.37 on Red Hat 7.0 from source. I've

Re: DISTINCT

2, field_3; table_distinct_records field_1 field_2 field_3 a b c a b d f g h d j k k i o Got the idea? Hope that helps Hannes On 6/26/01 4:00 AM, "tom harrow" <[EMAIL PROTECTED]> wrote: > Hi Hann

Re: Creating Table with a Default Datetime field

Sorry, for quoting the manual but this might be just another example where it could have the answer right away: Hannes http://www.mysql.com/doc/D/A/DATETIME.html > The TIMESTAMP column type provides a type that you can use to automatically > mark INSERT or UPDATE operations with the c

Re: DISTINCT

ique combination (so you could assign a combined primary key from those columns). But you are certainly right that this is not needed if you don't need the feature to access the differences created by extra fields among these identical tuples by using count(), max(), min() and so on. Cheers H

Re: HELP NEEDED: Problems with SELECT in combination with HAVING

Thomas You might want to consider to post a sample select from the table, some things become apparent just then. Hannes On 6/27/01 3:35 AM, "Thomas Michael Koch" <[EMAIL PROTECTED]> wrote: > Hey Hans - it didn't work (damn) but thank you for your reply and sorry >

Re: select query for duplicate records

S/E/SELECT.html Hannes On 6/27/01 1:13 PM, "Pete Kuczynski" <[EMAIL PROTECTED]> wrote: > Hi, > How would a word a select statment, to search a database for duplicate > entries in one field. > > For example, the fields: device, hostname, IP, comments > > I w

Update based on subselect

hannes - 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 &

Mac OS X MySQL GUI

Has anybody successfully compiled MySQL GUI on the Mac OS X platform (or rather Darwin)? Hannes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Update table using regular expressions MySQL

bar WHERE field = $foo; Any ideas? Help greatly appreciated. Hannes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request th

Re: Update table using regular expressions MySQL

Thanks Karel, This worked almost out of the box, just needed to find out that 'len+1' has to be replaced with the actual number and is not automatically set (like len = length('CONSTANT%'). But the manual also explains this very well, I just didn't think of substring.

Re: Copy table structure to another database?

. Although there might well be smarter methods out there. Hannes On 7/4/01 8:19 AM, "Graham Nichols" <[EMAIL PROTECTED]> wrote: > Hi, > > Can I copy a table (structure only) to another database? I've searched > though my manuals without success s

Lost connection

e for you input Hannes - 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 unsubs

Re: Lost connection

Jul 26 14:13 genpept_sequence_protein_lostconnection.frm But as you all pointed out one should not bet on it. Thanks for your input Hannes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Parsing text file into mysql database.

your goal. Hannes On 7/28/01 10:46 AM, "Kit Kerbel" <[EMAIL PROTECTED]> wrote: > Hello, > I was wondering if anyone could give any advice on how to go about parsing a > plain text file into a mysql database. I have a class Roster table that I > need to parse a tex

Re: Parsing text file into mysql database.

of the preceding expression 10) + = 1 or any number of the preceding expression 11) ^ = start of the line: $ end of the line 12) . = any character except a new line (\n) 13) # = comment I hope that gets you started. Hannes And remember clicking just the reply button in response to messages from the

Re: double quotes and single quotes

. > > How to override the problem ?? > > Thank you > > Eric Chan You could escape the the double quotes before sending them to mysql like so: $formdata =~ s/"/\"/sg; #this is valid for perl Hope that helps. Hannes -

Re: Cannot change column type from varchar(32) to char(32)

-length columns and reverts the changed column back to VARCHAR to save space. To deal with this, change all the VARCHAR columns at the same time:... ALTER TABLE branch MODIFY codebase CHAR(32) NOT NULL DEFAULT 'Ipriori', MODIFY other_varcharfield CHAR(?) ; Hope that helps Hanne

JDBC - Access denied (was Cannot change column type fromvarchar(32) to char(32))

ost might be deleted by readers who could heave helped you, but looking only at the subject line. I created it for you and I hope there is a quick answer to your problem from the experts on this list. Hannes - Befor

Very (excruciatingly) slow select

Hi List, I'm new to the list and I have a BrainTeaser for all of you. I have yet lots to learn about sql and mySQL so any suggestions are very welcome! Thanx in advance Hannes I have following select over a Database that I cannot setup myself, but have to take on as is: S

Re: MySQL Port number

ven't found much on > the subject. Thanks for your input. > > Gene Sanborn > Standard port is 3306 Hope that helps Hannes - Before posting, please check: http://www.mysql.com/manual.php (the manual) h

Select query

| | length | int(10) unsigned | | | 0 | | | mol_wt | float(10,2) | YES | | 0.00| | +-+--+--+-+-+---+ Thank you Hannes - Before pos

Re: Select query

;; Ok, I should have mentioned that I tried the quotes. I am running out of ideas. Hannes mysql> select sequence_id, mol_wt from sequence_protein limit 1; +-+--+ | sequence_id | mol_wt | +-+--+ | 100368 | 53211.62 | +-+--+ 1 ro

Re: Select query

= > FreeSQL.org offering free database hosting to developers > Visit http://www.freesql.org > > - Original Message - > From: "Hannes Niedner" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Th

Re: No identical entries in a field

nfo? > > Jari Mäkelä > How about creating a unique index for that field? Details in the manual. Good luck Hannes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.co

Interupting client-server-link during longlasting queries

mysqladmin which doesn' give me any clue how long I still have to wait. Comments appreciated Hannes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Re: Interupting client-server-link during longlasting queries

uery being completed after quitting the client. Hannes - 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 <

Perl DBI Error 19

delighted to learn about. Thanks Hannes -snippet- #issue query $sth = $dbh->prepare ( "SELECT primary_id, other_id FROM merge ORDER BY

Re: DISTINCT AND NON DISTINCT

t(*)>1; Hope that helps. (BTW, you can also combine fields, but they have to appear in the 'select' and in the 'group by' part. More in the really good manual). I hope that accomplishes what you wanted. Hannes ---

Re: Perl DBI Error 19 -solved

Just if somebody is interested: I solved the mystery with Error 19. All I needed to do was introducing a second statement handle for the update query. (BTW, the script runs probably faster using '$sth = $dbh->do' instead of '$sth = $dbh->prepare', followed by '

Best MYSQL for MaxOSX Server 10.2.2

I am planning on setting up mysql server on a Mac OS 10.2.2 Server running on a Xserve machine. It will be a development system for now, but I still want end up with a good usability status. The server will run Perl, PHP, Apache/Tomcat, Mysql to start with. Are there any recommendations or experie

Re: Best MYSQL for MaxOSX Server 10.2.2

On 11/22/02 4:32 AM, "Stu Duncan" <[EMAIL PROTECTED]> wrote: > Try going to > http://www.entropy.ch/software/macosx/mysql/ > It's the best Mac MySQL reference around (but seems to be down this > Friday AM). I've used version 3.23.52-entropy.ch on a low bandwidth > website with no problems at all.

Re: MySQL subquery that works

On 11/24/02 4:30 PM, "Bruno Batarelo" <[EMAIL PROTECTED]> wrote: > The question is what does Access do in order to perform subqueries on MySQL > via MyODBC driver since it is obvious that they work? What can I do, but I > do not want to use access database as a layer between my application and > m

Re: Mysql db create error

On 11/27/02 1:24 PM, "Tim V" <[EMAIL PROTECTED]> wrote: > I am trying to create a new db in phpmyadmin with > MySQL 3.23.53a running on localhost. > > > SQL-query : > > CREATE DATABASE `` gulf `` > > MySQL said: > > > You have an error in your SQL syntax near 'gulf``' at > line 1 > > >

Re: CREATE TABLE and CHECK clausole

Maybe it's just to late for me to think clearly but there are NO INTEGERS between 0 and 1, try FLOAT or DECIMAL. Best/h On 12/3/02 1:08 AM, "Achille M. Luongo" <[EMAIL PROTECTED]> wrote: > Dear subscribers, > > MySQL seems to support the CHECK() clausole in the implementation of CREATE > TABLE

Re: CREATE TABLE and CHECK clausole

NTEGER (alias INT) data type is supported. > > Thanks in advance for any other suggestion. > > Achille. > > "R. Hannes Niedner" wrote: >> >> Maybe it's just to late for me to think clearly but there are NO INTEGERS >> between 0 and 1, try FLOAT or D

Re: Installing MySQL on Jaguar?

On 12/3/02 11:37 PM, "Brian Radford" <[EMAIL PROTECTED]> wrote: > Hello all, > > Could someone be so kind and share with this newbie where he might find > crystal clear step-by-step instructions on how to install MySQL v3.23 > on Mac OS X 2.2. I've looked through the manual and all I could find >

Re: mysql port number

On 12/4/02 9:04 AM, "Mike At Spy" <[EMAIL PROTECTED]> wrote: > > How can I tell what port number mysql is running on? I need it for a chat > program. :) > > Thanks, > > -Mike > Default is 3306 /h - Before posting, plea

Re: alter table syntax

ALTER TABLE town_db1 DROP PRIMARY KEY; ALTER TABLE town_db1 ADD PRIMARY KEY(town, subcity ); On 12/5/02 10:31 PM, "kayamboo" <[EMAIL PROTECTED]> wrote: > sql, mysql, query > > Hello folks > > This is my table structure with MySql 4.0.3-beta-max-nt with InnoDB > > +-+--+

Re: Can MySQL handle 120 million records? - Impressive! How doyou guys do that?

On 12/18/02 9:48 AM, "Qunfeng Dong" <[EMAIL PROTECTED]> wrote: > But I am indeed seeing > not-so-good performance (join on tables much smaller > than yours takes minutes even using index) and I seem > to read all the docs I could find on the web about how > to optimize but they are not working for

FW: Can MySQL handle 120 million records? - Impressive! How doyou guys do that?

-- Forwarded Message From: Joseph D <[EMAIL PROTECTED]> Date: Wed, 18 Dec 2002 13:55:47 -0800 (PST) To: "R. Hannes Niedner" <[EMAIL PROTECTED]> Subject: Re: Can MySQL handle 120 million records? - Impressive! How do you guys do that? thanks i actually can't pos

To join or not to join

I am looking for an expert opinion on the speed difference between fetching related data from 2 tables with a join and fetching them in to single selects. The scenario is kind of the following: SELECT a , b, c FROM table1 WHERE a='x'; # gets b='y' SELECT b, d , e, f FROM table2 WHERE b='y'; inst

Joins are slow?

Scott Ambler recommends in his publication " Mapping Objects to Relational Databases" not to do joins but to traverse tables. He claims that 'several small accesses are usually more efficient than one big join'. Is that true for mysql? I am particularly interested in a scenario where I would retrie

Re: An Idea

On 12/31/02 8:11 PM, "JamesD" <[EMAIL PROTECTED]> wrote: > lists work, and faq's work, some like to call...etc. > personally, I'd prefer a search engine style... > like google, but only for mySQL topics, and with > a visible list of most popular search terms. > > something that can be based upon

Re: user/root

On 1/1/03 2:31 PM, "Richard Nagle" <[EMAIL PROTECTED]> wrote: > Well after 3 times installing mysql, finally > got it working (tks to those whom help) > now I need to take care of user and root. > first root. > > mysql> mysql -u root mysql > > just want to confirm this is correct before I push e

Re: host.frm

On 1/1/03 8:43 PM, "Jason Steig" <[EMAIL PROTECTED]> wrote: > > ./myqld: Can't find file : './mysql/host.frm' (errno:13) > > does anyone know how to solve this problem? This file is part of the host table in your mysql database 'mysql'. Did you by any chance copy the mysql data directory or par

Re: user/root

On 1/1/03 5:46 PM, "Richard Nagle" <[EMAIL PROTECTED]> wrote: > Well it would appear that I finally have a connection Congrats. > q. since I am root, do I still need to GRANT a database to myself? > or just a to a new user. aka: bob@localhost If you are the only person using the computer that t

Re: host.frm

From that > and my experiences, we're looking at a permissions issue. Hannes needs to > look at the permissions on his data and logging directories to make sure > that they are set to the default mysql:mysql. > > -Original Message- > From: R. Hannes Niedner [mailto:[EMAIL PROT

Re: converting text to hypertext

On 1/8/03 8:34 AM, "Rick Tucker" <[EMAIL PROTECTED]> wrote: > I just imported a .csv file and one of the columns of data was websites > addresses. Those addresses aren't being recognized as links when I output > an html table from my queries. I'm scratching me head on how to make the > conversio

Re: converting text to hypertext

On 1/8/03 8:34 AM, "Rick Tucker" <[EMAIL PROTECTED]> wrote: > I just imported a .csv file and one of the columns of data was websites > addresses. Those addresses aren't being recognized as links when I output > an html table from my queries. I'm scratching me head on how to make the > conversio

Re: mySQL, TCP/IP, Mac OS X --- HELP PLEASE !

On 1/20/03 6:18 AM, "Ram Kumar" <[EMAIL PROTECTED]> wrote: > greetings > > can anyone help to get mySQL on Mac OS X (entropy pkg), work on TCP/IP > rather than unix socket, please ? > > Is Marc Liyanage on this list ? > > regards, ram I don't know if Mark is on the list, but I might have some

Re: Mac OS X 10.1 build

If you download the binary, there is nothing to compile. Just follow the instructions in the file INSTALL_BINARY and you are ready to go. I did the same on 10.2.2 server and it worked great. Hth/h On 1/20/03 2:21 PM, "James LaFountain" <[EMAIL PROTECTED]> wrote: > > > I've been trying to compi

Why does mysqld_safe look for mysqld in libexec

Iwhat am I doing wrong: After downloading the binary for mysql 4.09-max for Mac OS 10.2 safe_mysql complains: % sudo bin/mysqld_safe The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as

Re: sql query using select and row functions

On 1/28/03 8:26 AM, "Christopher Lyon" <[EMAIL PROTECTED]> wrote: > I am trying to do an sql query and am trying to select the last x rows > from the database. I see the limit function but that seems like that is > from the first row down. I want to start from the last row to the first > row. So,

Re: sql query using select and row functions

tention. > >> -Original Message- >> From: R. Hannes Niedner [mailto:[EMAIL PROTECTED]] >> Sent: Tuesday, January 28, 2003 11:50 AM >> To: Christopher Lyon; MySQL Mailinglist >> Subject: Re: sql query using select and row functions >> >> On

Re: cannot access mysql and see privileges

On 1/28/03 3:42 PM, "Jon Miller" <[EMAIL PROTECTED]> wrote: > Warning: Access denied for user: 'root@localhost' (Using password: NO) > in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255 > > Warning: MySQL Connection Failed: Access denied for user: > 'root@localhost' (Using password: NO) in > /v

Re: Recovery in MySql

On 1/29/03 5:13 AM, "Inbal Ovadia" <[EMAIL PROTECTED]> wrote: > Hi All, > I have MySql on Windows. > Today i had an electrical power interruption in the middle of working. > The database remain not consistent and i could not continue working with it. > > Is there any Recovery after crash mechanis

Fulltext Index

If I create a FULLTEXT index for 2 or more columns in a table will I be able to use it for a MATCH only against a single column (of the above) or do I have to create additional FULLTEXT indices for each of these columns? Thanks/h sql,query,queries,smallint --

Re: Fulltext Index

Restrictions.html > > > On Thu, 2003-01-30 at 21:40, R. Hannes Niedner wrote: >> If I create a FULLTEXT index for 2 or more columns in a table will I be able >> to use it for a MATCH only against a single column (of the above) or do I >> have to create additional FULLTE

Re: CREATE TABLE, NOT NULL fields, and empty strings

On 2/6/03 9:05 AM, "Doug Beyer" <[EMAIL PROTECTED]> wrote: > I attempted to search various places for my answer but with no luck. So I'm > posting here. > > > > I create the following table: > > create table t1 ( id varchar(5) not null, name varchar(5) not null ); > > > I insert the followin

Re: MySQL book TOC

On 2/7/03 2:20 AM, "Vikram Vaswani" <[EMAIL PROTECTED]> wrote: > Hello all, > > My name is Vikram Vaswani, and I'm currently working on the outline for a > MySQL reference book. This is supposed to be a comprehensive reference to > MySQL 4, covering all aspects of the software, including the new

Re: multiple simultaneous DBI connections?

On 3/13/03 6:47 AM, "Tom Norwood" <[EMAIL PROTECTED]> wrote: > I am currently looking at building a Perl object to handle data from a > a database. > I'm not really sure if it is best to have one connection to MySQL and > let the object just deal with its own properties. > Or to allow the object t

Re: Newbie Question

On 3/14/03 9:31 AM, "Paul DuBois" <[EMAIL PROTECTED]> wrote: > At 8:04 -0800 3/14/03, Thomas Knight wrote: >> How do I change Mysql default database location? > > Please explain what you mean by that? Maybe you need to look at the commandline options or the my.cnf files. You can specify the data

Re: mysqladmin processlist = weird in version 4.0.12

The change log for 4.012 mentions (Lenz Grimmer just posted this a couple of messages ago): Functionality added or changed: * `SHOW PROCESSLIST' will now include the client TCP port after the hostname to make it easier to know from which client the request originated. I guess whenever th

Re: Allowing a user to change their password

That is all ok but what do you suggest? Row level privileges are not available in MySQL (yet). Or did I miss something? Cheers/h On 3/24/03 12:18 PM, "Shawn P. Garbett" <[EMAIL PROTECTED]> wrote: > On 3/24/03 10:37 AM, "R. Hannes Niedner" <[EMAIL PROTECTED]> w

Re: MySQL: Selecting a patricular row

On 3/29/03 7:55 AM, "Marc Bakker" <[EMAIL PROTECTED]> wrote: > Hello, > I am working on a PHP/MySQL/Apache website. I have a MySQL table with 5 > rows. I want to select a patricular row using it's absolute row number. How > can I do this? I found mysql_row_seek() n te MySQL docs but this requires

Re: MySQL and UPDATE query

On 11/9/02 3:01 AM, "Bruno Batarelo" <[EMAIL PROTECTED]> wrote: > Greetings > > I have problems executing very simple UPDATE query. I do not know whether it > is a bug or not, but it works in Access and also works with mySQL, but only > from access using linked tables. > Query is as followes: > >

Re: little problem, I need some help...

On 11/9/02 3:14 PM, "3mip1s4la-Emilio Pisanty" <[EMAIL PROTECTED]> wrote: > hello everyone: > > to begin with, I apologise for asking a question which is probably > obvious. My name is Emilio Pisanty and I and one of the two makers of my > school's website. recently we updated the database system

Re: PHP bias

On 11/10/02 5:12 AM, "Robert Macwange" <[EMAIL PROTECTED]> wrote: > I am bothers me. > It bothers me that that the MySQL people have a bias towards PHP. > PHP is an inferior language. Deal with perl instead. > > > Robert Ouch.Death to all fanatics!!! Do you have

Re: PHP bias Stop feeding the troll

On 11/9/02 11:31 PM, "Georg Richter" <[EMAIL PROTECTED]> wrote: > Looks like you're not very familar with the spirit of Open Source: > > Perl, PHP, Python, Ruby etc. are very excellent languages. They all have > benefits and of course some disadvantages. But this competition helps each > one to i

Re: PHP bias

On 11/9/02 11:04 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote: > I agree. It's really a drag that you can't use databases very well from > within Perl very easily. I wish that someone would invent a database > inferface for Perl. And it'd be really cool if they'd do it in such > a way that the g

Re: PHP bias

On 11/9/02 11:04 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote: > I agree. It's really a drag that you can't use databases very well from > within Perl very easily. I wish that someone would invent a database > inferface for Perl. And it'd be really cool if they'd do it in such > a way that the g

Re: Problem with MySQL-GUI

On 11/10/02 1:50 PM, "Allan J Horwitz" <[EMAIL PROTECTED]> wrote: > Hi there -- I'm relatively new to LINUX (I have RedHat 8.0 on my system) > and I just downloaded MySQL-GUI and can't seem to get it working. It > keeps telling me that it cannot connect through the socket (111). Can > someone te

Re: Problem with MySQL-GUI

On 11/10/02 9:14 PM, "daniel" <[EMAIL PROTECTED]> wrote: > running on localhost using the socket connection (as supposed to > tcp/ip ). > > what are you saying that mysql can connect another way other than through > mysql.sock ? If I am not mistaken the socket works only for a connection between

Re: Problem with MySQL-GUI

On 11/10/02 9:42 PM, "daniel" <[EMAIL PROTECTED]> wrote: > i've made connections to a remote mysql from one server to our main one and > the main one is running socket connections ? I guess I lost you. All I wanted to say is this: If you run mysql (client) and mysqld (server) on the same compute

Re: access denied

On 11/11/02 9:10 AM, "Inbal Ovadia" <[EMAIL PROTECTED]> wrote: > Hi all > I am working with mysql, in windows, visual c++. > I am trying to run this query from c++ program: > > select * into outfile 'table_name.txt' FIELDS TERMINATED BY '\t' ESCAPED BY > '\0' LINES TERMINATED BY '\r' from table_n

Re: S.O.S. with mysql

On 11/11/02 9:26 AM, "Victoria Meza" <[EMAIL PROTECTED]> wrote: > I've a problem whit some tables in mysql, you know how repair damages > tables? > this is the message error: > Didn't find any fields in table 'criterios_evaluacion' > Didn't find any fields in table 'mensaje' > Didn't find any fiel

Re: How to link tables in MySQL

On 11/12/02 12:41 PM, "tmb" <[EMAIL PROTECTED]> wrote: > 2 - In MS Access you have to graphically connect the > table id fields to tell Access how the tables relate. > > How do you do this In MySQL... from the command line > I'm sure... just a code snippit or reference to one > would be nice...

Re: Impossible SQL ???

On 11/12/02 12:43 PM, "Charlie" <[EMAIL PROTECTED]> wrote: > I can't seem to come up with a solution to the following SQL query, and have > a project dependent on a solution. I'd rather not load the whole database > and then parse it in the code. > > With the following Database structure: > Field

Re: Count Rows in two tables

On 11/12/02 5:36 PM, "Alan McDonald" <[EMAIL PROTECTED]> wrote: > You can't count the join? > Alan >> >> Hello all, >> >> Does anybody have a SQL string to count the rows in two different >> tables and >> give you a total number of rows? I have been trying to find an >> answer for a >> couple of

Re: Problems

On 11/12/02 7:05 PM, "Daniel Griggs" <[EMAIL PROTECTED]> wrote: > Hi there, > > I am having trouble with connecting to a Mysql host, the host version is > 3.23.51 on debian stable. After countless re- > reads of the documentation and checking the permissions all I get when I try > to connect rega

Re: support table synonyms?

On 11/12/02 8:59 PM, "Phillip Rhodes" <[EMAIL PROTECTED]> wrote: > I can not find anywhere that says that mysql supports table name synonyms. > > For example, I have two databases (test1 and test2) in the same mysql > instance. > > In test1 schema, there is a table called "table1" > > I would l

Error on Mysql Doc website

I try to access thesearchable documentation with user comments: And get: Forbidden You don't have permission to access /doc/en/index.html on this server. Apache/1.3.26 Server at www

TIMESTAMP

W if I try an INSERT with the same data (1 row of the file) everything is fine. Thanks Hannes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list