To copy table A to table B(non-existent) use this command:
CREATE TABLE B SELECT * FROM A;
Note. If your two tables are from different databases the syntax is
still the same. For instance if table A is in database Da and table B is
in database Db then use the MySQL command:
CREATE TABLE Db.B S
Hello,
I have a strange problem with my mysql server. The mysql process seems to be
using between 60 and 70 percent of the CPU at all times. Even when it is
seemingly idle (not active queries). I'm not sure what to look for to see what
it is doing other than truss'ing the process (I'm running i
Hi,
- Original Message -
From: "Eternal Designs, Inc"
Sent: Saturday, August 30, 2003 9:46 PM
Subject: Re: Newbie Table question
> To copy table A to table B(non-existent) use this command:
>
> CREATE TABLE B SELECT * FROM A;
>
> Note. If your two tables are from different databases the
On Sat, 2003-08-30 at 23:18, [EMAIL PROTECTED] wrote:
> Hello,
>
> I have a strange problem with my mysql server. The mysql process seems to be
> using between 60 and 70 percent of the CPU at all times. Even when it is
> seemingly idle (not active queries). I'm not sure what to look for to see w
yes mytop is very wicked it helps monitor the queries and gives you
benchmarks
-Original Message-
From: K Old [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 31, 2003 2:02 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: CPU Usage and MySQL...
On Sat, 2003-08-30 at 23:18, [EMAI
I have a table I use to keep track of referred users on my top list. Below
you will find the four columns in my table. What I need to do is keep
entries (rows) unique based on the linkid, ipaddress, and the clicktype so
that a user is not counted twice if they enter my site. Can someone tell
me wha
Hi
I've a DB using InnoDB tables and FK. If dump DB and try to import the
resulting text file I receive many errors because at import time mysql try
to import tables that have FK on tables not yet imported.
How could I dump/import telling MySQL to order dump tables having in mine
FK to avoid err
I think the message they were trying to convey in the answer is
"two-way replication will result in data corruption and therefore
should not be used." Consider a table with an AUTO_INCREMENT id
field. If two different inserts are done simultaneously, one on each
master, both will get the same id
Can this tool be used on Windows and if so what version do I need to DL and
does it need anything else besides the software (e.g. Perl - which I see
listed for the nix versions.
Thanks
Albert
- Original Message -
From: "K Old" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL P
On 01/09/2003 at 1:01 Chris Nolan wrote:
>Hi!
>
>If you have a look at the documentation at www.innobase.com, you'll find
>somewhere it mentions a few directives that you can use to turn off FK
>checking for a temporary period. The solution to your problem is there.
>
Thanks for your reply.
I o
Well, not logically valid in the general sense (in that naive
master-master replication can be self-destructive) but can be extremely
useful when utilized knowing all the limitations and potential pitfalls.
On Sun, 2003-08-31 at 10:01, Douglas Granzow wrote:
> I think the message they were trying
Hi Friends,
I have a problem with "AUTOCOMMIT" Variable.I'm using
release 4.0.14.When I change default-character-set
variable to "latin5" I can't execute "SET AUTOCOMMIT =
1 | 0" command.It returns "SQL Error:Variable
AUTOCOMMIT does not exist" error.
How can I solve this problem.I'm waiting your
Hi,
Am pretty new to mysqls power so kindly excuse if some of the questions are
very basic.
I have a table Cusomer_Data with 13 fields, (for the sake of simplicity lets
call the fields 1 to 13)
I want add 5 more fields after the 13th one and add the default falues of
1,1,'no',1,'no'
to all the ol
You are looking for the ALTER TABLE statement. Here's a link to the
manual page about it:
http://www.mysql.com/doc/en/ALTER_TABLE.html
Your command should be something like:
ALTER TABLE Custumer_data
ADD field14 tinyint DEFAULT 1,
ADD field15 tinyint DEFAULT 1,
ADD field16 enum('no', 'yes') DEF
I have a similar problem but not with the clicking but with filling out a
survey that is captured in mysql, twice.
Any help would be appreciated
Albert
- Original Message -
From: "Joseph" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 31, 2003 2:07 AM
Subject: uniques
I get this error when trying to create grants for a user I know
exists.Anyone know why this is happening?:
mysql> grant all privileges on jpox.* to [EMAIL PROTECTED] identified by
password 'password';
ERROR 1133: Can't find any matching row in the user table
--
MySQL General Mailing List
For
Michael,
> I get this error when trying to create grants for a user I know
> exists.Anyone know why this is happening?:
mysql>> grant all privileges on jpox.* to [EMAIL PROTECTED] identified by
> password 'password';
> ERROR 1133: Can't find any matching row in the user table
The error number
Subject:how to select with a set type field
I have a table 'organisms' with a field 'category'
of type SET('birds','bees','flowers','trees').
A record could have none or more of these in that field.
How do I select all records with both 'flowers' and 'trees'?
I can "SELECT category,key FR
18 matches
Mail list logo