Hi,
I have RH 7.1 and installed all the 5 MySQL rpms from
mysql website except for MySQL Benchmark/test suites
because it needs msql-mysql modules. so I installed
msql-mysql modules, DBI and I not encountered any
errors installing the modules. When I install MySQL
Benchmark again I encoutered the
> >Thanks for answering
> >"search character by character" 11 May 2002
> >Making use of a HTML textfield which sends text to
> >variable 'varLastName'.
> >How do I concatenate the variable
> part('varLastName')
> >with
> >the % part is it something like:
> >
> >SELECT LASTNAME, FIRSTNAME,
> >DEP
Hi
I build a batch file that run a few sql queries.
I want to know the results (how many rows affected)
but it doesn't recognize the method mysql_affected_rows.
What should i use to get the results?
Thanks
-
Before posting, ple
hi,
Can any body tell me that EJBs specially Entity beans(CMP) can be implemented by MySQL
with the constraint that MySQL does not support distributed transaction or not.
Thanks
Nayyer
e-mail: [EMAIL PROTECTED]
-
Before p
When I try to join a temporary table to itself, I get an error message, as
follows:
create temporary table TEMP (X int NOT NULL);
select * from TEMP A, TEMP B;
The select gives: ERROR 1137: Can't reopen table: 'A'
It appears to work as expected without the "temporary". Can I not jo
I'm still trying to get MySQL running on Mac OS X and previously after installation
when MySQL was running, I was getting 1045/6 errors and now, after a re-boot, MySQL is
not running (I didn't add the start-up script because of the constant permissions
errors I was getting).
When I try to ente
Hi,
I am new in the "MySql" business so I'm sorry if my question is too simple.
Is there any way to nest queries in MySql in the following manner:
"select from where id = (select ...)"
Thanks for your attention,
Sigalit
_
Join
i am connecting to mysql thru myodbc using iodbc driver manager. when
retrieving data, SQLFetch() crashes with
SIGSEGV signal. i 'gdb'ed into SQLFetch() and found that it crashed in the
very first statement, ENTER_STMT(pstmt). there are no problems when
executing SQLExecDirect and SQLBindCols
As far as I know MySQL does not yet support nested SELECT statements.
-Nick
> Hi,
>
> I am new in the "MySql" business so I'm sorry if my question is too
> simple. Is
there any
way to nest queries in MySql in the following
> manner: "select from
where id = (select ...)"
>
> Thanks for your a
Hi all,
I'm a total newbie when it comes to windows set-ups... I've managed to get
Apache and PHP4 running nicely on an old Pentium laptop running Win95, and
have managed to install MySQL with ease.
However, I'm not all that sure how to set up users (or even what the default
user "root"'s passwo
Hello to all,
I've had some severe issues on redhat-7.x boxes and
mysql compiled from source with gcc-2.96 much like
the warning states on the download page. On these boxes,
more than say 20-25 concurrent or near-concurrent connects
produced unexpected results with PHP4.
Replacing the binaries c
On Sat, May 11, 2002 at 08:39:55PM -0400, [EMAIL PROTECTED] wrote:
>
> Paul, do you have any idea what this "Repair with keycache" state,
> is all about.
It means that MySQL is building up the indexes on the imported data.
It is doing so using the keycache (or key_buffer) just as it does
during
On Sun, May 12, 2002 at 12:06:33PM -0400, Mike Robinson wrote:
> Hello to all,
>
> I've had some severe issues on redhat-7.x boxes and mysql compiled
> from source with gcc-2.96 much like the warning states on the
> download page. On these boxes, more than say 20-25 concurrent or
> near-concurren
At 12:15 +0200 5/12/02, Inbal Ovadia wrote:
>Hi
>I build a batch file that run a few sql queries.
>I want to know the results (how many rows affected)
>but it doesn't recognize the method mysql_affected_rows.
>What should i use to get the results?
>Thanks
mysql_affected_rows().
Unless they're SE
At 6:32 -0400 5/12/02, Bill Easton wrote:
>When I try to join a temporary table to itself, I get an error message, as
>follows:
>
> create temporary table TEMP (X int NOT NULL);
> select * from TEMP A, TEMP B;
>
> The select gives: ERROR 1137: Can't reopen table: 'A'
>
>It appears to w
At 13:36 +0100 5/12/02, Phil Dobbin wrote:
>I'm still trying to get MySQL running on Mac OS X and previously
>after installation when MySQL was running, I was getting 1045/6
>errors and now, after a re-boot, MySQL is not running (I didn't add
>the start-up script because of the constant permiss
Hello all,
I'm rather new with MySQL. I'm running Linux SuSE 7.1 and try to convert
from MSAccess to MySQL. In MSA I have created a query to select persons
who have to get a bill. I connected this query to a report and
automatically a bill is printed on my Epson printer. Doing this saves me
a
On 12/5/02 at 12:18, [EMAIL PROTECTED] (Paul DuBois) wrote:
> At 13:36 +0100 5/12/02, Phil Dobbin wrote:
[...]
> >20512 00:13:18 mysqld restarted
> >rm: /usr/local/mysql/data/localhost.pid: Permission denied
> >../bin/safe_mysqld: permission denied:
> >/usr/local/mysql/data/localhost.err [235]
On 12/5/02 at 18:40, [EMAIL PROTECTED] (Phil Dobbin) wrote:
> I got finally got it started by doing:
>
> su mysql
> password xx
> mysql% cd /usr/local/mysql
> mysql% ./bin/safe_mysqld --user=mysql
>
> but now I get 1045 error messages when I try to access mysql whether
> as me or root:
>
hmm it got a little more complicated now,
i have a table with: id title question answer1 answer2 answer3 answer4.
how can i use all of those in a php page but only randomize the answers?
so i get
title title
questionquestion
answer3 answer4
answer2 answer1
ans
Hello,
I just want to get the value of one column in the row where max of
another col of this table is.
With the possibility of sub queries I would write:
select col1
from table t1
where col2 = (select max(col2)
from tab1e t2);
But how to do it without a sub query?
Just with 1 st
I could be missing something, but what about:
select col1 from t1 where col2 = max(col2);
On Sun, 12 May 2002 23:04:14 +0200
Sabine Richter <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I just want to get the value of one column in the row where max of
> another col of this table is.
> With the poss
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Mark" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, May 12, 2002 2:39 AM
Subject: Re: AUTOCOMMIT and FLUSH?
> At 2:16 +0200 5/12/02, Mark wrote:
>
> > Hello folks,
> >
> > Could somebody please tell me what the eff
Hello Philip,
that was my first choice, too.
But no, error : Invalid use of group function
and select col1, max(col2) from table;
is error 1140: mixing of group cols with non groupü cols is illegal
(That would other sql backends say too)
and other variants of the above like "select col1 fr
Oh, someone should fix that... I guess it won't let you put a group statement in the
where clause.
Here is another way. On the down side, its a bit more roundabout. On the up side,
however, I actually tried it and it worked.
select col1 from t1 order by col2 desc limit 1;
-Philip
On Sun,
I'm trying to link libmysqlclient into a C/C++ program using g++.
But I get the following errors:
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_uncompress':
my_compress.o(.text+0xaa): undefined reference to 'uncompress'
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
> Date: Sun, 12 May 2002 17:00:01 +0500
> Message-Id: <[EMAIL PROTECTED]>
>From: "" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Entity Beans(CMP) in mysql
>Mime-Version: 1.0
>Content-type: text/plain; charset=us-ascii
>hi,
> Can any body tell me that EJBs specially Entity beans(CMP) can
Win/98
MySQL 3.23.46
I'm trying to use AUTO_INCREMENT=1000 to specify my staring value in an
ID column in batch mode, but it doesn't want to work. I can get it to
work in interactive mode though.
In a file (create_tables.sql) I have:
CREATE TABLE Respondents (UserID SMALLINT UNSIGNED AUTO_INCRE
At 23:41 +0200 5/12/02, Sabine Richter wrote:
>Hello Philip,
>
>that was my first choice, too.
>But no, error : Invalid use of group function
>
>and select col1, max(col2) from table;
>is error 1140: mixing of group cols with non groupü cols is illegal
>(That would other sql backends say too)
I will guess that the NULL field you defined is of a numeric
type such as INT. In standard SQL the empty string '' is not
the same as the special value NULL, and this is also true in
MySQL, but not in Oracle. Probably you are inserting a ''
into the database column but MySQL correctly interprets
On Fri, 10 May 2002, Paul DuBois wrote:
> At 12:06 +0100 5/9/02, Sandeep Murphy wrote:
> >Hi,
> >
> >What appears to be the problem with the fwg query:
> >
> >select code,date from multimedia_header where rubrica=87 and now() >
> >'08-03-2002 13:10:53' and date IS NOT NULL
> >
> >The records re
Hi everyone,
My slave cant replicate due to this error
020513 8:27:37 Slave: reconnected to master
'[EMAIL PROTECTED]:3306',replication resumed in log 'rdbesas-bin.023' at
position 573578
020513 8:27:37 Error reading packet from server: Could not find first log
(read_errno 0,server_errno=655
Hey guys and gals,
How do i add info to a table, and give a varchar(16) row the function of
password, so that it is encrypted? my query now is:
INSERT into table values('0', 'username', 'password', 'email')
thanks
Jule
--
|\/\__/\/|
| Jule Slootbeek |
You need to use PASSWORD() function..
INSERT INTO table VALUES('0', 'username', PASSWORD('passwd'), 'email');
See: http://mysql.com/doc/M/i/Miscellaneous_functions.html
Gurhan
-Original Message-
From: Jule [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 12, 2002 8:37 PM
To: [EMAIL PROTECT
Dear all,
i'm a new member of this community, and also a beginner in database (mysql
and other).i wonder if anyone here can tell me or explain to me how to
benchmark the ability of this engine (read:mysql). In this case, the amount
of data is about 10 million records.
I'm waiting for the solu
Use the PASSWORD() MySQL builtin function as follows:
INSERT INTO Table
VALUES ('0', 'username', PASSWORD('password'), 'email')
This function is not part of the SQL standard. It is
used for storing passwords in the MySQL user table in
the mysql database schema named mysql among other things.
N
I was wondering if anybody here knows the layout for a row in a static
MyISAM table file (*.myd).
The byte count at the begining of a row varies with the field count.
And the Header bytes I think tell MySQL what fields are Null?
I have been studying code in the myisam dir and the file "table.
I don't know if this will work or not, but try
SELECT * FROM table ORDER BY id, RAND();
That should keep all of the questions and answers together, but give a
random order for the answers.. ?? Like I said, not exactly sure on it
though.
Best option, like someone else said, is to split this up i
OK, I just finally got MySQL installed and I can't make ANYTHING work. when
I try to run "mysqladmin -u root -h Death -p password 'somepassword'" I get
an Enter Password prompt, I have never told it a root password and it won't
accept the system root password. Then if I try to connect to the ser
I work on a site called Creature World. We get ~110,000 pageviews per day.
Our server load is constantly at like >10. From investigation...pretty much
all of this load comes from mySQL. How can we optimize mysql to make it run
faster and produce less load?
Only table field names are allowed after the ORDER BY clause in
standard SQL. The answer to your question is that SQL is not designed to
do that kind of thing. Rather, I would suggest computing a random
permutation of the numbers 1, 2, 3, and 4 in the PHP application prior to
constructing your
Hi,
There is not enough information in your email to help you.. IS your mysql
server running ? Also you may wanna scrutinize this page:
http://www.mysql.com/doc/P/o/Post-installation.html
Gurhan
-Original Message-
From: Kevin Queen [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 12
Try this...
mysqladmin -u root -p password 'abc123'
When you get the password prompt hit enter (dont type anything)
Your new root password is now abc123. The default root password is blank,
thats why u just hit enter
- Original Message -
From: Kevin Queen
To: MySQL List (E-mail)
Sent: M
Hint:
The user and host combinations for allowed MySQL connections are stored
in a table called mysql. You can access this table by issuing:
$ mysql -u root
mysql> use mysql;
mysql> SELECT user, host, password FROM user;
If you have set up a root password then issue:
$ mysql -u root -ppassword
Why does select * from usertable where user=username and Password =
password('passowrd') not worked?
select * from usertable where user=username and password('password') does
work, but that only checks if user exists and doesn't check for the correct
password...
Any help will be greatly apprecia
1) Can I add new users with mysqladmin?
2) With mysqladmin as root I can get a response to
# /usr/bin/mysqladmin -pmypassword ping
However this does not work in a script:
mysql_connect("209.204.172.122", "root", "mypassword");
What am I missing?
Todd
--
Todd Cary
Ariste Software
2200 D Stre
On Monday, 13. May 2002 06:10, Matthew Hale wrote:
> I work on a site called Creature World. We get ~110,000 pageviews per day.
> Our server load is constantly at like >10. From investigation...pretty much
> all of this load comes from mySQL. How can we optimize mysql to make it run
> faster and p
Hello, mysql,
In select field list if they have some field that field type is text or blob and if I
use group by some filed MySQL will generate "Got error 28 from table handler" the
query like this
select a.f1,a.f2,a.f3,b.f1,b.f2
from table_a as a,table_b as b
where a.f1=b.f1
and a.f1='xxx'
you can use perror 28 to see what does that error code mean
Rahul T
-Original Message-
From: Kittiphum Worachat [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 10:50 AM
To: [EMAIL PROTECTED]
Subject: Error code 28
Hello, mysql,
In select field list if they have some field that f
On Monday, 13. May 2002 07:20, Kittiphum Worachat wrote:
Hi,
>
> In select field list if they have some field that field type is text or
> blob and if I use group by some filed MySQL will generate "Got error 28
> from table handler" the query like this
>
> select a.f1,a.f2,a.f3,b.f1,b.f2
> from
Hi Rahul Torvi, and MySQL user group
>you can use perror 28 to see what does that error code mean
>
>Rahul T
>
>-Original Message-
>From: Kittiphum Worachat [mailto:[EMAIL PROTECTED]]
>Sent: Monday, May 13, 2002 10:50 AM
>To: [EMAIL PROTECTED]
>Subject: Error code 28
>
>
>Hello, mysql,
>
> Hallo,
>
> i tried to use MySQL together with MySQL-ODBC 3.51.02 für an MS-Project
> Database. While storing the following error comes up.
>
> <<...>>
>
> When the error occures the programm has written 19 tables with entrys.
>
> Is it realy a bug or is do you now a solution to work with
Hi, Georg Richter,
Thanks after got your mail that
>perror 28
>Error code 28: No space left on device
I try to check my disk spack it have 2 GB space left so it may not cause by this
problem .And I found that with MySQL 4.0.1 it error but not error in 3.23.49a
thank again.
Kittiphum Wora
Hi,
> Why does select * from usertable where user=username and Password =
> password('passowrd') not worked?
>
You should quote the username, and fix the typo in 'passowrd'.
select * from usertable where user=username and password('password') does
work, but that only checks if user exists and d
On Monday, 13. May 2002 07:06, Todd Cary wrote:
Hi,
> However this does not work in a script:
>
> mysql_connect("209.204.172.122", "root", "mypassword");
>
> What am I missing?
What script do you use? Which language?
Georg
-
B
55 matches
Mail list logo
