Re: Delphi MySQL Access Components

Hi, You can have a look at the Delphi 56/Kylix 12 single source components from SciBit at www.scibit.com/mysqlcomponents. Kind Regards SciBit MySQL Team -Original Message- From: Pierre du Parte [EMAIL PROTECTED] To: Daniel Kiss [EMAIL PROTECTED] CC: [EMAIL PROTECTED] [EMAIL

Re: Is type of datetime timestamp same??

Hi Jenny, The formatting are the same -MM-DD HH: - The timestamp field is set automatic by the system when updating a record. The date/time fields are for Your control and usage. Take a look in the manual 6.2.2.2 The DATETIME, DATE, and TIMESTAMP Types Best regards Peter -

Facing some problem in installation

I am trying to install the mySQL on our remote server thr putty (SSH). Following are the set of commands given by me, I have downloaded mysql-3.23 for BSDi. 1)put into /usr/home/mysql-src directory and given following 2 commands going into shellcd /usr/home/mysql-src shellgunzip

MySQL loses databases

Hello, Earlier i posted my message here, but haven't got any real solution. So now I'll try to post with some more details. I have a FreeBSD 4.6 box, dual cpu, runing MySQL. It runs with linuxthreads enabled and it is under heavy load all the time. Few weeks ago it started to work a little

error in mysql - help!!!

I have tried to install mysql, but there is something wrong... When I start up my computer I get this error-message in a pop-up with a 'winmysqladmin.exe'-header: Error reading Memo2 - Lines.Strings: The parameter is incorrect. Does anybody know what this means, and what I can do to make mysql

SUMMARY: how to update time field with current time?

Thanx to all those how answered: hcir walt William Mussatto David Yahoo The answer was now() or update tab_name set fd_name = (now()) where_expr; I had tried this but was missing a pair of brackets (honest..) MYSQL dp. ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Administrator @ Science Photo

Re: MySQL loses databases

Pada Thu, 25 Jul 2002 09:28:45 +0200 Simas Cepaitis [EMAIL PROTECTED] menulis : Hello, Earlier i posted my message here, but haven't got any real solution. So now I'll try to post with some more details. I have a FreeBSD 4.6 box, dual cpu, runing MySQL. It runs with linuxthreads

RE: Facing some problem in installation

If you are NOT installing as root, you are trying to create mysql.sock in an area where you don't have write permission. what is the --prefix you supplied to ./configure ? -Original Message- From: Manisha [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 12:18 PM To: [EMAIL

Re: compiling mysql 3.23.37

SandraR, Tuesday, July 23, 2002, 6:04:42 PM, you wrote: S I need re-compiling mysql 3.23.37 in linux, how can I do this. S In the maestrosdelweb link said how is the compilation, the problem is that S these commands (./config and make) are not available from my install S folders. I have not a

Re: MySql 3.23 to version 4 upgrade

chuck, Wednesday, July 24, 2002, 11:33:21 AM, you wrote: ca Hi all , i'm about to upgrade from MySql 3.23 to version 4 are there any ca issues that should be addressed ie uninstall v3 prior to installing v4 ca or can i just install over v3. ca Any suggested sites' ,FAQ regarding my question.

Re: RE: Problem downloading MySQL4.0.2a for windows

Tam, Tuesday, July 23, 2002, 9:38:17 PM, you wrote: T Hi Victoria, TDo you know when the 4.0.2a-MAX would be available for download then? T Thank you. Use mysql-win-4.0.2-alpha.zip instead. It the same as with -max. -- For technical support contracts, goto

Re: Alter table and sort_buffer_size is to small

Martin, Tuesday, July 23, 2002, 10:29:13 AM, you wrote: MP I'm running a MySQL server v 3.23.39 on Linux Debian. The server has 500 MP MB RAM. I have a table called sender with 18 columns (only integers MP and varchars, no blobs) and with 3 indexes. The table has about 15000 MP records. Now I

Re: re[2]: MySQL Errors -

Richard, Tuesday, July 23, 2002, 3:56:36 PM, you wrote: RM What instances can cause a Table to crash? RM Is this caused by a bug in itself, a power failure, or something else? It may be a bug in MySQL, hardware errors, abnormal shutdown, running myisamchk, when mysqld is running ... Some of

Re: TZ time zone variable

Renato, Tuesday, July 23, 2002, 9:40:35 PM, you wrote: RL I have several mysql servers installed, all without TZ variable, one of RL them, insists in set the select now() to 4 hours ahead of my internal RL clock, first I touch that I should set TZ to my time time zone in RL /etc/init.d/mysql,

Re:RE: Query Optimization

Dave Dutcher [EMAIL PROTECTED] wrote on 24.07.2002 21:35:03: Hi, I did some more research on my problem. (Sorry for not doing it before I posted the other message), and I think perhaps my question could be summarized into the following. Can I use an index to speed up a select max() or select

Re: Joins, ANSI 92 or the old way

Benjamin Pflugmann wrote: Hi. On Wed 2002-07-24 at 09:46:03 +0100, [EMAIL PROTECTED] wrote: As I understand it an ANSI92 join is written as; SELECT b.columnA FROM tableB AS b JOIN ON tableC AS c ON b.id = c.id Ah. Okay. Was not aware that this was new in ANSI92. Whereas the

Re: question about varchars

Hello! Desmond Lee wrote: Hello there Mysql documentation says the following: values are stored using only as many characters as are needed, plus one byte to record the length. Values are not padded; instead, trailing spaces are removed when values are stored. So, then would there

Re: Splitting textarea values to put into a database

Emma Grant wrote: Hi, Does anyone know how to separate values in a text area field, to enter the separated values into a database? For instance if enter these values into a text area field Dogs Cats Fish I want to be able to take Dogs, Cats and Fish and put them in different rows in a

Re: Performance Problem - LEFT JOIN

Guilherme wrote: I have 3 tables tableA, tableB and tableC and the fields tableA.id, tableB.idA and tableC.idA. I'm using this query (bellow) to call information from the database that has in tableA but tableA.id is not found on tableB.idA and tableC.idA. SELECT tableA.* FROM tableA

Re: Facing some problem in installation

Hello! Barnali wrote: If you are NOT installing as root, you are trying to create mysql.sock in an area where you don't have write permission. what is the --prefix you supplied to ./configure ? I'd say install as root, change owner and group of the mysql directories, remove /tmp/mysql.sock

Re: hebrew/arabic language

Hytham Shehab wrote: hi guys, am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show characters of language such as hebrew/arabic? thanks for help sql -- Hytham Shehab - Before posting, please check:

Selecting from one table to UPDATE another.

What I am trying to do in MySQL. Table1 UserID ProductID Old_UserID 1 2 4 2 3 5 Table2 UserID ProductID 4 Null 5 Null Table1 has new correct data. Table2 has old incorrect data. The link is Table2.UserID and Old_UserID What I

SQL Syntax (May be OT)

If this question is off topic, please let me know. I have a description field with a set of keywords. I need to update some data based on a keyword, which is randomly placed in the field. Can someone please help with a SQL syntax to find the word within the field. Thanks in anticipation.

Re: hebrew/arabic language

Hytham, Thursday, July 25, 2002, 12:54:22 AM, you wrote: HS am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show HS characters of language such as hebrew/arabic? MySQL returns char strings as they were inserted. For correct sorting you can set up hebrew character set

Re: Performance Problem - LEFT JOIN

Guilherme, Thursday, July 25, 2002, 4:18:13 AM, you wrote: G I have 3 tables tableA, tableB and tableC and the fields tableA.id, G tableB.idA and tableC.idA. G I'm using this query (bellow) to call information from the database that has G in tableA but tableA.id is not found on tableB.idA and

Re: question about varchars

Desmond, Thursday, July 25, 2002, 2:42:31 AM, you wrote: DL Mysql documentation says the following: DL values are stored using only as many characters as are needed, plus one DL byte to record the length. Values are not padded; instead, trailing spaces DL are removed when values are stored.

RE: Performance Problem - LEFT JOIN

Try SELECT tableA.* FROM tableA WHERE NOT EXISTS (select * from tableA, tableB, tableC where tableA.id tableB.idA and tableA.id tableC.idA) -Original Message- From: Ralf Narozny [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 2:46 PM To: Guilherme Cc: [EMAIL

Re: TZ time zone variable

in the redhat instalation procedure. And I did that for all servers, but only this one has this behaviour. Egor Egorov wrote: Renato, Tuesday, July 23, 2002, 9:40:35 PM, you wrote: RL I have several mysql servers installed, all without TZ variable, one of RL them, insists in set the select

Re: compiling mysql 3.23.37

ok but I haven't a install folder as MySQLversion because the version that I have instaled is binary and the software are by all sides (/usr/bin and /var/lib) and in this folder I haven't a configure file. ¿what can I do? I don´t want install another version if it was possible. thanks. sandraR

Re: SQL Syntax (May be OT)

Hello! David Durham wrote: If this question is off topic, please let me know. I have a description field with a set of keywords. I need to update some data based on a keyword, which is randomly placed in the field. Can someone please help with a SQL syntax to find the word within the

RE: SQL Syntax (May be OT)

Use LIKE '%KEYWORD%' At least this works for Oracle -Original Message- From: David Durham [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 3:39 PM To: [EMAIL PROTECTED] Subject: SQL Syntax (May be OT) If this question is off topic, please let me know. I have a description

groupadd

Hello I am trying to install mysql on macosx and in the INSTALL-BINARY file it says shell groupadd mysql shell useradd -g mysql mysql These commands are not available under MacOS X Regards -- Dave Houghton [EMAIL PROTECTED] System Manager

Re: Alter table and sort_buffer_size is to small

Hi, MP But when I do it I get: MP ERROR 1034: sort_buffer_size is to small Hm.. Error 1034 means: Incorrect key file for table ... not a sort_buffer_size is to small How did you installed the server? I compiled it from the source files. sql -- Martin Pavlas Pwrgeneration.net ICC

Which binary version for which platform?

I have a product for which I would like to use mySql to hold information used in a product demonstration. The product runs on Windows, HP, Solaris and AIX. The demonstration (and the mySql database) will be distributed with the product. I am trying to determine the correct binary distribution of

Re: compiling mysql 3.23.37

How about downloading the source of a newer version??? If you are too lazy to search for the URL: http://www.mysql.com/downloads/index.html SandraR wrote: ok but I haven't a install folder as MySQLversion because the version that I have instaled is binary and the software are by all sides

Czech complex character set

Hi, I would like to get the Chech complex character set. Where can I find it? Thanks, Daniel SQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

hebrew/arabic language

hi guys, am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show characters of language such as hebrew/arabic? thanks for help sql -- Hytham Shehab - Before posting, please check:

Re: Concat() Syntax..

Ashwin, Wednesday, July 24, 2002, 3:15:25 PM, you wrote: AK I have a table with a field full of urls.. what I need to do is to append AK to those urls with a new url, so for example, if the field had AK http://www.yahoo.com i want to make it AK

Re: Re: Re: Alter table and sort_buffer_size is to small

Hello Martin, Thursday, July 25, 2002, 4:48:03 PM, you wrote: Please, send your questions/answers to the mailing list, not to me. MP But when I do it I get: MP ERROR 1034: sort_buffer_size is to small Hm.. Error 1034 means: Incorrect key file for table ... not a sort_buffer_size is to

Re: Re: compiling mysql 3.23.37

SandraR, Thursday, July 25, 2002, 2:54:39 PM, you wrote: S ok but I haven't a install folder as MySQLversion because the version that I S have instaled is binary and the software are by all sides (/usr/bin and S /var/lib) and in this folder I haven't a configure file. S ¿what can I do? I dont

Re: Re: TZ time zone variable

Renato, Thursday, July 25, 2002, 2:35:56 PM, you wrote: RL in the redhat instalation procedure. And I did that for all servers, but RL only this one has this behaviour. Run safe_mysqld --timezone=America/Manaus and show me the output of SHOW VARIABLES LIKE 'timezone' RL Egor Egorov

generic sample data script

I'm looking for a script that will fill mysql tables with sample data so we can see how our web pages look with data in them. Does anyone know of any? I've written one in perl but I would like to see how someone else did it. thanks, Peter

RE: question about varchars

Hello, What you say below is of great interest to me. Currently I have been writing front end code to handle the size issue but I would like to be open to other possibilities. So my question about your answer below is: Just how does the developer obtain the error condition from Mysql when an

Data Entry for a Newbie

At the moment I have Mysql installed and understand command line entry of data, or entry via a text file. Either way, it is difficult, especially if you have been used to data entry screens. Is there a utility somewhere that would allow me to do this? Failing that, is it possible to write a html

MySQL and Filesystems

Hello everybody, someone can tell me the best FS to run MyISAM along with InnoDB tables ? SQL - For you-know-who -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED] -

Re: Joins, ANSI 92 or the old way

Hi. On Thu 2002-07-25 at 10:41:54 +0200, [EMAIL PROTECTED] wrote: [...] Personally I find the former much easier to read though not sure about the practical differences between them when the statements are executed. AFAICT, there should be no differences on execution speed. We

Storing Records Alphabetically

Hi I am storing a list of titles on a mysql db. Some of the records start with 'The','A' or 'An'. I would like to be able to enter the title in the form 'The Count .' instead of 'Count ..., The' and have the record stored as 'Count ' but displayed as 'The Count ...' when I display it.

Re: MySQL loses databases

I had this problem. For some reason MySQL has decided to look at your tmp directory (which contains vi.recover) instead of your data directory. Compiling with -DHAVE_BROKEN_REALPATH fixed it for me, on FreeBSD 4.6, linuxthreads and dual CPU. --Mike - Original Message - From: Dicky

how to retrieve data from two table?

Hi I have be scratching my head with this for a few days. I want to select data from 2 tables conditionally. 1 table has users, the other times relating to the users. I want to create a query that will select the user from the users table and if they have any time data against them (for that

problem with win98

Mysql engine is running under win98, then at the prompt I type mysql mysql then press enter and I have control. I can delete users (root included), whatever I want, so How can I make Mysql always require a username and a password to connect to it? Alex

Re: IBM-AIX 4.3 MySQL Binnary Installation Problem: libz is missing.

Francisco, Thursday, July 25, 2002, 2:46:39 AM, you wrote: FR When I try to execute scripts/mysql_install_db, I get FR some errors about some libraries missing: FR exec(): 0509-036 Cannot load program FR ./bin/my_print_defaults because of the following FR errors: FR 0509-150 Dependent module

FIND_IN_SET index problem

Hi, I have a problem where the index for a SET column does not get used once I link in another table. The output to explain: mysql explain select count(*) from NS_articles where find_in_set('approved', artFlags) 0;

Re: Selecting from one table to UPDATE another.

Hello! Simon Green wrote: What I am trying to do in MySQL. Table1 UserID ProductID Old_UserID 1 2 4 2 3 5 Table2 UserID ProductID 4 Null 5 Null Table1 has new correct data. Table2 has old incorrect data. The link is Table2.UserID

error in solaris 8

Subject: [50 character or so descriptive subject here (for reference)] Description: precise description of the problem (multiple lines) How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known

strange backquote problem

Hi, On my application's setup.php I have quite simple MySQL queries like DROP TABLE IF EXISTS `ee_test` Now, some users (perhaps 5 out of 1000) complain that they get an SQL error on the first query with backquotes, and when I provided them with a setup file without any backquotes (luckily

Re: compiling mysql 3.23.37

because I have a cobalt server and the only version that they suggest are the 3.23.36 an 37, this is the reason about I don't wish re-install another version if I can. anyway thanks for its aid. sandra - Original Message - From: Ralf Narozny [EMAIL PROTECTED] To: SandraR [EMAIL

Change string quote char

Hi, is it possible to change the default string quoting chars (')? I'm using MySQL with an older shop solution. The data to write has both: ' and chararcters. It isn't possible to escape those chars. Therefor I have to change the quoting char to a char that isn't used i.e #. Is it possible?

Which binary fro which platforms?

I have a product for which I would like to use mySql to hold information used in a product demonstration. The product runs on Windows, HP, Solaris and AIX. The demonstration (and the mySql database) will be distributed with the product. I am trying to determine the correct binary distribution of

Do you run multiple servers on WIndows?

It's not uncommon to run multiple MySQL servers on a given Unix system. I'm wondering: Does anyone do this on Windows, and if so, what particular configuration issues did you have to solve to keep them from interfering with each other?

*FREE* slides of an upcoming web presendation : MVC+ STANDARD tags

Subject: *FREE* slides of an upcoming web presendation : MVC+ STANDARD tags From: Vic C. [EMAIL PROTECTED] === Open source SQL web app: In order to facilitate discussion of the live web presentation (coming up in less than 24 hours) you can download the slides before the presentation; I have

Starting on Windows 2000 Server

Hi, I just downloaded the binaries. I have followed the installation instructions. Have run the command mysqld-max-nt --install-manual and checked the service panel and MySql is installed as a service. However when I either try to start the service in the service panel or issue the command net

max_connections recovery

I've been running MySQL for 2 years with no problems. Yesterday, I increased the max_connections because I was getting too many connections error. This morning, the server again reached its limit but it never seemed to recover from it and constantly gave the too many connections error. I was

Help me with my mysql...errormessage!

Mysql is not working. I get an error pop up which says: Winmysqladmin 1.3. : Error reading Memo2 - Lines.Strings: The parameter is incorrect. I get this message at startup and when I try to open winmysqladmin.exe. Before I restarted the computer everything was fine. Help anyone???

Re: hebrew/arabic language

am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show characters of language such as hebrew/arabic? My best suggestion would be to store all your test in Unicode UTF-8 format and use the type BLOB in the table in order to store it. We do this and can quite happily mix

Re: how to update time field with current time?

William R. Mussatto wrote: On Wed, 24 Jul 2002, Dermot Paikkos wrote: Date: Wed, 24 Jul 2002 17:46:00 +0100 From: Dermot Paikkos [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: how to update time field with current time? Hi Probably a silly question but how can I set a time field to the

RE: Data Entry for a Newbie

MySql Front, http://www.anse.de/mysqlfront/, is a win32 GUI for admin and data entry. Yes, you can use html and some web programming to communicate with MySQL. -Original Message- From: William Bradley [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 8:13 AM To: Mysql Subject:

Re: Re: IBM-AIX 4.3 MySQL Binnary Installation Problem: libz is missing.

Victoria, I am using mysql-3.23.49-ibm-aix4.3.3.0-rs6000.tar.gz, which is the latest version posted on your site. Also, when I try to compile mysql-3.23.51.tar.gz, I get the following error executing the make command: my_gethostbyname.c, line 81.5: 1506-068 (S) Operation between types struct

Re: Data Entry for a Newbie

phpMyAdmin if you have a webserver with php you can use. or you can use MyODBC and us MS Access to make a front end for data entry. -- Forwarded Message -- Subject: Data Entry for a Newbie Date: 25 Jul 2002 11:12:35 -0400 From: William Bradley [EMAIL PROTECTED] To: Mysql

RE: Data Entry for a Newbie

I would buy a book called PHP Essentials. www.thickbook.com I used it to learn how to write an html/php interface to my databases and i use it all the time now. It takes a bit of work to get the interfaces built but the book is really easy to follow and understand. seth -Original

Re: Data Entry for a Newbie

On 2002-07-25 07:12, William Bradley [EMAIL PROTECTED] wrote: At the moment I have Mysql installed and understand command line entry of data, or entry via a text file. Either way, it is difficult, especially if you have been used to data entry screens. Is there a utility somewhere that would

4.0.2 libmysqlclient.so.10 not found

I am in the process of testing out the 4.0 series of MySQL and am having some problems when I try to install the php-mysql RPM. The machine is a RedHat 7.2 i386 box with all current patches. I pulled down the source RPM for 4.0.2-2 and rebuilt the RPM's with debug enabled then installed all the

Re: question about varchars

Your application uses the field size and type to validate the data BEFORE sending it to MySQL. Norris, Joseph wrote: Hello, What you say below is of great interest to me. Currently I have been writing front end code to handle the size issue but I would like to be open to other

Re: Storing Records Alphabetically

Hi. On Thu 2002-07-25 at 11:24:36 -0400, [EMAIL PROTECTED] wrote: Hi I am storing a list of titles on a mysql db. Some of the records start with 'The','A' or 'An'. I would like to be able to enter the title in the form 'The Count .' instead of 'Count ..., The' and have the record

Re: how to retrieve data from two table?

Hi. On Thu 2002-07-25 at 16:44:19 +0100, [EMAIL PROTECTED] wrote: [...] I want to create a query that will select the user from the users table and if they have any time data against them (for that day) return that also. If there is not data for that day only the user data should be

Re: problem with win98

Hi. On Thu 2002-07-25 at 11:44:26 -0400, [EMAIL PROTECTED] wrote: Mysql engine is running under win98, then at the prompt I type mysql mysql then press enter and I have control. I can delete users (root included), whatever I want, so How can I make Mysql always require a username and a

TRUNCATE TABLE

Hello mysql, Why after TRUNCATE TABLE data file with indexes not freed ? and TRUNCATE TABLE is very slow ... MySQL 3.23.51+InnoDB OS: Linux 2.4.18/ReiserFS Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109

RE: Data Entry for a Newbie

Hello! two ways: Fun way: Get Perl and write some cgi using html/javascript front end Another way (maybe not as fun - but gets the job done): Enter data in Excel spreadsheet and export to comma delimited file. Then go and read the docs on mysqlimport command. Cheers! -Original