Monthly Archives: October 2009

How To Export and Import data from csv into Mysql

Posted on October 26, 2009 by

How To Export and Import of csv data out of and into MySQL This method works for the MySQL 5  and not sure about other versions. Exporting the MySQL data into a comma delimited (.csv) file SELECT * INTO OUTFILE ‘ /data.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\n’ FROM table1; This will dump your table into a file with each row from the database being on it’s own line, columns separated by commas, and … More ->

Leave a comment

Ping not recognized as internal or external command

Posted on October 22, 2009 by

How to fix the error “Ping not recognized as internal or external command”? Solution : Right click on My computer Go to Properties Click on the advance tab. click on Environment Variables Scroll to Path but if there is none please just create a new one and write Path under variable name and paste this: %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem under variable value and click on ok. Otherwise Select Path and click on Edit and paste the same. It should fix the issue.

Leave a comment

MS SQL Server 2000 authentication modes

Posted on October 6, 2009 by

With Microsoft SQL Database Server 2000 you can choose either of the two security (authentication) modes, namely: NT security mode (Windows NT Authentication only), Mixed mode (Windows NT Authentication and SQL Server Authentication). NT security mode (Windows NT Authentication only): It is related to windows domain. Access will be given to existing domain user account.Using those credentials, user can access the database.Separate account is not created as in other databases. Mixed mode (Windows NT Authentication and SQL Server Authentication) In … More ->

Leave a comment