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

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 or depending on your version of php function cleanup($copy) { $copy=trim($copy); $copy=htmlspecialchars($copy, ENT_QUOT

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

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

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)."';"; > $STLook

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 (the

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 anti

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 int

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 f

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 (ret

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

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

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 struct

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

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

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 coul

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

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 le

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 th

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

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 c

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 c

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 i

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 hav

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 f

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.

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 let

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

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 yo

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 fo

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' /usr/lib/mysql/libmysqlclie

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

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

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 len

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 hav

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

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

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 set-variabl

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

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

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

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 qu

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 why

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

create table w/ SELECT statement

Can someone tell me why this doesn't work? create table download_warehouse ( avalonid int, downloads int, month int, year int ) SELECT avalonid, count(avalonid) downloads, month(stamp) month, year(stamp) year FROM avalon_downloads group by avalonid, month, year; The select statement works fine b

install

Hello, 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: ./bin/mysql: symbol not found: bzero Killed $ ./bi

Re: quotes

Gregory, This is a PHP question, really, but... If you just echo the $companyname variable, you don't need double quotes around it: If that is not what you are actually doing, give us the real code you are usign with $companyname in it, and we'll take it from there. At 19:38 2001-10-24 +0200

RE: concatenating fields

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 /var/www/html/scripts/cfg_code_delete.php on line < $ssql="select concat(category, "-", code) as fill_column, code_id as submit_colum

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 workin

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 linke

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 som

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 > /var/www/html/scripts/cfg_code_delete.php on line < > > $ssql="select concat(category, "-", code) as fill_colu

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 know

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] Cons

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 values

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

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 [mailto:[EMA

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 SHO

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 Exch

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

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

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

Re: quotes

Sorry bout the blank one. try this 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 mysql, but since I am using them

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

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 Me

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 no

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

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 e

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

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 obj

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 "

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", "use

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 re

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

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 u

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), custo

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 : /usr/local/mysql-3.23.43-pc-sc

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

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 wan

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 Meyer

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 B

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:

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 tw

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

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 sy

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

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

  1   2   >