Good morning,
I have scripts to create constraints, sequences, storage..., tables from
ORACLE and I don't know if I can create them in MySQL?
Appreciated your help,
Thank you,
Phong
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi,
I have scripts to create constraints, sequences, storage..., tables from
ORACLE and I don't know if I can create them in MySQL?
MySQL doesn't have sequences or storage specifiers.
You cannot run your script directly.
Depending on your current Oracle structure, you might want to give
our
Nguyen, Phong wrote:
Good morning,
I have scripts to create constraints, sequences, storage..., tables from
ORACLE and I don't know if I can create them in MySQL?
You can try our Migration Toolkit which has pretty good support
for Oracle now...
, Phong [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 26, 2005 7:55 AM
To: mysql@lists.mysql.com
Subject: ORACLE and Mysql: Create tables, constraints, swquences, storage.
..?
Good morning,
I have scripts to create constraints, sequences, storage..., tables from
ORACLE and I don't know if I can
Hi Caroline,
Hi, I have several simple questions regarding creating
tables in the MySQL.
1. For a variable of Java primitive int type, I should
use INT or INTEGER? Do I have to specify the length of
the field?
CREATE TABLE message_thread( thread_id INT or INTEGER
NOT NULL AUTO_INCREMENT
Michael,
- Alkuperäinen viesti -
Lähettäjä: [EMAIL PROTECTED]
Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED]
Kopio: [EMAIL PROTECTED]
Lähetetty: Monday, December 29, 2003 11:53 PM
Aihe: Re: Foreign Keys in CREATE TABLEs produced by mysqldump
Heikki Tuuri [EMAIL PROTECTED] wrote on 12
Hi, I have several simple questions regarding creating
tables in the MySQL.
1. For a variable of Java primitive int type, I should
use INT or INTEGER? Do I have to specify the length of
the field?
CREATE TABLE message_thread( thread_id INT or INTEGER
NOT NULL AUTO_INCREMENT PRIMARY KEY);
2. A
Heikki Tuuri [EMAIL PROTECTED] wrote on 12/24/2003 01:53:07 PM:
Michael,
this is the question where the valid answer is: upgrade!
In which version was this corrected? I'm hesitant to upgrade to the latest
and greatest without it being banged on by the masses first..
I have half a dozen or
Michael,
- Original Message -
From: [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, December 24, 2003 1:45 AM
Subject: Foreign Keys in CREATE TABLEs produced by mysqldump
--=_alternative 008277CD88256E05_=
Content-Type: text/plain; charset=US-ASCII
First let
First let me state that this is not a question where a valid answer is to
SET FOREIGN_KEY_CHECKS=0... (no, its not *that* question..)
I have noticed that mysqldump includes the database name in foreign key
specifications within CREATE TABLEs. This is causing a bit of grief as I
would like
)
values ('someuser','%', PASSWORD('somepw'),
'Y','Y','Y','Y','Y','Y','Y');
flush priviliges;
The new users can log in and can create new databases, but they can
neither create tables inside the new database nor use show tables.
Am I missing something (I read the online manual and came across some
Perumal,
Saturday, October 12, 2002, 11:27:44 AM, you wrote:
P Please anybody could tell me how to start mysql-max to work with DB.
P What i did : start mysqld like
P ./configure --prefix
P =/usr/local/mysqlit starts like
P
Dear sir,
Please anybody could tell me how to start mysql-max to work with DB.
What i did : start mysqld like
./configure --prefix
=/usr/local/mysqlit starts like
Starting mysqld daemon with databases from
use it anymore??
DROP TABLE helps you :-)
http://www.mysql.com/doc/en/DROP_TABLE.html
WM - Original Message -
WM From: Victoria Reznichenko [EMAIL PROTECTED]
WM To: [EMAIL PROTECTED]
WM Sent: Tuesday, September 24, 2002 10:34 AM
WM Subject: re: Create Tables Dynamically
Hello All,
I am building a web robot in perl that will find equipment from various
manufacturers and will get information about that equipments specifications.
Can you build tables in MySQL 4.0 dynamically with some type of script.
Example. If if have 10 parts in my database and my robot
William,
Tuesday, September 24, 2002, 4:52:54 AM, you wrote:
WM I am building a web robot in perl that will find equipment from various
WM manufacturers and will get information about that equipments specifications.
WM Can you build tables in MySQL 4.0 dynamically with some type of script.
WM
since your are already using Perl, check out DBI at www.cpan.org
- hcir
On Monday, Sep 23, 2002, at 17:52 America/Anchorage, William Martell
wrote:
Hello All,
I am building a web robot in perl that will find equipment from various
manufacturers and will get information about that
Well, just that thing. I'm able to search, retrieve and update Mysql tables
(server located on a Linux Box) but I cannot create tables, nor modify its
structures. Does anyone knows why. Leonardo Belen. Afip AR
PS: I tried with the last stable release of Mysql and MyODBC from MYSQL.COM
At 6:11 + 6/29/02, toby - wrote:
thnx a million paul
got that :)
So ... why do you want to do this?
well i get really irretated of seein row# 66 right after 5
So basically, it's just a psychological thing on your part, right?
but seriously i dont know the + or - points of the types
hi guyz
i va all my tables myisam since its da default type
how can i make isam tables
1. will someone plz guide me with about the syntex
2. how can i change the type of my myisam tables to isam
:( without having to drop them
thnx a million
toby .
sql, query
At 5:29 + 6/29/02, toby - wrote:
hi guyz
i va all my tables myisam since its da default type
how can i make isam tables
Add
TYPE = ISAM
to the end of your CREATE TABLE statement.
1. will someone plz guide me with about the syntex
2. how can i change the type of my myisam
thnx a million paul
got that :)
So ... why do you want to do this?
well i get really irretated of seein row# 66 right after 5
but seriously i dont know the + or - points of the types
besides my project supervisor just declared v DONT NEED isam
since v dont NEED row 6 after 5 n not
hi guyz
im stuck bad
i cant create tables, the tables which had NO foreign keys or they didmt
refer to another table were created fine
but the ones WITH foreign key ... refferring to fieldz in other table(s)
cant be created
mysqlcreate table lang ( lang_id int auto_increment primary
toby,
Monday, June 24, 2002, 10:06:57 AM, you wrote:
t i cant create tables, the tables which had NO foreign keys or they didmt
t refer to another table were created fine
t but the ones WITH foreign key ... refferring to fieldz in other table(s)
t cant be created
t mysqlcreate table lang
Stefaan Contreras writes:
Heya,
I am quite new to all this intriguing stuff.
I use mysql-3.23.47-win with MySqlGUI 1.7.5
I see my mysql database, but cannot create tables in it.
Any ideas?
Kind regards,
Stefaan
Hi!
MySQLGUI does not have that feature.
You may use CREATE
- Original Message -
From: [EMAIL PROTECTED]
To: Stefaan Contreras [EMAIL PROTECTED]
Sent: Friday, March 15, 2002 5:58 PM
Subject: Re: cannot create Tables with MysqlGUI 1.7.5
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter
Heya,
I am quite new to all this intriguing stuff.
I use mysql-3.23.47-win with MySqlGUI 1.7.5
I see my mysql database, but cannot create tables in it.
Any ideas?
Kind regards,
Stefaan
___
http://www.vitamine-z.com/esse
]
- Original Message -
From: Alexander Shaw [EMAIL PROTECTED]
To: MySQL Win 32 List [EMAIL PROTECTED]
Sent: Monday, February 18, 2002 6:56 AM
Subject: Create Tables in MySQL Database from Access
Hi all,
Seem to be hitting another annoying problem and can't find an answer -
which
no doubt
the permission i tryed the artonic
administrator but i can't understand how to create clients ,could tell me how to
create tables and also there is an error some when i am starting mysqld-max-nt
--standalone --console at prompt saying InnoDB is error with my.cnf showing different
size
Please send
Hi Shekar,
-Original Message-
From: ChandraShekarReddy Talakola [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 09, 2001 6:50 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: How to Create Tables ... and Clients using winmysqladmin
Hi,
I am
Dear Sir,
The Create Table function is not working. Any steps that I need to
take besides creating a database first.
Yew Peng
Singapore
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
On 27 May 2001 18:10:11 +0800, Wong Yew Peng wrote:
Dear Sir,
The Create Table function is not working. Any steps that I need to
take besides creating a database first.
No. Give the error messages to get help.
--
MySQL Security Administrator
__ ___ ___ __
/ |/ /_ __/
32 matches
Mail list logo