Wednesday, January 24, 2018

start support system for your comapny with email support

tickets are the new trends in support systems, because of its simplicity and tracable nature tickets are nothing but support /queries raised aganist services of a firm to its concerned departments osTicket is...

ASP MSSQL Connection

While using asp my convention is to make a connection function inside asp block and to include it on all ASP Files Sub OpenDatabase(ByRef dbConn)    Set dbConn = Server.CreateObject("ADODB.Connection") dbConn.ConnectionTimeout = 150 dbConn.CommandTimeout =...

find number of days in a month from ms sql server

to find no of days in a month in sql apply a simple logic take difference in number of days to the next months date with day that of current date for this...

Change Default User for

Syntax: Alter user <user> with default_schema =  <schema  name> Eg. alter user study with default_schema=study

My SQL backup From Linux Console

To schedule a mysql database backup it is necessary to take the back up from Console with out prompting pasword, to call crom scheduler crontab Use the following to backup to sql script ]#...

Change MySQL Admin password

# mysqladmin -u root password 123456 # mysqladmin -u root password 123456 mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' # mysqladmin -u root -p'123456' password 123456 # When...

Backing Up MySQL Database

Do you need to change your web host or switch your database server? This is probably the only time when you really think of backing up your MySQL data. If you've got a...

PHP MYSQL CONNECT

<?php $con = mysql_connect("localhost","peter","abc123"); if (!$con) { die('Could not connect: ' . mysql_error()); } // some code ?>

More