Tuesday, January 17, 2012

grant access to a ip for ur DB

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'


'localhost' will be replaced by user ip

put value on j table

jTable1.getModel().setValueAt(((String) jComboBox1.getItemAt(jComboBox1.getSelectedIndex())), 0, 0);

put value on j table

jTable1.getModel().setValueAt(((String) jComboBox1.getItemAt(jComboBox1.getSelectedIndex())), 0, 0);

sql count

SELECT COUNT(DISTINCT date) FROM `attendence` WHERE name='Sazzad' and date>'2012-01-01' and date<='2012-01-15'