Member Avatar for indr

hi,

i am getting a "no database selected error" when i give the following command..

mysql>source company_data.sql
ERROR 1046 (3D000):No database selected

pls help me out with this error!!

  • 2 Contributors
  • 1 Reply
  • 114 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by d5e5
Member Avatar for d5e5

You must select the database that contains the objects to which the rest of the SQL statements refer. For example, if the statements in your company_data.sql refer to objects in a database called 'db1' you need to either run the following statement

USE db1;

before running source from the company_data.sql or else add that statement to the beginning of your company_data.sql file.
http://dev.mysql.com/doc/refman/5.0/en/use.html

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.