` )
ON DELETE NO ACTION
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
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 Consultant
`) REFERENCES `users`
(`userid`) ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT `fk_roleid` FOREIGN KEY (`roleid`) REFERENCES `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
`) 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 General Mailing List
For list archives: http
], [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.com/mysql
To unsubscribe:http://lists.mysql.com
.
--
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]
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 is the Ultimate thing we
`.`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.com/
Peace
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.
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 I
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# Developer
/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.
/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.
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
(C++/C
?
--
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 is not in .net
2007/5/28
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/news/
A revolution is about to begin.
A world is about to change
16 matches
Mail list logo