Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Simple MySql question


Recommended Posts

i need to enter these queries into my database:


INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Display Product Description', 'PRODUCT_LIST_DESCRIPTION', '99', 'Set to 0 to disable, set to 99 to enable.', '8', '11', '', '', NULL, NULL);


can i put that into notepad and save it as a file.sql file then type


mysql -u username -p password databasename < file.sql


to import it into my database?

Link to comment
Share on other sites

Yup. That syntax looks right, assuming you're inserting into a database that's running on the same server as your file. If you're doing it from a remote server (IOW you have a dedicated database server which is separate from the one you're currently logged into), you'll need to add the host parameters to that command.


Alternately, you can insert it using phpMyAdmin, MySQLCC or something like that.



Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...