Sometimes, we need to check when was the data last accessed. In MySQL, we had taken a field last_modified_time as timestamp datatype in a table, which was set to CURRENT_TIMESTAMP by DEFAULT. When a new record was inserted, it automatically [...]
While working in eclipse, we faced a problem in which Ctrl+click was not redirecting to the parent function or class. Solution: To solve this problem, we followed the below steps : 1. Exit Eclipse 2. Go to Workspace 3. Open [...]
To access Mysql database remotely a good way is to create a new Mysql user and grant it permissions to access database from remote, as explained below: You can create user with two ways From Mysql command prompt: 1. Open [...]
We have data as below: We need output like this: Solution: For SQL server STUFF function is the key here: SELECT Id,STUFF( ( SELECT distinct ' ' + cast(Name as varchar(500)) from table1 t2 where t1.Id = t2.Id FOR XML [...]
In one of the project we had to import some .csv files into Mysql database. Files were of size 80mb and more. When we tried to upload the files through phpmyadmin it was resulting in timeout error - Maximum execution [...]
While working with Joomla if you get an error - "Database Error: Unable to connect to the database:Could not connect to database”, check following properties in Joomla's configuration.php file : //given values are sample data only. var $dbtype = 'mysql'; [...]
Below are the Moodle database tables that will be used to fetch all the categories based on the programs assigned to a user (complete query is also written after table information): 1. mdl_prog : This table contains each program along [...]
If you forget mysql root password these are few easy steps to regain access: 1. shell> mysqld_safe --skip-grant-tables 2.Open another terminal shell> mysql -u root -p (hit enter and use blank password) 3. mysql>UPDATE mysql.user SET Password=PASSWORD('NewPassword')WHERE User='root'; 4. mysql>FLUSH [...]
Sometimes you need to fill a database table with thousands of test data records. You may also need to generate test data in the form of csv file to feed to a program. How can you generate such a large [...]
We were using insert_records() function to insert multiple records in a Moodle database table but it was not working. We checked for errors by adding following lines in config.php file of moodle: @error_reporting(E_ALL | E_STRICT); @ini_set('display_errors', '1'); $CFG->debug = (E_ALL [...]
In one case we noticed that SQL Server (SQL Server 2014) service was scheduled to start Automatically on system boot but still it was not starting up. It did not even start when we manually tried to start the service. [...]
We had a table in our database having dot in the table name as below: Table name - kpc.product_categories On trying to delete kpc.product_categories using below command: drop table kpc.product_categories It used to give error that no such table exists. [...]
Following are the steps to delete the Postgres database backup: 1. Login into heroku. 2. Click on the database>PG Backups. Here you can see all the PG backups list. 3. . For deleting the database, first of all you have [...]
This is a simple idea to reduce API calls consumption when you pull data from Zoho CRM into an integrated piece of code (like server side code in PHP or Java that connects to Zoho CRM to retrieve records). In [...]
To see the database backup retained limit see the steps followed below: 1. Login into heroku. 2.Now click the database you are using. As you can see in the below screenshot database name is Heroku Postgres - Charcoal and it [...]
Problem Recently in a website we were developing in Codeigniter PHP Framework, some of the urls stopped working and started throwing 500 internal server error. On investigation we found a MySQL query which was causing the problem .Query is simple [...]
In previous 2 posts in this series we covered benefits of having a website for your business and difference between Responsive and Non-Responsive website. We also shared some stats on how small business presence on Internet is going up. In [...]
Inside $tomcat_home/conf/context.xml add this inside <Context> <Resource name=”jdbc/datasourcename” auth=”Container” type=”javax.sql.DataSource” maxActive=”100″ maxIdle=”30″ maxWait=”1000″ username=”dbuser” password=”dbpwd” driverClassName=”com.mysql.jdbc.Driver” url=”jdbc:mysql://localhost:3306/exodus”/> Now restart tomcat Inside you web.xml add this before </web-app>: <resource-ref> <description>My DB Connection</description> <res-ref-name>jdbc/datasourcename</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> Java code to connect: Context [...]
That’s the error you get for oracle user for whom password is expired. One Solution – Connect using sqlplus to set new password, you can even use the same password you had earlier. $ sqlplus SQL*Plus: Release 11.2.0.1.0 Production on [...]