: Testing Email
INSERT INTO a VALUES (NOW()) ?
Regards,
Chris.
- Original Message -
From: "Renato Golin" <[EMAIL PROTECTED]>
To: "Nicholas Vettese" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, August 25, 2006 4:31 PM
Subject: Re: Testing Email
> Nicholas V
INSERT INTO a VALUES (NOW()) ?
Regards,
Chris.
- Original Message -
From: "Renato Golin" <[EMAIL PROTECTED]>
To: "Nicholas Vettese" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, August 25, 2006 4:31 PM
Subject: Re: Testing Email
Nicholas Vettese wrote:
Nicholas Vettese wrote:
I have been having problems with my email, and I wanted to test to this
list.
Will let you know when I receive it...
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
> The table should not be locked, right :D
Most probably it will be locked. If you are not running in strict SQL
mode, any column not explicitly given a value is set to its default
(explicit or implicit) value. For example, if you specify a column list
that does not name all the columns i
Hi Gleb
Thanx a lot for explanation, make sense.
I haven't try with INSERT INTO Y (t_y_time,and so on) SELECT
(t_x_time, ... and so on) FROM X
excluding t_y_id
The table should not be locked, right :D
Thx
Gleb Paharenko wrote:
Hello.
It seems that the problem is in the t_y_id auto_in
Hello.
It seems that the problem is in the t_y_id auto_increment field. InnoDB
puts special AUTO-INC table lock, and prevent other threads from
inserting into Y. See:
http://dev.mysql.com/doc/refman/5.0/en/innodb-auto-increment-column.html
Ady Wicaksono wrote:
> Below is the SQL to create tabl
Below is the SQL to create table Y
CREATE TABLE `Y` (
`t_y_id` int(11) NOT NULL auto_increment,
`t_y_time` timestamp NOT NULL default CURRENT_TIMESTAMP,
`t_y_dest` varchar(16) NOT NULL default '',
`t_y_msg` varchar(160) NOT NULL default '',
`t_y_status` tinyint(2) NOT NULL default '0',
`t_y
Hello.
According to:
http://dev.mysql.com/doc/refman/5.0/en/innodb-locks-set.html
INSERT ... SELECT set a non-next-key lock on each row. So in most cases
you should be able to insert the record into Y. Please, provide
the CREATE statement for table Y and the output of 'show variables'
statement
Hello.
> I'm trying to initialize to a database
Does this mean that you're unable to connect to MySQL Server? What
error message does mysql command line client report ? You said you were
able to telnet to 3307 port - have you seen the MySQL protocol messages
(usually seems like a garbage
On Tue, Aug 24, 2004 at 11:57:05AM +0200, Thomas Spahni wrote:
> Jesse,
>
> mysql> SHOW INDEX FROM mytable;
>
> gives you all indexes for `mytable`; you can process the results with
> perl.
Thanks very much. This works fine, and since I don't care about the
return value--just that there is one--
Jesse,
mysql> SHOW INDEX FROM mytable;
gives you all indexes for `mytable`; you can process the results with
perl.
Thomas Spahni
On Mon, 23 Aug 2004, Jesse Sheidlower wrote:
> I have a database where, most of the time, I'm bulk-loading
> data into new tables from an external source, several mi
On Mon, Aug 23, 2004 at 03:45:28PM -0500, Victor Pendleton wrote:
> Why don't you disable the indexes before the load and enable the indexes
> after the data load?
If I'm bulk-loading a fresh install of data, then I'll be using
un-indexed tables and index them afterwards. Otherwise, I want
to kee
Why don't you download navicat or use php admin and then just open the table
up in design view? You can then see if it has an index or not and add one if
you need?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL P
Why don't you disable the indexes before the load and enable the indexes
after the data load?
-Original Message-
From: Jesse Sheidlower
To: [EMAIL PROTECTED]
Sent: 8/23/04 3:33 PM
Subject: Testing for the existence of an index
I have a database where, most of the time, I'm bulk-loading
DeNewbie,
Monday, September 30, 2002, 9:36:03 PM, you wrote:
D> I am a MySQL newbie and i am somewhat confused. Firstly did I make a mistake
running mysql_install_db and afterwards running the commands;
D> /usr/bin/mysqladmin -u root password 'new-password'
D> mysqladmin -u pazin1 sqlpass
D>
> You could just exec() the page again, with a parameter telling it to
use
> the test server, like so:
I like this general idea, though the above method would take a little
more work since I would have to pass the environment variables and
apache variables (GET and POST, etc) to exec and I don't
On Tuesday 21 August 2001 23:30, Alexander Skwar wrote:
> So sprach »Sasha Pachev« am 2001-08-21 um 19:51:25 -0600 :
> > I have updated the filter, this message should make it.
>
> This message arrived 5 times at the list - or at least, I got it 5
> times. All the messages had different times.
>
Wahoo I m famous I have been immortalized on the MySQL forum...
To unsubscribe, e-mail <[EMAIL PROTECTED]>
That's me
Love you sense of humor Sasha...Keep up the excellent work!
Cheers
M;)
-Original Message-
From: Sasha Pachev [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2
Seems to be..Was wonding if the magic e-mailer nuked me again for being
naughty
Cheers
Mike Benzel [EMAIL PROTECTED] for NT Linux-Palm-CASL Support
Cross Platform Messaging and TDataSet Components: TAstaPDADataSets
Servers (Win32,Linux,Java) Clients (Win32,Linux,Java,Palm,WinCE,Linux PDA's)
ASTA
On Monday 09 July 2001 10:51, Tibor Simko wrote:
> Hello
>
> On Tue, 19 Jun 2001, Sasha Pachev wrote:
>
> > If you have a spare development system, plug in 4.0 binary and try
> > to run your applications on it to see if it will crash.
>
> I just tried it on Debian GNU/Linux for i386 with up-to
Hello
On Tue, 19 Jun 2001, Sasha Pachev wrote:
> If you have a spare development system, plug in 4.0 binary and try
> to run your applications on it to see if it will crash.
I just tried it on Debian GNU/Linux for i386 with up-to-date "testing"
distro and up-to-date "bk clone". The compile pr
On Wednesday 20 June 2001 07:30, Michael Widenius wrote:
> Hi!
>
> > "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes:
>
> Sasha> On Tuesday 19 June 2001 17:43, Russell E Glaue wrote:
> >> > . After you've pulled, run BUILD/compile-pentium (for a lean fast
binary)
> >> > or BUILD/compile-
On Wed, 20 Jun 2001, Michael Widenius wrote:
>
> Hi!
>
> > "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes:
>
> Sasha> On Tuesday 19 June 2001 17:43, Russell E Glaue wrote:
> >> > . After you've pulled, run BUILD/compile-pentium (for a lean fast binary)
> >> > or BUILD/compile-pentium-
Hi!
> "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes:
Sasha> On Tuesday 19 June 2001 17:43, Russell E Glaue wrote:
>> > . After you've pulled, run BUILD/compile-pentium (for a lean fast binary)
>> > or BUILD/compile-pentium-debug - it will build a binary for you.
>>
>> We run all our M
On Tuesday 19 June 2001 17:43, Russell E Glaue wrote:
> > . After you've pulled, run BUILD/compile-pentium (for a lean fast binary)
> > or BUILD/compile-pentium-debug - it will build a binary for you.
>
> We run all our MySQLs on the fast SPARCs and PPCs
> is pentium the only supported hardware r
> . After you've pulled, run BUILD/compile-pentium (for a lean fast binary)
> or BUILD/compile-pentium-debug - it will build a binary for you.
We run all our MySQLs on the fast SPARCs and PPCs
is pentium the only supported hardware right now?
-RG
On Tue, 19 Jun 2001, Sasha Pachev wrote:
> Hel
Hi.
Sorry, but I cannot see how this relates to MySQL. Please ask in the
appropriate forum. Here, it is off-topic. Try http://www.php4.org
Bye,
Benjamin.
On Tue, Jan 16, 2001 at 11:53:00AM -0300, [EMAIL PROTECTED] wrote:
> Using PHP+Apache+Linux, how can I find out from the browser whe
27 matches
Mail list logo
