Re: Regarding SQL query with Unique

use distinct() instead. - Original Message - From: "AVDHUT SHEDGE" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 08, 2001 3:00 PM Subject: Regarding SQL query with Unique > We want to get the Unique value from a table. > can we use the following query: > > select uniq

Regarding SQL query with Unique

We want to get the Unique value from a table. can we use the following query: select unique(ProblemNo) from MainProblem; where MainProblem is a Table having Column ProblemNo. the contents of ProblemNo are 1 1 2 2 3 3 3 the result of the above query must be : 1 2 3 Thank You. __

Re: Server Hardware

depends on your budget :) We assembled a nice dual pIII server with 512Mb ram and 40Gb ide disk (+40 for backup) running redhat 7 for less than $3000 You can spend any amount you like, from $30 for an old P133 up to $3 for a compaq, and choose almost any platform you like. without indicat

MySQL

Fatal error: out of dynamic memory in yy_create_buffer() in Unknown on line 0 I am getting this error on my machine. MySQL proccesses are growing up to consume all the machine memory. I have seen them running with 48 M . How can I find out the source of the problem ? ; how can I check

'Can't find file: './mysql/user.fr

I get the following message: $ mysqladmin -u root password 'newpassword' mysqladmin: unable to change password; error: 'Can't find file: './mysql/user.fr m' (errno: 13)' I think I may have run scripts/mysql_install_db twice! (never work on a computer when you're half asleep!) Could that be t

Re: AUTO_INCREMENT Confusion

At 12:14 AM -0400 5/8/01, Kevin McBrearty wrote: >I'm a bit confused about AUTO-INCREMENT behaviour. I have a table with an >AUTO-INCREMENT column defined as int unsigned primary key. Records are >regularly added and then later deleted from this table. If the last record >is deleted, the sequence

MySQL Help

Hi, I am having a terrible problem with MySQL and I am desperated as nobody seems to find the source. I have a Web site ( www.genteirc.com ) whith MySQL database access. The problem is that those Mysql processes are growing continuously until they consume all of the memory ( 2 Gig

Re: mysqld - immediate segfault

On Monday 07 May 2001 20:35, [EMAIL PROTECTED] wrote: > >Description: > > I've been using the Slackware mysql package, but I want to use ODBC, and > MyODBC won't compile because "my_dir.h" is missing. In order to get all > the headers, shared libraries, and thread support I need, I apparently >

AUTO_INCREMENT Confusion

I'm a bit confused about AUTO-INCREMENT behaviour. I have a table with an AUTO-INCREMENT column defined as int unsigned primary key. Records are regularly added and then later deleted from this table. If the last record is deleted, the sequence begins at 1 again. Reading from MySQL (Paul Dubois)

How to install MYSQLGUI?

Hi, I'm a new user for MYSQL, I have a problem that I want to install the GUI application for MYSQL. Which I should download and install, also would you mind send or tell me where I can find the install instruction? Thank you for you attention, and I'm look forward to heard from you soon. R

mysqld - immediate segfault

>Description: I've been using the Slackware mysql package, but I want to use ODBC, and MyODBC won't compile because "my_dir.h" is missing. In order to get all the headers, shared libraries, and thread support I need, I apparently have to compile MySQL from source, but I'm can't get that to work.

Re: Problem involving negative values and AUTO_INCREMENT

Why would you want to manually set an AUTO_INCREMENT column?? You might as well use an integer column if you want to be able to change its values... - TIM > >Description: > > On some releases of mysql, after you manually set an AUTO_INCREMENT > column to a negative value, the AUTO_INCREM

Problem involving negative values and AUTO_INCREMENT

>Description: On some releases of mysql, after you manually set an AUTO_INCREMENT column to a negative value, the AUTO_INCREMENT fails. On mysql 3.23.32 mysql> DROP TABLE IF EXISTS temp; Query OK, 0 rows affected (0.00 sec) mysql> CREATE TABLE temp( ->id INT NOT NULL AU

How to get rid of the lock on database?

MySQL support two locks:table lock,db lock, is it true? if true,how could I get rid of db lock for I want to access two different tables in one db, help! Thanks and best regards ~{B7B~B~FdP^T6Yb~} ~{Na=+IOOB6xGsKw~} - Be

Re: running mysql as different users

It could be either you haven't set up a user by that name or you didn't set that users password correctly. Have another read of Ch 6 of the manual and then the GRANT and REVOKE commands in chapter 7. - Original Message - From: "Xiaowu Gai" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent

Re: problem while SETting A PASSWORD during installation

- Original Message - From: "tang jie" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 08, 2001 5:41 Subject: problem while SETting A PASSWORD during installation > After installation of MySQL version 3.23.37 on > Linux/i386 with the command: > > rpm -i MySQL-3.23.37-1.i38

Re: My SQL C_API(urgent)

Try mysql_real_query(). This function takes three parameters, the first two are the same as mysql_query(). The third is the length of the query string. Regards. Alec At 06:51 PM 5/7/01, VVM Ravikumar Sarma Chengalvala wrote: >Hi, >I am having a peculiar problem with C_API.How to >execute a quer

Re: My SQL C_API(urgent)

On Tue, May 08, 2001 at 12:51:02AM +0100, VVM Ravikumar Sarma Chengalvala wrote: > Hi, > I am having a peculiar problem with C_API.How to > execute a query string with its length more than 255 > characters using mysql_query() function.My sql query > is > more than 255 characters long and is getti

My SQL C_API(urgent)

Hi, I am having a peculiar problem with C_API.How to execute a query string with its length more than 255 characters using mysql_query() function.My sql query is more than 255 characters long and is getting truncated. Regards, Ravi Do

OLAP

Is anyone using mysql for OLAP? Any particular tools to check? thanks in advance, thalis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Server Hardware

We are trying to purchase a server for mysql and were wondering about what is the best hardware to go with. Any suggestions or web sites that have information would be appreciated. Thank you, Dan Mouw

Re: AW: MySQL-Server getting signal 11 ... !!

On Monday 07 May 2001 12:25, Stephan Skusa wrote: > > Some things to do: > > > > * Can you resolve those stack traces with resolve_stack_dump ? Follow > > instructions in http://www.mysql.com/doc/U/s/Using_stack_trace.html > > done ... and attached as mysql.zip > > > > > * What is the structure

running mysql as different users

Hi all: I need help here. I am trying to install mysql here. First, I was able to install it, but only be able to run it as either root or mysql. I tried installation several times. Somehow, it worked now. I was able to login as a different user and run /usr/local/mysql/bin/mysql (just run mysql

Re: char -> varchar ?

Hi, Char columns are used with fixed-length type table, whereas varchar are used with dynamic table. If you have varchar columns in your table, all char columns will be convert to varchar column (you can't have a fixed-length table if your table contain varchar, blob or text field). Here are

Re: char -> varchar ?

Alec Solway wrote: > > Hi, > > In various create table statements char columns are converted to varchar.. > I was wondering why this was happening. Here's an example: > > CREATE TABLE realtors(name VARCHAR(255) not null, address VARCHAR(255) not > null, city VARCHAR(255) not null, state CHAR(2)

Re: char -> varchar ?

http://www.mysql.com/doc/S/i/Silent_column_changes.html second item, quoted here: If any column in a table has a variable length, the entire row is variable-length as a result. Therefore, if a table contains any variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR columns longer than three

problem while SETting A PASSWORD during installation

After installation of MySQL version 3.23.37 on Linux/i386 with the command: rpm -i MySQL-3.23.37-1.i386.rpm two lines of instruction come up, asking to /usr/bin/mysqladmin -u root -p password 'new-password' /usr/bin/mysqladmin -u root -h hostxxx -p password 'new-password' the first line works

char -> varchar ?

Hi, In various create table statements char columns are converted to varchar.. I was wondering why this was happening. Here's an example: CREATE TABLE realtors(name VARCHAR(255) not null, address VARCHAR(255) not null, city VARCHAR(255) not null, state CHAR(2) not null, country CHAR(2) not nu

Re: How to return the value of deleted rows

Not having a copy of the MYSQL manual in front of me, I asked my resident M$ SQL expert. He said if there is no built in function, then do a count before, a count after and subtract the two. :) Cal - Original Message - From: "Carlos Fernando Scheidecker Antunes" <[EMAIL PROTECTED]> To:

Re: How to return the value of deleted rows

If you are using the C or PHP API, use mysql_affected_rows() If you are working with SQL only, then you will need to issue multiple queries. AFAIK there is no MySQL function to return the number of rows affected. --zak - Original Message - From: "Carlos Fernando Scheidecker Antunes" <[E

Multiple connections with the C API

I seem to be having a problem on linux with the mysql c api hanging sometimes when I try to make 2 connections in a threaded program, with p threads. It's redhat 7 box, and it is an intermittient problem. Sometimes it works great, and sometimes it hangs on the second connection. Anyone know

How to return the value of deleted rows

Hello Folks, I wonder how can I return the number of deleted rows after a DELETE SQL statement. Is there any way to return the quantity of updated rows as well? Thanks, C.F.

php - MySQL 3.23.37 problem

I just installed mySQL and want to install the rpm that allows it to communicate with php. When I do that I get the following error: error: failed dependencies: mysql is needed by php-mysql-4.0.4pl1-9 I don't understand. Here is a list of installed components: mysql-DBI-p

RE: Database Connection

http://mmmysql.sourceforge.net/mm.doc.tar.gz -Original Message- From: Greg Cardoza [mailto:[EMAIL PROTECTED]] Sent: Monday, May 07, 2001 3:10 PM To: [EMAIL PROTECTED] Subject: Database Connection Hello: Is there anyone who can supply me with the syntax for connecting to a database usin

Database Connection

Hello: Is there anyone who can supply me with the syntax for connecting to a database using JAVA and mm.mysql... I've been to sourceforge.net and couldn't find exactly what I was looking for. All I'm asking for is the detailed lines of code in the try block statement to connect to a database.

Re: looking for information

Your Name wrote: > > dear sir/madam > i'm currentlly doing a research on MYSQL and i would like to know more > information about it :where does MYSQL come from who created it ... www.mysql.com - Before posting, please check:

looking for information

dear sir/madam i'm currentlly doing a research on MYSQL and i would like to know more information about it :where does MYSQL come from who created it ... - Before posting, please check: http://www.mysql.com/manual.php (the

Alternate Database Location

I have been evaluating mySQL (Windows Version 3.23) as a backend for our Intranet/Management Information Database - so far so good. However, I have one question... how do I point the software to a database location that's not on the same drive as the mySQL software? For example, mySQL is inst

AW: MySQL-Server getting signal 11 ... !!

The Cron-Jobs working on all tables of these database are all running between 2:00 and 4:00 ... none at 0:00! > -Ursprungliche Nachricht- > Von: Gerald Clark [mailto:[EMAIL PROTECTED]] > Gesendet: Montag, 7. Mai 2001 15:24 > An: Stephan Skusa > Cc: MySQL > Betreff: Re: MySQL-Server getti

Errcode 122 - Redhat Linux question

I had an errcode 28, so redirected the tmpdir to my /home directory. Now I'm getting another error. I don't know if this is Linux or MySQL?? mysql> select count(*),state from import_talents group by state; ERROR 3: Error writing file '/home/tempspace/MYfZExbS' (Errcode: 122) Error 122 tells me

Re: restoring mysql db backup..

Helza wrote: > > Hi, > > I've made an backup of my MySQL db using: > > mysqldump -uoperatio_operati -p* operatio_forum >> database.sql > > and with: > mysqldump -uoperatio_operati -p* --quick --add-drop-table --add-locks >--extended-insert --lock-tables operatio_forum > database.sql >

RE: NULL value in VARCHAR fields SOLVED

Though really, this shouldn't be done in this way at all (i.e. having to rebuild mysql with some flag that has unknown potential other effects..) It's OK to implement it in such a way that columns with not-NULL constraints automatically get some default. What's wrong is in hard-coding an error if

restoring mysql db backup..

Hi, I've made an backup of my MySQL db using: mysqldump -uoperatio_operati -p* operatio_forum >> database.sql and with: mysqldump -uoperatio_operati -p* --quick --add-drop-table --add-locks --extended-insert --lock-tables operatio_forum > database.sql both produce a mysql back of aro

Re: Probs with AUTO_INCREMENT column - thanks

Right, only on an INTEGER col, as documented [sheepish grin] thanks all matt On Mon, 07 May 2001, Peter Pentchev wrote: > > On Mon, May 07, 2001 at 07:21:59AM -0700, [EMAIL PROTECTED] wrote: > > > > Hi all, > > > > I've started using MySQL for the first time and I'm hvaing a bit of a probl

RE: mysqladmin

http://www.mysql.com/doc/C/o/Connecting.html Scroll to the bottom, where it describes adding your password to .my.cnf in your home directory. > I actually wanted to disable passwords completely. > > so when I type mysql the mysql> comes up. > > Tom -

Connection problem

Hi, I got Mysql running for few month whitout problem, but since one week à got these error: - Warning: MySQL Connection Failed: Unknown MySQL Server Host '**.**.com' (2) in dbConnect.inc on line 14 Unable to connect to database - Warning: MySQL Connection Failed: Lost connection to MyS

Re: SELECT DISTINCT or GROUP BY problem

On Monday 07 May 2001 03:37, Andrew Leshkin wrote: > Hello, > > I have the following perfomance problem with simple query on one of my > servers: > > Here is my table ~6 records. > > +-+-+--+-++- > ---+ > | Field | Type

Re: MySQL-Server getting signal 11 ... !!

On Sunday 06 May 2001 20:06, Stephan Skusa wrote: > Hello, > > I've got a problem: > > My MySQL-Server gets signal 11 almost every day arround 0:00 am ... I have a > nice > mrtg - graph showing this ... ;o) > > In fact every time the server crashes the statement shown in the server.log > (or a

Do I need to locak a file when foind a SELECT?

Hi, As the subject states, I am getting an error in my Perl script telling me that a table is not locked yet all I am doing is a SELECT. Why do I need lock a table in order to issue a SELECT? The code in question is: $sqlCmd = $dbh->prepare(q{ SELECT Booking FROM Bookings where

Re: Question regarding memory usage

Hi, >From a system point of view, there are 3 main reasons for a slowdown: - CPU : Your machine is slow because the CPUs are at 100% and can't do anything more. - I/O : Your processes are waiting for data from the disk. - RAM : You don't have enough RAM so your machine is swapping and al

Re: Question regarding memory usage

On Mon, 7 May 2001, Rene Tegel wrote: > On Mon, 7 May 2001 07:40:26 -0400 (EDT) > <[EMAIL PROTECTED]> wrote: > > > > > Thanks for the quick reply. > > > > I set max_connections so low because even at peaks I never need more, and > > when the slowdowns happen, it seems to have an easier time r

Re: Probs with AUTO_INCREMENT column

On Mon, May 07, 2001 at 07:21:59AM -0700, [EMAIL PROTECTED] wrote: > > Hi all, > > I've started using MySQL for the first time and I'm hvaing a bit of a problem with >defining an AUTO_INCREMENT column. I'm using ver 3.23.32 which I downloaded for >Linux and Win2k. I am having this problem on

Probs with AUTO_INCREMENT column

Hi all, I've started using MySQL for the first time and I'm hvaing a bit of a problem with defining an AUTO_INCREMENT column. I'm using ver 3.23.32 which I downloaded for Linux and Win2k. I am having this problem on both systems. Ok if I try to run the create table statement: create table

Re: Cron job to start/restart mysql for non-root user

On Fri, May 04, 2001 at 06:08:29PM -0700, Gary Bickford wrote: > I have a 'normal user' mysql setup on a server not my own - I have no > root access and they won't add mysql to the server's startup scripts. Many free Unix-a-like's are using Paul Vixie's cron, which I think has an undocumented '

Re: MySQL-Server getting signal 11 ... !!

Check what cron does every day at 0:00. It is probably deleting your socket. Stephan Skusa wrote: > Hello, > > I've got a problem: > > My MySQL-Server gets signal 11 almost every day arround 0:00 am ... I have a > nice > mrtg - graph showing this ... ;o) > > In fact every time the server cras

Re: socket

On Mon, May 07, 2001 at 04:08:53PM +0300, Halil TAS wrote: > I Installed redhat 7.1 and Mysql. And use mysql_install_db and know when i > use mysqladmin -u root -h myhostname -p password 'mypassword' take a error > message. It's began Can't connect to MySQL server on ... (111) and i didn't > see

socket

I Installed redhat 7.1 and Mysql. And use mysql_install_db and know when i use mysqladmin -u root -h myhostname -p password 'mypassword' take a error message. It's began Can't connect to MySQL server on ... (111) and i didn't see mysql.sock file anywhere in my HD. I try telnet myhost 3306 but i

Re: Question regarding memory usage

On Mon, 7 May 2001 07:40:26 -0400 (EDT) <[EMAIL PROTECTED]> wrote: > > Thanks for the quick reply. > > I set max_connections so low because even at peaks I never need more, and > when the slowdowns happen, it seems to have an easier time recovering if > there are 15 slow connections hanging tha

RE: myODBC

I am going to assume that you are on a windows platform and tell you about what I did. I developed a large ERP system using MSAccess for the front end and MySQL for the backend. Because MSAccess doesn't notice changes to the table structure of a MySQL (ODBC) table, I wrote a routine that del

Re: Question regarding memory usage

That's the weird part; it doesn't seem to be swapping at all. When trying different combinations in my.cnf, I had key_buffer as low as 64M without any effect. Jon On Mon, 7 May 2001, Joseph Bueno wrote: > Hi, > > Are you sure that you need 200Mb of key_buffer cache ? > Since your machine is o

Create Database error

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 With a bad syntax, i create a database named : Ysa2E3iU mysql create it, but i can't drop it...? there's a bug? How can i do to drop it? Thank's.. Davy Azevedo La Vie est l'art d'apprendre à mourir dignement La Naissance est son Apothéose. ---

Re: Question regarding memory usage

Jon Valvatne wrote: > > Hello, > > I have a hopefully simple question here: > > My web site is dynamically serving 300k page views a day from a MySQL > database, running on a dual P3/700 with 512 megs of ram. Considering the > complexity of my queries and the data amount involved, I know I shou

Re: mysqladmin

I actually wanted to disable passwords completely. so when I type mysql the mysql> comes up. Tom - Original Message - From: "Zak Greant" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, May 06, 2001 11:57 PM Subject: Re: mysqladmin > Use the -p option to

Re: Question regarding memory usage

Thanks for the quick reply. I set max_connections so low because even at peaks I never need more, and when the slowdowns happen, it seems to have an easier time recovering if there are 15 slow connections hanging than if there are hundreds. I'll try the thread concurrency thing, thanks. I was u

Re: mySQL setup

A brand new installation has no password set, therefore you do not need -p so your command should be exactly as I've already given you. Of course you add your-brand-new-password after the word password. If that still doesn't work, you can stop the server, delete the privileges database, rerun my

need help

Hi,all How can I get rid of the lock on database? for I want to operate one database but two tables at same time, Thanks and best regards ~{B7B~B~FdP^T6Yb~} ~{Na=+IOOB6xGsKw~} - Before posting, please check: h

Re: Question regarding memory usage

On Mon, 7 May 2001 06:27:08 -0400 (EDT) Jon Valvatne <[EMAIL PROTECTED]> wrote: > As you'd expect, the server gets bogged down rather quickly at this > point, serving new requests very slowly if at all. Restarting MySQL helps > right away, buying me another 24 hours of stable uptime. If this i

Source Make Error

Running FreeBSD 4.2 64MB Ram 2Gb HD on Pent MMX166. df says that I have 1.2GB free on /usr Trying to "make" Mysql 3.23.37 source after a while I get the following error bsdbox /kernel swap_page_getswapspace: failed Now I don't know if this a BSD problem or to do with Mysql Any ideas anyone? H

Which version of mysqlshow allows the %?

Hi all, I've successfully used 'mysqlshow db_name %' under MySQL v3.23, but under 3.22.20a, it returns the message: Cannot list fields in db: db_name, table: %: You have an error in your SQL syntax near '%' at line 1 Did the wildcard feature get included in a particular version? If so

RE: mySQL setup

Hi Thanks, I tried, but it still didn't work. Can somebody point me to an idiot proof installation site, I've tried a few from the web, some seam to help slightly, others seam to hinder more Cheers, Alud -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: 07 May 200

Question regarding memory usage

Hello, I have a hopefully simple question here: My web site is dynamically serving 300k page views a day from a MySQL database, running on a dual P3/700 with 512 megs of ram. Considering the complexity of my queries and the data amount involved, I know I should expect the server to be overwor

Re: host.frm error

I did a search and i do not have that file on my system, and i have been running RedHat for about 6 years now. And this is a redhat-7.1 box HTH -- Dane Knudson wrote: > > I have installed mysql during the install of RH linux. When I try and > start the service, there is an entry in the error lo

Re: mySQL setup

Since this a first installation try ./bin/mysqladmin -u root password instead. - Original Message - From: "Alud" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 07, 2001 17:27 Subject: mySQL setup > > Hey > > I'm kinda new to all this, so please forgive me if this sea

mySQL setup

Hey I'm kinda new to all this, so please forgive me if this seams like a dumb question: I've been trying to set up a mySQL server today, and I can get so far, but keep getting a problem, I've never done anything like this before so I'm quite happy to accept that I'm missing something easy, but

JSP-Mysql:-Bad handshake problem

Hi I am using resin-1.2.3 and mysql at backend on windows 2000...I am trying to connect to mysql thru my JSP's but gotta bad handshake...I am using mysql-jdbc driver... My JSP code is like this.. %@ page language="java" import=" java.sql.*, java.util.*" %> <%@ page import="sqlBean" %> <%@ p

problem when typing sql statment in mysql shell

>Description: when typing sql statment in mysql shell after specific amount of chars the line continue over itself . >How-To-Repeat: >Fix: >Submitter-Id: >Originator: >Organization: >MySQL support: [none | licence | email support | extended email support ] >Syno

Re: i have a real problem ...

On Mon, 07 May 2001 08:42:23 +0200 Stephan Weißleder <[EMAIL PROTECTED]> wrote: > i use mysql 3.23.34a and using BLOB's and timestamps leads to errors ( > when giving all timestamps the value "now()" only some of them return > the correct date the BLOB's don't even return anything ... ) > ..