Default values in a column of a MySQL Table
here is a query to define the default value of a column. create table test(username varchar(20) not null default ”) […]
mysql, sql
sql
mysql, sql
primary and foreign key in MySQL
I am very bad at quering. I was playing with mysql yesterday and find it is very easy to create […]
mssql, sql
Specify a Maximum Cost for a Query in SQL Server 7
Ever had a user accidentally create a query that resulted in aCartesian product of your two largest tables? Of course, […]
jdbc, ms-access
How to access MS Access database from JDBC?
btw, I dint test it. I just post it for my reference. thanks Angsuman Chakraborty. How to access MS Access […]
mssql, sql
Determining Table sizes in MS-SQL
Hi, I was searching for a query that will give me the size of the table in MS-SQL, here it […]