What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-11-19 16:32:22
mysql query return excel file
#Before exectue query in sql run following command: sudo chmod 755 -R /var/lib/mysql/ #run query in mysql SELECT ... FROM ... WHERE ... INTO OUTFILE 'file.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'; #Then Ope... Add solution -
SQL 2021-10-14 18:53:10
version and edition of SQL Server Database Engine
--version and edition of SQL Server Database Engine is running --Step: Connect to the instance of SQL Server, and then run the following query in SQL Server Management Studio (SSMS): SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'... Add solution
Best helpers
Ranking is empty