 | | | MySQL General | | On Oct 31 2007 3 22 AM robert rottermann <robert@(protected) > wrote
> Hi there
> I have a strange problem.
>
> I am using Server version 5.0.45 SUSE MySQL RPM
>
> I made a backup of a database by cOn 03.11.2007 22 52 CE(S)T Yves Goergen wrote
> Is my design bad?
I should explain why I do it this way at all. There 's some other tables
in my system that need to keep a list of "keys " (i.e. user This one time at band camp Baron Schwartz <baron@(protected) > wrote
> INSERT INTO item (`key`)
> SELECT CONCAT( 'my-item '
> (SELECT IF(COUNT(*) 0 ' ' CONCAT( '- ' COUNT(*)))
> FROM itemI hope you understand my problem. There 's two potential solutions which
both don 't work for me. Is there a third? Can I create this kind of
referential integrity on the DBMS level at all? Is my designHi
I have a problem with my foreign keys. I have the following two tables
CREATE TABLE "keylist " (
"KeylistId " INTEGER NOT NULL
"UserId " INTEGER NOT NULL
PRIMARY KEY (KeylistId UserHi
mos wrote
> If I have a large table with 20 million rows is it going to be faster
> to use one delete statement like
>
> delete from mytable where rcdid in(20 300 423 .... 99999)
>
> to del
Good evening.
I have mysql cluster installed and I 'm trying to start the mysql server with
a new user account recently created and I 'm having trouble accessing the
server with the new account.
[If I have a large table with 20 million rows is it going to be faster to
use one delete statement like
delete from mytable where rcdid in(20 300 423 .... 99999)
to delete 10-100 random records uKevin Waterson wrote
> I have a table of item
> I wish to have the value of the item incremented if there is a duplicate.
> I looked at ON DUPLICATE KEY UPDATE but this modifies the exsisting value.
mikesz@(protected) wrote
> Hello mysql
>
> I have a PHP script that I have written and it runs beautifully on
> current MySQL and PHP sites BUT it barfs on MySQL 4.0 because I am
> usingIt sounds to me like you might be trying to find the standard
deviation or the variance which are functions you can use right in
your query.
On Nov 2 2007 at 7 37 AM Octavian Rasnita wrote
You would need to have an auto_increment field and your primary key
would be the item id (or what you call it) field + the auto_increment
field. Mysql will then handle incrementing the field if thHello mysql
I have a PHP script that I have written and it runs beautifully on
current MySQL and PHP sites BUT it barfs on MySQL 4.0 because I am
using the DATE() to extract the Date from a timestaHi
I 'm reloading a backup and I 'm getting loads of warnings like
+---------+------+
An update for those actually paying attention.
I have been fighing unusual performance issues with replication between
FreeBSD 6.2 machines.
The unusual part is that while replication would neverThis one time at band camp "Martin Gainty " <mgainty@(protected) > wrote
> Kevin-
>
> Declare the column AUTO_INCREMENT
> http //lists.mysql.com/mysql/161930
You can auto increment a non INT fieldI have a table of item
I wish to have the value of the item incremented if there is a duplicate.
I looked at ON DUPLICATE KEY UPDATE but this modifies the exsisting value.
If the item is my-item and tKristen G. Thorson wrote
> -----Original Message-----
> From Artem Kuchin [mailto matrix@(protected)]
> Sent Friday November 02 2007 9 23 AM
> To Baron Schwartz
> Cc mysql@(protected)
> SubThere 's a bitmap of which columns in the table allow NULL. This
contains as many bits as there are NULL-able columns in the table
rounded up to the nearest byte. When a column is NULL the bit isThanks for all of your help/information. One additional question... do NULL values take up any space?
For example if I have a column defined as
repAccess char(1) default null
When a user should Hi
Octavian Rasnita wrote
> Hi
>
> I have a table with the following columns
>
> symbol
> date
> value
>
> I want to select all the symbols (grouping by symbols) between 2
> specified dates Many of you have used MySQL Table Sync (or other tools from the MySQL
Toolkit I maintain). It has become increasingly complicated and
time-consuming to develop these tools and I can 't keep up with
-----Original Message-----
From Artem Kuchin [mailto matrix@(protected)]
Sent Friday November 02 2007 9 23 AM
To Baron Schwartz
Cc mysql@(protected)
Subject Re sporadic error 13 on windBaron Schwartz wrote
> What do you get from the following
>
> mysql > show variables like '%tmp% '
1) if i set
tmpdir C /temp
it shows
mysql > show variables like '%tmp% '
+What do you get from the following
mysql > show variables like '%tmp% '
Artem Kuchin wrote
> anyone any idea on this ?
>
> > > On 10/31/07 Artem Kuchin <matrix@(protected) > wrote
> > > > I am runninanyone any idea on this ?
> > On 10/31/07 Artem Kuchin <matrix@(protected) > wrote
> > > I am running
> > > Server version 5.0.45-community-nt MySQL Community Edition (GPL)
> > > on WIndows 2003 R2 ServicHi Max
Max Thayer wrote
> > What 's your question?
>
> Heh yah that might be important...
> Has anyone experienced this? Does it look like anything in the my.cnf
> could be altered to alleviate orHi
I have a table with the following columns
symbol
date
value
I want to select all the symbols (grouping by symbols) between 2 specified
dates and calculate the percent of change for each symbHi All
I have this question...
I send a INSERT from client to server the server write the row and send
the result "ok "
to the client. Due to a network failure the client doesn 't receive the
resulPhilip Hallstrom wrote
> > pgpool is a connection pool server for PostgreSQL. pgpool runs between
> > PostgreSQL 's clients(front ends) and servers(back ends).
> >
> > Well there are a few solutions out t |
|
|
