error messages you are getting, and makes it quite simple to
figure out voided transactions from real transactions.
If this didn't make sense, feel free to e.mail me and I can give more
details off list, and include some screenshots from Worldship showing how
I set it up to talk to M
On Fri, 3 Mar 2006, David Griffiths wrote:
} Definitely give this tool a try if you haven't - it has some very powerful
} features - schema diffs (and the ability to create patches, etc - very
} powerful if you maintain development, quality-assurance, and production
} databases).
}
} The ability
On Wed, 1 Mar 2006, Price, Randall wrote:
} Try the following:
}
} REPLACE(products_description, CHAR(9), " ")
Thanks, Randall, that did it. And I feel quite stupid, as well, because I
re-checked my two test entries [33 and 37] and both had had their tabs
removed at some point. So it turns out
On Wed, 1 Mar 2006, Vince LaMonica wrote:
} update products_description set products_description =
} replace(`products_description`,'\t',' ') where products_id = "37";
[snip]
I should have also stated that in the above example, both the table name
and the column
On Wed, 1 Mar 2006 [EMAIL PROTECTED] wrote:
} [snip]
} Does anyone have any suggestions? The mysql server [and client] are
} running under Linux. The products_description field is a 'text' type. If
}
} there's further info you need, please let me know.
} [/snip]
}
} Are you using REPLACE(column
ion`,"\t"," ") where products_id = "33";
Does anyone have any suggestions? The mysql server [and client] are
running under Linux. The products_description field is a 'text' type. If
there's further info you need, please let me know.
Thanks in advance,
/
Hi all,
I'm curious if this is possible in 4.10: I have a table:
+--+-+--+-+---+--+
| Field| Type| Null | Key | Default | Extra|
+--+-+--+-+---+--+
| trac
I have tried to remove myself from this list, but the unsubscribe
function does not function. How does one get off of this list?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
printed output. My queries can get the information needed, with the
exception of output.
Thanks!
Vince Bravdica
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
into" command allowed? (see below)
--
Thanks in Advance and Best regards,
Vince mailto:[EMAIL PROTECTED]
drop table FremdeNLTB;
drop table FNL_ErkennungTB;
create table FremdeNLTB
(
FN_ID int unsigned not null,
Topic varchar(255),
Name v
east 1 author], and then 4 left joins on the
priorities 2-5. However, the result of this query produces only accurate
results for the join [eg: all the author '1's are right, but author2-5 are
all NULL].
What am I doing incorrectly? I know it's something simple I'm not seein
m/doc/en/ANSI_diff_Transactions.html
It's a well written explanation on how MySQL deals with transactions. For
a more detailed look, check out:
http://www.mysql.com/doc/en/InnoDB_transaction_model.html
HTH,
/vjl/
--
Vince LaMonica UC Irvine, School of Social Ecology
W3
ect to that server.
You need to make sure that mysqld is running. Since it appears you're on a
linux box, you can run this command:
ps aux |grep mysql
If nothing comes up, then you need to start mysqld. It may reside in
/usr/sbin. You should probably check the MySQL manual:
http://www.mys
On Thu, 14 Nov 2002, Roger Baklund wrote:
} * Vince LaMonica
[snip]
} > The user has created multiple author cols in the publications table
} > because the order of the author matters [eg: it is better for someone to
} > be an author1 than an author2 or a dreaded author5]. Some pub
ors.last_name? I'm a
php coder, but in this case, the user wishes to do this with straight sql
queries. And for whatever reason, I can't come up with a solution to this.
If anyone has an idea or two to throw my way, I would really appreciate
it!
/vjl/
--
Vince LaMonica
to getting the above to work, or a source for
a binary compile of SunOS 4.1.3 [client only] would be most appreciated.
Thanks,
/vjl/
--
Vince LaMonica UC Irvine, School of Social Ecology
W3 Developer <*> 116 Social Ecology I, Irvine, CA 92697
[EM
16 matches
Mail list logo