I'm going to have a php web form that potentially many users will use to
insert into a MYSQL DB, maybe they will try at the same time. Do I have
to lock the tables that are being populated?
Will a solution queue insert requests or just say I am busy?
Thanks,
Lee
--
MySQL General Mailing List
I'm going to have a php web form that potentially many users will use to
insert into a MYSQL DB, maybe they will try at the same time. Do I have
to lock the tables that are being populated?
You can use inserts, updates and selects without locking tables as long as
you don't need the table to
Unless your form is changing the same rows and order of operations is
important (which is probably not the case), there is no need to lock the
tables. So if each time the form is submitted it inserts a new row, there is
no reason to lock the tables.
---
Tom Crimmins
Interface Specialist
On Sat, 8 Jan 2005 04:06:44 -0600 , Tom Crimmins
[EMAIL PROTECTED] said:
Unless your form is changing the same rows and order of operations is
important (which is probably not the case), there is no need to lock the
tables. So if each time the form is submitted it inserts a new row, there
is
Correct, if the form generates independent insert statements then they will
not bump into each other, even with an auto_increment.
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: leegold
Sent: Saturday, January 08, 2005 4:46 AM
To: No name
Greetings.
I don't understand why DATETIME takes 8 bytes. It's just a waste, since
DATE+TIME take 6 bytes. And in fact, while DATE and TIME are each rounded
up to bytes on its own, a combined DATETIME should only take 5 bytes:
14 bits for year
04 bits for month
05 bits for day
05 bits for
When I su mysql and run mysqld I get this:
050107 14:09:12 [Warning] Asked for 196608 thread stack, but got 126976
mysqld: Can't create/write to file '/tmp/ib5ArcLz' (Errcode: 13)
050107 14:09:12 InnoDB: Error: unable to create temporary file; errno: 13
050107 14:09:12 [ERROR] Can't init
At 06:00 AM 1/8/05, Ehud Shapira wrote:
I don't understand why DATETIME takes 8 bytes. It's just a waste, since
DATE+TIME take 6 bytes. And in fact, while DATE and TIME are each rounded
up to bytes on its own, a combined DATETIME should only take 5 bytes:
14 bits for year
04 bits for month
05
[snip]
datetime is displayed as -MM-DD HH:MM:SS - it is *not* stored that
way. It is stored as a *nix timestamp - an integer number of seconds since
1970-01-01 00:00:00.
[/snip]
Actually datetime is not stored as epoch time. It has a range from
1000-01-01 00:00:00 to -12-31 23:59:59
At 12:15 PM 1/8/05, Tom Crimmins wrote:
[snip]
datetime is displayed as -MM-DD HH:MM:SS - it is *not* stored that
way. It is stored as a *nix timestamp - an integer number of seconds since
1970-01-01 00:00:00.
[/snip]
Actually datetime is not stored as epoch time. It has a range from
At 10:04 -0500 1/8/05, Frank Bax wrote:
At 06:00 AM 1/8/05, Ehud Shapira wrote:
I don't understand why DATETIME takes 8 bytes. It's just a waste,
since DATE+TIME take 6 bytes. And in fact, while DATE and TIME are
each rounded up to bytes on its own, a combined DATETIME should
only take 5
Hello.
Use -e command line option for mysql client program. For example:
mysql -u root -p test -e 'drop view v'
sam [EMAIL PROTECTED] wrote:
Hi,
What is the easiest way to drop a table created by create view?
I m using mysql 5.0. I would like to execute the drop from Unix
Hello.
As said at:
http://dev.mysql.com/doc/mysql/en/SET_PASSWORD.html
Only clients with access to mysql database can set passwords for
other accounts.
Joshua J. Kugler [EMAIL PROTECTED] wrote:
I've read the sections on GRANT's and permissions, and done some googling,
and
Hello.
In bug database I haven't found any verified bugs. And there was
a non-official binaries. In most cases you should use official
binaries of the latest release. At:
http://bugs.mysql.com/bug.php?id=4570
updating to the newest OS has solved the problem.
Chris Waterson [EMAIL
Hello.
mysqldump usually produced
SET NAMES utf8
at the begining of the dump file. The clues may be in this. Send us
the output of such statements:
SHOW CREATE TABLE avatardata;
SHOW CREATE DATABASE 'put the name of the avatar database';
SHOW VARIABLES LIKE '%char%';
and your
Hello.
Yes.
Karam Chand [EMAIL PROTECTED] wrote:
So if I use FLUSH MASTERS and FLUSH SLAVES, it will
have the same effect with new versions of MySQL too.
Karam
--- Gleb Paharenko [EMAIL PROTECTED] wrote:
Hello.
Also, from which version of MySQL LOCAL and
Hi,
I've just encountered a strange problem when trying to update a table :
UPDATE searchmainhardwarefr0, searchjoinhardwarefr0 SET
searchmainhardwarefr0.numeropost=searchjoinhardwarefr0.topic WHERE
searchmainhardwarefr0.numreponse=searchjoinhardwarefr0.numreponse;
ERROR 1114 (HY000): The table
17 matches
Mail list logo