User Profile

Collapse

Profile Sidebar

Collapse
John McCulloch
John McCulloch
Last Activity: Oct 30 '11, 12:50 AM
Joined: Oct 18 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • John McCulloch
    replied to MySQL 5.5 execution of sql file using "source"
    in MySQL
    Thanks for the reply!

    I tried \. c:/john/mysql-start.sql , and i get "error 1046 <3D000>: No database selected". Here are the contents of the mysql-start.sql file:
    drop table if exists T;
    create table T (A text, B text);
    insert into T values ('Hello,', 'world!');
    select * from T;

    Thanks again! Any ideas?

    John M
    See more | Go to post

      Leave a comment:

    • John McCulloch
      started a topic MySQL 5.5 execution of sql file using "source"
      in MySQL

      MySQL 5.5 execution of sql file using "source"

      Greetings,

      I'm trying to execute a sql file in the command line for sql 5.5 on a windows 7 computer. My sql file is on my c drive in the directory "john". My sql file is named mysql-start.sql. How do I execute the source command to run this sql file? This is something I am learning from a free online database class from Stanford. Here is how the class suggests I do this:

      To try executing a SQL file from the...
      See more | Go to post
      No activity results to display
      Show More
      Working...