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

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 'inn

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 safe_m

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 PR

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 SQL-

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 enoug

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 confid

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

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 tr

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 do

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.ht

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 con

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 Databa

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 confid

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 > 0x80

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 country

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, tha

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 d

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 w

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 id

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 do

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 -> http://

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 views

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: [E

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__F

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 T

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 deta

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, V

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 t

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

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 e

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 o

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.so

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 th

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 contributio

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

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

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 Intell

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 handl

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

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 s

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: U

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 Wex

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 mysql-3.23.46-sun-solaris2.8-sparc/sql-bench/Results/ATIS-Adabas-Linux_2.0.

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 wid

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 -0500,

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 ch

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 buildin

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 t

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 >mysql-3.23.46-sun-solaris2.8-s

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 an

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) :-) --

Re: Help with hanging MySQL server

Egor Egorov ([EMAIL PROTECTED]) writes: > Ed, > > Monday, January 28, 2002, 11:26:44 PM, you wrote: > > EC> Hi! I'm having a problem with mysql hanging. I'm running mysql-3.23.36 on > EC> a Linux 2.2.17 kernel. It ran just fine last week, but when we rebooted the > EC> box, mysql will start,

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 proble

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 u

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

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. január 30. 19:31 To: Vasoczki Ferenc; '[EMAIL PROTECTED]' Subject: R

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. Y

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 > thro

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

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 --e

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. > > >

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

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 >Lo

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 Now

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 "fi

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 tab

Re: mutiple-column index and sorting (DESC)

On Wed, Jan 30, 2002 at 06:21:20PM +, peaw peaw wrote: > 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 wher

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 th

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: Seeking Database/Scripts

At 13:29 + 1/30/02, Will K. wrote: >P.S. Is the Paul DuBois on this list the same Paul DuBois who wrote >"MySQL and Perl for the Web"? > >Just wondering. I believe so, yes. - Before posting, please check: http://www.mys

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

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 socke

RE: SQL help plz

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

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

  1   2   >