Rudi,
> I'll be using smaller tables with appropriate join tables and PHP.
> Just for interests sake I'll be using Dia to plan the schema.
> I prefer to use the UML drawing tools instead of the ER ones.
I still use a simple flowcharting program to plan my databases. Never
saw the value in UML
Nicolas JOUANIN wrote:
Hi,
Thanks for your help. In fact that means 2 solutions for this:
1) select * from pdi where rtrim(pdi) = '100058'
or
2) Use VARCHAR instead of CHAR
I don't which is the best , but both are working.
Nicolas.
Do you have a specific reason why to use CHAR?
I use
Denis Arh wrote:
How to delete "real" duplicates?
id | somthing
---
1 | aaa
1 | aaa
2 | bbb
2 | bbb
(an accident with backup recovery...)
In these cases, its certainly the best to rebuild your table
using a
CREATE TABLE new AS
SELECT col1,col1..
FROM old
GROUPY BY col1,col2..
