Search In
Sometimes we need to export Schema without data means table structure only. We can do this easily by providing "--no-data" option in mysqldump command.
Command:
mysqldump -u root -p --no-data database_name > database.sql
Example:
mysq
Hello guys if you are looking to use where clause with multiple attribute in ZEND Framework. Please use the below code for the same::
$databaseObj = Zend_Db_Table::getDefaultAdapter();
$selectQuery = $this->select();
$selectQuery->from(array('
The MySql provides us with various for wide use for handling the database. The AVG() function is also one of the important function used in MySql. The AVG() is used to calculate the average value of the columns.
Syntax:
SELECT AVG(column-name) FR
Hello all, I am unable to access my SQL database as I forgot the login details. I have tried with some but getting error "ORA -12560: TNS : protocol adapter error."
Kindly suggest me the way to retrieve the details. Is there any command to
While working with ADO.NET ActivexDataObject we use datasources for retrieving ,updating,inserting and deleting data.
Oracle is most used database in the modern industry. In Ado.net to make connection we can have multiple options. For this p
Hello Readers. Here is small code to encode password before it is saved into database.
Add the following code in your Model file User.php
App::uses('BlowfishPasswordHasher', 'Controller/Component/Auth');
class User extends AppModel {
public
Records can be deleted in bulk by providing their ids to unlink().
For example code like below.
models.execute_kw(db, uid, password, 'res.partner', 'unlink', [[id]])
check if the deleted record is still in the database
models.execute_kw(db, uid, pas
Hi Friends,
Please help me with the error ,when I am opening my database(pg-admin) in window server 2008 R2 It is giving me below mentioned error.
Error connecting to the server:received invalid response to SSL Negotiation
Pre requisites-->you need to have the lamp server running on your ubuntu.
Downloading pakages
sudo sh -c "echo 'deb http://download.opensuse.org/repositories/isv:/ownCloud:/community/xUbuntu_12.04/ /' >> /etc/apt/sources.list.d/ownclou
We always use SqlConnection class for making connections
1 Simple SqlConnection
SqlConnection=new SqlConnection()
If any exception occurs inside while block it throws exception the connection.close() process will not executed due to the excep
