On Friday, November 18, 2011 at 03:31:44 UTC, martin.muel...@mac.com
confabulated:
> Is it possible to make utf8 the default for all databases and transactions
> in a MySQL installation?
> The current default is Latin1. There is a suggestion on the Web to edit
> the my.cnf file as follows
> [m
On Mon, 19 Jan 2009, Duane Hill wrote:
I have two tables defined:
CREATE TABLE `tga_body` (
`body_id` int(10) unsigned NOT NULL auto_increment,
`blob_pos` mediumint(8) unsigned NOT NULL,
`file_id` int(10) unsigned NOT NULL,
`blob_id` int(10) unsigned NOT NULL
I have two tables defined:
CREATE TABLE `tga_body` (
`body_id` int(10) unsigned NOT NULL auto_increment,
`blob_pos` mediumint(8) unsigned NOT NULL,
`file_id` int(10) unsigned NOT NULL,
`blob_id` int(10) unsigned NOT NULL,
PRIMARY KEY USING BTREE (`body_id`),
On Thu, 7 Aug 2008, [EMAIL PROTECTED] wrote:
Hello
I would like to create my first mysql database. Is there a gui tool that makes
this easy to do?
http://dev.mysql.com/downloads/gui-tools/5.0.html
-d
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
On Wed, 28 Nov 2007 12:57:25 +0100 (CET)
"Alicia Amadoz"<[EMAIL PROTECTED]> wrote:
> Hi,
>
> I want to copy some databases to a new server and I have tried to
> backup my databases with mysqldump in the old server, then copy those
> files to the new server and recover them with mysqldump again. T
much do you care about "test" table, Duane?
> In your own words: "I do not have anything really set up yet", so drop
> the table or even the whole testdb database and see if that helps
> Regards,
> Mikhail Berman
> -----Original Message-
> From
That's a quick fix that does happen to correct the problem.
However, what if this was happening to a database/table I could not
just dump and start over?
> -----Original Message-
> From: Duane Hill [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 31, 2006 10:18 AM
>
.test | repair | error| Incorrect information in file:
'./testdb/test.frm' |
+-++--+-+
I even tried with the USE_FRM option and received the same result.
> -Original Message-
&g
yet. I will try that. Thanks.
> -----Original Message-
> From: Duane Hill [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 31, 2006 9:49 AM
> To: mysql@lists.mysql.com
> Subject: Incorrect information in file...
> MySQL v5.0.24 on FreeBSD v6.0-RELEASE
> I was a
MySQL v5.0.24 on FreeBSD v6.0-RELEASE
I was attempting to do some tweaking in a my.cnf to increase
performance on a server here. I had copied the my-huge.cnf config
file into /etc and uncommented the section on InnoDB from within. I
also changed the thread_concurrency option
On Mon, 3 Jul 2006, Stefan Hornburg wrote:
Duane Hill wrote:
Can someone either answer or point me somewhere for the answer?
I am attempting to store text lines from an e-mail message into a MySQL
table through the use of Perl and DBI. Periodically I get the error that
states there was an
Can someone either answer or point me somewhere for the answer?
I am attempting to store text lines from an e-mail message into a MySQL
table through the use of Perl and DBI. Periodically I get the error that
states there was an error in the statement and to check the syntax. I know
it has som
On Fri, 9 Jun 2006, Chris White wrote:
On Thursday 08 June 2006 05:30 am, Jesse wrote:
This may be a really stupid question, but I hate looking stupid if I can
avoid it. :-)
I have been using Microsoft SQL Server for a while, and I'm now trying to
switch all our applications over to use MySQL.
Sorry for responding to my own message. I figured this out.
DELIMITER //
CREATE TRIGGER only_this AFTER INSERT ON table_a
FOR EACH ROW
BEGIN
IF NEW.email_addr LIKE '[EMAIL PROTECTED]' THEN
INSERT INTO table_b (email_addr,value) VALUES (NEW.email_addr,0);
END IF;
END
On Saturday, January 7
Hello All,
I've been racking my brain trying to figure out something. I'm
relatively new to the arena of SQL and have been doing a bunch of
reading and experimenting.
I have found a need for a trigger that will fire after an insert
into a table. The trigger needs to act on
15 matches
Mail list logo
