Hi
How do I create a table inside a perl script using a hash to give table name
and mysql statements?
thanks.
--
View this message in context:
http://www.nabble.com/CREATING-A-table-using-a-hash-in-perl-tp15353263p15353263.html
Sent from the MySQL - General mailing list archive at Nabble.com
I'm trying to install ProBIND, and I'm running mysql 4.1.20.
One of the ProBIND install scripts calls for tables to be created in MySQL, and
I've culled it down to this:
mysql CREATE TABLE zones (
- id INT(11) DEFAULT '1' NOT NULL AUTO_INCREMENT,
- PRIMARY KEY (id)
-
It makes no sense to use a default value with an auto_increment
attribute, which means, the default value is the auto-incremented value.
Carlos
Al Sparks wrote:
I'm trying to install ProBIND, and I'm running mysql 4.1.20.
One of the ProBIND install scripts calls for tables to be created
It makes no sense to use a default value with an auto_increment
attribute, which means, the default value is the auto-incremented
value.
Carlos
Hmmm... I see your point. I sort of figured that the default was an
initial value, and from there, it incremented when accessed.
Sort of weird
]
To: mysql@lists.mysql.com
Sent: Tuesday, October 24, 2006 12:47 AM
Subject: Creating new table from distinct entries
MySQL 4.1.21-community-nt
I have a table in my database that has a Primary key on 2 fields (MyID
and MyChange) and a field that indicates if there is a problem with the
record
MySQL 4.1.21-community-nt
I have a table in my database that has a Primary key on 2 fields (MyID
and MyChange) and a field that indicates if there is a problem with the
record (MyError)- I want to create a new table that only has unique
MyIDs and where there is more than 1 I only want the
Rhino wrote:
- Original Message -
From: Ed mailto:[EMAIL PROTECTED]
To: mysql@lists.mysql.com mailto:mysql@lists.mysql.com
Sent: Tuesday, October 25, 2005 6:40 PM
Subject: Problem with syntax 4 creating 1 table
Shawn green was very kindly helping me ouy trying
Shawn green was very kindly helping me ouy trying to make mysql tables
and I thought I had go the hang of it until I get this error-any ideas? Thanks a
lot
CREATE TABLE PurchasedProducts(
`int_saleCart` INT AUTO_INCREMENT NOT NULL ,`int_ClientID` INT,`int_ProductID` INT,`int_Quantity`
Ed wrote:
Shawn green was very kindly helping me ouy trying to make mysql tables
and I thought I had got the hang of it until I get this error-any ideas?
Thanks a lot
CREATE TABLE PurchasedProducts(
`int_saleCart` INT AUTO_INCREMENT NOT NULL ,
`int_ClientID` INT,
`int_ProductID` INT,
- Original Message -
From:
Ed
To: mysql@lists.mysql.com
Sent: Tuesday, October 25, 2005 6:40
PM
Subject: Problem with syntax 4 creating 1
table
Shawn green was very kindly helping me ouy trying to make mysql tables
and I thought I had go the hang
Is there a way I can create a table on MySQL using Access and
establish a link remotely?
--
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Scott Hamm [EMAIL PROTECTED] wrote on 10/18/2005 09:46:20 AM:
Is there a way I can create a table on MySQL using Access and
establish a link remotely?
--
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html
You can write some
]
Sent: Tuesday, October 18, 2005 9:46 AM
To: 'Mysql '
Subject: Creating a table on MySQL from Access
Is there a way I can create a table on MySQL using Access and establish
a link remotely?
--
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word
[snip]
How can I list the rows and columns.
[/snip]
http://dev.mysql.com/doc/mysql/en/SELECT.html
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Gerald Preston [EMAIL PROTECTED] wrote on 01/07/2005 01:02:04 AM:
Hi!
Running mysql on a XP command line. Doing dhow databases list the
following;
Database
Club
Mysql
Test
I did a grant all user id;
How can I list the rows and columns.
One of these may help: SHOW CREATE TABLE
Hi!
Running mysql on a XP command line. Doing dhow databases list the
following;
Database
Club
Mysql
Test
I did a grant all user id;
How can I list the rows and columns.
I tried alter table club add ME varchar( 3)); and get :
You have an error in your SQL syntax; check
We are currently doing an audit of the software installed on all our
systems, in an effort to remove as much junk (adware, etc) from the
computers as possible.
To help give the management staff of the company a good overview of
where problems may be, my boss would like an Excel-style summary so
%; but every so often it
jumps to almost 100% and remains there for some time. My site slows to a
crawl. When I check SHOW PROCESSLIST I see a large number of processes in
'Locked' status, and one as 'Creating tmp table'. When I manually kill this
process, the server returns to normal.
I turned on slow
Excuse my naivety but how do I create a Table in MySQL?
I cant find any Text/Windows based programme that allows be to create and
edit the table, fields, data types, size etc?
Im not looking for anything complex.
Many thanks,
Ed
Edward Hasted
Contact Information:
E-mail : [EMAIL PROTECTED]
I would suggest myCC -- http://www.mysql.com/downloads/mysqlcc.html
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 6:45 AM
To: [EMAIL PROTECTED]
Subject: Creating a Table (wot no GUI?)
Excuse my
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 6:45 AM
To: [EMAIL PROTECTED]
Subject: Creating a Table (wot no GUI?)
Excuse my naivety but how do I create a Table in
MySQL?
I can't find any Text/Windows based programme that
allows
Becoming Digital
www.becomingdigital.com
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, 28 May, 2003 08:45
Subject: Creating a Table (wot no GUI?)
Excuse my naivety but how do I create a Table in MySQL?
I can't find any Text/Windows based programme
the username, apssword and database in the top 3 lines, saged
the script into a file called create_table.php and gave it permissions of
777 to be safe.
What have I missed as its not creating the table.
Scott
-
Before posting
Hello
I meet a strange problem:
when I create a new table, the mysql cleint loose connection with the server.
Synopsis:
$ mysqladmin -u mysql -px create temp
(no problem reported, /var/lib/mysql got a new directory 'temp')
$ mysql -u mysql -px temp
mysql create table oups ( id
Hello:
Am using Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
on RH 7.2.
I would like to construct a mysql command that select a unique
set of data from one table and creates a table with that
data.
I think I'm close here, but am still getting errors:
The query string
Hello Again:
I'm not usually this lucky, but it seems that the trick is
to let mysql do more of the work, and I'm happy to go
along with that:
What I needed is
CREATE TABLE EurCount SELECT DISTINCT Country FROM EUR;
(with EurCount being nonexistant)
I would
Hi Tim,
On Fri, 2002-05-10 at 11:53, Tim Johnson wrote:
I'm not usually this lucky, but it seems that the trick is
to let mysql do more of the work, and I'm happy to go
along with that:
What I needed is
CREATE TABLE EurCount SELECT DISTINCT Country FROM EUR;
Hello,
Today, I compiled MySQL (mysql-3.23.49.tar.gz) on a Debian Potato system. I
configure'd with following options:
./configure --prefix=/usr/local/mysql --with-innodb
make and make install ran without any problems. Then I followed the
instructions in the INSTALL-SOURCE file. Everything
in 3.23.50.
Best regards,
Heikki
Innobase Oy
-Original Message-
From: Borislav Bankov TEEC [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Date: Friday, March 01, 2002 5:32 PM
Subject: Error creating InnoDB table/MySQL parser bug?
Hello,
Today, I compiled MySQL (mysql-3.23.49.tar.gz
Oladejo,
Tuesday, February 12, 2002, 9:29:29 PM, you wrote:
Oeoen Hi All,
Oeoen I am trying to create a mysql table with one of the column to be for
Oeoen .gif/jpeg, is there a variable type for gif/jpeg and after creating the
Oeoen table, how do I insert the gif file on each record line
Hi All,
I am trying to create a mysql table with one of the column to be for
.gif/jpeg, is there a variable type for gif/jpeg and after creating the
table, how do I insert the gif file on each record line.
Toks
I do it all the time, just go
primary key c (a,b)
A. Clausen [EMAIL PROTECTED]
- Original Message -
From: sherzodR [EMAIL PROTECTED]
To: Demirchyan Oganes-AOD098 [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, December 06, 2001 11:58
Subject: Re: Creating
-
From: sherzodR [EMAIL PROTECTED]
To: Demirchyan Oganes-AOD098 [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, December 06, 2001 11:58
Subject: Re: Creating MySQL table w/2 primary keys
As far as I know, you can't do tht. What you could do instead is
have one Primary Key
06, 2001 1:54 PM
To: '[EMAIL PROTECTED]'
Subject: Creating MySQL table w/2 primary keys
Hello everyone,
I have this create table statement,
drop table IF EXISTS GROUP_CONCLUSION_GROUPING CASCADE;
CREATE TABLE IF NOT EXISTS GROUP_CONCLUSION_GROUPING(
ANALYSIS_RESULT_ID MEDIUMINT(20) PRIMARY
Hello everyone,
I have this create table statement,
drop table IF EXISTS GROUP_CONCLUSION_GROUPING CASCADE;
CREATE TABLE IF NOT EXISTS GROUP_CONCLUSION_GROUPING(
ANALYSIS_RESULT_ID MEDIUMINT(20) PRIMARY KEY REFERENCES
PAD_ANALYSIS_RESULT(ANALYSIS_RESULT_ID),
GROUP_CONCLUSION_ID
As far as I know, you can't do tht. What you could do instead is
have one Primary Key col and make another one UNIQUE.
I did that several times, and it does work!
--
What they need to teach in school is for people to think for themselves. :-)
-- Larry Wall in [EMAIL PROTECTED]
why not use a concatenated Primary key?
create table tname
col_name1 int,
col_name2 int,
PRIMARY KEY (col_name1,col_name2)
you get the drift
On Thu, 6 Dec 2001, sherzodR wrote:
As far as I know, you can't do tht. What you could do instead is
have one Primary Key col and make
On 6 Dec 2001 [EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
database,sql,query,table
If you just reply to this message, and
using primary key (col1, col2) makes no index on col2... which is not
good if you lookup only in col2
primary key (col1),
unique index (col2)
don't forget to add not null beside your col2 definition.
Etienne
rc wrote:
why not use a concatenated Primary key?
create table tname
I found a way to have two primary key, if those keys relate on many
columns.
mysql create table keytest(
- col1 int not null,
- col2 int not null,
- unique index (id1,id2),
- unique index (id2,id1)
Query OK, 0 rows affected (0.01 sec)
mysql describe keytest;
for a table in a database (just so my message makes it to the list):
can you make a concatenated primary key, then make the second one an
index?
-
Before posting, please check:
http://www.mysql.com/manual.php (the
December 2001 9:42 a.m.
To: sherzodR
Cc: Demirchyan Oganes-AOD098; '[EMAIL PROTECTED]'
Subject: Re: Creating MySQL table w/2 primary keys
I found a way to have two primary key, if those keys relate on many
columns.
mysql create table keytest(
- col1 int not null,
- col2 int not null
42 matches
Mail list logo