Hello,
I am trying to develop a back-up procedure for our MySQL database.
The database is housed on our production Web server. My thought is to
simply make a slave on our file server that is backed up. I use InnoDB
type tables and my application uses transactions. I am wondering how
table/ro
Hello,
I am trying to develop a back-up procedure for our MySQL database.
The database is housed on our production Web server. My thought is to
simply make a slave on our file server that is backed up. I use InnoDB
type tables and my application uses transactions. I am wondering how
table/ro
Sorry to bother the list with the mundane, but I have searched the
entire MySQL manual and can't find the answer. Is there a way to output
the table description (using DESCRIBE) into an OUTFILE like you can for
SELECT query statements? Thanks! Aaron
I've had simmilar problems.
I had something like this...
String blah = myResultSet.getString("BLAHBLAH");
if(!myResultSet.wasNull()){
if(blah.equals("something)){ ...boom nullPointer exception
I'm not sure why the null value wasn't caught by wasNull(). Anyway I
worked around it by adding an if(b
I actually posted this yesterday, but I think it got lost with the whole
Oracle debacle. If anyone has experienced this your feedback would be
greatlt appreciated. best regards, Aaron
Occasionally with MyODBC, MySQL and Access I am getting an error when
trying to close a window stating 'This a
...uhm...yeah right. I also heard Larry Ellison was going to give all
his money away to help starving children in Afghanistan as well.
-Original Message-
From: MadProfessor [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 3:48 PM
To: [EMAIL PROTECTED]
Subject: Impact of Free ORA
Occasionally with MyODBC, MySQL and Access I am getting an error when
trying to close a window stating 'This action will reset the current
code in break mode. Do you want to stop the running code-Yes/No'. It
becomes impossible to close the window because it wont allow me to
select Yes. The only
MySQL can do the whole job. The client doesn't need to do the
encryption. Just use the password() function in your select and
updates.
--Aaron
Java examples:
String insertStatementStr = "INSERT into users VALUES
(?,?,?,?,PASSWORD(?),?,?, ?, ?)";
ResultSet myResultSet = stmt.executeQuery("SELE
I would think an add on to Apache Xerces would be perfect for this--and
not difficult. Has anyone from MySQL contacted members of the Apache XML
project about this? It would be great if this was done in a high
profile open source environment. An XML wrapper API for MySQL would fit
a huge whole i
Hello,
In my application I would like to update a MySQL record where one
column
is the largest value. Do I have to create a separate SELECT sql query
statement
to get that value and then update it? Or, is there a function that
allows me to specify it as part of my WHERE clause. I scanned th
--Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:12 PM
To: Rutledge, Aaron
Cc: Mysql List (E-mail)
Subject: Re: LIKE work around??
Work-around? LIKE should work just fine...
mysql> select * from fruits where fruit_name like '%banana%
MySQL doesn't support LIKE does it? I got an error when I tried. =20
-Original Message-
From: Nathan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:04 PM
To: Rutledge, Aaron
Subject: Re: LIKE work around??
Um... keep using LIKE? Just a thought... :-)
- Ori
I am trying to query the database for records that have the same
sequence of starting characters--such as banana1 and banana2 and have a
result set returned that contains everything that starts with banana.
Any way to do this? I think I would use LIKE in other types of
databases, but I was wonder
al Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:12 PM
To: Rutledge, Aaron
Cc: Mysql List (E-mail)
Subject: Re: LIKE work around??
Work-around? LIKE should work just fine...
mysql> select * from fruits where fruit_name like '%banana%
MySQL doesn't support LIKE does it? I got an error when I tried.
-Original Message-
From: Nathan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:04 PM
To: Rutledge, Aaron
Subject: Re: LIKE work around??
Um... keep using LIKE? Just a thought... :-)
- Ori
I am trying to query the database for records that have the same
sequence of starting characters--such as banana1 and banana2 and have a
result set returned that contains everything that starts with banana.
Any way to do this? I think I would use LIKE in other types of
databases, but I was wonder
A quick question. When creating a table that will hold values generated
by the password() function, what kind of column should this be stored
in...I am assuming VARCHAR(?). Could someone kindly tell me the length?
I've skimmed the whole manual and I can't find any reference to this.
Thank you!
12:24 PM
To: [EMAIL PROTECTED]
Subject: Re: innoDB confusion
Aaron,
"Rutledge, Aaron" wrote in message ...
>
>Woah...
>
>Heikki Tuuri wrote:
>"With some work, yes. innodb_table_monitor prints the internal schema
of
>InnoDB. There are fewer column types inside I
Woah...
Heikki Tuuri wrote:
"With some work, yes. innodb_table_monitor prints the internal schema of
InnoDB. There are fewer column types inside InnoDB than in MySQL. For
example, a DATE column will appear as an integer."
Now I am confused again. Do you only have access to column types
specifi
The added complexity frightens me a little. It seems a little
black-boxish to me right now. I am sure it is only a matter of getting
use to and working with the architecture. The idea of a separate
table-handler in the RDBMS seems very foreign when you come from the
Oracle world. However, I ca
ssage-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 10:43 AM
To: Rutledge, Aaron
Cc: [EMAIL PROTECTED]
Subject: Re: innoDB confusion
Aaron,
-Original Message-
From: Rutledge, Aaron <[EMAIL PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>
Date:
Hello, I am new to this list and MySQL. I am very excited about this
open source community. I can definitely see MySQL becoming to database
servers, what Apache has become to web servers.
I am currently developing a mission critical manufacturing web
application in Java and I am leaning towards
22 matches
Mail list logo
