Sven Köhler wrote:
I was very disappointed by Interbase/Firebird. It seemed to me like a
MS-Access: a database-engine that works on regular files
Firebird seems simple, but it doesn't mean it's inferior or
[intentionally] crippled like MS-Access. SQL server also works on
"regular files" (db is s
What do people recommend for storing money amounts? I've seen people use
NUMERIC(18,3) and other use NUMERIC(18,4). Which one is more appropriate
and why? This is considering various existing currencies, some having
low rates (like IDR, in which you can have large amount up to hundreds
of trill
David Garamond wrote:
insert into t1 values (3,char(32));
Record 3, 5, and 7 is rejected due to duplicate value.
++--+--+
| id | length(code) | code |
++--+--+
| 1 |0 | |
| 2 |1 | 0|
| 4 |2 | 0 0 |
| 6
Can CHAR/VARCHAR store strings with nul (ASCII 0) in them? It seems it
can't. [I've used CHAR(2), VARCHAR(2), CHAR(2) BINARY, VARCHAR(2) BINARY].
===
create table t1 (
id int not null primary key,
code varchar(2) not null, un
We can use SUM(), AVG(), COUNT(), etc. in GROUP clause. These are all
numeric functions. Is it possible to use string functions as well? I
know MIN() & MAX() can be asciibetical for string fields, but wouldn't
this be very handy/practical?
SELECT division,
G_CONCAT(", ",first_name) as nicks,
Bruce Feist wrote:
David Garamond <[EMAIL PROTECTED]> wrote:
CREATE TABLE `payments` (
`date` date NOT NULL,
`payee` varchar(255),
`amount` double
)
The 'payments' table records the amount of money that should be paid
to each person every month. But the actual cheque is
Haydies wrote:
That was an amazingly vage question.
Yup, sorry for that. Accidentally sent :)
--
dave
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Victoria Reznichenko wrote:
David Garamond <[EMAIL PROTECTED]> wrote:
Can I do this with in pure SQL (instead of having to create logic in
programming language)?
What do you mean "Custom/conditional grouping"? Please, be more detailed.
Sorry, please refer to my other post. The
[Sorry for the accidental premature sending in the first post...]
CREATE TABLE `payments` (
`date` date NOT NULL,
`payee` varchar(255),
`amount` double
)
INSERT INTO payments VALUES ('2003-05-01','david',38);
INSERT INTO payments VALUES ('2003-06-02','david',13.4);
INSERT INTO payments VALUE
Can I do this with in pure SQL (instead of having to create logic in
programming language)?
Thanks in advance,
--
dave
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is there an option for mysqld to add a sleep() call after each failed
connection request, before reporting to the client (to slow down brute
force attack)? I glanced at the manual and there doesn't seem to be one.
If there isn't, would it be a good idea? If yes, I could probably submit
a patch.
I'm just wondering if there is an MTA/MDA/IMAPD/Exchange-like app/other
mail-related daemons that stores mail messages in a relational database
like MySQL?
Regards,
--
dave
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EM
David Garamond wrote:
On Fri, Apr 04, 2003 at 01:22:39PM +0700, David Garamond wrote:
i found this on my server log:
mysqld-max: raid.cc:160: my_off_t my_raid_seek(int, long long
unsigned int, int, int): Assertion `pos != (~(my_off_t) 0)' failed.
and then mysqld shuts down. i start it
Jeremy Zawodny wrote:
On Fri, Apr 04, 2003 at 01:22:39PM +0700, David Garamond wrote:
i found this on my server log:
mysqld-max: raid.cc:160: my_off_t my_raid_seek(int, long long unsigned
int, int, int): Assertion `pos != (~(my_off_t) 0)' failed.
and then mysqld shuts down. i start it
i found this on my server log:
mysqld-max: raid.cc:160: my_off_t my_raid_seek(int, long long unsigned
int, int, int): Assertion `pos != (~(my_off_t) 0)' failed.
and then mysqld shuts down. i start it again but after a short while the
same error appears and mysqld stops again. what does this ind
i read in several places (like in recent osnews.com newspiece and some
other prior postings to this list) that mysql 4.0.x is supposed to be
"stable" now. but the front page of mysql.com still lists 4.0.5 under
"development".
so does the mysql developers suggest that mysql is still "unstable" o
David Garamond wrote:
mysql> select 1/29;
+--+
| 0.03 |
+--+
mysql> select 100.0*1/29;
++
| 3.448 |
++
mysql> select 1/29*100.0;
++
| 3.45 |
++
sorry for the previous post, misleading problem statement. the exact
pr
hi,
mysql> select 1/29;
+--+
| 1/29 |
+--+
| 0.03 |
+--+
1 row in set (0.00 sec)
mysql> select 100.0*1/29;
++
| 100.0*1/29 |
++
| 3.448 |
++
1 row in set (0.00 sec)
mysql> select 1/29*100.0;
++
| 1/29*100.0 |
++
|
Jan Steinman wrote:
> Today's "modern" operating systems really stopped evolving in the 80's. Many ideas
>like database filesystems never really got a chance to show their utility.
isn't the next windows operating system (longhorn) supposed to have a
new filesystem that's based on SQL Server? i
19 matches
Mail list logo
