Re: MySQL on iSCSI or IPSAN?

In the last episode (May 22), Jeremy Zawodny said: On Wed, May 22, 2002 at 03:52:33PM +0800, Patrick Hsieh wrote: Hello Dan Nelson [EMAIL PROTECTED], Is there any lock problem on iSCSI or SAN environment? Say, mutliple mysql server mount the backend iSCSI or SAN storage device. Is it

Re: can't connect to server2

you can try command ps -ef | grep mysql to see if safe_mysqld is alive and also one or more mysqld processes are running to check the socket type command netstat -na | grep 3306 see if you can see the processes are listening to the socket if the socket if not being listen, you cannot connect to

Re: Apache + php + MYSQL

Hi, How do i check whether PHP has MYsql support built or not Please help Sameer -- you wrote: On Tuesday 21 May 2002 09:51, Robert Vetter wrote: On Tuesday 21 May 2002 10:38, Sameer Maggon wrote: in /var/www/html/rcmms/appl.php on line 5 Hello, 1. make shure the PHP module is

RE: Apache + php + MYSQL

Hi, try to use phpinfo()... it will list all php configuration and support modules. ? phpinfo() ? -Original Message- From: Sameer Maggon [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 4:37 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Apache + php + MYSQL Hi,

How do I uninstall a MySQL source installation on Linux ?

How do I uninstall a MySQL source installation on Linux ? Regards Jacob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Is Pattern Matching possible with MySQL?

Hi, I have a table with 2 fields, of char type. One field contains a 'ID number'. Another field 'Aliases' contains a list of comma-delimited values. (eg aaa,bbb,ccc) Is it possible using MySQL functions to return the 'IDnumber' when the string aaa exists in 'Aliases' ? Thank u

Re: transferring databases

Hello, check if the files have to be in a special directory. check the datadir varible from show variables hope this helps samier.

Perl DBI

Hi, How can i use Perl DBI to create tables in mysql? Denny __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com

how to tell if innodb has enough memory

Hi. I've got an database-server with 768MB RAM running MySQL/InnoDB. There is quite a lot of I/O activity - about 7Mbytes/s. I am not quite sure why there is so much I/O - maybe the indexes won't fit into memory? Is there a way to tell how innodb is spending available memory? Or even better - a

Re: Problem with index

Hi, I have a Mysql database with one Master and one slave I have a problem with the following table session: +--+-+--+-+-+---+ | Field | Type | Null | Key | Default | Extra |

Re: Union does not work

Dan, Wednesday, May 22, 2002, 7:16:50 PM, you wrote: DL Could somebody tell me what is wrong with this query? DL select location from visiExPr where location=1 union (select location from demandInfoAd where location=0); DL ERROR 1064: You have an error in your SQL syntax near 'union (select

Re: newbie - Old Samp_db question

Eugene, Wednesday, May 22, 2002, 8:59:57 PM, you wrote: EM I searched the archive found the issue but not the answer. EM Configuration: EM I'm running win2000, mysql is loaded and I can manually create databases and EM tables per MySQL manual (via Amazon). I've loaded samp_db in sub EM

Re: Is Pattern Matching possible with MySQL?

Chan, Thursday, May 23, 2002, 10:36:04 AM, you wrote: I have a table with 2 fields, of char type. One field contains a 'ID number'. Another field 'Aliases' contains a list of comma-delimited values. (eg aaa,bbb,ccc) Is it possible using MySQL functions to return the 'IDnumber' when the

Re: Root user Access denied - Please Help!

Miretsky, Wednesday, May 22, 2002, 8:41:57 PM, you wrote: M I tried to create a password for the root user in a new installation of M MySQL by typing M % mysql -u root mysql M Then typing and update statement like M Update user set password = somepassword where user=root; You must use the

update query

Hi could somebody please tell me what's wrong with this query? I just can't find the error in it..and it does not update the records at all... update memberscopy set rank='$rank', cname='$cname', caddress='$caddress', ctel='$ctel',

MySQL Query Speed

Hello our database consists of one table with approx. 150 columns. We have a query going over 11 columns (most tinyint, int and some varchar) Out of 217237 rows the query found 56 matches. Without Indexing, the query took 2,55 seconds. With Indexing, the query took 0,04 seconds. The database

Re: MySQL on iSCSI or IPSAN?

Hello Dan Nelson [EMAIL PROTECTED], So, what will happen if I use iSCSI/Fiberchannel/NFS to share the storage? Well, I am just worried about the chance of data loss in MySQL 3.23 two-way replication. I hope there is a share storage and 2 or more write-only mysql servers could mount the device.

Re: 4.0.1 Bugs

My unions are only performed by a looping script so its ok for me. Thanks for the heads up. Did you encounter any extra problems beyond increasing the heap size? Just so I know in advance, is this a my.cnf option. Ric - Original Message - From: Michael Grover [EMAIL PROTECTED] Cc:

RE: MySQL Query Speed

Sounds about right. How have you got your my.cnf set? Have you got RAID on you HDD? Simon -Original Message- From: Florian Wilken [mailto:[EMAIL PROTECTED]] Sent: 23 May 2002 10:17 To: [EMAIL PROTECTED] Subject: MySQL Query Speed Hello our database consists of one table with approx.

$20 YEAR WEB SITE HOSTING / $9.95 DOMAIN

$20 YEAR WEB SITE HOSTING / $9.95 DOMAIN - Server based in U.S.A - 99.9% uptime - Pay monthly or Yearly by Credit Cards - 50MB Disk Space [more plans are available] - PHP, MySql, CGI, ASP and many more - POP3, SMTP, Forwarding and Auto Reply - Cpanel 4.7 - 1500MB Traffic per month - 9.95$

Re: strange fulltext behavior

Hi! On May 23, Przemyslaw Popielarski wrote: Sergei Golubchik [EMAIL PROTECTED] wrote: It looks like a bug. Can you create a test case for this ? create table tBooks ( isbn char(10) not null primary key, title varchar(60) not null, fulltext index (title) ); insert into tBooks

Re: mysql priviledges question

Taylor, Tuesday, May 21, 2002, 4:40:06 PM, you wrote: TL Could someone give me a brief description of the following priviledges and what they are used for...? TL 1) References Not yet implemented. Is that still true? Yes, it's for future features. If you do this, it will grant you right

Re: Grant tables

Glenn, Thursday, May 23, 2002, 1:11:25 AM, you wrote: GH I have had trouble with the script that creates my user access tables. GH I am assuming those tables should get created in the ./var/mysql folder. They are created in the MySQL data dir. So, if you data dir is /var/mysql they will be

Re: can't connect to server2

Hoa, Thursday, May 23, 2002, 8:49:36 AM, you wrote: HD Okay so it says that I can't connect through socket HD '/var/lib/mysql/mysql.sock'. So I checked and the UNIX socket is located HD here: /tmp/mysql.sock. I'm relatively new to Linux. What does this mean? You should specify path to your

Re: GROUP BY on multiple fields apparently broken

matt, Sunday, May 19, 2002, 6:14:17 PM, you wrote: mDescription: m mysql describe DLSummary; m ++--+--+-+-+---+ m | Field | Type | Null | Key | Default | Extra | m ++--+--+-+-+---+ m

License question ...

Dear friends, I wish to know the answer of the next question : If i add some code/functionality to libmysql.dll (ver 3.x.x) i must change the name of the project or can be remain the same ?(I mean : libmysql or other name) Thanks Regards, Gelu

Re: Perl DBI

Hi Denny, How can i use Perl DBI to create tables in mysql? I am not an expert in CPAN modules for Perl but I am using the DBD module that needs DBI module for access the MySQL. Please see the man pages for DBI module. I am using the: DBI-1.22 DBD-mysql-2.1017 You can installing all

Re: strange fulltext behavior

Sergei Golubchik [EMAIL PROTECTED] wrote: 1 row in set (0.00 sec) Works fine for me (that is No rows - and no bug). Probably, it's one of numerous fulltext-related bugs that were fixed since 4.0.1 release. Will you fix it in 3.23.x ? There is still lot of time (I think) to release 4.x

RE: info...

[snip] can some one point in the right direction .. other than the mysql manul for mroe information on the INSERT SELECT statement whether or not it can handle date inserted from a form on a web page... [/snip] Any query you can write in MySQL monitor can be written in your choice of

RE: info...

Peter said: --- hi there ... can some one point in the right direction .. other than the mysql manul for mroe information on the INSERT SELECT statement whether or not it can handle date inserted from a form on a web page... --- *Any* database can

Re: Problem with join syntax

Hello, thanx for your help. Anyhow this statement does not return the wanted fields. I would like to return the website and the signature of the user, but only if those values are available. There might be none of them available, but maybe 1 or even both. this query: SELECT w.website,

new functions in MySQL ?

Hi, Can we create and add new functions in MySQL with windows NT. This fonctions must be developped on C and C++ ? How compiled this C program in win NT (the compiled file must be a .so or a .dll file ?) exemple : SELECT My_Fonction(name) from personnel; I want to write My_Fonction() and

building tree view in mysql?

Hi, I'm trying to build a simple categories tree in MySQL. Say I have the following table: CREATE TABLE test ( id int(10) unsigned NOT NULL auto_increment, parent int(10) unsigned NOT NULL default '0', name tinytext NOT NULL, PRIMARY KEY (id), KEY parent (parent) ) TYPE=MyISAM;

Re: Moving Data Between Proprietary Database and MySQL

Hello, Because most web providers will not allow direct TCP/IP access to MySQL servers, I am considering the following strategy: a) Save the proprietary database to a file containing a series of SQL CREATE TABLE and INSERT INTO calls. b) Upload the SQL file to the server via FTP. c)

WHERE MATCH () AGAINST ('%$search_string%');

hi all, i'm new to this list. currently busy with mysql. I'm having troubles with the query string below. The part MATCH results in an error: Can't find FULLTEXT index matching the column list however it looks like i'm doing the query according to the manual. Anybody has any clue what's going

SQL Help Needed

I have 2 tables Users (UserID) History (UserID, WeekID, Points) When a User record is created a record is inserted into History with the current WeekID, so for example data could be : Users History -- - 1 - 10 - 1 - 20 - 1 - 30 - 2 -

Re: Perl DBI

Yes. Denny said: Hi, How can i use Perl DBI to create tables in mysql? Denny __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com

FW: newbie - Old Samp_db question

Victoria Thanks for the quick response. If I enter what you provided using a 'dos' command, I get Access is denied. I thought I had to be in Mysql in order to execute the command. So I enter (in dos) mysql\bin\mysql to get into mysql. And, I get the 'Welcome to the MySQL monitor' message. I

Location of header files - RPM

Description: Installed MySQL-3.23.49a-1.i386.rpm and the client. Then tried to install PHP which needs path to header files. From what I can determine from your website documentation, the header files should be in an include directory. There is no include directories under mysql.

Newbie question: Which is better InnoDB or BDB?

Hello, I'm new to MySql. I plan to switch my Java/JDBC web application to use MySql. The application requires transactions so, as I understand it, I need the table types to be BDB or InnoDB. Can anyone offer comments on which file type is preferred? Is one more stable than another? Is there a

Binary Installation of mysql-max

hello, i'm trying to install mysql-max...using binaryver 3.23.49 i change the [mysqld] options in /etc/my.cnf as foollows to enable InnoDB table options:: innodb_data_file_path innodb_data_home_dir but after changing the options, mysqld starts but ends immediately... Pls. let me know the

Re: FreeBSD LinuxThreads from BK Tree?

In the last episode (May 22), Jeremy Zawodny said: Has anyone built MySQL 4.x from the BitKeeper tree using LinuxThreads on FreeBSD? If so, how'd you do it? It looks like someone is in the process of removing getopt_long() usage from the commandline tools. They're doing it backwards,

Re: HELP uncancelled query

I posted this yesterday .. and it didn't seem to catch anyones imagination .. sigh PLEASE .. the developers are looking into their side but I need to find what could cause this type of thing to happen .. We do not have this problem against Oracle. I would prefer not to use Oracle for this

Where is my.cnf in FreeBSD?

Hi. Anybody knows where is the my.cnf file (or equivalent) in FreeBSD? I've installed mysql-3.23.49 using the port in FreeBSD 4.5. The script than launches mysql (usr/local/etc/rc.d/mysql-server.sh) is very simple and don't look for any configuration file. The script is: -

Re: Caching

Hi. If you are using a decent operating system and have enough memory, it will do it for you implicitly by caching the files. This is not as fast as it could be (because the content still has to be evaluated each time), but already gives you the main speed advantage of memory vs. disks. If you

RE: how to design mysql clusters with 30,000 clients?

I believe slashdot uses one heavy duty database server (quad xeon) and a redundant one. This isn't an actual cluster, but I would have to assume that slashdot gets more that 30,000 clients at a time. slashcode.org has information (somewhere deep in there, I couldn't find it, but I remember

Re: new functions in MySQL ?

Try here: http://www.mysql.com/doc/A/d/Adding_functions.html --jeff - Original Message - From: a a [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 23, 2002 6:14 AM Subject: new functions in MySQL ? Hi, Can we create and add new functions in MySQL with windows NT. This

Re: 0xADA1 in ujis character set

Neglected to mention the version (changing is not an option - sorry) Ver 11.15 Distrib 3.23.43, for sgi-irix6.5 (mips) -- (from mysql -V) On Wed, 22 May 2002 15:43:31 + Warren Pollans [EMAIL PROTECTED] wrote: A colleague who is connecting to mysqld started as

RE: Problem with join syntax

* andy thanx for your help. Anyhow this statement does not return the wanted fields. I would like to return the website and the signature of the user, but only if those values are available. There might be none of them available, but maybe 1 or even both. this query: SELECT

Replication problem

Hi all, I have master - Linux 7.2, mysql-4.0.1 and slave - win2000, mysql-4.0.1. I have the following error on my replication server: Table 'access.pagespromo' doesn't exist. Slave error 'Table 'access.pagespromo' doesn't exist.' on query '%' error-code=1146. Error running query, slave aborted.

Re: How do I uninstall a MySQL source installation on Linux ?

On Thu, 23 May 2002, Sharksforum wrote: How do I uninstall a MySQL source installation on Linux ? make uninstall Regards, Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: SQL Help Needed

Ok this should be easy so I'm prolly going to screw it up, but here goes =D Your query should be: SELECT UserID, SUM(points) FROM History WHERE WeekID = 'whatever' GROUP BY UserIdI think that should do it. Someone yell if its wrong though. -Nick I have 2 tables Users (UserID) History

Replication problem

Hi all, I have master - Linux 7.2, mysql-4.0.1 and slave - win2000, mysql-4.0.1. I have the following error on my slave server: Table 'access.pagespromo' doesn't exist. Slave error 'Table 'access.pagespromo' doesn't exist.' on query '%' error-code=1146. Error running query, slave aborted. But

RE: How do I uninstall a MySQL source installation on Linux ?

How do I uninstall a MySQL source installation on Linux ? make uninstall I tried that without success. Would it require the original source code? Regards Jacob - Before posting, please check:

MySQL 4

Hey people, I'm using MySQL 3.23.49 now, but I'd like someone to tell me if I can use new MySQL 4. Is it very buggy? Is it safe enough to use not only at home? AFAIR it has some features 3.23 doesn't have. Thank's in advance. -- Best regards, Olexandr mailto:[EMAIL

RE: SQL Help Needed

* Dave I have 2 tables Users (UserID) History (UserID, WeekID, Points) When a User record is created a record is inserted into History with the current WeekID, so for example data could be : Users History -- - 1 - 10 - 1 - 20

Re: building tree view in mysql?

On Thursday, 23. May 2002 16:16, Sagi Bashari wrote: Hi, snip How can I get MySQL to sort it like that? I tried to use group/order by, but I cannot get it to sort it this way.. Any ideas? /snip For trees you need self joins. Regards Georg mysql, query

Re: how to design mysql clusters with 30,000 clients?

Hi. On Thu, May 23, 2002 at 10:44:15AM +1200, [EMAIL PROTECTED] wrote: At 16:02 22/05/2002 +0800, Patrick Hsieh wrote: [...] 1. use 3 or more mysql servers for write/update and more than 5 mysql servers for read-only. Native mysql replication is applied among them. In the mysql write

Re: how to design mysql clusters with 30,000 clients?

Hi. On Thu, May 23, 2002 at 11:16:33PM +0800, [EMAIL PROTECTED] wrote: Hello Benjamin Pflugmann [EMAIL PROTECTED], This scenario is fine. But in real life, the circular master-slave replication will probably cause inconsistency of data among them. That is why I wrote you have to take care

errno: 145

hi when i try to read a table using query select * from table name it shows following error: cant open file:'anil.MYD'.(errno: 145) y such an error can come!! earlier it was fine. thanx for help anil - Before posting,

Re: newbie - Old Samp_db question

- Original Message - From: Mark Matthews [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, May 23, 2002 12:24 PM Subject: Re: newbie - Old Samp_db question - Original Message - From: Eugene McQuade [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

RE: WHERE MATCH () AGAINST ('%$search_string%');

Hi Wilbert, The error tells it all.. To be able to use FULLTEXT search you have to have FULLTEXT index on the column(s) that you want to perform FULLTEXT search.. See: http://www.mysql.com/doc/F/u/Fulltext_Search.html Gurhan -Original Message- From: Wilbert Enserink [mailto:[EMAIL

RE: newbie - Old Samp_db question

you probably need to supply username and passwword to be able to access to the mysql server? See: http://www.mysql.com/doc/B/a/Batch_mode.html Gurhan -Original Message- From: Eugene McQuade [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 9:43 AM To: [EMAIL PROTECTED] Subject:

Re: Using LDAP with mysql.

openLDAP is capable of using various back end data stores, including an SQL database. You have to set up MySQL (obviously), and set up MyODBC (which probably means you will need to install an odbc manager like iodbc or unixodbc), and create a data source. Then you can reconfigure slapd so it

Re: Location of header files - RPM

On Thursday, 23. May 2002 17:46, Carl Carpenter wrote: Hi, From the php-4.2.1 directory, enter: ./configure --with-mysql=/usr/share/mysql --with-xml --with-apache=/usr/loca l/src/apache_1.3.23/ --enable-track-vars --enable-ftp You don't need the configure option --with-mysql.

Re: FreeBSD LinuxThreads from BK Tree?

On Thu, May 23, 2002 at 10:02:51AM -0500, Dan Nelson wrote: In the last episode (May 22), Jeremy Zawodny said: Has anyone built MySQL 4.x from the BitKeeper tree using LinuxThreads on FreeBSD? If so, how'd you do it? It looks like someone is in the process of removing getopt_long()

Re: SQL Help Needed

Thanks for your responses but it's not that much help I need with my SQL ;-) None of the 3 suggestions work. Please look at the examples I gave. I need *all* UserIDs regardless of whether they have a record in History that matches both UserID and WeekID. In other words some UserIDs will only

replication problem

Hi all, I have master - Linux 7.2, mysql-4.0.1 and slave - win2000, mysql-4.0.1. I have the following error on my slave server: Table 'access.pagespromo' doesn't exist. Slave error 'Table 'access.pagespromo' doesn't exist.' on query '%' error-code=1146. Error running query, slave aborted. But

Re: MySQL 4

On Thu, May 23, 2002 at 08:20:13PM +0300, Olexandr Vynnychenko wrote: Hey people, I'm using MySQL 3.23.49 now, but I'd like someone to tell me if I can use new MySQL 4. Is it very buggy? Is it safe enough to use not only at home? AFAIR it has some features 3.23 doesn't have. Thank's in

Re: Where is my.cnf in FreeBSD?

In the last episode (May 23), Iago Sineiro said: Hi. Anybody knows where is the my.cnf file (or equivalent) in FreeBSD? I've installed mysql-3.23.49 using the port in FreeBSD 4.5. Run mysql --help: Default options are read from the following files in the given order: /etc/my.cnf

Deleting from multiple tables

I am using MySQL with a PHP front end. Is there a better way to delete from multiple tables than the following? $result=mysql_query(DELETE FROM team WHERE team_id = '$team_id'); $result=mysql_query(DELETE FROM conflicts WHERE team_id = '$team_id');

Re: MySQL 4

What is it you are trying to accomplish with MySQL? I have MySQL 4.0.1a running on WinNT 4.0 SP6a with Apache 2.0.36 and PHP 4.2.1. So far, in a development environment, MySQL 4.0.1 has done all I have asked it to do (granted I am not doing anything at the edge of the envelope). Mike -

RE: building tree view in mysql?

Hi, There are of course several ways of doing it !! I had to do this kind of thing few weeks ago, and I think the easier way of doing it is use a treepath schema in a field of your table +++---+ | id | treepath | name |

RE: Deleting from multiple tables

[snip] I am using MySQL with a PHP front end. Is there a better way to delete from multiple tables than the following? $result=mysql_query(DELETE FROM team WHERE team_id = '$team_id'); $result=mysql_query(DELETE FROM conflicts WHERE team_id = '$team_id');

Re: how to design mysql clusters with 30,000 clients?

On Wednesday 22 May 2002 18:44, Dave Watkins wrote: At 16:02 22/05/2002 +0800, Patrick Hsieh wrote: Hello list, I am expecting to have 30,000 http clients visting my website at the same time. To meet the HA requirement, we use dual firewall, dual Layer-4 switch and multiple web servers in

Re: Deleting from multiple tables

On 23 May 2002, at 12:48, Steve Buehler wrote: I am using MySQL with a PHP front end. Is there a better way to delete from multiple tables than the following? $result=mysql_query(DELETE FROM team WHERE team_id = '$team_id'); $result=mysql_query(DELETE FROM conflicts WHERE

RE: How can I do this SQL query

How can I do this SQL query I have a file(transfile) that has 2 fields(cust# and item#) CUST# ITEM# 1 '12a' 1 '13a' 2 '12a' 3 '13a' 4 '15a' If I want to select customers that have ordered item '12a' but not

Indexing words

We have an application that needs to index every word (token) in a name, separately. Ex: New York must be indexed under New and York. One solution is to create an auxiliary table, extract the tokens one word at a time, and cross-reference to the key of the original table. Ex: CREATE TABLE

SELECT and WHERE clause

Ok. I can NOT find out what I am doing wrong. The book makes it look like any of these would work (deleted is a column name): SELECT team_id,name FROM team WHERE deleted NOT LIKE '1' ORDER BY 'name' SELECT team_id,name FROM team WHERE deleted != '1' ORDER BY 'name' SELECT team_id,name FROM

Re: Query Problem

I'm wondering if anyone has a response for the query question I posted last night regarding my Songs/Albums/Artists database and related linking tables. I'm new to this list, so I'm not sure what kind of response time to expect. I'm still unable to solve this problem on my own, and searches

mysql load data question

What priviledge does a user need in order to be able to execute the load data infile command in mysql..? is it FILE? Thanks, Taylor Taylor Lewick Unix System Administrator Fortis Benefits 816 881 6073 Help Wanted. Seeking Telepath... You Know where to apply.

Re[2]: MySQL 4

Hello MikeParton, Thursday, May 23, 2002, 9:47:13 PM, you wrote: M What is it you are trying to accomplish with MySQL? M I have MySQL 4.0.1a running on WinNT 4.0 SP6a with Apache 2.0.36 and PHP M 4.2.1. So far, in a development environment, MySQL 4.0.1 has done all I M have asked it to do

Re: How do I uninstall a MySQL source installation on Linux ?

On Thursday, 23. May 2002 19:18, Sharksforum wrote: How do I uninstall a MySQL source installation on Linux ? make uninstall I tried that without success. Would it require the original source code? Regards Jacob just, make clean like in any other makefiles. Regards Georg

RE: mysql load data question

Yes it is ... See: http://www.mysql.com/doc/P/r/Privileges_provided.html Gurhan -Original Message- From: Taylor Lewick [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 4:46 PM To: [EMAIL PROTECTED] Subject: mysql load data question What priviledge does a user need in order to

Re: SELECT and WHERE clause

That did the trick. That just seems like it shouldn't have to be that way. Thanks a LOT Steve At 05:50 PM 5/23/2002 -0400, Keith C. Ivey wrote: On 23 May 2002, at 15:20, Steve Buehler wrote: Ok. I can NOT find out what I am doing wrong. The book makes it look like any of these would

Re: MySQL 4

On Thursday, 23. May 2002 19:20, Olexandr Vynnychenko wrote: Hi, Hey people, I'm using MySQL 3.23.49 now, but I'd like someone to tell me if I can use new MySQL 4. Is it very buggy? Is it safe enough to use not only at home? AFAIR it has some features 3.23 doesn't have. Thank's in advance.

Re: MySQL on CYGWIN installtion

Hi, On Thu, 2002-05-23 at 13:29, [EMAIL PROTECTED] wrote: Anybody has tried installing MySQL on CygWin? Not to evade your question, but... why would you want this, since there are native Windows binaries? Faster and more reliable. Regards, Arjen. -- MySQL Training in Australia: 9-13 Sep

RE: SQL Help Needed

* Dave Thanks for your responses but it's not that much help I need with my SQL ;-) None of the 3 suggestions work. Please look at the examples I gave. I need *all* UserIDs regardless of whether they have a record in History that matches both UserID and WeekID. ...and that is what I

Re: Query Help Needed

sql,query I have a table with the following structure: CREATE TABLE cartconfig_module ( UserID int(10) unsigned NOT NULL default '0', GroupID int(10) unsigned NOT NULL default '0', SiteID int(10) unsigned NOT NULL default '0', Perms enum('Modify','View','Deny') NOT NULL default 'View',

php+apache+mysql installation. Help!

Hi, I am new to linux and trying to install Apache, php and mysql on my Redhat 7.2.Linux box. When I run the configure for PHP 4.2.1, I got this error: checking whether build environment is sane..configure error:newly created file is older than distributed files! I have Apache 1.3.20 (from

Re: SELECT and WHERE clause

You should also get rid of the quotes, so MySQL doesn't have to convert from string to integer: SELECT team_id,name FROM team WHERE deleted != 1 ORDER BY 'name' --jeff - Original Message - From: Steve Buehler [EMAIL PROTECTED] To: Keith C. Ivey [EMAIL PROTECTED]; [EMAIL PROTECTED]

MySQL-InnoDB autoextend syntax gives errors

I changed my.cnf to add an autoextending datafile but I get errors on startup. Here's the my.cnf syntax: innodb_data_file_path = hat/hatdata1:64M;hat/hatdata2:64M:autoextend Here's the error output from mysqld: InnoDB: syntax error in innodb_data_file_path 020523 16:34:24 Can't init databases

Re: Location of header files - RPM

The quick way to answer this question is to go to the directory where you have the rpm (if you still have it) and run the following command: rpm -qpi -l MySQL-3.23.49a-1.i386.rpm This will give ytou the details on where everything has been installed. On Thursday 23 May 2002 11:46 am, Carl

RE: How can I do this SQL query

* Smith, Mike I have a file(transfile) that has 2 fields(cust# and item#) CUST# ITEM# 1 '12a' 1 '13a' 2 '12a' 3 '13a' 4 '15a' If I want to select customers that have ordered item '12a' but not '13a' How can I do

RE: Query Problem

Thanks for the tips! I'll definitely try that out. I've already finished the arduous task of entering all of the playlist data, I have all of the data in a readily sortable form, so trying out different stuff doesn't involve much more than creating tables and writing my queries. Let me throw

GUI compiling on OSX

Greetings. I'd really enjoy having a SQL GUI for my Mac laptop, is it likely that one of BSD sources will compile under OSX? I haven't compiling anything yet, so I thought I'd should ask if it has been mentioned before. -

Re: MySQL-InnoDB autoextend syntax gives errors

Hi Steve, On Fri, 2002-05-24 at 09:56, Orr, Steve wrote: I changed my.cnf to add an autoextending datafile but I get errors on startup. Here's the my.cnf syntax: innodb_data_file_path = hat/hatdata1:64M;hat/hatdata2:64M:autoextend Here's the error output from mysqld: InnoDB: syntax

query

Hi everybody, Can anybody help me? is there any other specific command instead order by ID DESC to select all the record from table where the ID is the last ID.The ID is autoincrement. Record is like this:- ID name gender 1 aF 2 bM 3 cM 4 dF 5 eM Result should

Re: Help with REPLACE INTO statement syntax

At 21:27 -0500 5/23/02, Andrew Lietzow wrote: Dear MySQL wizards, I have two tables, call them A and B. The database structure is identical. I want the records in B to overwrite the records in (REPLACE INTO) A. This is the statement that does NOT work. REPLACE INTO a SELECT b.* FROM b

Re: php+apache+mysql installation. Help!

Dear Andy, Here's a thought. Before you go much further, install Apache 2.0.36. It's easy to install and lots of improvements will be gained that you'll appreciate down the road, i.e. mod_ssl is preconfigured into the system. Andrew Lietzow The ACL Group, Inc. On Thursday 23 May

  1   2   >