error in confguring mysql

Dear mysql, I have a problem when I want to configure mysql-3.23.32 from source distribution ( mysql-3.23.32.targz) . Below, I enclose the message after I configure mysql. For your information, I use DEC OSF/1 V4.0 878 alpha as my platform. Also, I have some question. Does mysql support

content of a MySQL-Database on searchable CD-ROM?

Good morning, we want to create a bibliographical database with ca. 500.000 entries and a very simple structure (3 tables) to publish it on the internet (with PHP and Apache). A second aim is to make a CD for those, who cannot always be online. It should be usable like the CD-ROMs you normally

Newbee Question !

Dear lists members, I gonna download MySQL and PHP to install on my machine. But the problem is that I don't know which tarballs are required to do from mysql.com and php.net. I mean I would like to manage databases using HTML interface (MySQL/PHP). Any points or links to the web sites are

Mysql and transactions and perl DBI

Good morning! Where is mistake? my $dbh=DBI-connect("DBI:$driver:$database:$hostname",$user,$pass,{AutoCommit=0}); my $sth=$dbh-prepare(q{ insert into test.Pokus (a,b) values (?,?) }); foreach my $a ("a","b","c","d") { $sth-execute($a,$a); } $dbh-commit;

RE: Newbee Question !

Oh...Yeah I forgot to mention it. It's Red Hat kernel 2.2.16. Apache x.x.19. Browser Mozilla/Netscape. I would like also to verify all users to give their Username/Password to access my database. This Computer gonna be both Server for my team project and Client for me. I mean I'll test and

Re: content of a MySQL-Database on searchable CD-ROM?

if your going to view it with a browser why not include the browser on the CD? and set the home to the first page? At 10:02 AM +0100 1/25/01, Bernd Kulawik wrote: Good morning, we want to create a bibliographical database with ca. 500.000 entries and a very simple structure (3 tables) to

Re: Apache - MySQL - PHP (Auto-start Apache)

You don't configure apache to do this, since apache has no idea when the server boots up... You have to edit your start-up scripts which are mostly in /etc/rc.d to start up apache. There's a huge number of ways to do this (to script it) ie with error checking/without error checking with mail on

Re: Best way to duplicate a table in a running database?

What is wrong with the CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)] [table_options] [select_statement] syntax. Note that you can append a SELECT statement to a CREATE statement to automatically add rows to the new table. Read the following manual sections:

Re: Ignoring duplicate records during bulk import

You will need to add a primary key to the column in your table that will uniquely identify a record. The IGNORE keyword only ignores records that would generate a "duplicate key" error if there is already a record in the table with the same key value. So, use ALTER TABLE and add a primary key to

Re: Select not working selectively

You have read the manual? http://www.mysql.com/doc/F/u/Full_table.html Nathan Cook wrote: When I run this query on a 20,000 record table with 18 fields. The table has some identical entries and I am trying to get a count of those entries descending. SELECT email, fname,

OT - Cron

Hi, I`ve been searching for hours now so I thought I`d ask some lists I belong to, does anyone know of a decent CRON tutorial??? TIA Ade - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: OT - Cron

Actually now I look thats not the one i mean ;=( sorry - cant find the one i was looking for http://www.lfix.co.uk/oliver/linux.mail.crontab.html HTH D - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 25, 2001 9:56 AM Subject:

Drop Database

Hi! I was testing some queries and now I've created a database named "#Muffin", and I cannot drop it! I've tried the following: DROP DATABASE #Muffin DROP DATABASE '#Muffin' DROP DATABASE "#Muffin" But it doesn't work! Please help! / David

Re: OT - Cron

take your time and read man crontab - Original Message - From: "Derek Almond" [EMAIL PROTECTED] To: "Derek Almond" [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 25, 2001 1:25 PM Subject: Re: OT - Cron Actually now I look thats not the one i mean ;=(

Re: Drop Database

David, Firstly are you sure it`s a database you have created and not a table? Either way try the following DROP DATABASE #Muffin; or DROP TABLE #Muffin; HTH Ade - Before posting, please check:

JDBC Driver

Hey dudes I'm having some troubles accessing a Mysql database with Java thru basic JDBC Drivers. Looks like when the java code doesn't receive any replies to its query, it stalls and I'm stuck with a dead process. Which basically annoys me :) Can anyone confirm or infirm the fact that JDBC

RE: Drop Database

Hi! Yes, it is a database. I recieve these errors, regardless if I use the semi-colon: Query: DROP DATABASE #Muffin Returns: ERROR 1064: You have an error in your SQL syntax near '' Query: DROP DATABASE '#Muffin' Returns: ERROR 1064: You have an error in your SQL syntax near

Mysql with BDB Tables : some times mysqld down ...

Description : I am use mysql with bdb tables. My front end is make in PHP 4.0.4. And since i have installed bdb support, some times my ServerMysql (mysqld) down !!! And i lost all my data bases !! Before this, i dont can repair the tables which use bdb tables, and i lost every datas !! I

isamchk / myisamchk return error 22

i am trying to run isamchk / myisamchk on some table files in my database. the tables are read just fine from the mysql terminal and the ANALYZE TABLE query returns no errors, yet the isamchk / myisamchk say"error: 22 when opening ISAM-table ... " the file name is correct ( i get a totaly

PROJECT (for perl/sed/regex person)

I've got a quickie project here, that's over my head, that I could pay a little something for: Can you set up a script that will take flat text files, (one file per record, many files per directory) - and do some sed/regex conditional replace, and turn it into MySQL statements? I've done

PROJECT: for perl/sed/regex type...

I've got a quickie project here, that's over my head, that I could pay a little something for: Can you set up a script that will take flat text files, (one file per record, many files per directory) - and do some sed/regex conditional replace, and turn it into MySQL statements? I've done

Re: Change character set

Firstly, upgrade to 3.23.x as with 3.22 you will need to compile from sources to change character sets. Next, read the following section in the manual: http://www.mysql.com/doc/L/a/Languages.html -- Richard Ellerbrock [EMAIL PROTECTED] [EMAIL PROTECTED] 2001/01/25 01:50:33 Hello, I am

Re: write problems via MS Access 97 in table with timestamp and primary key

Ensure that your TIMESTAMP definition is a TIMESTAMP(14). If it is, identify which workstations are failing and compare MDAC versions against those that are not failing (we are using MDAC 2.5 ). Upgrade/downgrade MDAC as appropriate. In any case, be sure to refresh all the link tables in MS

oriented objetc database

hello there; can someone give me any suggestions for what DBMS should i use for implantation of an oriented object databases. thank's - Before posting, please check: http://www.mysql.com/manual.php (the manual)

hello there;

i don't know what should i do to configurate the odbc driver with mysql. can somone give me a procedure for release this operation - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Problem on installing MySQL in AIX powerPC

Hyup Cho writes: Dear MySQL supporter, I tried to install MySQL version 3.23.32 on our AIX machine but got errors. Source compilation also failed. Here are the situation I worked and attached are error log files. Binary Installation released file :

Re: Apache - MySQL - PHP (Auto-start Apache)

(quicky coz this is way off topic): ln -s /usr/local/apache/bin/apachectl /etc/rc.d/init.d/httpd ln -s /etc/rc.d/init.d/httpd /etc/rc.d/rc3.d/S90httpd ln -s /etc/rc.d/init.d/httpd /etc/rc.d/rc5.d/S90httpd ln -s /etc/rc.d/init.d/httpd /etc/rc.d/rc6.d/K90httpd That should do it. Should bring up

password mysql

we are just getting started using mysql and want to develop an admin password access section for our site using cold fusion mysql. Is thier a site with examples of this type of thing ? Thanks, Byron - Before posting, please

Re: Field_float::val_str crash in 3.23.32

Kevin Day writes: Description: I'm getting a pretty consistant crash in mysqld: /usr/ports/databases/mysql323-server/work/mysql-3.23.32/sql/mysqld: ready for connections Program received signal SIGSEGV, Segmentation fault. 0x282ae35c in bcopy () from /usr/lib/libc_r.so.4

Re: Change character set

This problem is with charset support not by languages. I have also this problem, but at the moment nobody doesn't say anything about this. I am sure so this is a problem in new MySQL 3.23.xx, with oldes version everything was fine. Boril - Original Message - From: "Richard Ellerbrock"

BDB Check tables

Hello monty, As I remember according to documentation MYSQL should support check table on BDB tables: `CHECK TABLE' only works on `MyISAM' and `BDB' tables. On `MyISAM' tables it's the same thing as running `myisamchk -m table_name' on the

RE: Drop Database

Yes I've tried that, but it didn't work either... But now I recieved a "Database Muffin doesn't exist"-error instead! /d -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mikel King Sent: den 25 januari 2001 09:14 To: David Lidstrm Cc: Mysql@Lists.

RE: Drop Database

Outside of MySQL, use a native OS command to rename or remove the directory named '#Muffin' . If you rename it 'foobar', you should be able to DROP it with MySQL. Cheers, Kent Hoover - Before posting, please check:

RE: Drop Database

Yes! This worked! I shut down mysqld, renamed the folder and then I could use a regular DROP query to get rid of the database! Thank you for the help, and all answers! Regards David -Original Message- From: Kent Hoover [mailto:[EMAIL PROTECTED]] Sent: den 25 januari 2001 14:55

Syntax problem: mysqladmin start-slave

What is the CORRECT syntax for the mysqladmin command to start the slave thread at a particular position in the log? Here's the situation I ran into. I got an error message in the slave's .err file that said the following: 010125 9:11:16 Error running query, slave aborted. Fix the

Re: Best way to duplicate a table in a running database?

On Thu, Jan 25, 2001 at 01:43:17AM -0800, Richard Ellerbrock wrote: What is wrong with the CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)] [table_options] [select_statement] syntax. Note that you can append a SELECT statement to a CREATE statement to

Re: OT - Cron

Ade, Try: http://www.ocsny.com/main/index.ocs?url=osl It should have what you need. Cheers, Mikel [EMAIL PROTECTED] wrote: Hi, I`ve been searching for hours now so I thought I`d ask some lists I belong to, does anyone know of a decent CRON tutorial??? TIA Ade

large tables?

hi, i've been asked to design a for a new web-based system which stores lots of data on it's members. There are currently about 500,000 member records. the problem is that i have to store at least 248 pieces of information on each user. i've made the system as relational as possible so that

Changing a Table name

Hi, Is there a quick and simple way to change the name of a Table that is contained within my database? Thanks, Don - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: What now?

Is /usr/local/mysql/bin/ within your PATH environment? What happens when you type the full path to the command: /usr/local/mysql/bin/mysql ? Jonathan - Original Message - From: "Evan James Dembskey" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 25, 2001 9:24 AM Subject:

Berkeley Tables under NT!

I'd like to know if is possible to use Berkeley Tables under MySql Nt version and if the answer is YES, I'd like to know how do I install and use these facility! Thanks! - Before posting, please check:

Re: Best way to duplicate a table in a running database?

Woops! Sorry, but I somehow missed the version number. Yes. You could probably shutdown the server, copy the relevant files making sure the permissions are correct and then restart the server. I would rather upgrade to 3.23.x though! -- Richard Ellerbrock [EMAIL PROTECTED] [EMAIL PROTECTED]

Re: Changing a Table name

Of course there is... ALTER TABLE name RENAME newname ; Of course you can find this sort of thing in the manual of even on Quetin Smith's SQL reference site... http://comclub.dyndns.org:8081/sqlref/ Cheers, Mikel Don wrote: Hi, Is there a quick and simple way to change the name of a Table

Re: parallel Mysql ?

Hi! "Jeremy" == Jeremy D Zawodny [EMAIL PROTECTED] writes: Jeremy On Wed, Jan 24, 2001 at 10:04:36AM -0800, Steven Roussey wrote: Jeremy I'm not sure that this discussion belongs here anymore, so I'll set Jeremy the reply-to and hope the list software respects it. What about scaling read

[Q] I need to pass one database from the computer A to computer B, they have MySQL installed

Hi, I have been designing a database in a computer 'A' with MySQL, now i've finished and i need to copy the database to the computer 'B' which is also with MySQL. The computers operating system is Linux Mandrake 7.2. Where does it store the MySQL databases? , the name of the database is

Patch to add restart to mysql.server rc start script

Dear All Here is a quick / obvious hack to supportfiles/mysql.server.sh to add restart command. I added this as I sometimes do a hard restart, and thought it may be of use to others. Can this be patched to the one in the source by someone with CVS rights - it should not break anything ;-)

Re: Changing a Table name

ALTER TABLE $old_name RENAME $new_name Boril - Original Message - From: "Don" [EMAIL PROTECTED] To: "msql list" [EMAIL PROTECTED] Sent: Thursday, January 25, 2001 4:59 PM Subject: Changing a Table name Hi, Is there a quick and simple way to change the name of a Table that is

OpenBSD 2.8 update / Add to FAQ please

Hi all. I had the OpenBSD problems others have reported, with slow response, high load/cpu usage, crashes, etc. Sinisa reported a month or so ago it was a bug in the 2.8 threading library. I wrote to the OpenBSD developers, and they had made changes to libc_r which solved mysql problems for

Re: PROJECT: for perl/sed/regex type...

see LDIF parsing. Derek Sivers wrote: I've got a quickie project here, that's over my head, that I could pay a little something for: Can you set up a script that will take flat text files, (one file per record, many files per directory) - and do some sed/regex conditional replace, and

Re: Berkeley Tables under NT!

Harja Robert writes: I'd like to know if is possible to use Berkeley Tables under MySql Nt version and if the answer is YES, I'd like to know how do I install and use these facility! Thanks! Hi! This feature for Win32 is in the works. Regards, Sinisa __ _

RE: newbie question re: manual tutorial

Well, I loaded mySQL 3.23.32 onto my RedHat 6.2, kernel 2.2.14-5.0 box, and the installation appears to have gone well. I ran through the problem selects in the tutorial and of course it works properly. (Tutorial steps at

Uninstalling and Troubleshooting RPM

I am very frusturated as of right now. I have a mysql database that doesn't work on Cobalt Raq3. I installed the RPM version and guess what the mysql.sock file isn't there and ther server gives me this error when starting: Starting mysqld daemon with databases from /var/lib/mysql mysqld daemon

RE: Uninstalling and Troubleshooting RPM

Sir, What OS are you running? What version of MySQL are you trying to install? What RPMs are you trying to install? - Scott -Original Message- From: lkeeton [mailto:[EMAIL PROTECTED]] Sent: January 25, 2001 10:56 AM To: [EMAIL PROTECTED] Subject: Uninstalling and Troubleshooting

I am failing to optimize this left join ...

= ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND '20010125' = ArgumentCalendar.Date The second query works correctly with the left join, but now mysql looks at all 19000 records in Parties (according to EXPLAIN) and the query takes about 15 seconds to execute. I have fiddled

Re: large tables?

Hi. I find that 1-to-1 relationships are often useful appropriate, and they would help you reduce the number of columns per row. For instance in some db of people, addresses, salary info, medical info, c, --although they could be jammed into one giant row per person, make perfect sense

CREATE DATABASE not replicated in the slave server

CREATE DATABASE command is not replicated in the slave server. The database is created on the master but not on the slave. The SQL statement does not appear in the replication log file on the MASTER. I have set the master to ignore replicating one database on the master. Is this causing

Re: OT - Cron

Don't you hate it when someone just tells you to read the man files? They seem to be written for C programmers with Unix background. Essential System Administration from O'Reilly has a pretty good tutorial. I just got through researching crontab to set up automatic backup on a new tape drive.

Re: I am failing to optimize this left join ...

ON Preview.CASEID = Parties.CASEID WHERE CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND '20010125' = ArgumentCalendar.Date On 25 Jan 2001 13:17:14 -0500, Brian Hughes wrote: Hi. I have a query which works and is quick, but it misses a couple of records. SELECT

Re: simple SQL question

[EMAIL PROTECTED] wrote: Hi, Sorry for the possible offtopic question I'm going to ask. I have got something similar (this is very simplicated situation of my problem but this is the core of my headache): CREATE TABLE cityname ( id BIGINT NOT NULL AUTO_INCREMENT,

Re: Uninstalling and Troubleshooting RPM

lkeeton wrote: I am very frusturated as of right now. I have a mysql database that doesn't work on Cobalt Raq3. I installed the RPM version and guess what the mysql.sock file isn't there and ther server gives me this error when starting: Starting mysqld daemon with databases from

RE: I am failing to optimize this left join ...

, Parties LEFT JOIN Preview ON Parties.CASEID = Preview.CASEID WHERE Preview.CASEID IS NULL AND CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND '20010125' = ArgumentCalendar.Date Hi. I have a query which works and is quick

Newbie: difference between tinytext and varchar

I am trying to determine when it is best to use varchar and when it is appropriate to use tinytext. I have looked at the manual and have read the difference between them but would like to have an understanding of this in more practical, real-life terms. Is a space between characters considered

Problem with replication. :-(

Hi, I'm running linux, mysql 3.23.32 (latest stable) I have 2 servers running a circular master-slave. Server1 has: log-bin=/var/lib/mysql/binary_log master-host=server 1 host master-user=user master-password=password log-slave-updates Server2 has: log-bin=/var/lib/mysql/binary_log

Re: parallel Mysql ?

Hi, - Original Message - From: Michael Widenius [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Steven Roussey [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 25, 2001 9:28 PM Subject: Re: parallel Mysql ? We plan to use the following algorithm on top of our current

Resource id #2

When I run any kind of query this is the value of result Resource id #2 Example $result= mysql_query (" Select * from ACCT_TBL ") or die ("Error".mysql_error()); print result; any ideas? randy - Before posting, please

RE: Newbie: difference between tinytext and varchar

The answer to your question depends upon depends on the nature of the text information you are going to store: - The length of text you want to store. - Database size and fragmentation considerations. - Uppercase/Lower case significance - Indexing (prior to 3.23). I am trying to determine

RE: Resource id #2

This is really more of a PHP question, than it is a MySQL question mysql_query returns an integer which is the identifier that you will use to call other mysql functions which utilize the results from your query. For example: $row_count = mysql_num_rows($result) ; ...this will set

Re: I am failing to optimize this left join ...

CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND '20010125' = ArgumentCalendar.Date On 25 Jan 2001 13:17:14 -0500, Brian Hughes wrote: Hi. I have a query which works and is quick, but it misses a couple of records. SELECT ArgumentCalendar.Docket

RE: I am failing to optimize this left join ...

ON Parties.CASEID = Preview.CASEID WHERE Preview.CASEID IS NULL AND CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND '20010125' = ArgumentCalendar.Date Hi. I have a query which works and is quick, but it misses a couple

BSDI 4.2?

Anyone have any luck building Mysql 3.32.23 on a BSDI 4.2 machine? I get an error during the make command. Alan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: simple SQL question

On Thu, Jan 25, 2001 at 12:52:11PM -0600, Gerald L. Clark wrote: I would suggest not having 2 cities in your firm record, and making fname,city your key. select * from firms order by fname,city would give you. A+B company Dallas A+B company London New systems Ltd New York New

RE: Berkeley Tables under NT!

I asked a week ago if BDB tables had ever been tested by the MySQL team on RedHat 7. Any ideas? - / Rick Mehalick Senior Consultant / Shell Services International SSI-GPAX / Phone: 281-544-5092(WCK) / Fax:281-544-2646(WCK) / email:

Can I do this in a SELECT

I have a need for a SELECT query... I don't really want any of the data from the select... Rather I need the size of the data basically I need SELECT sum(length(*)) FROM MyDB WHERE MyDB.Something LIKE 'this%' - Before

Re: I am failing to optimize this left join ...

ArgumentCalendar , CaseID , Parties LEFT JOIN Preview ON Preview.CASEID = Parties.CASEID WHERE CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND '20010125' = ArgumentCalendar.Date On 25 Jan 2001 13:17:14 -0500, Brian Hughes wrote: Hi. I have a query

Re: Big Integer

I don't know why you'd really want to store numbers that big. Since mysql's aggregate functions wouldn't work on them anyway, just store the numbers as strings. At 03:53 PM 1/25/2001 -0500, Ashutosh Somani wrote: Hi, I am working on an application where I need to be able to store 96 bit

Re: BSDI 4.2?

Hi Alan, I have uploaded a binary distribution to mysql.com, but they have not yet had time to post it. Here are my instructions for MySQL, Good Luck: My notes on building mysql gunzip mysql-3.23.xx.tar.gz | tar xvf - The default config works pretty well. I change into the directory just

OpenBSD 2.8 update / Add to FAQ please

Hi! "Jonathan" == Jonathan Roy [EMAIL PROTECTED] writes: Jonathan Hi all. I had the OpenBSD problems others have reported, with slow Jonathan response, high load/cpu usage, crashes, etc. Sinisa reported a month or Jonathan so ago it was a bug in the 2.8 threading library. I wrote to the

how to get the union of the values in a SET column ?

I have a column that is defined as a SET. For simplicity's sake, let's say the column is defined as: set_col SET ('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'Z') After entering a few hundred rows, I know that some but not all values of the SET have been used at least once. How can

Re: BSDI 4.2?

"AH" == Alan Halls [EMAIL PROTECTED] writes: AH Anyone have any luck building Mysql 3.32.23 on a BSDI 4.2 machine? I get an AH error during the make command. Using extreme powers of mental telepathy, we might be able to guess your problem. However, if you told us exactly what the errors were,

RE: Apache - MySQL - PHP (Auto-start Apache)

Yes, but does it get cleanly stopped when you shutdown? put the start command in /etc/rc.d/rc.local, fine, but I think there needs to be a kill link added to /etc/rc.d/rc.3 dir. I like the link from apachectl to /etc/rc.d/init.d/ idea: ln -s /usr/local/apache/bin/apachectl

RE: Can I do this in a SELECT

no. You can do: SELECT sum(length(Something)) FROM MyDB WHERE MyDB.Something LIKE 'this%' But you will have to specify that for each field you want...then add them all up to get the length. Cal http://www.calevans.com -Original Message- From: Jason Terry [mailto:[EMAIL PROTECTED]]

Getting autoincrement value from insert using JDBC

Hi all, If I have an insert statement that adds data to a table that contains an autoincrement column, is there a way to get the value of the auto increment column without doing an additional query in JDBC ? . I am using the org.gjt.mm.mysql driver . Thanks

Re: How do I make a CSV dump

If you're running windows go to my.anse.de his client will do it. Scott At 02:54 PM 1/25/2001 -0700, Jason Terry wrote: Anybody have a quick way to make a CSV dump of a SELECT? If MySQL can't do it directly is there an easy way in PERL?

Strange behavior of MySQL 3.23.xx with GROUP BY ...

Hello, I found a very strange behaviour of MySQL 3.23.xx with GROUP BY clause ... I have a Table: CREATE TABLE groupbyTEST ( fldNAME varchar(20) NOT NULL, fldMONTH tinyint(4) DEFAULT '0' NOT NULL, fldSALARY decimal(10,0) DEFAULT '0' NOT NULL, fldDATE datetime DEFAULT '-00-00

Re: I am failing to optimize this left join ...

') AS formatted_date , CaseID.CASEID , CONCAT(Party1, ' v. ', Party2) AS name , Blurb FROM ArgumentCalendar , CaseID , Parties LEFT JOIN Preview ON Preview.CASEID = Parties.CASEID WHERE CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND '20010125

Re: Getting autoincrement value from insert using JDBC

On Thu, Jan 25, 2001 at 05:17:03PM -0500, Gary Lyons wrote: Hi all, If I have an insert statement that adds data to a table that contains an autoincrement column, is there a way to get the value of the auto increment column without doing an additional query in JDBC ? . I am using the

Re: How do I make a CSV dump

As will the urSQL Utility (MS Windows): http://www.urbanresearch.com/ursql urSQL can export query results in a variety of formats: - HTML - CSV - Excel - Word - Text Depending on your data, you might also be able to use the SELECT INTO OUTFILE syntax: select * into outfile "tableout.txt"

RE: simple SQL question

Hi, how about select fname, c1.cname, c2.cname, c3.cname from firms, cityname as c1, cityname as c2, cityname as c3 where first.city0 = c1.id and first.city1 = c2.id and first.city2 = c3.id; CC'ing the dialogue to the list lets us know that you have received the first reply, and what you

Version distribution

Hi, I wonder if any of the mySQL people have any guesses or real stats about the number of people using each version of mySQL. I am wondering if I develop a tool that only supports the latest 3.23 version will I cut out a whole lot of people? How long does it tend to take for most people to

RE: How do I make a CSV dump

mysqldump --tab=/tmp --no-create-info --fields-terminated-by=',' database table Should do the trick. This will create a file called /tmp/table.txt, containing the data. Use --where=".." to select from fields. For more complext selects, look at select field1, field2 into outfile

Large Table Problem

Hello there, I was hoping you guys could help me with a little problem I'm having with MySQL. I'm trying to dump the contents of one field of a multi-field table to a text file. The table is on the large side (about 3 million rows). Whenever I run: SELECT rowname FROM table INTO OUTFILE

Search engine database structure

As I understand it, search engines use a "special" type of database structure. They have a special table for common words/phrases and another one with all the data. They link theese together by a third one that contains only the ids from the other two, thus making the search much faster. How do

Help Pub Crawl display

PUB TABLEEVENT TABLE |p_id|pub_name |address ||eventid|date |host_id| |13 |John Barleycorn's |1800 N. Lincoln ||321|2001-01-27 | 32| |26 |Harry Carry's |300 N. Dearborn ||198|2001-02-21 |

Upgrading to MySQL 3.23.32

Hi All, We are thinking to upgrade our MySQL servers to MySQL 3.23.32. Have any one experienced any unexpected problem due to upgrade. Thanks in advance for any comments. James R. Butzen NEBIS Tech. Support http://www.nebis.com

3.23.32 + FreeBSD 4.2 /w Lastest Snapshots - Still CoreDump

I'm using 3.23.32 + FreeBSD 4.2 /w Lastest Snapshots on a Dual P2 Xeon 400MHz 1MB Cache, 1GB Ram on 3ware IDE RAID The traffic of it is about 300 queries/second on average, and keep staying at around 400 q/s at night. The problem is that, it core dumps in 5-10 mins, especially at night (high

Re: SV: undefined reference to `uncompress' ?

Jarmo Paavilainen ([EMAIL PROTECTED]) writes: I could answer "read the manual", "look it up in the FAQ" and so on. But add "-lz" to you list of libraries to link in (ie libz.so). I couldn't find it in the manual, where did you find it hiding? Thank goodness for this list! -- Ed Carp,

RE: Help Pub Crawl display

Your Query is making me thirsty ;-) Unfortunately your tables got garbled so I had to improvise. Next time don't paste the tables beside each other... Also, I'm not sure if I understand your problem or what you are trying to accmplish. Are you trying to de-normalize your data and display the

Re: 3.23.32 + FreeBSD 4.2 /w Lastest Snapshots - Still CoreDump

On Fri, Jan 26, 2001 at 09:41:09AM +0800, Sam Wong wrote: I'm using 3.23.32 + FreeBSD 4.2 /w Lastest Snapshots on a Dual P2 Xeon 400MHz 1MB Cache, 1GB Ram on 3ware IDE RAID The traffic of it is about 300 queries/second on average, and keep staying at around 400 q/s at night. The problem

Re: Help Pub Crawl display

Thanks for your reply. Believe I'm thristy two and if I ever get this thing to work I'm going to pub crawl all the way home. What I am trying to do is display the beginning and ending points for each pub crawl effedtively leaving out any intermediate stops so that the summary of the pub craw

Converting a dump postgresql

Hello, I'm new with mysql and I've got a little problem. Somebody gave me a dump of a database made with postgresql. So I can't dump it it in my mysql database. Is there a utility that can convert a dump postgresql into a dump mysql? If not, where can I find the rules to convert it by hand.

  1   2   >