Re: Formatting Large amounts of Text into Mysql

tim gales writes: Hi. I am trying to have type in a story into a form textfield and submit it using PHP into blob formatted field mysql database. When I submit, all the returns are removed and all the text runs together like on ebig paragraph. Is there a way to have mysql or PHP

RE: journaled file system

We've had good luck with ReiserFS. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 48 days, processed 1,051,983,004 queries (253/sec. avg) ^^ Are these stats

Re: select stmt problem

Teddy A Jasin writes: Hi, I have this mysql statement: select hpnumber,count(*) as counts from Mobile_Ringtone_Manialogs where counts 10 and datesent between '2001-09-24' and '2001-10-24' and (returncode 0 and returncode 10) group by hpnumber order by counts DESC and i Get this

Re: into outfile error

Avelino F writes: I managed to set the file permission and managed to send the output to the mysql database directory used. Do you know if there is a way to make mysql write to a remote directory? As in on any machine in the world? No. As in on the client machine? Not really, since

Re: journaled file system

On Wed, Oct 24, 2001 at 04:12:27PM +0930, Andrew Braund wrote: We've had good luck with ReiserFS. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 48

Printing

Hi! How print the result from a query on my printer? I'm using the command line on linux. Lets say that I want to print everything from the table Mercedes in the database Cars. How do I adjust the lenght of the lines? // Christian

Re: Re: Question about left join.

This is the second time out of three that I get filtered out. Couldn't this filter be made a little bit smarter? At 10:00 24.10.2001, you wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the

Re:MySQL-Front can't open some InnoDb tables ***

Ansgar, what could cause the problem Brent reports in MySQL-Front? InnoDB returns the error Can't open file mytable.InnoDB when it cannot find the table in its internal data dictionary. Maybe the case of letters in the database name is wrong? Brent, if you look at the MySQL server error log,

Re: Formatting Large amounts of Text into Mysql

I use this function to cleanup my text. It converts any weird characters that may cause problems when outputting to html with php. It also converts end of line to br or br / depending on your version of php function cleanup($copy) { $copy=trim($copy); $copy=htmlspecialchars($copy, 

Pictures in mysql

Hello friends. I am a newbie in mysql and web programming. Can someone please tell me where I can find some info on putting pictures into mysql fields and also how I can use a web interface to add the pictures to the database. Thanks Denis

Re: select stmt problem

for one, counts is not a colums, it aggreate values. In your case, since you didn't group, all record retrieved will have the same value for count(*), the number of record. So of course you can't order by counts, it's a single value. On Wednesday 24 October 2001 02:43 am, Carl Troein wrote:

Re: Pictures in mysql

You should just enter the path to the picture in the database, in a varchar field. On Wednesday 24 October 2001 08:09 am, [EMAIL PROTECTED] wrote: Hello friends. I am a newbie in mysql and web programming. Can someone please tell me where I can find some info on putting pictures into

Apostrophe In SELECT

Hi, I am having bother trying to perform a select, that has an apostrophe in the value I’m looking for. Below is the Perl code I’m using. $SQLStatement = SELECT ID FROM Albums WHERE Name = '.$DBHandle-quote($Name).';; $STLookUpHandle=$DBHandle-prepare($SQLStatement);

Re: select stmt problem

I did the grouping too... ...group by hpnumber so what could be wrong? regards, Teddy At 02:13 AM 10/24/2001 -0400, Kodrik wrote: for one, counts is not a colums, it aggreate values. In your case, since you didn't group, all record retrieved will have the same value for count(*), the number

Re: Apostrophe In SELECT

On Wed, 24 Oct 2001, John Abel wrote: Hi, I am having bother trying to perform a select, that has an apostrophe in the value I’m looking for. Below is the Perl code I’m using. $SQLStatement = SELECT ID FROM Albums WHERE Name = '.$DBHandle-quote($Name).';;

mysql 4.0

Hi, If I install mysql-4.0 to upgrade in mysql-3.23.xx with old setting value (use myisam type), Could I need to change or re-load my old db? SF - Before posting, please check: http://www.mysql.com/manual.php

Query Analyzer

Are there tools for MySQL like MS SQL Query Analyzer, that can analyze and estimate effectivity of a query? Or is it possible to approximate execution plan of queries that will be run on MySQL with above mentioned utility? Thank you. --- Outgoing mail is certified Virus Free. Checked by AVG

Uneven replication nodes??

I am looking for a creative way to optimize my web application (largely reads) with a transaction firehose on the data input side. Batch vs. OLTP, if you will. Is there any technical reason why I could not configure the master database without indices and the slave(s) _with_ indices? The

Question about Encrypt function and Windows 2000 (Help a Newbie!)

I am working on a password scheme, however I read in the MySql manual that if encrypt isn't available, it will return a null set. This is causing a problem with something I am working on using a windows 2000 machine (with the recent version of MySql for windows platforms), is there a similar

Re: select stmt problem

On Wednesday 24 October 2001 05:43 am, you wrote: I did the grouping too... ...group by hpnumber so what could be wrong? select hpnumber,count(*) as counts from Mobile_Ringtone_Manialogs where counts 10 and datesent between '2001-09-24' and '2001-10-24' and (returncode 0 and

RE: Question about Encrypt function and Windows 2000 (Help a Newbie!)

How about using only one-way passwords. You could check that the encrypted version of their entry matches the stored password data. Its much safer not decrypting anything like passwords. Andrew -Original Message- From: Jeb [mailto:[EMAIL PROTECTED]] Sent: 24 October 2001 10:41 am

Slow multi-column index

Hello all Grateful for any help on this - I have a table (definition for MAIN below) with a number of indexes corresponding to various frequently used queries. A SELECT statement using one of the multi-column indexes is running very slow if it retrieves data that is not in in the index itself.

RE: Pictures in mysql

Yes this is what we're doing. Just put the pathname to the file into a VarChar field. As for using the web to add them, I would suggest using ASPUpload(if you are using ASP), or other similar utility, which allows you to create an upload form then stores the uploaded file into a directory

looping

Hi there, I have a small question for you all (and yes I have searched the documents but not be able to found what I want) Lets say that I have a table with these values 1, 5 and 7 is it possible to create an sql query that will loop through these values a certain amount of time for example if i

Re: looping

You can't at this point. But anyway, it is usually better to make your application do the work than your database. MySQL doesn't process functions faster than you would with arrays (which is what it would have to do ) and it's better to take as much load off from your database. Even if you

Re: Problem compiling MySQL 4.0 with GCC 3.0.1

Fournier Jocelyn [Presence-PC] writes: Hi, I know this problem has already been reported (but I don't remember the solution :( ) : I encounter the following error after installing gcc 3.0.1 and trying to compile MySQL 4.0 : mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0x14): undefined

Re: Slow multi-column index

So, is it *really* the variable length row lookup that's taking all the time here ? I don't see how. 18000 record is nothing and varchar searches are pretty fast. On top of that, you first search is on the date which would be extremelly fast and narrow the next searches to many less

Re: Slow multi-column index

Hi Phil, I suspect you have already answered your own question! Warning: high ignorance factor - am currently researching indexes for myself - if I can't figure it out for myself, you can help me with that later... When the SELECT can, it will answer a query from a scan-of/data-retrieval-from

Re: Length limit of 500 on primary keys?

In the last episode (Oct 23), Jeremy Zawodny said: On Mon, Oct 22, 2001 at 11:42:23AM -0600, Steve Meyers wrote: If you use a good 64-bit hash, I doubt you'll run into any uniqueness problems. MySQL will support that as a 64-bit BIGINT. You especially should not have any problems if you

Re: Tree in SQL

In the last episode (Oct 22), Daniel _a_ said: I have a table in database which describes tree structure of article groups. In this table I have: 1. group_id - group identifier 2. parent_group_id - identifier of parent group I need to select history, from top to wanted group. I can't change

Re: Query Analyzer

Moshe Gurvich writes: Are there tools for MySQL like MS SQL Query Analyzer, that can analyze and estimate effectivity of a query? Or is it possible to approximate execution plan of queries that will be run on MySQL with above mentioned utility? Thank you. --- Outgoing mail is certified

Re: GNU question

Anthony Evans writes: Hi all, I am using the MySQL book by Paul DuBois. Apparently on page 74 mysql has the GNU Readline library built in. When trying an input edit command such as 'Up arrow, Ctrl-P' to recall the previous line when I am at the Dos prompt within MySQL all I ever get is a

Problems Compiling 4.0.0-alpha (fwd)

I submitted this back on the 6th of October, and never got a reply to it, so I'll try one more time in hopes that someone can help me with this compilation problem. I've got a Dual Pentium 233MHz with 64MB of RAM loaded with SuSE Linux 7.1 and gcc-2.95.2. I'm running the 2.4.7 kernel, and I

MySQL question.

Hello, I am using phpMyAdmin which is MySQL database to create database. My OS is windows 2000. For example, I have a table City. It generates for me 3 files: City.frm, City.MYD, City.MYI My question is how I can connect to this table to do query, insert.by using Java or Visual basic. Thanks

Re: MySQL question.

I am using phpMyAdmin which is MySQL database to create database. My OS is windows 2000. For example, I have a table City. It generates for me 3 files: City.frm, City.MYD, City.MYI My question is how I can connect to this table to do query, insert.by using Java or Visual basic. For

Re: Re:MySQL-Front can't open some InnoDb tables ***

Hi *.* what could cause the problem Brent reports in MySQL-Front? InnoDB returns the error Can't open file mytable.InnoDB when it cannot find the table in its internal data dictionary. Maybe the case of letters in the database name is wrong? Sorry, I don't know.. On win32-hosts letter

Re: select ... on empty innobase tables crashes MySQL-Server

Hi! At 10:38 PM 10/23/01 -0700, you wrote: On Tue, Oct 23, 2001 at 01:43:32PM +0300, Heikki Tuuri wrote: Hi! Thank you for a detailed bug report. This bug is already fixed in the source release 3.23.43b available from http://www.innodb.com Is there now a test case for it in the MySQL test

RE: Pictures in mysql

as someone suggested, if you have ASP, you can get an upload module. if you have php 4, you already have full capability to upload images, either using FTP, or if your server will let you copy from the temporary directories, for instance: page 1 has a form that allows you to select an image on

SCO OpenServer 5.0.x and Mysql DBI Driver

Hello all, I'm the poor guy trying to get Perl talking to a MySQL database on SCO OpenServer 5.0.5. I've managed to get the binary distributions of MySQL 3.23.43 working, as well as DBI-1.20 installed. However, I cannot get the MySQL driver working. It compiles, but the 'make test' returns the

Link error : where is compress ?

Hello. I am linking with libmysqlclient as told by the MySQL Manual. However I am getting the following linker error messages: /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0xbb): undefined reference to `compress'

Re: mysql 4.0

Sommai Fongnamthip wrote: Hi, If I install mysql-4.0 to upgrade in mysql-3.23.xx with old setting value (use myisam type), Could I need to change or re-load my old db? AFAIK, If you are keeping the table type, you can just copy the .MYI, .MYD, and .frm files to the new location. Or

Re: Printing

Wix,Christian XCW wrote: Hi! How print the result from a query on my printer? I'm using the command line on linux. Lets say that I want to print everything from the table Mercedes in the database Cars. Pipes. How do I adjust the lenght of the lines? man nenscript Basically: echo

Spontaneous restarting of mysqld

Hello All. Advise, plz. When some inquires, mysql says: ERROR 2013: Lost Connection to MySQL server during query I repeat my query and result is good after follow message: ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id: 1 Current database: database

Table Crashes Constantly on prod server!!

I am running 3.23.40 on a dual pentium III 800 with 1 GB Ram. I have been getting an table handler returns error 127 error If I fix the table with myisamchk -r or -o it will work for a while and then I will get the same error again. Here are some of the stats on the table rows:1126904 index

Re: DATA DIRECTORY bug on Win32

At 14:24 24/10/2001 +0400, Mike Blazer wrote: Hi Mike, Thanks for the bug report. The explanation why the insert command doesn't works on Win32, is because the link file pointing for the DATA DIRECTORY wasn't created in the create table command, like the Unix version does. The Win32 OSs don't

RE: select stmt problem

Well, count(*) is not a column, it is a function of a column. When it searches, it doesn't know the result of count so you cannot specify it in the where clause. This would work, but you have all the records retrieved, not only the ones who have more than 10 in the group: select

Sessions

Dear members, How to know how many connections are established using the MySQL ODBC driver ? Thanks. Ing. Gustavo A. Edelstein Tech. Mgr. Equiplus Argentina S.A. __ Visit us On Line at www.equiplus.com Email addresses: Operations: [EMAIL

Creating InnoDB tables

Hello everyone, I really need your help. I have been stuck for couple of days on trying to setup MySQL server such, that it supports InnoDB tables. First of all I copy the following into my.ini after [mysqld] innodb_data_file_path = ibdata1:2000M innodb_data_home_dir = c:\ibdata

RE: Slow multi-column index

I'm wondering whether this has something to do with the following words of wisdom in the reference manual: For tables that changes a lot you should try to avoid all VARCHAR or BLOB columns. You will get dynamic row length as soon as you are using a single VARCHAR or BLOB columns. but I

Sessions

Dear members, How to know how many sessions are currently open against a MySQL database ? Thanks. Ing. Gustavo A. Edelstein Tech. Mgr. Equiplus Argentina S.A. __ Visit us On Line at www.equiplus.com Email addresses: Operations: [EMAIL PROTECTED] Consulting:

RE: Creating InnoDB tables

First try: mysqld-max-nt -remove When its the first time running use: mysqld-max-nt --standalone -So you can see what is happening... Shutdown Then: mysqld-max-nt -install Restart as a service. I just went through this last night... Butch Bean -Original Message- From:

RE: Sessions

A quick check of a MyODBC connection made from Access 2000 to a MySQL database (with 5 tables open) shows as a single process in WinMySQLAdmin... the total connections show up as 3 (including the WinMySQLAdmin connection, I assume). Bumping that up to ten open tables and one open query increases

quotes

This is more of a php problem than mysql, but since I am using them in combo... I have a database for people from the former Soviet Union that have participated in a certain program. One of the fields represents the name of their company. It is common (although not universal) practice to use

mysql_errno: 1015, can't lock file(errno: -30989)

I've encountered this problem several times on complicated queries that return no rows. mysql_errno:1015 mysql_error:Can't lock file (errno: -30989) After this error, I can't run queries to any associated tables, and the only I know how to get around it is to restart mysqld. Does anyone know

Re: Length limit of 500 on primary keys?

Steve Meyers wrote: In a previous message, I failed to mention one of the main reasons you would NOT want to use a 500-character primary key. MySQL uses a key buffer to keep as much index information in memory as possible. The longer the key, the less info it can keep in memory, and

Re: Sessions

How to know how many sessions are currently open against a MySQL database ? Gustavo, MySQL manual 7.28 SHOW Syntax Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: SCO OpenServer 5.0.x and Mysql DBI Driver

On Wed, 24 Oct 2001, Scott Powell wrote: Hello all, I'm the poor guy trying to get Perl talking to a MySQL database on SCO OpenServer 5.0.5. I've managed to get the binary distributions of MySQL 3.23.43 working, as well as DBI-1.20 installed. However, I cannot get the MySQL driver working.

Re: install

On Wed, 24 Oct 2001, Allen Tang wrote: I have sco-unix 3.2v5.0.4. Now, install mysql-3.23.43-pc-sco3.2v5.0.6-i386 Seems the mysql server can't start. The error message as follow. Please give me a hint. Thanks. $ ./bin/mysql -h ed -u allen -p Enter password: dynamic linker:

forgot manager password

Hi, i ran into a pretty boxy problem this morning, as I tried to login as mysql manager with #mysql -u root -p # (i forgot the password) its either this, or the other administrator, whom i cannot contact right now, changed the password without my knowledge of it. What can i do? is there

Re: concatenating fields

Harpreet wrote: I am using concat in my sql and it runs fine on mysql client. But when use din php it gives me an error: Supplied argument is not a valid MySQL result resource in b/var/www/html/scripts/cfg_code_delete.php/b on line $ssql=select concat(category, -, code) as fill_column,

Install help

I am thinking of running MySQL on my box for some work with PHP. I am concerned about the mods to the directory structure. I can't seem to find a list for mods it will make on RedHat7.1 Could you please help me out with that? Thanks

Re: Table Crashes Constantly on prod server!!

Michael Blood wrote: I am running 3.23.40 on a dual pentium III 800 with 1 GB Ram. I have been getting an table handler returns error 127 error If I fix the table with myisamchk -r or -o it will work for a while and then I will get the same error again. Try dumping and restroing the

Re: forgot manager password

Oscar Castaneda V. wrote: Hi, i ran into a pretty boxy problem this morning, as I tried to login as mysql manager with #mysql -u root -p # (i forgot the password) its either this, or the other administrator, whom i cannot contact right now, changed the password without my knowledge of

Re: Sessions

Thanks for your answer, but I need to know the names of the users currently logged in the database. Regards, Ing. Gustavo A. Edelstein Tech. Mgr. Equiplus Argentina S.A. __ Visit us On Line at www.equiplus.com Email addresses: Operations: [EMAIL PROTECTED]

Re: Install help

Tom Hicks wrote: I am thinking of running MySQL on my box for some work with PHP. I am concerned about the mods to the directory structure. I can't seem to find a list for mods it will make on RedHat7.1 Could you please help me out with that? Not sure what you mean by 'mod', but you can

Problem with NULLs where they shouldn't be in mysql.user

Under MySQL 3.23.40/Win32 and 3.23.33/Linux, neither mysql.user.user nor mysql.user.password are permitted to have NULL values: mysql insert into mysql.user set user=NULL,password=NULL; ERROR 1048: Column 'User' cannot be null However, the default 'guest' user has NULLs for both of these

Re: Sessions

On Wed, 24 Oct 2001 14:36:45 -0300, Ing. Gustavo Edelstein [EMAIL PROTECTED] wrote: Thanks for your answer, but I need to know the names of the users currently logged in the database. Regards, check your log files, normally found in the DATADIR, this will tell you who's doing what and when.

Re: Sessions

Ing. Gustavo Edelstein wrote: Thanks for your answer, but I need to know the names of the users currently logged in the database. Regards, SHOW will do that as will 'mysqladmin processlist'. http://www.mysql.com/doc/S/H/SHOW_PROCESSLIST.html b.

RE: Sessions

I believe WinMySQLAdmin (if running on Windows) or the Unix/Linux/Solaris equivalent (I assume there is one) shows in its Processes window all users connected to the server and their associated process IDs. Cheers, Fred Woolsey -Original Message- From: Ing. Gustavo Edelstein

RE: Sessions

How to know how many sessions are currently open against a MySQL database ? MySQL manual 7.28 SHOW Syntax Thanks for your answer, but I need to know the names of the users currently logged in the database. Regards, And he told you exactly where to find it. Try SHOW PROCESSLIST

LEFT JOIN?

I have these 3 tables: T1: T2: Service Application | Application Machine --- network DHCP DHCP mach1 Database SQLSQL mach2 EmailExchange SNMP mach2 network SNMP

Re: Table Crashes Constantly on prod server!!

Hi! Michael Blood wrote: I am running 3.23.40 on a dual pentium III 800 with 1 GB Ram. I have been getting an table handler returns error 127 error If I fix the table with myisamchk -r or -o it will work for a while and then I will get the same error again. Try dumping and restroing the

Query help...

I'm trying to come up with a query to do the following... I'm not having lots of luck :( The table is a user database. The columns I'm interested in are: username, lastip. I'm interested in pulling information out that would show usernames for each IP that appears more than once in the

Re: quotes

- Original Message - From: Gregory Jon Welling/Parts Trading Inc. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 24, 2001 10:38 AM Subject: quotes This is more of a php problem than mysql, but since I am using them in combo... I have a database for people from the

Re: quotes

Sorry bout the blank one. try this ?=htmlspecialchars($companyname)? Jim Lucas - Original Message - From: Gregory Jon Welling/Parts Trading Inc. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 24, 2001 10:38 AM Subject: quotes This is more of a php problem than

Re: What is MySQL-max?

I saw this (mysql-max) on the MySQL Website but no where (at least no where obvious) can the description be found. Its here... http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm ini stration.html#mysqld-max I just tried that, it gave me a page not found

RE: What is MySQL-max?

http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Da tabase_Administration.html#mysqld-max I just tried that, it gave me a page not found error. That's because the link is too long for one line -- try copy and pasting, making sure to get the entire link. Steve Meyers

Re: Query help...

Try SELECT lastip,username FROM users HAVING count(*) 1 GROUP BY lastip; (or possibly SELECT lastip,username FROM users GROUP BY lastip HAVING count(*) 1; ) david On Wednesday 24 October 2001 2:21 pm, David Wolf wrote: I'm trying to come up with a query to do the following... I'm not

Absolutely Cannot Do Anything

Hi I've installed MySQL 3.23.43 binaries on Solaris 2.5.8 without UNIX root privilege. During installation, someone else with UNIX root privileges ran mysql_install_db, added a normal user xxx and an admin yyy. At this point I do not see yyy owns all directories and all files.

relational DBMS vs object-relational DBMS

Everything that I have read describes MySQL as a Relational DataBase Management System (RDBMS). PostGreSQL bills itself as an Object-Relational DataBase Management System. Is there a difference between the two and, if so, come someone either explain the difference or point me to a resource that

Re: Query help...

Not quite what I need.. Though, it's very close :) The problem is that with the query given, it only shows one username for each IP.. I actually want to show ALL usernames for each IP with the IP occurs more than once... (and ignore the users who have a distinct IP address). David -

foreign keys and innodb

Hi, if you want to enjoy the foreign keys from innodb in mysql 4 then you can't use binaries from the rpm files. The rpm files contain innodb .43, not .43b! But the source 4.0.0 and the .tar.gz binary 4.0.0 (non-rpm) contains .43b which supports foreign keys. Kind regards Tore

Re: relational DBMS vs object-relational DBMS

http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci213671,00.html An object-oriented database management system (OODBMS), sometimes shortened to ODBMS for object database management system), is a database management system (DBMS) that supports the modelling and creation of data as

Connecting to a remote database.

Sorry for for the dumb question buuut. I have been connecting to a database on my localhost using perl's DBI.pm This is how I currently do it. use DBI; $data = databasename; $driver = DBI:mysql; my $dbh = DBI-connect($driver:database=$data, username, password) or die Can't

Re: Connecting to a remote database.

Jason Whitlow wrote: Sorry for for the dumb question buuut. I have been connecting to a database on my localhost using perl's DBI.pm This is how I currently do it. use DBI; $data = databasename; $driver = DBI:mysql; my $dbh = DBI-connect($driver:database=$data, username, password)

Re:MySQL-Front can't open some InnoDb tables ***

Hi! Ok, it was probably how Brent had moved .frm files around. MySQL-Front is not to blame. Regards, Heikki http://www.innodb.com At 02:25 PM 10/24/01 -0500, you wrote: At 03:25 AM 10/24/2001 , you wrote: Ansgar, what could cause the problem Brent reports in MySQL-Front? InnoDB returns the

Solaris 2.6

I am running Solaris 2.6 (on Sparc) and would like to install mysql, dose new version mysql 3.23.43 support Solaris 2.6? I only see 2.7 and 2.8 in binary download and notes. Thanks, Sam, - Before posting, please check:

RE: Query help...

I think you're looking for: SELECT username, ip, count(*) FROM users GROUP BY 1, 2 Steve Meyers -Original Message- From: David Wolf [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 24, 2001 12:21 PM To: [EMAIL PROTECTED] Subject: Query help... I'm trying to come up with

Re: relational DBMS vs object-relational DBMS

In Relational Database you usually create tables where the columns are primitive datatypes such as number, varchar2, date (these are oracle primitive dataypes). So... to create a table Customer, for example, you would do something like: create table customer ( customerID number(10),

install mysql

Hi Boyd, Thanks. I check pub/openserver5 nothing relate the MYSQL. What value I should give those two parameter MYSQL_TCP_PORT=??? MYSQL_UNIX_PORT=??? When I run bin/safe_mysql --user=mysqladm get error message 011024 16:44:52 mysqld started dynamic linker :

Re: SCO OpenServer 5.0.x and Mysql DBI Driver

Here are my compiling notes. I find gcc the best for compiling both MySQL and Perl modules as outlined below. Compiling Applications for SCO Open Server 5.0.5 Compiling the Tools This CD contains compilers and tools in the sco-downloads directory that can be loaded using the SCO 'custom'

Re: Query help...

It's still not quite doing what I want. I only want a list of IP's where there are more than 1 instance of an ip--and then display each of the multiple occurrences of the single ip (and repeat for each ip which has more than 1 occurrence).. The queries are all so close, but, don't give what I

RE: Query help...

I think I understand. This should work... select distinct a.username, a.ip from users a, users b where a.ip=b.ip a.username != b.username; Steve Meyers -Original Message- From: David Wolf [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 24, 2001 3:17 PM To: Steve Meyers;

RE: Query help...

David, The way I accomplish this is using two queries...first I write a general query that shows the IP address of any IP that has more than one user associated with it: SELECT DISTINCT(ip) AS ip, COUNT(*) AS count FROM members GROUP BY ip HAVING COUNT 1 ORDER

Re: Query help...

Thanks!! Worked like a dream! I'm not quite sure why it knew to pull only ip's that are in there more than once though? David - Original Message - From: Steve Meyers [EMAIL PROTECTED] To: David Wolf [EMAIL PROTECTED]; Steve Meyers [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday,

Re: install

On Wed, 24 Oct 2001, Allen Tang wrote: Hi Boyd, Thanks. I check pub/openserver5 nothing relate the MYSQL. What you need from this site is all patches for your OS version. uname -X will tell you then you need to down load and install them for your version. What value I should give those two

Re: New server/client protocol

Hi! Jeremy == Jeremy Zawodny [EMAIL PROTECTED] writes: Jeremy On Tue, Oct 16, 2001 at 12:40:31AM +0300, Michael Widenius wrote: Benefits (of BIND): - The server doesn't have to convert numbers to strings before sending them to the client. - The clients doesn't have to convert numbers to

PHP and MySQL 4.0.0

Hi! Sebastian == Sebastian Bergmann [EMAIL PROTECTED] writes: Sebastian Just compiled PHP (current CVS) with support for MySQL 4.0.0, but now Sebastian Apache won't start: Sebastian Cannot load /usr/local/apache2/modules/libphp4.so into server: Sebastian undefined symbol:

Re: Cant optimize self-join order

Eric == Eric [EMAIL PROTECTED] writes: Eric What is quite puzzling is MySQL's estimation of the number of rows Eric from each of the self-joins. The conditions on alias queryTable0 Eric actually refer to 1582 rows, and the conditions on alias queryTable1 Eric refer to 39 rows. Notice in the

Re: bugs for mysql 4.0

Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Jeremy Zawodny writes: On Wed, Oct 17, 2001 at 12:18:28AM +0100, Mark Maunder wrote: Where does one post (possible) bugs for mysql 4? I believe this worked in MySQL 3: mysql create table events ( id int(11) );

  1   2   >