- Original Message -
From: "Olav Mørkrid" <[EMAIL PROTECTED]>
To:
Sent: Friday, August 24, 2007 1:07 AM
Subject: where column
hello
does anyone know what is returned when you do a where column without
further parameters?
SELECT * FROM TABLE WHERE COLUMN;
for integer columns it se
hello
does anyone know what is returned when you do a where column without
further parameters?
SELECT * FROM TABLE WHERE COLUMN;
for integer columns it seems to return non-zero columns, but for other
types of columns the results seemed unpredictable.
--
MySQL General Mailing List
For list arch
Hi there !
Does anyone knows if there is a specific MySQL ERROR (SQLSATE)
for DELETE of a not found key?
I have tried MySQL Error 1032 e 1176 (SQLSTATE HY000) but it
does not seems to work ..
Thanks in advance
Ni
We know that we won't need to do those sorts of queries except for
statistical analysis which can happen offline (and for that we'll assemble
the data back into a single table).
Each table is for a specific user and there's no need to run queries across
users (for this data).
Doug
-Original
How are you going to do queries that join or merge thousands of tables? or
won't that be necessary?
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etude
We're trying to figure out how to design a particularly critical table in
our database schema. The choices are to use a single large table or a
series of dynamically created small tables.
This table will receive the majority of traffic (queries and updates) in the
database so it's a key part of t
Hi, I work for a mobile technology company in London.
We are looking to recruit a MySQL DBA.
The world of the enterprise DBA is changing, be part of it. Like it or
not, open source technology is making serious inroads into the
enterprise environment. Justifying the purchase of a heavyweight RDBM
I concur. Also it makes it easier to remove a customer if they leave.
Finally your backups will only lock up one customer's database at time and
for a much shorter period.
On Thu, August 23, 2007 10:50, Jerry Schwartz said:
> Personally, I think I'd go with one DATABASE per customer. That way th
Personally, I think I'd go with one DATABASE per customer. That way the your
code would be the same, and easier to handle. It would be easier to manage
the security at the database level, I suspect. I'd set up a ../inc directory
outside the web server root that would have one file per customer, and
On 8/23/07, Jason Pruim <[EMAIL PROTECTED]> wrote:
>
>
> > b)Terminating TCP connections and ensuring that each PHP script
> > runs to
> > completion, anyway, and that the database isn't left in an
> > indeterminate
> > state due to this.
> >
> > Dave.
>
> What do you mean by "b"? If all the connec
On Aug 23, 2007, at 11:50 AM, David T. Ashley wrote:
On 8/23/07, Jason Pruim <[EMAIL PROTECTED]> wrote:
I am planning on having the database open to customers of mine to
store their mailing addresses on-line, and be able to manage the
records.
Is it safe, to have 1 database with lots of tabl
On Aug 23, 2007, at 11:28 AM, Rolando Edwards wrote:
Think about how your going to make backups.
1) Would you backup one database with all the mailing lists together ?
If I went the route of 1 database, Many tables, I would just backup
the entire database and all the tables in one shot. Un
On Aug 23, 2007, at 11:44 AM, Gary Josack wrote:
I'd never have a separate database for everyone or even a separate
table for everyone. Here's a rough idea of how I'd do it
mysql> CREATE TABLE customer (
-> `custid` INT NOT NULL AUTO_INCREMENT,
-> `lastname` VARCHAR(25) not null,
->
On 8/23/07, Jason Pruim <[EMAIL PROTECTED]> wrote:
>
> I am planning on having the database open to customers of mine to
> store their mailing addresses on-line, and be able to manage the
> records.
>
> Is it safe, to have 1 database with lots of tables? Or am I safer
> setting up separate database
I'd never have a separate database for everyone or even a separate table
for everyone. Here's a rough idea of how I'd do it
mysql> CREATE TABLE customer (
-> `custid` INT NOT NULL AUTO_INCREMENT,
-> `lastname` VARCHAR(25) not null,
-> `firstname` VARCHAR(25) NOT NULL,
-> PRIMARY KEY(
Think about how your going to make backups.
1) Would you backup one database with all the mailing lists together ?
2) Would you keep the backups of each user separate ?
3) Could users ask you to restore mailing lists from the past ?
You could make one mysqldump for everybody from one database if
Hi Everyone,
Just had a quick question about a database I'm working on.
I am planning on having the database open to customers of mine to
store their mailing addresses on-line, and be able to manage the
records.
Is it safe, to have 1 database with lots of tables? Or am I safer
setting up
mysql> select format(300,0);
+---+
| format(300,0) |
+---+
| 3,000,000 |
+---+
1 row in set (0.00 sec)
mysql> select format(300,2);
+---+
| format(300,2) |
+---+
| 3,000,000.00 |
+-
Not really a MySQL problem, this is a presentation problem. MySQL will
store the number as digits only (unless you are storing in a character
field - but why would you?). If using PHP, for instance, the output of
the field would be
number_format($fieldvalue)
or if you want the answer to two d
Was wondering if anyone could help me with this little problem I'm having.
I'd like to have a comma separator after every 3 digits. E.g "3,000,000".
How would i go about this?
www.coderewind.com
Best Place to hunt for Code
--
View this message in context:
http://www.nabble.com/seoparator-
I'd guess this may be a funny related to Crystal Reports as I don't recall
experiencing this myself.
Rhys
-Original Message-
From: Eric Lommatsch [mailto:[EMAIL PROTECTED]
Sent: 22 August 2007 22:21
To: Rhys Campbell; mysql@lists.mysql.com
Subject: RE: Why is the average of an int column
21 matches
Mail list logo
