hi all,
first of all, since this is a jdbc specific question, you might say i should
post to java mysql
mailing list, but for some reasons my java mysql subscribtion seems didn't
succeed although
i got a confirmation and a welcome email. (of course i confirmed my
subscribtion)
Anyway my request is
Paul,
At 16:56 2001-11-25 -0600, Paul DuBois wrote:
>database,sql,query,table
>
>At 7:40 PM +0100 11/25/01, Marjolein Katsma wrote:
>>At 12:19 2001-11-25 -0600, Paul DuBois wrote:
select * from users where dbname= "Brain" returns both "brain" and "Brain".
I read section 6.3.2.2 and s
At 20:45 25/11/01 -0800, Bryan Chong wrote:
Hi,
>Hi folks,
>
> I need help to start my server with InnoDB. I have manually created
>innodb_data_home_dir,
>which is c:\mysql\ibdata. The mysql server is running on Windows ME
>platform. my.cnf is
Notice that beside the c:\mysql\ibdata directory
From what I see in the release notes, MySQL 3.23.45 is an important
release for Mac OS X since it fixes the bug in which one could not
use mysqladmin shutdown and had to force the mysqld to quit using
kill -9.
Two questions:
1) Will there be a binary for MySQL 3.23.45 for MacOS X 10.0.x (Dar
Perfect.
Thanks, Anvar.
--
coop
On Sun, 2001-11-25 at 22:20, Anvar Hussain K.M. wrote:
> Hi Chris,
>
> The following query should work for you.
>
> select date_sub(date_col, interval weekday(date_col) day),
> date_add(date_col, interval 6-weekday(date_col) day) from table_name
>
> Anvar.
I am tring to install MySQL on a raq2. There's already a version of MySQL
installed on the box -- I put it there a year and a half ago.
Here's what I've done:
(1) Configure like so:
./configure --with-low-memory --disable-assembler --disable-shared \
--with-mysqld-ldflags="-all-static"
--w
Hi folks,
I need help to start my server with InnoDB. I have manually created
innodb_data_home_dir,
which is c:\mysql\ibdata. The mysql server is running on Windows ME
platform. my.cnf is
as follows:
# Example mysql config file.
# Copy this file to c:\my.cnf to set global options
#
# One can
Hi Chris,
The following query should work for you.
select date_sub(date_col, interval weekday(date_col) day),
date_add(date_col, interval 6-weekday(date_col) day) from table_name
Anvar.
At 07:20 PM 25/11/2001 -0500, you wrote:
>Hey all,
>
>I'm hoping someone can help me out with a little da
On 26 Nov 2001 at 0:39, [EMAIL PROTECTED] wrote:
> > Isn't left a reserved word? As in left join? But then, create
> shouldn't have
> > worked either...
>
Hello,
Thanks a lot, that worked! I changed the name of the field, bingo!
Sincerely,
Gil.
PS: for spam filter: database
--
http://pla
Well, whatever language you are using to output your data, there should be
some unix tampstamp converting function.
In php it's date().
On Sunday 25 November 2001 04:20 pm, Chris Cooper wrote:
> Hey all,
>
> I'm hoping someone can help me out with a little date/time problem I'm
> having. I've go
Hey all,
I'm hoping someone can help me out with a little date/time problem I'm
having. I've got a database full of timestamps that I want to group
together based on their week. I can use the WEEK() function or
DATE_FORMAT() to convert the timestamp to a week number, but I'd rather
display the bo
At 6:59 PM -0500 11/25/01, Gil G. wrote:
>Hello,
>
>If someone could give me a pointer on this issue:
>
>I have a table called "codes" with only one field "left".
>
>When trying this in PHP:
>$result=mysql_query("DELETE FROM codes WHERE
>left='$temp'");
>
>I get a syntax error...
A syntax error f
Hello,
If someone could give me a pointer on this issue:
I have a table called "codes" with only one field "left".
When trying this in PHP:
$result=mysql_query("DELETE FROM codes WHERE
left='$temp'");
I get a syntax error...
This must be some stupid mistake... But I am stuck...
Thanks, sinc
At 2:45 PM -0800 11/25/01, Mark Rissmann wrote:
>Hey guys,
>
>Can anybody out there give me a helping hand?
>
>I have a table of the following format
>
>UserId LoginDate(datetime) LogoutDate(datetime)
>
>1 2001-11-25 11:00:00 2001-11-25 13:45:00
>2 2001-11-26 2
database,sql,query,table
At 7:40 PM +0100 11/25/01, Marjolein Katsma wrote:
>At 12:19 2001-11-25 -0600, Paul DuBois wrote:
>>>select * from users where dbname= "Brain" returns both "brain" and "Brain".
>>>
>>>I read section 6.3.2.2 and select binary dbname from users where
>>>dbname="brain" also
Hey guys,
Can anybody out there give me a helping hand?
I have a table of the following format
UserId LoginDate(datetime) LogoutDate(datetime)
1 2001-11-25 11:00:00 2001-11-25 13:45:00
2 2001-11-26 22:25:00 2001-11-27 02:00:00
I want to write a query
I think your diagnosis is correct. There is an FRM without a corresponding
InnoDB table. The question is, what causes this, and how do we prevent it?
It appears to be a bug related to CREATE TABLE and DROP TABLE. I have found
it a good idea to commit and reconnect after creating an InnoDB tabl
At 12:19 2001-11-25 -0600, Paul DuBois wrote:
select * from users where dbname= "Brain" returns both "brain" and "Brain".
I read section 6.3.2.2 and select binary dbname from users where
dbname="brain" also returns both records.
SELECT dbname FROM users WHERE BINARY dbname = "brain"
perhaps?
Jan,
Thanks for the pointer, indeed it was a rights issue, and all sorted now.
Regards,
Martyn
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Martyn Wendon" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, November 25, 2001 7:53 PM
Subject: Re: Symbolic Links to Data
>
Martyn,
On Sun, 25 Nov 2001, Martyn Wendon wrote:
> No problems in general with the installation. Everything has been working
> fine, I need to move the database files as I am running out of space on the
> /var partition.
This is surely an access rights problem. If you'd su to the user running
So, if you pass NULL in as the first parameter to mysql_real_connect, a
possibility opened up by the manual, what is the return. If it is "a MYSQL*
connection handle if the connection was successful", where did the space for
that handle come from.
I agree with Mario - if someone is going to go th
Hi Edward,
No problems in general with the installation. Everything has been working
fine, I need to move the database files as I am running out of space on the
/var partition.
Kind Regards,
Martyn
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Martyn Wendon" <[EMAIL PROTECTED]>
At 11:23 PM -0500 11/24/01, Gary Huntress wrote:
>I have a table of user info containing mixed case text. One user has
>created a database named "brain" and another has created a database "Brain".
>I was surprised to see that:
>
>select * from users where dbname= "Brain" returns both "brain" and
Martyn Wendon wrote:
> Hello,
>
> I'm having some trouble in re-locating my MySQL databases to a different
> directory. My scenario is:
>
> Platform: Red Hat Linux 6.2
> MySQL: 3.23.43
>
> MySQL data currently stored in /var/lib/mysql
> The database name is "music" (so files are therefore in
> /
The MySQL server is localhost.
As for checking if the query was successful or not, this was the check, and
that was the result of the failure.
if (mysql_query(&mysql,sqlcmd))
logger("[sql] %s\n%s \n\n",sqlcmd,mysql_error(&mysql));
sqlcmd is the query
If the query fails logger() is executed w
Hi,
How do you get JDBC Connection, named 'conn'?
It is from Driver Manger or Connection Pooling Utility?
Is 'conn' variable auto variable of method or instance variable of JSP?
Generally, JSP is called from multiple threads.
Do you lock 'conn' variable by synchronization?
I sugges
I tried:
select ... from T1 a inner join T1 b using(...);
and it doesn't work. I get a message about "Can't reopen table: 'a' ".
Is this not something that belongs in section "1.4.4 Functionality
Missing from MySQL" of the manual?
-
Hello,
I'm having some trouble in re-locating my MySQL databases to a different
directory. My scenario is:
Platform: Red Hat Linux 6.2
MySQL: 3.23.43
MySQL data currently stored in /var/lib/mysql
The database name is "music" (so files are therefore in
/var/lib/mysql/music)
I wish to move the
Hi takashi,
My environment is :
Win2000, jdk1.3, tomcat 4,
Well, i am sure i added a snippet which closes statemnt and the connection.
for example, below is the snippet from one of my pages content.jsp :
<% if (stmt!=null) { // actually this is a curly left brace
stmt.close(); } // actually th
>Description:
Documentation section 6.5.7 regarding create index states: "For CHAR and
VARCHAR columns, indexes can be created that use only part of a column, using
col_name(length) syntax. (On BLOB and TEXT columns the length is required.)"
It's still possible in the mysql clien
I don't know if this will answer the question:
Is MySQL located on the same computer your script/software is running on..??
If this is not the case you have a chance that your network connection to the computer
which MySQL is running on loses some packets which results in the above problem..
An
I'm using MySQL 3.23.43 running on Linux with a 2.2.16 kernel.
My software does around 50,000 inserts a day and from some of those inserts
they result in:
Lost connection to MySQL server during query
The software is developed in C, using the mysql C api to talk to the
database.
Problem is.. on
Prem,
you are probably running a very old version of MySQL, 3.23.38. There was an
error in the compilation:
May 30, 2001:
In the MySQL binary distribution for Windows 3.23.38 mysqld.exe was compiled
with __NT__ defined. If you run it on 95, 98, or ME, you will get an
assertion failure in os0
33 matches
Mail list logo
