List:MySQL on Win32« Previous MessageNext Message »
From:jed Date:January 9 2001 2:28pm
Subject:Re: SQL...
View as plain text  
No, it's OK so....

I create quite new table,
it means it's all the same how it is called....

regards
jed


Stephen Woodbridge wrote:

> jed,
>
> Is this a typo in the email or a typo in your commands:
> > mysql> create table tst2 select * from test1.test;
>                       ^^^^
>                       test2
> -Steve
>
> jed wrote:
> >
> > Hi @,
> > and now my messages:
> >
> > mysql>
> > mysql>
> > mysql> create database test1;
> > Query OK, 1 row affected (0.00 sec)
> >
> > mysql> create database test2;
> > Query OK, 1 row affected (0.00 sec)
> >
> > mysql> use test1;
> > Database changed
> > mysql> create table test (txt varchar(20));
> > Query OK, 0 rows affected (0.00 sec)
> >
> > mysql> insert into test values('Line1'),('Line2'),('Line3');
> > Query OK, 3 rows affected (0.00 sec)
> > Records: 3  Duplicates: 0  Warnings: 0
> >
> > mysql> use test2;
> > Database changed
> > mysql> create table tst2 select * from test1.test;
> > ERROR 1064: You have an error in your SQL syntax near 'select * from
> > test1.test' at line 1
> > mysql>
> > mysql>
> >
> > .............
> > So, I suppose, that I have a version problem..
> >
> > I use at the time:
> > kj@jed:~ > mysqladmin --version
> > mysqladmin  Ver 8.0 Distrib 3.22.32, for pc-linux-gnu on i686
> > kj@jed:~ >
> >
> > Is it too old for this feature...?
> >
> > regards
> > jed
> >
> > Luc Van der Veken wrote:
> >
> > > > From: Frank M. Betz, Jr. [mailto:fbetz@stripped]
> > > > Sent: Monday 08 January 2001 6:11
> > > >
> > > > if that works that's unbelievable.  I always thought you
> > > > could only move
> > > > data from table to table from the same database not from two
> > > > different ones.
> > > > How do you establish a connection to two at the same time
> > > > through straight
> > > > SQL?
> > >
> > > You have a connection to a server, not to a database, and a server can
> carry
> > > more than one database (in fact, most of them should: your own database(s)
> > > and its own MySQL database with info about databases, tables and users).
> > >
> > > I find it unbelievable that in this whole thread, nobody actually tried it
> > > after that first message ;-)
> > >
> > > mysql> create database test1;
> > > Query OK, 1 row affected (0.00 sec)
> > >
> > > mysql> create database test2;
> > > Query OK, 1 row affected (0.00 sec)
> > >
> > > mysql> use test1;
> > > Database changed
> > > mysql> create table test (txt varchar(20));
> > > Query OK, 0 rows affected (0.02 sec)
> > >
> > > mysql> insert into test values('Line1'),('Line2'),('Line3');
> > > Query OK, 3 rows affected (0.00 sec)
> > > Records: 3  Duplicates: 0  Warnings: 0
> > >
> > > mysql> use test2;
> > > Database changed
> > > mysql> create table tst2 select * from test1.test;
> > > Query OK, 3 rows affected (0.00 sec)
> > > Records: 3  Duplicates: 0  Warnings: 0
> > >
> > > mysql> select * from test1.test;
> > > +-------+
> > > | txt   |
> > > +-------+
> > > | Line1 |
> > > | Line2 |
> > > | Line3 |
> > > +-------+
> > > 3 rows in set (0.00 sec)
> > >
> > > mysql> select * from test2.tst2;
> > > +-------+
> > > | txt   |
> > > +-------+
> > > | Line1 |
> > > | Line2 |
> > > | Line3 |
> > > +-------+
> > > 3 rows in set (0.00 sec)
> > >
> > > And it works equally well through ADO/ODBC.
> > > I just put this in an empty form in VB (note that test1 and test2 still
> > > existed from the previous example, so the first thing I do is kill them
> ;-)
> > >
> > > Private Sub Form_Load()
> > > Dim cn As New ADODB.Connection
> > > Dim rs As ADODB.Recordset
> > > cn.Open "Driver=MySQL;Server=<my server>", "root", <my
> password>
> > > cn.Execute "DROP DATABASE Test1;"
> > > cn.Execute "DROP DATABASE Test2;"
> > > cn.Execute "CREATE DATABASE Test1;"
> > > cn.Execute "CREATE DATABASE Test2;"
> > > cn.Execute "USE Test1;"
> > > cn.Execute "CREATE TABLE Tst1 (Txt varchar(20));"
> > > cn.Execute "INSERT INTO Tst1 VALUES ('Line1'),('Line2');"
> > > cn.Execute "USE Test2;"
> > > cn.Execute "CREATE TABLE Tst2 SELECT * FROM Test1.Tst1;"
> > > Set rs = cn.Execute("SELECT * FROM Tst2;")
> > > Do While Not rs.EOF
> > >     Debug.Print rs!Txt
> > >     rs.MoveNext
> > > Loop
> > > rs.Close
> > > Set rs = cn.Execute("SELECT * FROM Test1.Tst1;")
> > > Do While Not rs.EOF
> > >     Debug.Print rs!Txt
> > >     rs.MoveNext
> > > Loop
> > > rs.Close
> > > cn.Close
> > > End Sub
> > >
> > > ---------------------------------------------------------------------
> > > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> > > posting. To request this thread, e-mail win32-thread4742@stripped
> > >
> > > To unsubscribe, send a message to the address shown in the
> > > List-Unsubscribe header of this message. If you cannot see it,
> > > e-mail win32-unsubscribe@stripped instead.
> >
> > ---------------------------------------------------------------------
> > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> > posting. To request this thread, e-mail win32-thread4744@stripped
> >
> > To unsubscribe, send a message to the address shown in the
> > List-Unsubscribe header of this message. If you cannot see it,
> > e-mail win32-unsubscribe@stripped instead.

Thread
Danger! Will Robinson - NewbieSteve Mills7 Jan
  • Re: Danger! Will Robinson - NewbieJohn Dean7 Jan
    • SQL...jed7 Jan
RE: SQL...Rasmus Nyström7 Jan
  • Re: SQL...Jr. Frank M. Betz8 Jan
    • Re: SQL...Paul DuBois8 Jan
      • Re: SQL...Nick Tentomas8 Jan
        • Re: SQL...Paul DuBois8 Jan
    • RE: SQL...Luc Van der Veken9 Jan
      • Re: SQL...jed9 Jan
        • Re: SQL...Paul DuBois9 Jan
      • Re: SQL...Stephen Woodbridge9 Jan
        • RE: SQL...Luc Van der Veken10 Jan
          • Re: SQL...jed10 Jan
      • Re: SQL...jed9 Jan
      • RE: SQL...Paul DuBois9 Jan
      • Re: SQL...jed9 Jan
  • Re: SQL...jed8 Jan
  • Re: SQL...jed8 Jan
    • Re: SQL...Tim Endres8 Jan
      • Re: SQL...Paul DuBois9 Jan
    • Re: SQL...Paul DuBois9 Jan