Simple MySql question

[spr1nt]

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?

[Guest]

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.

 

-jared