Carsten,
Thanks for the answer (and other thanks go to the other guys that answered
me).
I think normalization is the way to go. I think it is the right thing to
do (in theory). The problem is that theory doesn't fit all.
Basically I have some tables with only 2 fields (ID and name), and a
|
| 4 | Madrid | C|
| 5 | Berlin | C|
---
where central_data.type is P for people and C for cities.
Do you think it is a good ideea ?
--
Best regards,
Ciprian Trofin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Is there a way to use a string concatenating function in connection with a
GROUP BY clause? I mean, for a one-to-many relation (like firm-stockholders
relation), to catch a structure like:
firm | stocholders
f_1 | s_1; s_2; s_3
f_2 | s_4; s_5
f_3 | s_6
instead of
firm |
I'm building a financial-like web site (PHP - MySQL). I was requested to
build a search engine for IT.
Everything works OK, w/ the exception of a certain component. The owner of
the web site will write, each day, a report for the customers. I use TEXT
fields to record each section of the report
I have 2 tables: currencies and quotes
currencies
==
id currency
-
quotes
==
id date id_currency value
---
Index (date, id_currency - UNIQUE)
In order to find the most recent value for a currency I use the following
logic:
1. SELECT
Nothing.
I fixed the problem w/ the indices, but it still doesn't work. Same probl.
g You have some unnecessary indicies.
g What happens if you remove them?
I am using MySQL 3.23.47-nt on Windows 2000 Pro SP3;
I have the following DB's:
# Host : localhost
# Database : test
CREATE
I am using MySQL 3.23.47-nt on Windows 2000 Pro SP3;
I have the following DB's:
# Host : localhost
# Database : test
CREATE DATABASE test;
USE test;
# Structure for table users :
CREATE TABLE `users` (
`id` smallint(4) NOT NULL auto_increment,
`user` varchar(8) NOT NULL default '',
A understand that a problem with temporary tables is that you can't
do a self-join in MySQL 3.xx using temporary tables. I have a situation
that requires exactly this (the alternative is not algorithm-effective).
I wonder if the following is a practical solution: to create a copy of the
I have a table that looks smth. like this:
id product price store
--
1 p1100s1
2 p1120s2
3 p1100s3
4 p2120s1
5 p2 95s2
6 p2300s3
7 p3100s1
8 p3120s2
Doesn't work the way I want to: I want the result to be like:
id | product | price | store
1 | p1 | 100 | s1
3 | p1 | 100 | s3
5 | p2 | 95 | s2
7 | p3 | 100 | s1
CL select * from table_name where product like 'p1' order
Hi,
R Alternatively, you can compute your order statistic explicitly by joining
R the table against itself, and then filter based on that:
Why did you use max(curEntry.family) and max(curEntry.member) ? I
tried the query w/out max, and it works just the same.
The
A closed mouth maintains a happy mind.
It could be that you specified signed TINYINT as type for the PRIMARY
KEY. Signed TINYINT goes from -127 to 127, hence your problem.
HO INSERT INTO `kontakt` (`id`, `navn`, `adresse`, `postnummer`, `by`,
HO `telefon`, `kommentar`) VALUES ('',
Confucius say: Man who kisses girl's behind gets crack in face.
Hi All !
I made a virtual stock exchange using PHP + MySQL. I'm not a programmer, so I
don't know how well the sistem behaves itself when it comes to performance.
Now, the project:
2 databases: stock players
Tables
Jack Daniel's Law of Motion: 'You can't fall off the floor'!
Try using Task Scheduler.
KHC I am using MySql version 4.0.0-alpha in Windows 2000.
KHC Everytime when I want to backup the database,i do it in MS-DOS.
KHC Using this command:
mysqldump --opt mydatabasename mybackup.sql
KHC
14 matches
Mail list logo