Whilst we're using 4.1.4 for most of our development, on e of our developers
who works remotely has been using 3.23.52 for his development. In trying to
migrate his database onto 4.1.4 (or 4.1.7) we appear to have hit an
introduce restriction in 4.1.x.
It appears that the length of the column nam
Hi,
is there a way i can make a restriction for inserting
data on a table?
I'll expose this idea with a simple (not real)
example.
Suppose i got table EMPLOYEE, wich has an attribute
called FLG_HAS_DEPENDENTS. I also have a table called
DEPENDENTS, wich has data for the dependents of some
employe
Maciej Bobrowski <[EMAIL PROTECTED]> wrote:
>
> Sometimes I want to restrict the structure of my data. Let's say that I
> need to some records does not contain NULL values, or some numbers are not
> longer then 10 digits. But when I try to use
>
> login char(32)NOT NULL default 'tralala',
>
Hi,
Sometimes I want to restrict the structure of my data. Let's say that I
need to some records does not contain NULL values, or some numbers are not
longer then 10 digits. But when I try to use
login char(32)NOT NULL default 'tralala',
or
id bigint NOT NULL default 5000
Hi
Using mysql v: 3.23.28
Having defined an index across x columns if I then query with say 3
words in my against argument will the query return any row that contains
all the words or any row that contains any of the words ?
As the version of mysql that my host uses is: 3.23.28 I do not have the
MySQLCC probably uses the backtick (`) to escape stuff so it issued
UNIQUE KEY `IDX_Postcode-Location` (Postcode,Location)
and not
UNIQUE KEY IDX_Postcode-Location (Postcode,Location)
It has been mentioned on the list a few times in the last couple months that
if you escape strings containing hyph
On Wed, Jan 15, 2003 at 11:44:24AM +1100, Daniel Kasak wrote:
> Hi all,
>
> I recently had to restore from a backup and discovered that mysql didn't
> want to re-create a table which had the minus symbol (-) in it, eg
Yeah, you need to quote such names now.
Upgrade your version of mysqldump and
Hi all,
I recently had to restore from a backup and discovered that mysql didn't
want to re-create a table which had the minus symbol (-) in it, eg
DROP TABLE IF EXISTS Postcodes;
CREATE TABLE Postcodes (
DanPK mediumint(8) unsigned NOT NULL auto_increment,
MyStamp timestamp(14) NOT NULL,