problem

hi i am attaching a log file which was generated by the server in starting up mysql could any please tell me what exactlly the problen is log file = 010427 18:25:29 mysqld started 010427 18:25:29 /usr/local/mysql-3.23.36-pc-linux-gnu-i686/bin/mysqld: Can

Computer Exploded!!!

My computer didn't explode i just wrote that to get attention. My question is this - I have a database with a table which looks like this - CREATE TABLE sites ( ID INT NOT NULL AUTO_INCREMENT, name VARCHAR(30) NOT NULL, keywords VARCHAR(200) NOT NULL DEFAULT 0, description VARCHAR(200) NOT NULL D

newbie question on variable length records.

Hi, I am a newbie to Mysql. I would like to know how to create a table with variable length records? i have an object with following variables: varchar v, int a, int b, int c. and i want to store variable number of such objects into the rows. varchar v is the primary key. the entries in the

Re: Fundamental (newbie) question

Thanks for the suggestion! I should have been more specific -- I don't need to do this as a bulk import. I need to do these on an ongoing basis. It doesn't have to be super-fast, though. I would expect something on the order of tens of events per hour at the most. > Given my crude understandi

Re: Fundamental (newbie) question

Unfortunately, I have no option to redesign database A. It's from a third party. I could potentially redesign database B somewhat, but I think there would be one table with 30+ columns no matter what. For instance, I could precisely duplicate the fields from the table in database A in a table i

Re: Fundamental (newbie) question

Well, first of all, you may want to consider redesigning your two databases. Most properly designed databases don't have 52 columns in a table. The process of normalization should decompose these tables further and make things way less complex. I don't know what the context of your databases a

Re: trouble installing mysql rpm on Linux

Did you download and install both client and server? Have you gone through post installation? - Original Message - From: "Nathaniel Hekman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 01, 2001 6:45 Subject: trouble installing mysql rpm on Linux > I'm having trouble in

AIX Binary Installation Problems

I haven't read through any of the MySQL mailing lists in a while. Now that I do I see that lots of the AIX related questions involve problems with /usr/local/lib/libz.a as part of the "ZLib" compression library. The pre-compiled ZLib on http://www.bull.de/pub/ fails for me with the [shr.o] missing

Re: BUG

What files are in the C:\MYSQL\BIN directory? If there is no file named MYSQLD.EXE, you have found the problem. Very likely there is one called MYSQLD-SHAREWARE.EXE or something like that. Suggestion? Uninstall the software provided with the book ... and download the current version (3.23.37) fro

Fundamental (newbie) question

Please forgive the relatively basic nature of this question. I'm new at this. I have the DuBois MySQL book and the O'Reilly one as well, so please feel free to point me at a page number. I couldn't find the answer myself. I have two databases. Database A has a few tables, and the table of int

BUG

To Whom it May Concern, I have downloaded mysql from the cd provided to me in the book "PHP: fast and easy web development" . To test the MySQL installation, at the MS-DOS command prompt I typed cd c:\mysql\bin. Followed by: c:\mysql\bin>mysqld --standalone I receive a BAD COMMAND OR FILENAME

Question regarding getting column value from previous record and putting in next record

Hi, I'm writing in PHP and in perl ISP billing software and I have some problems. I have following questions: I need get some column value from previous record and put it to next record column value. It is something like: Contract_idUseridPrevious_balanceDaily

What can I do to help the mysql developers to get mysql to work on OS X?

So, I'd really like to have mysql working on OS X and while there were a few people trying it out and having difficulty, I have yet to see any posts of total success. I'm an experienced MacOS programmer, but I have little experience on Unix -- so I'm way behind the curve on looking at the sou

Re: Ever heard of anything like this?

I personally use SSH (running as a server on the Unix/Linux system running MySQL, and which is now included in the RedHat 7 release series) which is configured to accept only 'ranges' of IP address (subnets that my dialup ISP might assign me, like 207.25.33.* 207.25.34.*).That should prett

Query Question

I have a members table which stores, among other things, a Member ID and a Points field. We get reports sent to us in a CSV format, with a list of all Members signing up for a certain offer. Basically, what I need to do, is create a query like this: UPDATE members SET points = points + (offer_val

Re: Ever heard of anything like this?

Yes, reverse lookups are a good idea from a static address but AITCOM is marketing reseller stuff to people who use dial-up connections and dynamic IP addresses. DNS does not have inaddr-arpa entries for dynamic addresses. It sounds to me if the passwords are sent in clear text, no Mysql Database

Re: Ever heard of anything like this?

Just a note. If you're requesting "telnet" or "ftp" access to your 'colocated' systems, the issue isn't only with your 'ISP'. I just got finished assisting another MySQL user in rebuilding his system (for the 2nd or 3rd time) who has been using "telnet" and "ftp" to remotely administer his sy

Is my table hosed?

MySQL 3.23.33: This morning, one of my tables suddenly reported index corruption. I locked the table, fixed with myisamchk -o, unlocked, and thought the problem was solved. But it keeps on re-corrupting (I'm not even writing anything to it first). Plus any query on that table which uses a "whe

Re: Ever heard of anything like this?

We are also using AITCOM and often have problems. They seem to work on their network at noon on Sat. and traceroutes die at their network.They seem to go offline randomly also. We asked for telnet access to administer a Mysql database and can't get it to work. They say our DNS is not configured fo

trouble installing mysql rpm on Linux

I'm having trouble installing the MySQL RPM on Linux. I've got mysql-3.23.32-1.7.i386.rpm and I'm on RH Linux 7.0. I run 'rpm -i mysql-3.23.32-1.7.i386.rpm' and it shows no errors, but then I try running 'mysql' (the client) and get this error: ERROR 2002: Can't connect to local MySQL s

Re: MERGE Tables

Hi! On Apr 30, Basil Hussain wrote: > Hi, > > Anyway, while we're on the subject, I seem to be having some trouble with my > indexes on MERGE tables. I posted a message a while ago, but no-one seems to > have noticed it... > > Basically, if I create my MERGE table with indexes on the same colum

RE: Database size

Erik, If your running Linux on an Intel machine (which I assume it is), then you've hit Linux's limit for IA32 and 2.2.x kernels .. If you want to go with sizes higher then 2gig you need to upgrade to a 2.4 kernel (and the latest GNU Libc) .. I've had (not mysql databases) 40gig files on Intel b

Re: MATCH AGAINST 2-3 tables

Thanks for the response! The two tables contain different types of information which are related by a foreign key (orginally designed that way).However, there is no reason that there can't be a single table that contains both (actually 3 seperate tables) sets of data. Unfortunately, building

RE: Database size

I run Linux 6.2 and don't have problems with file size. Check the version of MySQL you run. The maximum table size was recently expanded in 3.23.x I think. Also, look at the MAX_ROWS parameter for the table. Finally, if nothing else works perhaps you can define the table as a UNION, check the

ORDER BY DESC optimization

I have a fairly large table (greater than 4mil rows) that I would to preform a query like: SELECT col1,col2 FROM table WHERE a=1, c=2 ORDER BY b DESC LIMIT 50; I have an index on the table INDEX1( a,b,c ); When running the query as is, it takes around 4seconds. If I omit the "DESC" part the que

perl DBD make test errors??? Please Help

RedHat 6.2 on Intel, ...36 MySQL, and perl5, DBI installed correctly. I ran perl Makefile.PL, seemed to run ok, no errors seen. Ran make, same thing. Then the following from make tets: /perlmods/DBD10>make test make[1]: Entering directory `/perlmods/Msql-Mysql-modules-1.2210/mysql' make[1]: Lea

Re: Problem with LAST_INSERT_ID();

I have run into this problem in Access using MyODBC. Access will try to evaluate the function last_insert_id() before it passes the query to the database. It will do this EVEN if I say it is a 'dbSQLPassThrough' query. Very aggravating. j- k- On Sunday 29 April 2001 06:23, [EMAIL PR

Re: Newbie win 2000 install question (reprise)

At 12:49 30/4/2001 -0400, Rhasaun Campbell wrote: Hi! To install and start up MySQL is easy and fast on Win2000, below you see the commands I had, before the setup: Microsoft Windows 2000 [Versão 5.00.2195] (C) Copyright 1985-1999 Microsoft Corp. C:\>cd\mysql\bin C:\mysql\bin>mysqld-nt --instal

MATCH AGAINST 2-3 tables

Hi Everyone! I've got two seperate tables that I would like to query using a MATCH .. AGAINST() syntax. If I run the query individually on one table, the speed of the returned results is great! Very fast, indeed. However, when I try and use the following statement for querying both tables at

Tons of "opening tables"

Now and then when our site is very busy, mysql seems to get into a state where tons and tons threads 'stick' in the Opening Tables status... www# mysqladmin proc | grep -c "Opening tables" 188 Any ideas why that is? Anything I can do to try and figure it out? I'm stumped how to procede here

Problems with mysqlshow under linux

Hi all, When I try to execute mysqlshow under linux I get this message: $ mysqlshow mysqlshow: Can't connect to local MySQL server through socket '/tmp/mysqld.sock' (111) $ However when I do the same under NT it works fine E:\Program Files\mysql\bin>mysqlshow +---+ | Databases | +

[jcz@mylinepcx.com: Bug#95872: replication failure]

Hello This came through the Debian BugTrackingSystem but I have no clue about it. bye, -christian- Package: mysql-server Version: 3.23.33-3 Severity: normal from /var/log/mysql.err: 010430 16:06:52 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 4 010430 16:

Database size

Hi, I have a problem, my database has reached Linux Redhat 7.1 max file size. (2147483647 Bytes). Does eny one know what i can do to make a lager database. (lager filesystem) Thanks Erik Dhiin - Before posting, please check:

Re: Syntax error

I don't see any ticks surrounding userid...unless of coarse userid is a number?? Also, myResultSet, is that public? If not, are you returning it? (I'm not familiar with Java, so not sure if you need to or not) - Original Message - From: "Ryan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>

Re: LAST_INSERT_ID returning 3 rows?

Because you included a from clause, you got one line for each row of 'outages' Leave out the "from outages" Graeme B. Davis wrote: > mysql> INSERT INTO outages (status) VALUES ('Open'); > mysql> SELECT LAST_INSERT_ID() AS lid FROM outages; > +-+ > | lid | > +-+ > | 101 | > | 101 | > | 1

RE: LAST_INSERT_ID returning 3 rows?

last_insert_id is a function. It will return a value for each row in the table. You want to run: select last_insert_id() as lid; instead of selecting from a table. -Original Message- From: Graeme B. Davis [mailto:[EMAIL PROTECTED]] Sent: Monday, April 30, 2001 3:17 PM To: [EMAIL PROTECT

Syntax error

hi everyone in this group, i am getting lately mysql syntax error when i run query from JSP page. here is sample code: public selectMyPass (String userid) { String myQuery = "select pass from datainfo where id="; myQuery.concate(myQuery,userid); myResultSet = stmt.executeQuery(myQuery)

LAST_INSERT_ID returning 3 rows?

mysql> INSERT INTO outages (status) VALUES ('Open'); mysql> SELECT LAST_INSERT_ID() AS lid FROM outages; +-+ | lid | +-+ | 101 | | 101 | | 101 | +-+ 3 rows in set (0.00 sec) Why would MYSQL do this? Any ideas? Thanks, Graeme p.s. DESCRIBE outages; +---+---

Re: red hat 7.1 rpm --rebuild error

I try to "rpm --rebuild" the src.rpm for 3.23.37 on a Linux Red Hat 7.1 system, but i get this error: checking for gcc... egcs checking whether the C compiler (egcs -O3 ) works... no configure: error: installation or configuration problem: C compiler cannot create executables. error: Bad exit

Re: how to do a query using a file?

>From the command line you can load syntax from a file mysql -u [username] -p [database] < filename.txt On Mon, 30 Apr 2001 [EMAIL PROTECTED] wrote: > > query: load data local infile "file.txt" into table > > my_table > > Thank you. > But for creating an entire and complex database? > I mean

To install MySQL, where can free download Lunix?

Hi, I would like to install MySQL. I want to setup Lunix on IBM compatible computer. Do you know where I can get free download Lunix recent version? Thank you very much. John Ding

Re: Ordinary users can crash mysql server

I have been experiencing some environment modifications around about this bug. I am sure that's not related to mysqlbinlog only. It happens because of compilation with support for libwrap. Any other program da do tcp/ip mysql will crash it! Rene Tegel gravada: > > you just did the right thing:

Re: asian charatersets in mysql?

http://www.mysql.com/doc/c/o/configure_options.html http://www.mysql.com/doc/A/d/Adding_character_set.html Luis Hoeks wrote: > > I would be very pleased, if someone could tell me if MYSQL supports asian > character sets like big5 or thai charctersets. > If yes, what do I need to install to ge

asian charatersets in mysql?

I would be very pleased, if someone could tell me if MYSQL supports asian character sets like big5 or thai charctersets. If yes, what do I need to install to get it running. Where can I find any help? Any advice is very much appreciated! Kind regards from Luis ___

RE: upgrade rpm and database

The RPMs on the MySQL site don't seem to match RedHat's RPM layout at all - the RedHat RPM can't be "upgraded" to the MySQL RPM (even the package names are different - "mysql" in RedHat vs "MySQL" in the MySQL package). The only thing you can do is: * rpm -e `rpm -q -a | grep mysql` * rpm --inst

Newbie win 2000 install question (reprise)

Ok I tried both of your suggestions but no dice. I actuall failed to mention that once I got into the bin i tired to start the service by typing mysld--standalone, but it returned an error stating: mysqld--standalone is not recognized as an internal or external command, operable program or batch

Re: New filter

On Saturday 28 April 2001 19:28, Jeremy Zawodny wrote: > On Sat, Apr 07, 2001 at 10:42:09AM -0600, Sasha Pachev wrote: > > > I have now installed the new spam filter on this list. It is very > > simple - instead of having bad words, we now have good words. You > > must mention one of the followin

USE INDEX()/IGNORE INDEX() not getting through

I'm having the following problem with the IGNORE INDEX()/USE INDEX() directives on a mysql 3.23.32 mysql> explain SELECT age_0,reliable,COUNT(*) FROM age,reliable WHERE age.id=rel iable.id GROUP BY age_0,reliable; +--++---++-++-+- -

RE: index troubles

In your query your still asking for all rows in the table. To utilize an index, a restrictive query often works for example: Assuming you have an index on distance --- SELECT * FROM loeb WHERE distance = 2; The random tottid results from your grouping by distance. In effect you have made group

Re: mysql ended-addendum

>From: [EMAIL PROTECTED] >To: "Mike Loiterman" <[EMAIL PROTECTED]> >Subject: Re: mysql ended-addendum >Date: 30 Apr 2001 15:16:07 - > >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 fo

Re: SV: index troubles

On Mon, 30 Apr 2001, Wix,Christian XCW wrote: > But why doesn't this work then: > select name, tottid, distance, min(mintid) from loeb group by distance; > (tottid seems to be random) > > mysql> explain select name, tottid, distance, min(mintid) from loeb group by > distance; > +---+--+-

Re: myodbc uses bash'ism and should not have #!/bin/sh

In the last episode (Apr 30), Michael Widenius said: > >> Description: > ch> The following output occures when using ASH as /bin/sh. > ch> Your script seems to rely on non-POSIX features from bash > ch> and therefore should be called with #!/bin/bash. This works. > > ch> -=(~/debian/mysql/O

RE: Password security

Put it in an include file, like.. dbconnect.inc Then add this to your httpd.conf file: Order allow,deny Deny from all keeps people from downloading your .inc files. And also, make the .inc file readable only by the web server and no one else. Cheers. --

Re: Password security

On Sun, 29 Apr 2001, Philippe Louis Houze wrote: > Date: Sun, 29 Apr 2001 10:56:52 -0400 > From: Philippe Louis Houze <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Re: Password security > > Hi, > > How do you keep MySQL password out of view of "visitors" when needed in PHP to >access

Re: Ever heard of anything like this?

>>We are on a virtual server..we set up with this >>company AITcom.net to be resellers. This is your problem, right here. I had an account with them for 1 month. I was going to move one of my small sites over and if it worked out, move all my sites over. in 1 month, they shut my server down

"mysql ended"

Using RedHat 7 with mysql 3.23.33. Every time I do a ./mysql.server start i get the following error mysql ended. In the error log it says that it cannot find mysql.host. What can I do to fix this problem? _ Get your FREE download

Ever heard of anything like this?

I can't connect to my database via mysql This is the load of crap I'm getting... I would appreciate any input or feedback you have. We are on a virtual server..we set up with this company AITcom.net to be resellers. First of all we are getting this error message when we try to conn

restarting mysql

Greetings, I re-booted my server that a database resides oni started mysql (bin/safe_mysql --user=del &) However i think that the desired database is not loaded..not being a database guru, what is the proper way of starting mysql so that i can specify the proper database..? thanks donni

Re: Mysql can't start: help!

The RPM on the RedHat 7.0 CD does not work properly. Get a new one from the Red Hat or MySQL site. On Mon, 30 Apr 2001, [EMAIL PROTECTED] wrote: > > Please check the manual both about common problems and how to post > > problems in list. This error can depend on which MySQL version you > > instal

SV: index troubles

But why doesn't this work then: select name, tottid, distance, min(mintid) from loeb group by distance; (tottid seems to be random) mysql> explain select name, tottid, distance, min(mintid) from loeb group by distance; +---+--+---+--+-+--+--+---+ | tabl

RE: MySQL (3.23) connection bombardment question ..

Thanks for the advice! I put 2.4.3ac9 (will try 2.4.4 a bit later today) on the database (and web) servers .. However, at the peak hours and the onslaught of users hit the site everything goes to hell .. I'm tending to lean towards there being some issues in the MySQL area .. During normal hour

Re: Ordinary users can crash mysql server

you just did the right thing: you posted an anomaly to the list. that's not bad, that's good. Thanx for notifying us! don't worry about possible abuse, as far as i can see you need a normal mysql account anyhow in the first place, and if any system administrator would notice such a user killin

What is wrong with load_file

>Description: The following script should insert some files in a table, but load_file seems not to work I think it is only a small error, but I don't find it. Command File: # #!/bin/sh set -exv #Fügt die eingesc

upgrade rpm and database

Am running mysql 3.23.22 with problem with linuxconf. Want to upgrade to 3.23.36 or 37, but get following error messages: for 3.23.36 says: mysql = 3.23.22 is needed by mysql-server-3.23.22-6 libmysqlclient.so.9 is needed by mysql-server-3.23.22-6 libmysqclient.so.9 is needed by php-mysql-4.0.1

Re: index troubles

Hello, The index you have created is just fine and should be utilized as long as you perform a query that needs to use an index. Your query: select a,b from t; doesn't have any conditions imposed upon the table's rows. It just asks for all the them. Simple file scan. regards, thalis On Mon,

Re: Mysql can't start: help! SOLUTION

I report a solution of my problem for other people ho have (or will have) the same problem. I THANK VERY MUCH THE PEOPLE WHO HELPED ME Mario. IN A FEW WORDS: Istalling rpm of MySql don't meas that MySql can run. Some linux version (like My RedHad) have MySql istalled but not "inizialie" So

Re: Max connections on Freebsd

Hi Patric, I run serveral FreeBSD servers, although not on 4.2, please upgrade to 4.3, there are documented problems with thread on 4.2 that were corrected later. I have a number of machines set at 300 as the max_connections paramters althought I don't often see more than 130 connections at t

mod_auth_mysql & password trading

Is there a simple way to prevent password trading on an apache system using mod_auth_mysql? I've already got the module installed and working. It would be nice if a directory of flat files could be protected, without having any kind of SSI's, CGI's, etc. anyone ... anyone? -- [Joel-Gwy

index troubles

Hi! I have some troubles with my index. I want to be able to use an index (test=(mintid, name)). I will use the index when I write: select mintid, name from loeb; I have created an index but it doesn't seem to work. Why? // Chris - Copenhagen mysql> show index from loeb; +---++---

doc error?

hi! i found this in the mysql docs.. and it's irritating me: how can my_ulonglong have a value of -1? snip 22.4.1 mysql_affected_rows() my_ulonglong mysql_affected_rows(MYSQL *mysql) 22.4.1.1 Description Returns the number of rows affected (changed) by the last UPDATE, DELETE or

Re: Unix_TimeStamp()

On Mon, Apr 30, 2001 at 12:24:26PM +0100, Basil Hussain wrote: > Hi, > > >> Does the function Unix_TimeStamp() work in MySQL under Windows NT? > >> It doesn't seem to work here in simple queries, such as this query: > >> Select Unix_TimeStamp(); > > > > What about > > > > SELECT UNIX_TIMESTAMP(

Re: Mysql can't start: help!

> Please check the manual both about common problems and how to post > problems in list. This error can depend on which MySQL version you > installed. Is it RPM, binary or source installation? Check the manual > again I'm very sorry for take a noice to mailing list... but I try it! i try also

FW: TIMESTAMP Replication!!

Hi, I have just checked the logs, and the point is that in the update log there are statements for setting the timestamp, and in the binary log not. Is this OK? Thanks again. Gabriel > -Original Message- > From: Gabriel Corneanu > Sent: Monday, April 30, 2001 11:23 AM > To:

Re: show table status command in MySQL

Hi, > For show table status command in MySQL, which field is indicate the > table size? Or, Which command is to find out the database size. The 'Data_length' field in the SHOW TABLE STATUS output will tell you how big the data is (in bytes). Bear in mind this doesn't give the actual size taken

Re: MERGE Tables

Hi, > Table handler for MERGE can use keys of underlying tables for > key lookups, but in fact it never will, as SQL optimizer will never ask > to. Specifying keys for MERGE table is for SQL optimizer to able to > chose the best way to execute your SELECTs. No real keys are created, > as MERGE ha

ANNOUNCE: moodss-14.2

Hi everybody: here is a new version of moodss. Check it out! (or at least the screenshots at http://jfontain.free.fr/moodss3.gif or http://jfontain.free.fr/moodss4.gif :). ### CHANGES ### --- version 14.2 --- made thresholds table a drop zone for data cells MySQL myvars module updated to supp

Re: Mysql can't start: help!

On 30 Apr 2001 10:43:24 +0200, [EMAIL PROTECTED] wrote: > > I use RedHat (last release) > I try to use Mysql but It doesen' works: > I post you some lines can help you to understand the error. > how can create a table, use Mysql? > Thank you in advance, Mario. > > ---

Re: problem

On 30 Apr 2001 15:36:11 +0530, aditya shanker wrote: > hi > i have installd my sql on linux machine > but its giving lot of problems related to configuration > could you please tell me some link from where i can get a detailed trouble shooting >material > looking forward for your reply Thi

Re: Unix_TimeStamp()

Hi, >> Does the function Unix_TimeStamp() work in MySQL under Windows NT? >> It doesn't seem to work here in simple queries, such as this query: >> Select Unix_TimeStamp(); > > What about > > SELECT UNIX_TIMESTAMP(NOW()) The above shouldn't be necessary - it is actually supposed to give you th

Re: how to do a query using a file?

> query: load data local infile "file.txt" into table > my_table Thank you. But for creating an entire and complex database? I mean If you have to create 40 table?!? there is a way to do it by ascii file? I write the SQL commands once and then I can recreate the db whth tables in different compu

Re: Ordinary users can crash mysql server

Yes, i use the same directory for data and log files (/var/db/mysql). And, as far as i know, there is mysqld options that allows me to specify a directory to hold all logs. How can this be accomplished? Thanks for your support and time. -- Original Message -

Re: Ordinary users can crash mysql server

Hi folks! Since we(not we, just my account) at Ifour had some problem with email, i did'not get all resps to my bug report. But, by reading some messages, i can see it'was not a good thing to have posted the message on the list. Please, forgive for whatever i have done. I have just done so, caus

RE: problem

http://www.mysql.com Kind Regards Harish Gundecha Systems Administrator Email: [EMAIL PROTECTED] Versaware Technologies (India) Pvt. Ltd. Phone No. : +91-20-6136028 Extn: 331 -Original Message- From: aditya shanker [mailto:[EMAIL PROTECTED]] Sent: Monday, Ap

problem

hi i have installd my sql on linux machine but its giving lot of problems related to configuration could you please tell me some link from where i can get a detailed trouble shooting material looking forward for your reply regards aditya   Aditya ShankerTelecom and ConvergenceEscosoft T

TIMESTAMP Replication!!

Hello, The manual says that TIMESTAMP should work. What does this mean? When I replicate a table with such a field, the values on the slave is different. Is this OK or a bug? I'm trying to use this field to avoid data overwrite. In a JSP page I select a record, read TIMESTAMP field value, and when

Mysql can't start: help!

I use RedHat (last release) I try to use Mysql but It doesen' works: I post you some lines can help you to understand the error. how can create a table, use Mysql? Thank you in advance, Mario. - [root@localhost mysql

dynamic SET and ENUM

Just drawing a bow at a venture, but is it possible to have a SET or ENUM dynamically linked to a table so that valid elements for the SET/ENUM are composed from the rows in another table? E.g. ALTER TABLEpurchase MODIFY products_bought SET( SELECT * FROM products.name) I guess not,

Re: how to do a query using a file?

He, you can download the documentation file from http://www.lri.fr/~aze/PHP/docs/ or others and see the example chapter, In my case, I Store my Access data base in a text file and upload to my serveur, then I execute this sql query: load data local infile "file.txt" into table my_table it works

Re: New filter

>This is email. It's not a bomb on a plane. Choices exist for a digest, >or a newsgroup. Freedom has a price. I am more than willing to pay it. I don't feel our freedom has been limited by the filter used. Glad the listadmins does take some steps to prevent spam. just my 0,02 Bye, B. mysq

Re: MERGE Tables

Hi! On Apr 30, Matthew Shaw wrote: > Hi, > > The merge table created is called asic_cache. It has exactly the same > structure as above except there are no keys what so ever. My > understanding is that there is no need for keys on the merge > table as the table handler uses the keys on each indi

myodbc uses bash'ism and should not have #!/bin/sh

Hi! > "ch" == ch <[EMAIL PROTECTED]> writes: >> Description: ch> The following output occures when using ASH as /bin/sh. ch> Your script seems to rely on non-POSIX features from bash ch> and therefore should be called with #!/bin/bash. This works. ch> -=(~/debian/mysql/OD

how to do a query using a file?

I have to buitd a "big" database. I have to create table, insert row in database and then do the same thing on another computer. I'd like to do that using a file in whiich I write all ... but how can I do? Thank you in advance. Mario. --