Tutorial by Examples: database

Pre-requisites: cx_Oracle package - See here for all versions Oracle instant client - For Windows x64, Linux x64 Setup: Install the cx_Oracle package as: sudo rpm -i <YOUR_PACKAGE_FILENAME> Extract the Oracle instant client and set environment variables as: ORACLE_HOME=&...
To easily convert all tables in one database, use the following: SET @DB_NAME = DATABASE(); SELECT CONCAT('ALTER TABLE `', table_name, '` ENGINE=InnoDB;') AS sql_statements FROM information_schema.tables WHERE table_schema = @DB_NAME AND `ENGINE` = 'MyISAM' AND `TABLE_TYPE` = '...
In the .bashrc or .bash_profile, adding: export MYSQL_PS1="\u@\h [\d]>" make the MySQL client PROMPT show current user@host [database].
SELECT DISTINCT o.name AS Object_Name,o.type_desc FROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_id=o.object_id WHERE m.definition Like '%myField%' ORDER BY 2,1 Will find mentions of myField in SProcs, Views, etc.
Assume having a method returning IEnumerable<T>, f.e. private IEnumerable<T> GetData() { try { // return results from database } catch(Exception exception) { throw; } } Creates an Observable and starts a method asynchronously. Sel...
<?php //Create a new SQLite3 object from a database file on the server. $database = new SQLite3('mysqlitedb.db'); //Query the database with SQL $results = $database->query('SELECT bar FROM foo'); //Iterate through all of the results, var_dumping them onto the page while ($row = $resu...
Many databases can be used in Weka. Firstly, the DatabaseUtils.props file must be edited to match your database; specifically you must provide your database's name, location, port and correct driver. jdbcDriver=org.gjt.mm.mysql.Driver jdbcURL=jdbc:mysql://localhost:3306/my_database Then the dat...
CREATE DATABASE SAMPLEDB; This will create a new database called sampledb.
CONNECT TO SAMPLEDB; From the command line (db2clp, terminal, db2cmd) you can write: db2 CONNECT TO SAMPLEDB
Complete the Installation and setup to connect your app to Firebase. This will create the project in Firebase. Add the dependency for Firebase Realtime Database to your module-level build.gradle file: compile 'com.google.firebase:firebase-database:9.2.1' Configure Firebase Databa...
Steps to reset database in Heroku: 1. Drop the database, when SHARED_DATABASE_URL is used: heroku pg:reset DATABASE 2. Recreate the database with nothing in it: heroku run rake db:migrate 3. Populate the database with your seed data: heroku run rake db:seed Steps 2 and 3 can be combined...
Note: Let's setup some anonymous authentication for the example { "rules": { ".read": "auth != null", ".write": "auth != null" } } Once it is done, create a child by editing your database address. For example: https://your-proje...
This example assumes that you have already set up a Firebase Realtime Database. If you are a starter, then please inform yourself here on how to add Firebase to your Android project. First, add the dependency of the Firebase Database to the app level build.gradle file: compile 'com.google.firebase...
How to implement Firebase Real-Time database in Android applications. Setup/Installation: First, install the Firebase SDK (guide) Register your project using the Firebase console After successfuly completing the two steps above, add the following dependency in your application level ...
Achieving multitenancy on database server with multiple databases hosted on it. Multitenancy is common requirement of enterprise application nowadays and creating connection pool for each database in database server is not recommended. so, what we can do instead is create connection pool with datab...
show dbs or db.adminCommand('listDatabases') or db.getMongo().getDBNames()
show collections or show tables or db.getCollectionNames()
Given you have a valid CouchDbInstance instance, you connect to a database within CouchDB in the following manner CouchDbConnector connector = dbInstance.createConnector("databaseName", true);
System Requirements: Node JS Getting Started First Go to Firebase Console and Create New Project. After Creating the project, in project click on settings icon besides project Name in left sidebar and select Permissions. On Permissions Page Click on Service accounts in left sidebar then c...

Page 6 of 10