RE: Generic questions

Andrzej, As I understand it, MySQL does not have the concept of tablespaces like in Oracle. Databases are subdirectories underneath the /var/lib/mysql directory and files are tables within those subdirectories, so you can put an entire database or individual files on a different disk by

Re: 64MB Limit on MyISAM indexes?

Hi, I'm having that same problem, but I only have about 1.3 million rows in my table, and the size is only about 190MB or so. This started with 3.23.21 (Which had this problem, look in the changelog), but it is also continuing after upgrading to 3.23.36. I have a 3.23.36 slave that is

Problem in connecting to mysql using perl

Dear Sir, I have downloaded DBI-1.15. I tried installing it. The tests failed. I am using PMAKE to prepare an install program. The error is as follows: can't locate loadable object for module DBI in @INC. I am also providing you with the procedure i adopted to install DBI

Re: complicated query

try ORDER BY (Category = 'Other'), Category, Subcategory It should work, (I hope ^_-;;;) - Original Message - From: Jeff Shipman - SysProg [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 20, 2001 8:38 PM Subject: complicated query I would like to do something similar to an

Re: Every host is localhost

I don't exactly understand your problem but I think you want to secure access to a certain part of your webserver instead of our your MySQL server. If you are running apache you can secure complete directories with .htaccess files. On Wed, 18 Apr 2001, Sam Yenge wrote: Hi (Re: mysql

MySQL On Unix

Dear Gents, I would like to access MySQL database running on Unix from a Windows workstation through ODBC. IS it possible? Can you give me a tip how to do that? Thanks a lot for your help! Regards Janos Borbely - Before

Need help with 23.36

I copied my database files made with 23.29 to 23.26 and now I get this. I chowned mysql.mysql and chmoded 660. What's wrong? mysql use lumina; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any

RE: MySQL On Unix

Hi, You must install MyODBC in your Unix system, and the MyODBC module for windows. Once it is done, make a new connection trought this module whit de ODBC default fort, the machine name, user, pass and database. It was all I did and it worked correctly Javier

Selection bug in 3.23.37

HI, I have the following table: desc keywords_news; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | id_keyword | int(11) | | PRI | 0 | | |

Need help with 23.36

I copied my database files made with 23.29 to 23.26 and now I get this. I chowned mysql.mysql and chmoded 660. What's wrong? mysql use lumina; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any

Re: Connecting to mysql as root

For connecting I have given the user as root and no password in the PERL scipt. You NEED to provide the password otherwise you can't get any data out of the database.. If you didn't entered a password for the mysql root user you need to do it ASAP.. Is there any way to connect to

Re: Need help with 23.36

I copied my database files made with 23.29 to 23.26 and now I get this. I chowned mysql.mysql and chmoded 660. What's wrong? Perhaps or.. the location of your database is different.. or.. you didn't copy everything.. including subdirectories. Solution: check the location and if you copied

Berkely DB

Hi there I am trying to find out how the Berkely DB stuff works when running MYSQL on windows. How do I create a transactional table? Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Cell (083) 262-9163 Office (031)

Re: Src distribution of MySQL takes up a lot of space

I'm new to MySQL and I've recently installed MySQL (MySQL-3.23.36-1.src.rpm) and it's running ok. But, I noticed that it seems to be consuming so much of my hard disk space. Is this normal? I'm wondering if anyone encountered this problem before or can advise wat I can do abt it? I don't know

Complicated Query...

Hi there, I'm having a problem on my complicated query. My question is similar to the question in a couple of emails earlier in this mailing list which subject's is complicated query. I got 3 tables below. test1 table ++--+ | id | name | ++--+ | 1 | fumi | | 2 | ali | | 3 |

I need help to instal mysql

First of all sorry for my English, I hope it would be good enougth to be understood. I am trying to instal mysql on a digital unix os. First I had problem with the ./configure it prompted this message checking for cc++... no checking for cl... no checking whether the C++ compiler (gcc )

Strange output from EXPLAIN SELECT - explanation needed!

Hi all, I was just fiddling around with some indexes on a table and decided to do an EXPLAIN for a query I was trying to optimize. I got a peculiar message output, and I'm not sure what it's trying to tell me! This is what I got: mysql explain select min(impression), max(impression) from

Re: Offtopic: Anybody from London?

[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 If you just reply to this message, and include the entire

Criteria in the GRANT command

Greetings, and I'm sorry if this is a topic that's already been covered, but I've read over about 100 of the past mails and can't find something similar. How do I GRANT UPDATE to specific columns in specific records? Example: I've got a table u which covers complete data on each user for the

Re: compress problem when using MySQL++

William Dan Terry writes: When you say the bug is in the linker, do you mean in the linker app itself or how I'm using it? In terms of the static zlib, don't I have that covered with gcc -static metamgrd.o sock.o cfgfile.o cfgitem.o err.o -o ./metamgrd \ -lstdc++ -L/usr/lib/mysql -lz

Re: auto_increment dissapearing

ryc writes: I have a auto increment field in a table and after doing a few operations the flag has gone away. This is using mysql 3.23.36 on OpenBSD. Here is how it happened: I am using perl with DBI to interface with mysql. I have been inserting NULL into this field to allow mysql to fill

Re: Selection bug in 3.23.37

Nicola Sabbi writes: HI, I have the following table: desc keywords_news; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | id_keyword | int(11) | |

Query problems

Hi I have two similar tables. (table1 table2). They contain the columns name, distance and date. Table1 is year 2000 and Table2 year 2001. I need to get the total distance for each name. For year 2000 I would do this: select name, SUM(distance) from table1 group by name; How do I do it for

Any low budget database access available ???

Hi, I am hoping to find somebody who provides low budget mysql and php access. Thank you very much for any suggestion Andonny - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Random string for each row in a table

Dear All, How do I create random string for each row in a mysql table? and mail the same each recepient in the respective row. Thanks Love and regards Prasad - Before posting, please check: http://www.mysql.com/manual.php

how can i make it?

For example i have 3 tables (really i have to make it with 6 tables, but...) So 3 tables: Table1 uid| name 1user1 2user2 3user3 Table2 iduidc 1150 2123 3142 4223 52303 Table3 idctxt 123'twenty-three' 242

Re: Query problems

Create a merge table of the year 2000 and year 2001 tables as follows. Then run your select on the merged table. You can then drop the merge table if you don't need it anymore. CREATE TABLE table3 (name, distance, date) TYPE=MERGE UNION=(table1,table2); SELECT name, SUM(distance) FROM table3

Re: Need help with 23.36

The location is good because I have some other databases created with 36 and they work fine. I copied ALL the database's files to /var/lib/mysql where the others are and I get this error. Any idea? On Mon, 23 Apr 2001, B. van Ouwerkerk wrote: I copied my database files made with 23.29 to

mysql_install_db problems

Hi folks, Thought I'd see if I have a common problem before I do a bug report. I am trying to install the binary file for HP/UX 10.20 on a HP/UX 10.20 785 series computer. As the error message is about memory problems the following info may be of interest. The tar file is on a volume with

MySQL 3.23.37 Compile Problem

I'm having trouble building the mysql323-server port (3.23.36/7). I am running Freebsd 3.5 on an i386. The build breaks during the sql/share/Makefile with the following error: /bin/sh ../libtool --mode=link c++ -DDBUG_OFF -O -pipe -felide-constructors -fno-rtti -fno-implicit-templates

RE: Query problems

Hi In my opinion I would imagine Merged tables would do what you wanting. Refer to the MYSQL manual. Thanks ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Cell (083) 262-9163 Office (031) 767-0249 -Original Message- From:

Re: how can i make it?

how can i get a recordset constains all records (or records matching a where exp.) from the Table1 with the c values from the Table2, like this: uidnamecs - 1user1'50 - twenty-three - the reason of life' 2user2'twenty-three - 303 rulz' 3user3'' I

Re: Information Technique

Bonjour, J'utile le 'characterset default' de MySQL et je n'ai acune probléme avec mysql. Si'l te plait, donne ça un coup, D'abord on a besoin d'un ligne de commande de mysql liée à le serveur en question. (comme mysql -uusername -pmotdepasse -hhôte.domaine ) You should not need to escape

Any low budget database access available ???

Dear me - me writes: I am hoping to find somebody who provides low budget mysql and php access. Buy yourself a copy of Web Techniques magazine and browse the advertisements. Yours - Billy - Before posting,

Re: mysql_install_db problems

This sounds more like a OS problem then a MySQL problem. I don't know much about HPUX. Bye, B. Hi folks, Thought I'd see if I have a common problem before I do a bug report. I am trying to install the binary file for HP/UX 10.20 on a HP/UX 10.20 785 series computer. As the error message

Maximum number of columns in a table

Hello, Does any of you know how much columns a MySQl table can handle? Is it fixed or does it depends of some parameters (fields' datatypes, RAM, total table size...)? Thanks DELAUNAY Antoine - Before posting, please check:

Re: wildcard in tablesearch

Sven Heising wrote: Hi list, I'am new in this php and mysql-stuff so i need al lil bit support... this is my problem: $result = mysql_query(select * from $dbtable where $wonach like '%$first_name%' ); $wonach is a var which is set in a html form if i want to search one row it

mysql+bdb

I installed mysql 3.23.36 binary version for OpenServer 5.0.5. According to MySql documentation this version supposes to support BDB-tables. But if I try to create Type=BDB tables I get MyIsam. If I look into my variables I see have_bdb = No. How can I get it work? Eugene

Re: Convert varchar to number field

Steve Werby wrote: Martin E. Koss [EMAIL PROTECTED] wrote: I started a table with a varchar filed of 11 characters for a column that would hold data such as 0.27; 11; 0.6; 1; 5; 7.5; 11.2; etc I wasn't sure if a 'number' field would work. Now I want to list the values in this column

Re: how can i make it?

Of course left join. And group by moreover. But how? For the group by i need a sum-like function, which joins the strings. how can i get a recordset constains all records (or records matching a where exp.) from the Table1 with the c values from the Table2, like this: uidnamecs

Deleted user

I've made a stupid error. While logged in as root I was deleting records from the user table. Someone was talking to me while I was entering a command and I didn't realize what I entered until it was too late. I entered: delete from user where user='root'; I immediately used an insert

Probably a bug report

Hi! It looks like I found a strange behaviour of the MySQL (3.23.36 on windows and linux). Probably it's due to my own mistake but I really can't catch what's up. Look: I have two tables linked w/ the 'one-to-many' relation. They look like follows: mysql describe MessageType;

copying datatbase?

I have MYSQL 3.23 and php on a Win2k box running on IIS5. I must copy the database to a Solaris machine that uses php running on Apache. Can you help me on how to handle this issue. Your help would be greatly appreciated, John

Re: multiproz in mysql on FreeBSD?

Hi Tim, and everyone, I am moving this discussion to the main list (since I have questions others might be able to answer. I copied the entire (short) thread so people can catch up. 1) Is there anyone currently running multiple mysqld's on FreeBSD with success? 2) How much is this 'overhead'

Re: how can i make it?

It's a bad habbit to cc to a list. Of course left join. And group by moreover. But how? For the group by i need a sum-like function, which joins the strings. Hmmm, something like concat() you mean? Bye B. mysql, query -

Re: mysql+bdb

Hi Eugene, The binary version do not yet have BDB or Innodb support yet. You will need to compile your own version using --with-berkeley-db in order to use those features. I believe there are notes in the manual on how to compile this for SCO, but I don't know if BDB has been ported to SCO

Re: how can i make it? concat?

It's a bad habbit to cc to a list. Ooops. Sorry. Of course left join. And group by moreover. But how? For the group by i need a sum-like function, which joins the strings. Hmmm, something like concat() you mean? I tried it. Doesn't works. Without group by i have this set: idnamec

Need help with 23.36

Please anyone. I really need some ideas. I copied my database files made with 23.29 to 23.26 and now I get this. I chowned mysql.mysql and chmoded 660. The location of the databases is good because I have some other databases created with 36 and they work fine. I copied ALL the database's files

Problem with corrupted System (internal error 1030:Got error 127 from table handler)

Hi, A client has had some sort of disk failure and several files from one of my projects disappeared or were corrupted along with some system files I have replaced the files from my own backups and have the web/php based interface working again, but I get the following when trying to access

Re: Deleted user

From the very fine manual: http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.htm l#Resetting_permissions - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: jessica [EMAIL PROTECTED]

Re: Need help with 23.36

chown -R mysql /var/lib/mysql New Style MySQL Personnel wrote: The location is good because I have some other databases created with 36 and they work fine. I copied ALL the database's files to /var/lib/mysql where the others are and I get this error. Any idea? On Mon, 23 Apr 2001, B.

RE: Need help with 23.36

Hi, mysql use lumina; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'absences' Didn't find any fields in table 'admins' Didn't find any fields in table 'classes'

Re: I need help to instal mysql

Install gmake. Lana Conan wrote: First of all sorry for my English, I hope it would be good enougth to be understood. I am trying to instal mysql on a digital unix os. First I had problem with the ./configure it prompted this message checking for cc++... no checking for cl... no

Re: Criteria in the GRANT command

You don't. Privileges can be set for a column in a table, but not by record. Mark van Brenk wrote: Greetings, and I'm sorry if this is a topic that's already been covered, but I've read over about 100 of the past mails and can't find something similar. How do I GRANT UPDATE to specific

Re: Query problems

Use merge tables, or two separate queries. Wix,Christian XCW wrote: Hi I have two similar tables. (table1 table2). They contain the columns name, distance and date. Table1 is year 2000 and Table2 year 2001. I need to get the total distance for each name. For year 2000 I would do this:

how do i create mysql-logon.sock?

I was told that i need to create mysql-logon.sock so that mysql will start running - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

nested set trees.

hello lists, i want to use the nested set model to store a tree structure in a database. the normal way i do this looks like this: My table looks something like this: ID LEFT RIGHT NAME 11 14 Root 22 7Thema 1 33 4

Re: Deleted user

Hi! Not sure if this will be useful as well. Searched the MySQL manual and found this page. It mentions a bit about restarting MySQL and resetting the root password. http://www.mysql.com/doc/A/c/Access_denied.html Hope it helps! Sam. - Original Message - From: Ken Menzel

Copy part of a table to a temporary table

I'm looking for a way to create a temporary table containing a sub part of the master table... I know that I can use : CREATE TEMPORARY TABLE tbl_name [(create_definition,...)] [select_statement] but i'm working on a script that must create tables with the same create_definition that the

Re: Random string for each row in a table

Not understanding excactly why you'd need a random string, I'd suggest doing a simple password() call on each row's recipient ALTER TABLE ADD COLUMN rand_string char(16) NOT NULL; UPDATE my_table SET rand_string=password(email); This gives you a 16 char long (I think) random string. Sending

Re: multiproz in mysql on FreeBSD?

On Mon, Apr 23, 2001 at 10:33:48AM -0400, Ken Menzel wrote: Hi Tim, and everyone, I am moving this discussion to the main list (since I have questions others might be able to answer. I copied the entire (short) thread so people can catch up. [snip] Hmmm sounds like fun, I am going to try

[mysql@lists.mysql.com: Re: Re: Copy part of a table to a temporary table]

taxt/plain

Re: Java Example for connection

Hi, I use this code to connect to a mySQL 3.23.36: Connection cnn = null; try { Class.forName(org.gjt.mm.mysql.Driver); cnn = DriverManager.getConnection(jdbc:mysql://server/database, user, password); cnn.setAutoCommit(false); //

Tricky SQL query

Hi, I have a table that keeps track of when certain articles go up on the site. It has a field called featureStart, which is a unix timestamp. The features stay on the site until the next feature replaces them, so there is no featureEnd. If one feature started on Apr 23 and another one is

Re: changing data directory

Marc S. Bragg wrote: How does one redirect mysql to a data directory location different than the default. . . . and if possible, only for a particular database. You can find the 'official' notes on how to relocate tables or entire databases at:

Re: Information Technique

At 01:56 23/04/01 -0700, Van wrote: hassan el forkani wrote: j'ai eu le meme probleme mais en environnement de développement, ce que je sait c'est que ca dépend du characterset de votre base de donnée faut demander à votre hebergeur le characterset (dans les environnement variables) du

Re: multiproz in mysql on FreeBSD?

Load balancing, because I can't run two servers on the same port either! I have to use say 3307, 3308, 3309 and then do at least DNS round robin, what do you think Jeremey? Anybody on your end have a better idea? Doesn't sound to me like the best solution. I have heard of people trying to

Re: Information Technique

Bonjour Hassan, Il y a une liste français du MySQL que je viens de trouver. Peut-être ça t'aide. [EMAIL PROTECTED] En Plus, il y a php-france, envoyez un mail à [EMAIL PROTECTED] Je suis un participant tous les deux. J'espère que je t'y verra! Amicalement, Ken

Re: Error codes

Hello, A few days ago I asked if anyone knows the numeric values of the Mysql error codes. Nobody responded, so I looked through the source code to find the answer. This info would be valuable if, for example, you wanted to programmatically handle certain types of errors. In the source

Berkelely MYSQL

Hi there I have managed to download the Berkeley for Windows installation, however I have noted that MYSQL will not run without a patched version of berkeley's. Where can I obtain such a installation to run on Windows? Kind Regards Warren ~ Warren van der Merwe

Reg. determining version

Hi, When using mysql.h there is defined a: MYSQL_VERSION_ID It's defined as something like: 32235 I guess this is representing version 3.33.35. Is this the 'right' way of determining version? I want to do something like an ifdef to incorporate support in my code for different

Re: mysql+bdb

On Mon, 23 Apr 2001, Eugene Reuter wrote: I installed mysql 3.23.36 binary version for OpenServer 5.0.5. According to MySql documentation this version supposes to support BDB-tables. But if I try to create Type=BDB tables I get MyIsam. If I look into my variables I see have_bdb = No. How can

Re: Reg. determining version

On Mon, Apr 23, 2001 at 08:37:31PM +0100, Aigars Grins wrote: When using mysql.h there is defined a: MYSQL_VERSION_ID It's defined as something like: 32235 I guess this is representing version 3.33.35. Is this the 'right' way of determining version? I want to do something

Re: multiproz in mysql on FreeBSD?

On Mon, Apr 23, 2001 at 02:29:00PM -0400, Ken Menzel wrote: Load balancing, because I can't run two servers on the same port either! Right. I have to use say 3307, 3308, 3309 and then do at least DNS round robin, what do you think Jeremey? DNS round robin on affects hostnames, not port

Re: Information Technique

Ken Menzel wrote: Bonjour Hassan, Il y a une liste français du MySQL que je viens de trouver. Peut-être ça t'aide. [EMAIL PROTECTED] En Plus, il y a php-france, envoyez un mail à [EMAIL PROTECTED] Je suis un participant tous les deux. J'espère que je t'y verra! Amicalement,

Re: Berkelely MYSQL

At 21:28 23/04/01 +0200, Warren van der Merwe wrote: Hi, Hi there I have managed to download the Berkeley for Windows installation, however I have noted that MYSQL will not run without a patched version of berkeley's. Where can I obtain such a installation to run on Windows? Download our source

Re: Error codes

Type perror #error_num at the prompt, you can get what the error codes mean from there. ryan Hello, A few days ago I asked if anyone knows the numeric values of the Mysql error codes. Nobody responded, so I looked through the source code to find the answer. This info would be valuable

Re: Berkelely MYSQL

It will run just fine, you need the patched version if you want transaction support. ryan Hi there I have managed to download the Berkeley for Windows installation, however I have noted that MYSQL will not run without a patched version of berkeley's. Where can I obtain such a installation

how force mysql to use certain indexes

Hi there, I'm using mysql 3.22.27. How can I force mysql to use index's in my select statement? When I use explain to see what the optimiser is doing I see that its using the wrong index. When I try to use the USE INDEX(KEY1,KEY) i get a syntax error. Any ideas Thanks, Pat Pat Militzer

MySQL and php -- How do I force a connection open for a longer period ?

Hello, On a NT4/Apache server, we have a php application that uses the following syntax to open a connection : $connect = mysql_connect($serverhost,$serveruser,$serverpass); mysql_select_db($serverdb,$connect); $mysql_link = $connect; Since we upgraded to the latest version of mysql, the

Re: Re: Reg. determining version

- Original Message - From: [EMAIL PROTECTED] To: Aigars Grins [EMAIL PROTECTED] Sent: Monday, April 23, 2001 10:51 PM Subject: Re: Re: Reg. determining version Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter

MySQL CRASHED after some days with this message in errlog:

Hi, Mysql ran for 6 days.. It is a website with heavy traffic. /usr/libexec/ld-elf.so.1: /usr/local/libexec/mysqld: Undefined symbol strtoull 010423 23:18:08 mysqld restarted /usr/local/libexec/mysqld: ready for connections What is this function

min () - sql troubles

Hi SQL troubles: I have a table containing 4 columns: name - string, distance- double, speed - time and id - AUTO_INCREMENT (Primery key) I want a list of the fastest (speed) runner (name) of each distance and the speed. I use: select name, distance, min(speed) from table1 group by distance; I

Problem Inserting/Updating TEXT Fields

Hi all, I'm new to this list, and would like to post a question. I have a database with one table with a TEXT field where we save HTML files. This table is Updated and Selected from a Servlet Applicacion, using JDBC. Some TEXTs have a size of arround 60Kb. For records with this size (or

Compiling MYSQL for Win32 Platform BDB

Hi there I have both the patched source for BDB and the Win32 source for MySql. So now the next logical step is to compile them right? So I compile them, but one thing is lurking in the back of my mind, how do I set the MYSQL up to use the BDB table type? When I try and create a table and set

Re: Compiling MYSQL for Win32 Platform BDB

At 00:27 24/04/01 +0200, Warren van der Merwe wrote: Hi! Below the instructions that I sent some time ago, only change the version mentioned by the new ones that you have. Regards, Miguel Assuming that you have on hand: - The db-3.2.9 source stuff - The MySQL 3.23.36 source stuff - The VC++

Cannot start logging.

Hi. I have a 3.23.22 test db running on Linux 6.2. I am able to start the database in log mode. I also have a 3.23.28 production db running on Linux 6.2. When I start this database in log mode, there is no indication that logging is running. There are no log name.index or log name.nnn files

MySQL++ ./configure error

Help ! Does anyone have a clue ? tried to run configure on Ultra SPARC/Solaris 2.7 GNU binutils and libtool latest version, gcc 2.95.2 environment variables: CC=gcc CFLAGS=-O6 CXX=gcc CXXFLAGS=-O6 -felide -constructors -fno-exceptions -fno-rtti at the command line:./configure

Is MaxSQL backward compatible?

Hi all. Does anyone know for sure if MaxSQL backward compatible with MySQL. I know this may be a silly question but i have come across developments which are not backward compatible and want to make sure. If you also know of articles which states this then please let me know as well. Thanks.

you can help me

mysql: hi ,i am a user in china.Now i have a problem that i cound't find mysql-3.22.30.tar.gz in the site www.mysql.com. I think you can tell me where i can download it . Thanks! yongqiang tao [EMAIL PROTECTED]

innobase expects interactive input when disk is full

Description: My disc was full when I tried to restart mysql. The error log filled up with: Innobase encountered a problem with file /var/lib/mysql/ib_logfile0. Disk is full. Try to clean the disk to free space before answering the following: How

RE: Compiling MYSQL for Win32 Platform BDB

Hi there I have managed to follow your instructions, I have used the BDB source files from the Unix download (build_win32 directory). And I have used the Windows Source Files for MYSQL. Everything appears to compile correctly without any errors, however when trying to do a net start mysql I get

2 errrors while executing make

I have installed mysql 3.23.36 for the first time ever I did the test (ok) I ran the bench mark and could not load DBI I installed DBI 1.14 And Data Showtable 3.3 Then tried to install (Msql-Mysql-modules-1.2215) Perl Makefile.pl worked fine I run make and this is what it ends with: make[1]:

doubt about a SELECT

Hi, I have those tables: CREATE TABLE citys ( id mediumint(8) unsigned NOT NULL auto_increment, name varchar(100) NOT NULL, UNIQUE id (id) ); CREATE TABLE route ( id mediumint(8) unsigned NOT NULL auto_increment, id_from mediumint(8) unsigned DEFAULT '0' NOT NULL, id_to

2 errrors while executing make

I have installed mysql 3.23.36 for the first time ever I did the test (ok) I ran the bench mark and could not load DBI I installed DBI 1.14 And Data Showtable 3.3 Then tried to install (Msql-Mysql-modules-1.2215) Perl Makefile.pl worked fine I run make and this is what it ends with: make[1]:

Multibyte export/import Question

Hello to all, i want to properly export Data from a MySQL Table with columns that contain Thai and Latin characters and import this data to an Oracle Table with UTF8 characterset. Who can give me some advice. Where can i find detail MySQL-Information concerning this problem? Thanks in advace.