CREATING A table using a hash in perl

2008-02-08 Thread POLIVEIRA
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

Re: Creating a Table With a Default

2007-03-28 Thread Al Sparks
> 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 weir

Re: Creating a Table With a Default

2007-03-28 Thread Carlos Proal
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 in

Creating a Table With a Default

2007-03-28 Thread Al Sparks
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)

RE: Creating a table on MySQL from Access

2005-10-18 Thread Mikhail Berman
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-attachments.html -- MySQL Gen

Re: Creating a table on MySQL from Access

2005-10-18 Thread SGreen
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

Creating a table on MySQL from Access

2005-10-18 Thread Scott Hamm
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 unsubscrib

Creating a table

2004-01-22 Thread Timothy Donahue
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

Re: Creating a Table (wot no GUI?)

2003-05-29 Thread Becoming Digital
ard Dudlik 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 T

RE: Creating a Table (wot no GUI?)

2003-05-29 Thread Karam Chand
illyer > 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 naivety but how do I create

RE: Creating a Table (wot no GUI?)

2003-05-29 Thread Mike Hillyer
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?) Exc

Creating a Table (wot no GUI?)

2003-05-28 Thread edward
Excuse my naivety but how do I create a Table in MySQL? I can’t find any Text/Windows based programme that allows be to create and edit the table, fields, data types, size etc? I’m not looking for anything complex. Many thanks, Ed Edward Hasted Contact Information: E-mail : [EMAIL PROTECTED] T

Creating a table in mysql via a php script

2003-02-08 Thread Scott
Ok, trying to create a table in a mysql database via php script. heres the code:- I have added 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 tab

loosing connection to server when creating a table!

2002-10-18 Thread Mickael Bailly
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

Re: Creating a table from a query/How to?.....

2002-05-09 Thread Arjen Lentz
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; >

Re: Creating a table from a query/How to?.....

2002-05-09 Thread Tim Johnson
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 appr

Creating a table from a query/How to?

2002-05-09 Thread Tim Johnson
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 i

Creating a table with gif column

2002-02-13 Thread Victoria Reznichenko
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 li

Creating a table with gif column

2002-02-12 Thread Oladejo, Tokunboh
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 ---