Mark,
Is the only reason for this the fact that I have mysql running? Are
mysqlcheck and myisamchk doing the exact same thing. Or are
there scenarios in which one reports errors and the other doesn't.
mysqlcheck and myisamchk are doing the same things _basically_.
mysqlcheck does all the
RBE,
4) How exactly are you tring to connect (mysql -hlocalhost -uuser
-psecret)?
One of the problems is that I was not only not able to enter a
password, but cannot seem to get one entered. I get error 2002 with
that or almost any other entry. So far, following the suggestions
given
hello,
I've performed searches on this site and php.net to try and figure out
why this is occuring. I can't find any instance in my searches that
helped me. So, I'm posting my very first question to this list
Here's my table ($usertableDaily):
vanNumber|grossPay
-
select vanNumber, sum(grossPay) from usertableDaily group by vanNumber;
[EMAIL PROTECTED] wrote:
hello,
I've performed searches on this site and php.net to try and figure out
why this is occuring. I can't find any instance in my searches that
helped me. So, I'm posting my very first question
Hi
Interesting problem, normally to get a total by type, you would have a query
like,
select van, sum(pay) from ($usertableDaily) group by van;
However you are individually quering each total, your approach is correct, but
slower.
The problem you have though is the return of
Resource
Are you referencing the result set correctly in php ?
How are you dealing with what MySQL returns ?
Looks like the info is there, you just not getting it out of the result
set.
-
Jerry @
MetalCat.Net
-
- Original Message -
From: Guru Geek
Is it just me or is everyone on the list getting junk/spam from naver.com ?
-
Jerry @
MetalCat.Net
-
sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the
I assume you use gcc, and your object file is :myclient.o
and executable file : is myclient
so try it:
gcc -o myclient myclient.o -L/usr/lib/mysql -lmysqlclient -lz
You can use 'mysql_config' utility to determine the proper flags for
compiling and linking.Example:
% mysql mysql_config --cflags
Hi
Well I asked about index's earlier and had the answer in 30 mins
So I have created an index on several columns and I call my search like
so:
strsql = SELECT * FROM global WHERE MATCH (SURNAME, GROOMSURNAME,
BRIDESURNAME, OTHERSURNAME, MOTHERMNAME ) AGAINST ('gold')
Problem now is the
Jerry,
Is it just me or is everyone on the list getting junk/spam from naver.com ?
We all have this problem :/
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter
You probably have a permissions issue in your data or temp directory...Mysql
is not able to create a temporary table when making the table alteration.
Peter
^_^
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original Message -
Make a temporary table, SELECT DISTINCT the rows from the old table to the
new table, rename the old table TABLE_OLD, rename the temporary table to the
original table name.
Peter
^_^
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
-
I think 'mysql_config' built in mysql RPM (binary) package.
I use MySQL-3.23.55.1 and MySQL-3.23.33 under RedHat 7.2 and all are fine.
You can download binary format (RPM) from
http://www.mysql.com/downloads/mysql-3.23.html
included : MySQL-3.23.55.1.rpm (server),MySQL-client,MySQL_devel, and
lets try it:
- first, create database : dbase_name
and type it:
% mysql -uusername -ppassword dbase_name /path/to/directory/yourdump.sql
if anything wrong, please check yourdump.sql. May be incorrect syntax.
- Original Message -
From: kk [EMAIL PROTECTED]
Date: Fri, 14 Feb 2003
In our SQL database we want to create a user with certain privileges. Also we need to
only allow them to view certain tables not the entire lot.
GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...]
ON {tbl_name | * | *.* | db_name.*}
Using the above syntax, by granting a
Hi,
I'm having a quite serious problem. I wrote a web application that uses
MySQL via ConnectorJ V2.0.6 in combination with Apache's DBCP 1.0
(Jakarta Commons Database Connection Pool).
The web application is installed on a server, I don't have access to.
The same for the MySQL server.
Once in a
Hi,
I am facing mysql shutdown process hanging problem on Solaris 5.8, mysql
3.23.40
I am running our product Web NMS which uses MySQL DB, on solaris machine.
While shutting down the application, except MySQL process, all other
process are killed
and the application hangs.
On analysis I
At 23:30 -0600 2/14/03, Lewis Watson wrote:
I need to delete duplicate rows. Each row that is in the table has an
exact duplicate of itself. There are four columns. No one column could be
defined as a primary key; however, two columns together could. What's
going to be the best way to do this?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Holger Wiechert wrote:
Hi,
I'm having a quite serious problem. I wrote a web application that uses
MySQL via ConnectorJ V2.0.6 in combination with Apache's DBCP 1.0
(Jakarta Commons Database Connection Pool).
The web application is installed on a
Description:
Attempted to follow instructions to install from source tarball as indicated
in manual.pdf. I acquired manual.pdf from:
http://www.mysql.com/Documents/Manual/manual.pdf
On Page 81 of manual.pdf I followed the 'To install a source distribution'
Steps 1 through 6 went fine. However
if you have a file NameOfFile.sql where you have a table named Aux and you
try to create it using:
mysql -u USER -p DATABASE NameOfFile.sql
when it reaches the definition of table Aux, this will block the execution
of the command.
At 17:44 + 2/15/03, Pedro Vasconcelos wrote:
if you have a file NameOfFile.sql where you have a table named Aux and you
try to create it using:
mysql -u USER -p DATABASE NameOfFile.sql
when it reaches the definition of table Aux, this will block the execution
of the command.
I have no
Hello All:
using MYSQL Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) (RH 7.2)
I have data exported from an excel spreadsheet as tab delimited text.
Certain columns need to go to mysql table columns with a type of int(11).
(alternative datatypes will be considered)
The NameOfFile.sql contains:
#
# Table structure for table 'Aux'
#
DROP TABLE IF EXISTS Aux;
CREATE TABLE Aux (
PrecoBase decimal(40,2) default NULL
) TYPE=MyISAM;
#
# Dumping data for table 'Aux'
#
LOCK TABLES Aux WRITE;
INSERT INTO Aux VALUES
At 9:05 -0900 2/15/03, Tim Johnson wrote:
Hello All:
using MYSQL Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu
(i386) (RH 7.2)
I have data exported from an excel spreadsheet as tab delimited text.
Certain columns need to go to mysql table columns with a type of int(11).
At 18:10 + 2/15/03, Pedro Vasconcelos wrote:
The NameOfFile.sql contains:
#
# Table structure for table 'Aux'
#
DROP TABLE IF EXISTS Aux;
CREATE TABLE Aux (
PrecoBase decimal(40,2) default NULL
) TYPE=MyISAM;
#
# Dumping data for table 'Aux'
#
LOCK TABLES Aux WRITE;
INSERT INTO Aux
It works fine on Unix. Is Aux a special filename in Windows?
Not that i am aware of.
Maybe you should try this on Windows. I could be just a problem on
windows version.
Thanks.
On Sat, 15 Feb 2003, Paul DuBois wrote:
At 18:10 + 2/15/03, Pedro Vasconcelos wrote:
The NameOfFile.sql
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
Description:
Attempted to follow instructions to install from source tarball as indicated
in manual.pdf. I acquired manual.pdf from:
http://www.mysql.com/Documents/Manual/manual.pdf
On Page 81 of manual.pdf I followed the
Hi,
AFAIK, Aux is indeed a special filename in Windows (if I execute Aux under
the W2K console, it opens the open with window).
Regards,
Jocelyn
- Original Message -
From: Pedro Vasconcelos [EMAIL PROTECTED]
To: Paul DuBois [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday,
Ok :) You are absolutely correct. My mistake :)
Bye
On Sat, 15 Feb 2003, Jocelyn Fournier wrote:
Hi,
AFAIK, Aux is indeed a special filename in Windows (if I execute Aux under
the W2K console, it opens the open with window).
Regards,
Jocelyn
- Original Message -
From: Pedro
I have a field (cdfeature) that contains a list of comma seperated values.
Example follows:
select item_id, cdfeature from cars where (101 in (cdfeature));
+-+-+
| item_id | cdfeature |
+-+-+
| 320 | 101,104,106 |
|
Hi all,
I have a problem with replication, that while repeatable for me very
easily, I can not come up with a way for others to repeat it without all
our tables and binlogs (tens of gigabytes). So I'm simply going to
describe things here and see if anyone else has experienced anything
similar or
On 2/15/03 1:25 AM, Duncan Maitland wrote:
I am having trouble compiling a custom mysqld (version 4.0.10) under Red
Hat 8.0 - I did email this list a few weeks ago and I have tried a few
things since then but I am asking again in the hope that someone more
knowledgeable might be able to help.
At 12:41 -0600 2/15/03, Don! Briggs wrote:
I have a field (cdfeature) that contains a list of comma seperated values.
Example follows:
select item_id, cdfeature from cars where (101 in (cdfeature));
+-+-+
| item_id | cdfeature |
Hello
I have a simple table consisting of a couple of columns with int-values
and one datetime column. The table doesnt have any indexes and consists
of over 10 million records and are growing with more then 200 000
records per day.
Even though I am NOT using an index the time for inserting new
Hi,
I'm trying to compile mysql 3.23.55.
Some info:
uname -a
Linux atlas 2.4.20 #1 Sat Feb 1 10:39:59 CET 2003 i586 unknown
glibc with libpthreads 2.3.1
gcc -v
Reading specs from /usr/lib/gcc-lib/i586-pc-linux-gnu/3.2.1/specs
Configured with: ./configure --prefix=/usr --sysconfdir=/etc
Hi,
I have a table that contains ids for several other tables. Setup is as
followed:
+--+--+--+-+-++
| Field| Type | Null | Key | Default | Extra |
Paul, Pedro,
INSERT INTO Aux VALUES
(100.00),(100.11),(100.00),(100.22),(101.00),(102.00);
It works fine on Unix. Is Aux a special filename in Windows?
Good guess! Here's what I get:
C:\mysql\binecho hallo aus
C:\mysql\binecho hallo aux
Zugriff verweigert
This is access denied. Looks
RBE,
Sorry, but this doesn't answer my question. You said you used MySQL
Monitor (the command line tool) when trying to connect to the server.
When you started MySQL Monitor, how did you do that? Did you just
double-click mysql (the MySQL Monitor) in some graphical file manager
tool, or did
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Saturday 15 February 2003 3:03 pm, Stefan Hinz wrote:
RBE,
Sorry, but this doesn't answer my question. You said you used
MySQL Monitor (the command line tool) when trying to connect to
the server. When you started MySQL Monitor, how did you
Hello All:
(using MYSQL Ver 11.15 Distrib 3.23.41
for redhat-linux-gnu (i386) (RH 7.2))
I am importing text data (but in a numeric format).
The customers wants 'N/A' in an empty field.
Additionally:
The customer wishes that if a field = ''
the default value of 'N/A' be
Robert,
3) If it's running, you have a privilege problem. If your MySQL
installation is new, you'll have just some basic users set up. One of
them is called root, who can connect from localhost without
password. Thus, try this: mysql -uroot.
mysql -uroot gives me the following error
At 14:00 -0900 2/15/03, Tim Johnson wrote:
Hello All:
(using MYSQL Ver 11.15 Distrib 3.23.41
for redhat-linux-gnu (i386) (RH 7.2))
I am importing text data (but in a numeric format).
The customers wants 'N/A' in an empty field.
Additionally:
The customer wishes that if a field =
Tim,
I am importing text data (but in a numeric format).
The customers wants 'N/A' in an empty field.
Additionally:
The customer wishes that if a field = ''
the default value of 'N/A' be substituted.
Is this possible to do in MySQL?
Documentation?
AFAIK there's no way to
I am using mysql Ver 12.16 Distrib 4.0.7-gamma, for pc-linux-gnu (i686)
I created the following table without error.
The index line should have prevented the success of the command.
CREATE TABLE IF NOT EXISTS catalog.junk (
hat VARCHAR(14) DEFAULT '' NOT NULL,
hats VARCHAR(14) DEFAULT '' NOT
What type of platform/file system are you using?
Very large files on filesystems can suffer from inode indirection
problems...but I wouldn't think they'd be too noticeable.
Peter
^_^
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
-
On 15-Feb-2003 Jocelyn Fournier wrote:
Hi,
AFAIK, Aux is indeed a special filename in Windows (if I execute Aux under
the W2K console, it opens the open with window).
MS-DOS, actually.
Unix has 3 pre-defined file streams: stdin, stdout, and stderr.
MS-DOS has the same three, plus two
At 18:13 -0500 2/15/03, Barry Pollock wrote:
I am using mysql Ver 12.16 Distrib 4.0.7-gamma, for pc-linux-gnu (i686)
I created the following table without error.
The index line should have prevented the success of the command.
It may not make any sense, true, but it's not syntacticallyy
where would one put a .txt file to have mysql load it.?
what dir. would it have to be in.?
Richard
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
At 19:00 -0500 2/15/03, Richard Nagle wrote:
where would one put a .txt file to have mysql load it.?
what dir. would it have to be in.?
Anywhere you like, but the LOAD DATA statement must specify the
pathname correctly so that MySQL can find it. Read the manual
section on LOAD DATA, which
[EMAIL PROTECTED] 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 following words in your message:
sql,query,queries,smallint
If you just reply to this message, and include the entire
Reposted from my NG post, I'm hoping someone can help out, this is getting
ugly. The problem I am describing is happenning in less than 24 hours now.
As volume increases the period is getting shorter.
I'm hoping someone can help me, I've got a problem with mysql going
insane..
I've a quite busy
Well I have leaned a lot on creating an index and then using it to
search - I do however get strange results sometimes in my names dbase
This is my index info
FULLTEXT KEY `surnamei`
(`SURNAME`,`GROOMSURNAME`,`BRIDESURNAME`,`OTHERSURNAME`,`MOTHERMNAME`)
) TYPE=MyISAM COMMENT='Surname Index'
My
53 matches
Mail list logo