Programmer Coding Helper

Check Leap Year in mysql

2009-07-03T13:27:00.001+05:30

DELIMITER $$

DROP FUNCTION IF EXISTS `isLeapYear` $$
CREATE DEFINER=`root`@`192.168.10.116` FUNCTION `isLeapYear`(_year varchar(10)) RETURNS varchar(10) CHARSET latin1
BEGIN

declare tt varchar(10);

set tt = if(((_year % 4 = 0) AND ( (_year% 100 != 0) OR (_year % 400 = 0)))=1,'true','false');
return tt;

END $$

DELIMITER ;

Writing Registy Using VB.NET

2009-05-28T08:00:00.002+05:30

'function for read registry values

Public Function writeRegistryValue(ByVal reg_key As String, ByVal val As String) As Boolean
Dim regKey As RegistryKey
Dim i As Boolean
Try
regKey = Registry.CurrentUser.OpenSubKey("Software\adsdf\asdf", True)
regKey.SetValue(reg_key, val)
regKey.Close()
i = True
Catch ex As Exception
i = False
regKey.Close()
End Try
Return i
End Function

This function is for writing windos regsitry using vb.net

Here reg_key is the registry key and val is value of that key

Export MySQL Data to Comma Seperated File

2009-05-19T09:00:00.005+05:30

SELECT `doc_no`,`column1`,` column2`,` column3`

INTO OUTFILE 'C:\\result.txt'

FIELDS TERMINATED BY ','

OPTIONALLY ENCLOSED BY '"'

LINES TERMINATED BY '\n'

FROM table_name;

Here

`doc_no`,`column1`,` column2`,` column3` are the column name which you want to export

'C:\\result.txt' is the exported csv file name.

table_name is the table which you want export in to csv

imports comma seperated file (csv) to mysql database

2009-05-19T08:36:00.006+05:30

below show the simple query you want

LOAD DATA LOCAL INFILE 'C:\\test.csv'
INTO TABLE testing
FIELDS TERMINATED BY ','
ENCLOSED BY '"' LINES
TERMINATED BY '\\n';

Here

C:\\test.csv is the csv file path that you want to import in to mysql database

testing is the table that imported data hold in

\\n is the line end char of the csv file this may change \\r\\n , etc ...

by default mysql allow to import less than 1MB file for import into mysql,but if you want large file imports into mysql then you should do some changes.This happen because it by default mysql has Max packet size = 1MB

using mysql-administrator GUI you can easily change this value
In mysql-administrator GUI --> startup varables --> Advanced Networking tab --> data/memory size group box --> Max packet size = "your_value"

http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html