Re: error creating table

tried the below syntax. It failed. > > Then I redefined the primary keys in the parent tables to be the exact same > type as the foreign keys in UserRole and it worked. > > So, check the datatype of all your keys and make sure they match. > > On Mon, Nov 30, 2009 at 11:50 AM,

error creating table

ION ON UPDATE NO ACTION, CONSTRAINT `fk_roleid` FOREIGN KEY (`roleid` ) REFERENCES `mydb`.`Roles` (`roleid` ) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci; -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT

Re: error creating table

KEY (`roleid`, `userid`), >> INDEX `FK1_user` (`userid`), >> CONSTRAINT `fk_userid` FOREIGN KEY (`userid`) REFERENCES `users` >> (`userid`) ON UPDATE CASCADE ON DELETE CASCADE, >> CONSTRAINT `fk_roleid` FOREIGN KEY (`roleid`) REFERENCES `roles` >> (`roleid`) ON UPDATE CA

error creating table

FERENCES `roles` (`roleid`) ON UPDATE CASCADE ON DELETE CASCADE ) COLLATE=utf8_general_ci ENGINE=InnoDB ROW_FORMAT=COMPACT AVG_ROW_LENGTH=0 -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) http://safknw.blogspot.com/ "Peace" is the Ultimate thing we want. -- MySQL Gene

linq with mysql

o brackets '[' ? select [t0].[amount], [t0].[acct_num] FROM [Account] AS [t0] -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) http://safknw.blogspot.com/ "Peace" is the Ultimate thing we want. -- MySQL General Mailing List For list archives: http://lists.mysql.c

roles table design

e mapping table. -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) http://safknw.blogspot.com/ "Peace" is the Ultimate thing we want. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

foreign key cautions

HI, What are the caution should be taken when designing a db regarding foreign key? I have "user" table , from which userid is taken as reference in many tables, is it ok? -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) http://safknw.blogspot.com/ "Peace&q

error creating table

utest`.`permission` (`idpermission` ) ON DELETE SET NULL ON UPDATE CASCADE) ENGINE = InnoDB; -- here is the error mssage :Can't create table '.\menutest\role_perm.frm' (errno: 150) -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) http://safknw.blogspot

Linq support

Hi, Did latest Mysql .net provider (5.1.4) support Linq? -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) A revolution is about to begin. A world is about to change. And you and I are "the initiator".

mysql to mysql conversion tool

Hi, I'm looking an application which let me convert one mysql to another db. I need this to port my website from one cms (Vivvo) to another (Drupal). -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) A revolution is about to begin. A world is about to change. And you and

monitoring utility

Hi, I have a website running on Linux based cluster server. We don't have access to logs, nor we have ssh access. I want monitor mysql server usage of my site for the purpose of optimizing my site scripts. Pls suggest php based application. -- Sharique uddin Ahmed Farooqui (C++/C# Develope

Fwd: Table crashing

7; in * /www/ims/includes/database**.mysqli.inc* on line *151* I don't understand what's wrong with db. -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) A revolution is about to begin. A world is about to change. And you and me are "the initiator".

Table crashing

7; in * /www/ims/includes/database.mysqli.inc* on line *151* I don't understand what's wrong with db. -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) A revolution is about to begin. A world is about to change. And you and me are "the initiator".

Re: CSV import

MysqlAdmin? -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) A revolution is about to begin. A world is about to change. And you and me are "the initiator". On 5/28/07, Geoffroy Cogniaux <[EMAIL PROTECTED]> wrote: Hi, It can be done easily with PhpMyAdmin, but it

CSV import

I want to import data from a CSV file in a table. MySql admin doesn't support import from CSV files. Format of data is different from structure of table. Is there any app/snippet written for this task in .net , which I can modify according to my need. -- Sharique uddin Ahmed Farooqui (

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)

his in drupal forum http://drupal.org/node/140303. What I've done is I have exported data from old db via phpMyAdmin and imported into new database. Since it related to mysql so i'm posting here. -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) http://www.managefolio.net