Re: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2

Yes. Dumb question. You did install the OS X developer tools, yes? I just compiled 3.23.47 from source this morning on 10.1.2 with not a problem at all. -- John McCauley CTGi Oakton, VA 703-352-0590 http://www.ctgusa.com From: Ryan Walker [EMAIL PROTECTED] Date: Tue, 29 Jan 2002 18:40:12

How to get connected with mysql using perl scripts

Hi all, Please guide me to get the connection with mysql through perl scripts and through the scripts i have to insert some lot of data in the existing tables. Thank you. Regards, Charitha. - Before posting, please check:

AW: MySQL 3.23.47 on MacOSX 10.1.2: Could someone help me getting started

Paul, Okay, then try adding the --user=mysql option to the command. I killed the server (kill -9) and brought it back up with -Sg --user=mysql: The result: [localhost:/usr/local/mysql] root# /usr/local/mysql/bin/mysqld -Sg --user=mysql --- Here came some hints Cannot initialize InnoDB as

Re: renice -20 $$ in safe_mysqld

On Mon, Jan 28, 2002 at 05:30:00PM +0200, Egor Egorov wrote: Hi, In any place that is reached by the scope of execution of safe_mysqld. It must do fine right in the beginning of the script. It doesn't, or I am making a mistake : If I put renice -20 $$ (tried it on several places in

Re: How to get connected with mysql using perl scripts

Hi, Check the following links: http://dbi.symbolstone.org/ http://www.saturn5.com/~jwb/dbi-examples.html http://www.oreilly.com/catalog/perldbi/ Best of luck. ~ SubbaReddy .M E-mail: [EMAIL PROTECTED] W3Page: http://www.geocities.com/msubbareddy/ ICQ: 56093095 - Original Message

Re: Urgent Help needed

Hi Srinivas, Here is some info, may meet ur requirement. ALTER TABLE syntax :- ALTER [IGNORE] TABLE tbl_name alter_spec [, alter_spec ...] alter_specification: ADD [COLUMN] create_definition [FIRST | AFTER column_name ] orADD INDEX [index_name] (index_col_name,...) orADD

Re: FULLTEXT sintax.

Hi, I don't know if you have already an answer to you problem but.. There is an explanation to this bisarre result: - ++---+-+ | id | title| body

minimal SQL

I am new to databases and SQL and find the language rich and interesting. It seems to me, however, that there are quite a few redundant elements and that the language is the result of quite a few compromises. There are not less than 233 keywords in MySQL. Is there any preferred way to write

Re: How to get connected with mysql using perl scripts

And here some more good links for DBI: http://www.he.net/adm/mysql/chapter7.html http://www.he.net/adm/mysql/chapter6.html ~ SubbaReddy .M Sr. Programmer, Frontlinesoft, Hyderabad ( http://www.frontlinesoft.com ) Ph: 91-40-3392147, 3391683 w3doc: http://www.geocities.com/msubbareddy/

Re: for You

At 01:13 2002-01-30, Engr Duke Paul [EMAIL PROTECTED] wrote: NIGERIAN NATIONAL PETROLEUM CORPORATION (DEPARTMENT OF PETROLEUM RESOURCES) And he subscribed to this list, right? Grrr: database,sql,query,table -- Marjolein Katsma HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools

RE: Urgent Business Assistance.

At 03:52 2002-01-30, Todd Williamsen wrote: If its so urgent and private then why are you spamming a mail list? I smell scam, or is that Spam? It's both. And please do not quote the *whole* spam - the loss of bandwidth (it goes to every subscriber!) from the actual spam is already bad

Re: for You

On Wednesday 30 January 2002 13:02, Marjolein Katsma wrote: At 01:13 2002-01-30, Engr Duke Paul [EMAIL PROTECTED] wrote: NIGERIAN NATIONAL PETROLEUM CORPORATION (DEPARTMENT OF PETROLEUM RESOURCES) And he subscribed to this list, right? Grrr: database,sql,query,table Stop griping. I'm

Urgent Business Assistance.

Urgent Business Asistance. Engr.Martin Douglas. No. 16 Kingsway road, Ikoyi lagos Nigeria. Tel/Fax:: 234-1-7742913 30th,January 2002. Dear sir, REQUEST FOR URGENT BUSINESS RELATIONSHIP. First, I must solicit your

Re: SELECT DISTINCT BINARY crashes mysql on null values

[EMAIL PROTECTED] writes: Description: Executing a SELECT DISTINCT statement in conjunction with the BINARY cast operator will crash MySQL server when the column being cast contains one or more null values. How-To-Repeat: Executing the following code from a mysql

Error 1006: Cant create database (errno:13)

Gwen, Wednesday, January 30, 2002, 7:57:55 AM, you wrote: GT Hi All, GT Forgive me if this question has been asked before. I'm new to the list GT and MySQL! GT I'm getting the ERROR 1006: Can't create database 'tanner'. (errno: 13) GT when signed on as root and as user. GT I've also tried

Nested Queries

Amit, Wednesday, January 30, 2002, 7:45:13 AM, you wrote: ADL Hi!! ADL I am trying to execute the following query. But it is giving ADL an error at select max(columnname). ADL select columname from tablename where columname1 = ADL select max(columnname) from tablename MySQL doesn't

How to get connected with mysql using perl scripts

Charitha, Wednesday, January 30, 2002, 10:21:11 AM, you wrote: C Hi all, C Please guide me to get the connection with mysql through perl scripts and C through the scripts i have to insert some lot of data in the existing C tables. You can refer to: http://www.mysql.com/downloads/api-dbi.html

Is Triggers Possible in MySQL

sreedhar, Wednesday, January 30, 2002, 6:02:35 AM, you wrote: s Hi All s Is Triggers Possible in MySQL. If Yes, It is like in other RDBMS. MySQL doesn't support triggers, look at: http://www.mysql.com/doc/A/N/ANSI_diff_Triggers.html s regards, s SREEDHAR -- For technical support

Re: Urgent Business Assistance.

On Wed, 30 Jan 2002, Engr.Martin Douglas. wrote: Urgent Business Asistance. Engr.Martin Douglas. Ok.. I'm about to slamdunk a few phrases into my procmail filters. However, is there any way mere mortals on this list can get the full headers? (sql,mysql,database)

how to give a `root` mysql DB to each user ...

Frederic, Wednesday, January 30, 2002, 4:42:50 AM, you wrote: FT I`ll make myself more clear here ! FT I work for a small ISP, we give a MySQL DB access to each of our corpo FT users, if they request it. We just build new more performant machines, and FT instead of giving them only a Database,

Urgent Business Assistance.

Urgent Business Asistance. Engr.Martin Douglas. No. 16 Kingsway road, Ikoyi lagos Nigeria. Tel/Fax:: 234-1-7742913 30th,January 2002. Dear sir, REQUEST FOR URGENT BUSINESS RELATIONSHIP. First, I must solicit your

mySql ODBC or API which one is FASTER

Which one is faster in mySql api ou odbc, why is it faster and how much ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: MySQL 4.0.1 crashes when updating a field with fulltext index

Mike Wexler writes: Description: mysql crashes with the following stack trace: 0x807db7f handle_segfault__Fi + 383 0x823d60a pthread_sighandler + 154 0x8204407 _mi_compare_text + 71 0x821bb96 _mi_ft_cmp + 158 0x820bb01 mi_update + 721 0x80d07ef

FW: Urgent Business Assistance.

Dear Sir Unfortunatly too many people have already contacted me about this same mater, maybe you could rather say that you are a insurance broker that have to get rid of some policy money after this weeks miltary base explosion in your country, and that you urgently need to get out of the

Seeking Database/Scripts

Greets Folks, This is my first post here, so I'd just like to begin by saying hello. It seems like a busy list, so I hope to learn a lot and make some good contributions myself. =) But, right now, I have a question that I was wondering if someone could help me with... I need a database and

HEAP table size

Hello, I am using HEAP tables and would like to see how much memory they use. I found this snipped of instruction in the MySQL-documentation: -- The memory needed for one row in a HEAP table is: SUM_OVER_ALL_KEYS(max_length_of_key + sizeof(char*) * 2) + ALIGN(length_of_row+1, sizeof(char*))

Re: minimal SQL

Ah Håkan, =A man(?) after my own heart! When I was at school (and bored out of my skull) I was always trying to figure out where the 'Readers Digest Condensed Edition' of our text books was... I am new to databases and SQL and find the language rich and interesting. It seems to me, however,

Fwd: failure notice

Date: 29 Jan 2002 22:01:18 - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: failure notice Hi. This is the qmail-send program at web.mysql.com. I'm afraid I wasn't able to deliver your message to the following addresses. This is a permanent error; I've given up. Sorry it didn't

Re: Order By Query - Simple Help

Ok Jon, I am setting up a small bidding system. I have a table with one column for BID and the other for MAX_BID with each row having a unique id number. Anyone have a simple query example where I can select ID, BID, MAX_BID and sort in descending order the BID and MAX_BID as if it were one

RE: Seeking Database/Scripts

You could try php.resourceindex.com or freshmeat.net -Original Message- From: Will K. [mailto:[EMAIL PROTECTED]] Sent: 30 January 2002 13:30 To: [EMAIL PROTECTED] Subject: Seeking Database/Scripts Greets Folks, This is my first post here, so I'd just like to begin by saying hello. It

Re: Select with while loops

Rick, Welcome to the list - we try not to byte, er, bite... I am trying to do a select that will display events by category, but will NOT display a category name if it is empty (has no events). 2 tables: categories and events events contains a field called category_id that corresponds to the

Re: Manual references to safe_mysqld

Hi Jeremey! I think so. I just did that recently in my book. Imagine how many times I got it backwards and ended up second-guessing myself. :-( Yes I have that confusion all the time, but it is good to have all mysql tools begin with my or mysql. Also because the installation of MySQL does

My OLEDB Problem/Bug

With VB6 When I make an SELECT * FROM table when the tables as one of four type TEXT or BLOB Give always this error Table does not exist What is the problem? If I use other column type don't give the error. Create table example: CREATE TABLE Notas ( ID_Cliente int NOT NULL , Obs text NULL) ;

Size Limitations

Is there a database size limitation with MySQl in the Windows NT and Windows 2000 enviroment? Like some databases have size limitation of 2GB. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: how to give a `root` mysql DB to each user ...

Thanks Victoria, but will not this be very very insecure ? I mean, by granting access to mysql DB, user could drop it, or grab a passwd from another user in there. Am I missing something ? Frederic Trudeau [A]dvanced [S]upport [A]gent Colocation/Customer Support Agent CAM Internet -

triggers, stored procedures, and views

I am building a database system and have been, like many before me, quite surprised that MySQL doesn't support triggers, sp's, and views. I can see how one can get around not having views with advanced permissions, as stated in the manual, although as I understand it this is no substitue for

Re: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2

Cool. And the file ./mysql-3.23.47/sql/sql_udf.cc is present? Did you try a make clean? It shouldn't have any effect on configure but... -- John McCauley CTGi Oakton, VA 703-352-0590 http://www.ctgusa.com From: Ryan Walker [EMAIL PROTECTED] Date: Wed, 30 Jan 2002 00:21:44 -0800 To: [EMAIL

Re: MySQL 4.0.1 crashes when updating a field with fulltext index

Thanks. When is 4.0.2 due? I reported it (in less detail) 2 weeks ago, but didn't here anything back. So I created a test case, etc. Sinisa Milivojevic wrote: Mike Wexler writes: Description: mysql crashes with the following stack trace: 0x807db7f handle_segfault__Fi + 383

Workaround: Shutdown on OS X

For anyone having trouble with shutting down mysqld on OS X (especially if it times out waiting on the PID file): I had been having trouble getting mysql (3.23.26) to shutdown on OS X (10.1.1). I had been using sudo to start safe_mysqld with user mysql Now I su as user mysql to run safe_mysqld

Re: next insert id

I'm not going to address these comments to anyone - in an attempt to avoid inter-personal conflict... Herewith some psychology and philosophy: - some people can't be bothered to read the manual - writing a (good/complete) manual is even harder than reading it - fully appreciating each fine

Re: MySQL compile error, mysql-3.23.47, Mac OS X 10.1.2

Yes, the file is present. Yes, I've made clean between each attempt. At 10:11 AM -0500 1/30/02, John McCauley wrote: Cool. And the file ./mysql-3.23.47/sql/sql_udf.cc is present? Did you try a make clean? It shouldn't have any effect on configure but... -- John McCauley CTGi Oakton, VA

Table types

We're currently using MyISAM tables for everything. Are there circumstances in which the InnoDB table type would be better even if we're not going to use commit/rollback, or are transactions the only advantage of InnoDB? Would InnoDB's row-level locking improve speed over MyISAM for tables

Re: MySQL 4.0.1 crashes when updating a field with fulltext index

Mike Wexler writes: Thanks. When is 4.0.2 due? I reported it (in less detail) 2 weeks ago, but didn't here anything back. So I created a test case, etc. Should be soon. We have few more features to finish and test. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /

Re: Workaround: Shutdown on OS X

No luck with that here. The daemon is unstoppable! -- John McCauley CTGi Oakton, VA 703-352-0590 http://www.ctgusa.com From: Steve Fox [EMAIL PROTECTED] Date: Wed, 30 Jan 2002 09:33:44 -0600 To: [EMAIL PROTECTED] Subject: Workaround: Shutdown on OS X For anyone having trouble with

mysql trouble

Hello, We are students in a french university and we have a trouble while running mysql on our server. After typing the command mysql, we have this message: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) So we should know how resolve it. Excuse me for my

Re: mysql trouble

check your MySQL installation. I had the same problem on my machine, and all I did is create a sym link to /var/lib/mysql/mysql.sock in /tmp. Frederic Trudeau [A]dvanced [S]upport [A]gent Colocation/Customer Support Agent CAM Internet - http://www.cam.org My God ! It's full of stars On

Re: Largest datatype

At 10:07 +0530 1/30/02, Charitha wrote: I am not getting the requirement fulfilled from that manual page. That page gets you to the places in the manual that describe the storage size requirements for each of MySQL's data types. That tells you which of them are large enough to hold 10kb-sized

Re: mysql trouble

30.01.02 16:57:00, valentin [EMAIL PROTECTED] wrote: Hello, We are students in a french university and we have a trouble while running mysql on our server. After typing the command mysql, we have this message: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock'

AUTO_INCREMENT columns randomly restart counting from 1

Hi there We have some table used as sequences. They only have 2 columns (ID, PID), with the AUTO_INCREMENT flag set for one of them (ID). By default the tables are empty! The increment process is done by inserting a new record with a random value for the non-auto_increment column. After that

MySQL and 3NF

Hi, I came across a relationship between entities that I hadn't counted on, and I'm trying to adjust my database tables to handle this new relationship. I need some help with visualizing and implementing this relationship into the database design. The database is for an inventory of

Re: AW: MySQL 3.23.47 on MacOSX 10.1.2: Could someone help megetting started

At 9:57 +0100 1/30/02, Lutz, Helmuth wrote: Paul, Okay, then try adding the --user=mysql option to the command. I killed the server (kill -9) and brought it back up with -Sg --user=mysql: The result: [localhost:/usr/local/mysql] root# /usr/local/mysql/bin/mysqld -Sg --user=mysql Okay, here I

Re: how to give a `root` mysql DB to each user ...

Frederic, Wednesday, January 30, 2002, 4:56:11 PM, you wrote: FT Thanks Victoria, but will not this be very very insecure ? FT I mean, by granting access to mysql DB, user could drop it, FT or grab a passwd from another user in there. Am I missing FT something ? If you create user with

Re: AUTO_INCREMENT columns randomly restart counting from 1

At 17:15 +0100 1/30/02, Andreas Schoelver wrote: Hi there We have some table used as sequences. They only have 2 columns (ID, PID), with the AUTO_INCREMENT flag set for one of them (ID). Is the ID column one of the integer types? By default the tables are empty! The increment process is done

Re: [ale] MySQL and 3NF

From what I understand. Move the volunteer_id from the contributor table. put the contributor_id inside the volunteer table. This way you can have a 1-to-many relationship between the two. --- Get inside Atlanta's Tech Scene - http://www.atlantageek.com 'Business

Re: MySQL and 3NF

Hi. I would type museum: department or likewise in name field if its not so many it would work nicely. But thats just me:) /PM\ David S. Jackson wrote: Hi, I came across a relationship between entities that I hadn't counted on, and I'm trying to adjust my database tables to handle

Structure copy...

Hi, i want to copy a table structure. I saw on the archive, there is a syntax like: create [newtable] select * from [sourcetable] where 1=2; This is not work on my MySQL server v.3.22 Is it a 3.23 feature, or am i do something wrong ? If you know the solution please tell me that. Thx Vaso

RE: AUTO_INCREMENT columns randomly restart counting from 1

I think AUTO_INCREMENT is on a per-connection basis. So if you're doing this across different database connections, it will reset to 0. Rich Hi there We have some table used as sequences. They only have 2 columns (ID, PID), with the AUTO_INCREMENT flag set for one of them (ID). By default

Re: next insert id (slightly OT)

On Thu, 31 Jan 2002, DL Neil wrote: ... What should be understood is that MySQL's implementation of AUTO_INCREMENT requires a particular/different philosophical view: that first the 'primary row' is to be stored, then the AUTO_INCREMENT data captured, and finally the dependent row is

RE: Urgent Business Assistance.

On Wed, 30 Jan 2002, Marjolein Katsma wrote: Date: Wed, 30 Jan 2002 12:33:29 +0100 From: Marjolein Katsma [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Subject: RE: Urgent Business Assistance. At 03:52 2002-01-30, Todd Williamsen wrote: If its so urgent and private then why are you

Re: Size Limitations

At 09:49 AM 1/30/2002 -0500, Hashim Ismail wrote: Is there a database size limitation with MySQl in the Windows NT and Windows 2000 enviroment? Like some databases have size limitation of 2GB. Yes. Read the manual. In a Windows environment, table sizes are limited to 2 gigabytes if memory

select woes

Hello. If anyone has a quick moment, I would appreciate some suggestions with regards to the following select statement: SELECT widget_src FROM widgets WHERE items.foo='abc123' and item_details.item_type='I' and items.item_detail_id=foo.item_detail_id; Upon execution, I'm getting ERROR 1109:

Re: MySQL 4.0.1 crashes when updating a field with fulltext index

Which features are planned, but not implemented for 4.0.2? I assume they are featured either listed at http://www.mysql.com/doc/N/u/Nutshell_Future_features.html or are very small features, right? When are the new, text .frm files going to be introduced? Sinisa Milivojevic wrote: Mike

Can't untar mysql on Solaris 8

Hi. I've downloaded the .tar.gz files for MySQL 3.23.48, 3.23.47 and 3.23.46 for Sparc-Solaris 8 and all of them complain of a checksum error on the tar-extract. Here's the output of tar xvf of the gunzip'd-tar file: x

Re: select woes

You must also define the tables you want to 'look' at in the 'FROM' clause On Wednesday 30 January 2002 12:08, George M. Ellenburg wrote: Hello. If anyone has a quick moment, I would appreciate some suggestions with regards to the following select statement: SELECT widget_src FROM widgets

RE: Size Limitations

The manual doesn't specify the Windows limit - only the Linux value of 2 gb. -Original Message- From: Christopher Thompson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 9:57 AM To: Hashim Ismail; [EMAIL PROTECTED] Subject: Re: Size Limitations At 09:49 AM 1/30/2002

RE: MySQL and 3NF

Create two association tables: Contributor ++--+--+-+-++ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-++ | Contributor_ID | tinyint(3) | |

Re: Can't untar mysql on Solaris 8

Yes, it's a bug. In Solaris. You must use GNU tar, not Solaris tar. http://www.mysql.com/doc/S/o/Solaris.html At 12:15 -0500 1/30/02, Eurico de Sousa wrote: Hi. I've downloaded the .tar.gz files for MySQL 3.23.48, 3.23.47 and 3.23.46 for Sparc-Solaris 8 and all of them complain of a

RE: triggers, stored procedures, and views

Sounds like we just need a table to keep track of LAST_INSERT_ID per table. C:heers -Original Message- From: jds [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 7:05 AM To: [EMAIL PROTECTED] Cc: David T. Anderson Subject: triggers, stored procedures, and views I am

Re: select woes

But you are only selecting FROM 'widgets'. I think you need to buy an introductory book on SQL. I would also suggest 'MySQL' by Paul DuBois ( published by New Riders ). George M. Ellenburg wrote: Hello. If anyone has a quick moment, I would appreciate some suggestions with regards to the

Re: Can't untar mysql on Solaris 8

Use gtar. Eurico de Sousa wrote: Hi. I've downloaded the .tar.gz files for MySQL 3.23.48, 3.23.47 and 3.23.46 for Sparc-Solaris 8 and all of them complain of a checksum error on the tar-extract. Here's the output of tar xvf of the gunzip'd-tar file: x

RE: Size Limitations

The Linux version no longer has 2 GB limit. It is now whatever your disk capacity is. -Original Message- From: Steve Kramer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 11:34 AM To: Christopher Thompson Cc: MySQL Subject: RE: Size Limitations The manual doesn't specify

Re: Can't untar mysql on Solaris 8

Solaris tar is broken (can't handle long file names). You need to use GNU tar. See http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Solaris Michael On Wed, 30 Jan 2002, Eurico de Sousa wrote: Hi. I've downloaded the .tar.gz files for MySQL 3.23.48, 3.23.47 and

Re: Once more: MS Word MyODBC !?!?!

Hello Folks, oncemore I post this question: Is it possible to update data from Microsoft Word useing MyODBC? Is there any other way to update data from MS Word? Is here a VB Scripting Guru who can help me? cheers, Felix. (keywords: database, table, sql) :-)

Really good idea on Performance Tuning???

I sent a reply back to JW about his problem on performance tuning and came up with I thought a really good idea. But there weren't any bites so I thought I start it on a new thread. There are a lot of threads about setting up MySQL for the best performance. This might help to solve the

mutiple-column index and sorting (DESC)

Hello. I'm new to this mailing list :+) I created a mutilple-column index, say create index col1_col2 on table_name (col1,col2) Both col1 and col2 are mediumint unsigned. explain select * from table_name where col1='value' order by col1 DESC,col2 DESC shows that the query is still

Re: Structure copy...

At 17:29 +0100 1/30/02, Vasoczki Ferenc wrote: Hi, i want to copy a table structure. I saw on the archive, there is a syntax like: create [newtable] select * from [sourcetable] where 1=2; This is not work on my MySQL server v.3.22 Is it a 3.23 feature, or am i do something wrong ? It's a 3.23

RE: Structure copy...

Yes, just i need to make it from code, and from a windows machine, so i cant use shell() or something like that... So i need to upgrade... Vaso -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: 2002. janur 30. 19:31 To: Vasoczki Ferenc; '[EMAIL PROTECTED]' Subject:

RE: Once more: MS Word MyODBC !?!?!

Yes, using MS Query which comes with Office ODBC must be installed and working with a DSN set to you MySQL database then... See if you have MSQuery installed... if you do the file name is MSQRY32.EXE in your Office directory. If MSQuery is not installed, find your Office 2k CD and run setup.

Re: How to get connected with mysql using perl scripts

Hi, see the DBI perldoc here is a quick example: my $dbh = DBI-connect(DBI:mysql:mydb, $user, $password) or die Can't connect to $data_source: $DBI::errstr; Charitha wrote: Hi all, Please guide me to get the connection with mysql through perl scripts and through the

RE: Size Limitations

On Wed, 30 Jan 2002, Rick Emery wrote: The Linux version no longer has 2 GB limit. It is now whatever your disk capacity is. The no longer, however, is a function of later Linux kernels and filesystems. Linux 2.2 kernels with the ext2 filesystem (probably still the most common setup) have a

Can't install mysql on Solaris-2.5.1.

Dear sir, I used mysql-4.0.1 running on Solaris-2.5.1 and compile with Gcc-2.95.3. (package from www.sunfreeware.com) I used command below. CC=gcc CFLAGS=-O3 \ CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-low-memory

renaming a database

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'm kind of interested to find if there is a way to rename a database with something like the alter command. Looking in the index of the New Riders MySQL book I don't see anything other than renaming tables Looking through the Manual for version 3

RE: float/decimal ?

I need to store data like 12,213142124 where the decimal places can be 12. What column type should i use ? I tried float(4) but that is use only 2 decimal places, and i also tried decimal(12,12) but that is give me back 9. for 10,704704 ? vaso database,sql,query,table just to post :)

Re: urgent respnse

On Tue, 29 Jan 2002, Sasha Pachev wrote: On Tuesday 29 January 2002 06:20 pm, Michael Widenius wrote: I think we can avoid things like this by adding some extra 'not- allowed-on-the-list' words, that a non-subscribe can't use, without including an extra keyword in the email. Sasha,

Re: mysqld with daemontools

On Wed, Jan 30, 2002 at 01:31:53PM +0900, Tatsuhiko Miyagawa wrote: Has anybody out there experienced with mysqld running on daemontools? Yes. We're now testing this combination on our staging server without any problem, but if you can suggest any problem for it or anything, it would be

Storing word doc... 1000th..

I know this was in the list just i really can't found in the archive. I have about 20 tables, and every tables have a questionary in .doc format. I want to archive theese docs. How can i store theese doc files in table, and how can i get back in the same format what i stored ? Thx /replys can be

Re: renaming a database

At 11:10 -0800 1/30/02, JC wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I'm kind of interested to find if there is a way to rename a database with something like the alter command. Looking in the index of the New Riders MySQL book I don't see anything other than renaming tables Looking

SQL help plz

Hi I need help with an sql string: have a table similar to this: idkeynamedate 1 123name1 date1 2 123name1 date2 3 111name2 date1 4 111name2 date2 5 123name1 date3

RE: float/decimal ?

At 20:10 +0100 1/30/02, Vasoczki Ferenc wrote: I need to store data like 12,213142124 where the decimal places can be 12. What column type should i use ? I tried float(4) but that is use only 2 decimal places, and i also tried decimal(12,12) but that is give me back 9. for 10,704704 ?

Batch load of data

Hi. I have a question regarding loading data from text files into tables using the LOAD DATA statement. I tried this under Win98 without success. Basically, I have a file called create.tbl which has CREATE TABLE statements. The last statements in this file are of the form: LOAD DATA INFILE

Re: renaming a database

This may already be implemented, but the MySQL Technical Reference for Version 3.23.41 states: 1.6.2 Things that must be done in the real near future: - Implement RENAME DATABASE. To make this safe for all table handlers, it should work as follows: - Create the new database. - For every

Re: Really good idea on Performance Tuning???

I don't think this will work. The setting depend on a lot more variables then you list. For example the mix of queries to updates. Although what you are suggesting might make a first approximation. Maybe a field where you could copy and paste the output of show status would help to alleviate

Re: Can't untar mysql on Solaris 8

Appreciate those of you referring me to GNU tar - it did untar mysql properly whereas SUN's tar couldn't. Eurico - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: SQL help plz

At 21:36 +0200 1/30/02, P.Agenbag wrote: Hi I need help with an sql string: have a table similar to this: idkeynamedate 1 123name1 date1 2 123name1 date2 3 111name2 date1 4 111name2 date2

mysql trouble

valentin, Wednesday, January 30, 2002, 5:57:00 PM, you wrote: v Hello, v We are students in a french university and we have a trouble while v running mysql on our server. v After typing the command mysql, we have this message: v ERROR 2002: Can't connect to local MySQL server through socket v

RE: SQL help plz

mysql describe mytable; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | id| int(11) | YES | | NULL| | | keyq | int(11) | YES | | NULL| | | name |

RE: SQL help plz

Sorry, I meant: mysql select name,max(dateq) from mytable group by keyq; -Original Message- From: Rick Emery Sent: Wednesday, January 30, 2002 2:14 PM To: 'P.Agenbag'; mysql Subject: RE: SQL help plz mysql describe mytable; +---+--+--+-+-+---+ | Field

RE: SQL help plz

Further, I'd advise NOT using field names like date and key. Using eserved words is never a good prcatice. -Original Message- From: Rick Emery Sent: Wednesday, January 30, 2002 2:16 PM To: 'P.Agenbag'; 'mysql' Subject: RE: SQL help plz Sorry, I meant: mysql select name,max(dateq)

Combining and sorting large tables

Hi, I have two tables I wish to combine into a single table. Both tables use the same format and include a unique key (ID) auto-increment field. Each row also contains a date field. Whoever managed this database in the past at some point set up a new server, and initially had new data sent to

question re: field size

In the process of searching for a dynamic database solution for a work project I have just begun reading about MySQL. So far this looks like a very promising choice for us but I have one extremely basic question that I hope someone will kindly answer for me. Is there a character limit for text

  1   2   >