Duplicate column when creating table from table join

2008-11-05 Thread mos
I'm trying to create a table from a table join. Since each table has a similar column name. it won't allow me to create the table. create table tx1 (name1 char(10), employee_code char(1)) engine=myisam; create table tx2 (name1 char(10), addr char(10)) engine=myisam; create table tx12 select * f

Re: failed-mysql-bugreport

2008-11-05 Thread Joerg Bruehe
Hi ! Bob wrote: > mysql.sock doesn't exist on the hard drive. > > [[...]] > > kenny# ./mysqladmin create databasename > /mysqladmin: connect to server at 'localhost' failed > error: 'Can't connect to local MySQL server through socket '/tmp/mysql. > sock' (2)' > Check that mysqld is running and t

Re: failed-mysql-bugreport

2008-11-05 Thread Gerald L. Clark
Bob wrote: mysql.sock doesn't exist on the hard drive. Start the server. -- Gerald L. Clark Sr. V.P. Development Supplier Systems Corporation Unix since 1982 Linux since 1992 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysq

failed-mysql-bugreport

2008-11-05 Thread Bob
mysql.sock doesn't exist on the hard drive. >Originator:Charlie & >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: <[ non-critical | serious | critical ] (one line)> >Priority: <[ low | medium | high ] (one li

Re: Error: "Got error 139 from storage engine"

2008-11-05 Thread Thomas Spahni
On Tue, 4 Nov 2008, Jesse wrote: > > prompt> perror 139 > > MySQL error code 139: Too big row > > > > Seems you are exceeding some limit. > > Where did you run the "perror" command from? I tried to run that in the > MySQL command line utility and got an error? > > At any rate, the field in que