What about this? I will not take "AUTO INCREMENT" I tried removing
the underscore and putting `AUTO INCREMENT` , but im getting the same
error as before.
CREATE TABLE if not exists TASK (
`Payment Date` DATE,
ID INT AUTO_INCREMENT,
CaseNumber CHAR(12) NOT NULL,
It worked great but I would like to know why, thank!
On Fri, 05 Nov 2004 13:42:29 +0200, Gleb Paharenko
<[EMAIL PROTECTED]> wrote:
> Hi.
>
> Put Purge into backticks.
>
>
>
> `Purge` char(1),
>
>
>
>
>
> spiv007 <[EMAIL
tmentFluid ),
PRIMARY KEY ( CaseNumber )
);
On Thu, 04 Nov 2004 17:34:14 +0200, Gleb Paharenko
<[EMAIL PROTECTED]> wrote:
> Hi.
>
> You may send us fragment of your file, near line 355.
>
>
>
>
> spiv007 <[EMAIL PROTECTED]> wrote:
>
> > Thank
GN_KEY_CHECKS to 0 as of MySQL 4.1.1.
>
>
>
>
> spiv007 <[EMAIL PROTECTED]> wrote:
>
> > I just dumped my access tables into mysql via mysql dump script.
>
> >
>
> > But now when i del my ables in access then do an import it does not
>
> > save the p
ps, mysqldump automatically includes a statement in the dump
>
> output to set FOREIGN_KEY_CHECKS to 0 as of MySQL 4.1.1.
>
>
>
>
> spiv007 <[EMAIL PROTECTED]> wrote:
>
> > I just dumped my access tables into mysql via mysql dump script.
>
> >
&g
t; relationships, mysqldump automatically includes a statement in the dump
>
> output to set FOREIGN_KEY_CHECKS to 0 as of MySQL 4.1.1.
>
>
>
>
> spiv007 <[EMAIL PROTECTED]> wrote:
>
> > I just dumped my access tables into mysql via mysql dump script.
>
>
I just dumped my access tables into mysql via mysql dump script.
But now when i del my ables in access then do an import it does not
save the primary key info nor the tables relationships. Is there
something I need to do to save this info before i remove the old
tables and insert the links. Beca
Has anyone seen this before with mysql-administrator?
/usr/local/bin/mysql-administrator: line 9: 19856 Segmentation fault
$MYPATH/mysql-administrator-bin
I get this everytime i go to schema privileges to assian a user rights.
--
MySQL General Mailing List
For list archives: http://lists.mysql
> Have you considered replication
> <http://dev.mysql.com/doc/mysql/en/Replication.html>?
>
> Michael
>
>
>
> spiv007 wrote:
>
> > I want to know what to best way to keep a 4 mysql servers sync.
> >
> > I have 4 remote locations, I am think
I want to know what to best way to keep a 4 mysql servers sync.
I have 4 remote locations, I am thinking about putting a mysql server
in each location and every hour have the 1 db that I need to sync to
sync together.
Is there away to do its in somewhat real time or even a delay maybe of
an hour
10 matches
Mail list logo
