I have an issue where inserts are not being seen properly while in a SP. The
goal is to track payments made by customers, payment distribution. I narrowed
down the issue to the below, so I was able to exclude many columns and other
tables in hopes it is simple enough to get some help.
I have
This is a little dangerous as well; if an exception gets thrown, the
statement doesn't get closed. My sample code is below.
That said, your query looks fine. Add logging to your code to figure out
what's going on. Run your query by hand against your database; I suspect
you have an issue with
I tried everything you suggested. 'Think it is the way I have set up
the table in MYSQL. This is the table
++---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
++---+--+-+-+---
I have a large database, about a million records in some tables, and I
am trying to troubleshoot some stalls in our application. We have
assumed that slow query speed causes the stalls, however, when my web
app stalls I do not see the query in process list. What we see is the
web page stall
Hi Shaun!
Shaun T. Erickson wrote:
I have a client who has a RH9 server that I'm not allowed to upgrade
to something newer. It has MySQL 3.23.58 on it and I need to replace
that with the newest I can get. The MySQL-AB site doesn't seem (unless
I missed it, which is quite possible) to have any R
I had a similar problem a while ago and I got round it by using a trigger -
called a function on an insert to
read a value from a table (use for update when selecting)
update with incremented value
then use the return value from the ffunction to "set" the new value -
you can do all your login or
Hi,
Can someone please tell me what is going on? I keep getting this error
everytime I try to start the mysql server and there is no information about
this pid file error anywhere. Any help offered will be greatly appreciated.
[EMAIL PROTECTED]:/var/lib/mysql# mysqld_safe
Starting mysqld daem
Hi,
> > CREATE TABLE competenza (
> > competenza varchar(30) NOT NULL default 'comp-06-',
> > id_competenza int unsigned not null auto_increment,
> > descrizione varchar(100),
> > PRIMARY KEY (competenza, id_competenza)
> > )
> >
> > Since your PRIMARY KEY is a combination of 2 fields (competenza
On Tuesday 02 January 2007 16:51 Brent Baisley's cat, walking on the keyboard,
wrote:
> CREATE TABLE competenza (
> competenza varchar(30) NOT NULL default 'comp-06-',
> id_competenza int unsigned not null auto_increment,
> descrizione varchar(100),
> PRIMARY KEY (competenza, id_competenza)
> )
>
I don't think MySQL has exactly what you are looking for, but you may be able
to get the behavior you want.
The auto_increment value is actually based on an index and doesn't have to be unique. So you could create a compound index that has
one or more fields plus the auto_increment field. The e
Hi,
> I'm new to MySQL coming from PostgreSQL backgroud. I'd like to know how to
> obtain the same effect of a sequence + concat as default value of a table
in
> mysql. For example, consider the following table definition:
>
> CREATE TABLE competenza
> (
> id_competenza character varying(30) NOT
Here is the code:
ps = con.prepareStatement("select first, last from cust where ssn=?");
int ssnint = Integer.parseInt(ssn.trim());
ps.setInt(1, ssnint);
ResultSet rs=ps.executeQuery();
if ( rs.next()) {
rs.close();
out.println("Cust
Hi all,
I'm new to MySQL coming from PostgreSQL backgroud. I'd like to know how to
obtain the same effect of a sequence + concat as default value of a table in
mysql. For example, consider the following table definition:
CREATE TABLE competenza
(
id_competenza character varying(30) NOT NULL DE
On 1/1/07, mos wrote:
At 12:49 PM 1/1/2007, Jochem van Dieten wrote:
>On 1/1/07, mos wrote:
http://www.mysqlperformanceblog.com/2006/11/30/interesting-mysql-and-postgresql-benchmarks/
http://tweakers.net/reviews/649/6
Has this been fixed?
As the article on the MySQL Performance Blog mention
14 matches
Mail list logo
