Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

How to subtract two column of different table using sql query

I Have 2 tables WIthdrawMaterial and DepositMaterial,Both In WithdrawMaterial contain quantity column, and DepositMaterial contain totalDeposit ,I want to perform subtraction between quantity and totalDeposit column using query and store the resu...

How to solve ArrayIndexOutOfBoundsException in Java?

I want to insert a csv data into a MySQL table. When I run the code, I've got the following error message. Any suggestions? java.lang.ArrayIndexOutOfBoundsException: Index 3 out of bounds for length 3     at BudgetTrackerCu...

How to Use Calculation of an Aggregate Function as Filter Criteria?

I have tables on booking orders for trips. Bookings (booking_id, booking_time, driver_id, customer_id) Drivers (driver_id, name) I need to identify all customers who have had at least 60% of their bookings completed by the same driver within t...

Problems in writing sql queries anyone who can write following queries?

1. List all the directors who directed a film in a leap year by using SELECT statement 2. Find the film(s) with the largest cast using SELECT statement 3. Find all actors who acted only in films before 1960 using SELECT state...

How to Solve PHP Connectivity Error with MySQL

<?php if(isset ($_POST['Signup'])) { $file_name = $_FILES['image']['name']; $file_tmp =$_FILES['image']['tmp_name']; $file_ext=strtolower(end(explode('.',$_FILES['image']['name...

How to Execute Multiple Insert Queries in NodeJs Application?

I am trying to perform an insert query, use the insertid of the row and then perform another insert query using the inert id. the first query is executing but the second query is not. please help. Below is my code: $("#addopdfrm").subm...

Enable sending mails on localhost

I am trying to send mails from localhost. I followed a tutorial and found online but still cant send the mail. please help!!!

Convert SQL Query into Laravel?

SELECT * FROM jobs WHERE published = 1 AND (created_at between '2017-05-12 00:00:00' and '2017-05-13 00:00:00' OR created_at between '2017-05-10 00:00:00' and '2017-05-12 00:00:00' OR created_at between '2017-05-05 00:00...

How To Record Urls Loading on iFrame Into MySql Db ?

Programmer Experts,   I'm embarking on an interesting project to gain work experience in php. Just stuck on one thing and wondering if you can help. You probably used Team Viewer. This is where I create a Team Viewer session and...

How To Add More Than One Entry On A Single Cell/Array Where Each Entry Is Separated By Commas?

Programming buddies, I'm back online after nearly 2wks of offline. Gonna be harassing you guys again and more this time. Eeek! Anyway, right now, I'm trying to build a script that adds multi-entries into the same single cell MySQLsq...

Mysql database browsers not working after upgrade

needed version 5.7 of mysql server for a project. I upgraded from version 5.5 to 5.7 using this tutorial. The upgrade was successful and I am able to use the updated version via command line. However, mysql browsers (mysql-workbench as sqlyog as ...

query roll back

hey ci experts can you help me plz where im making mistake.... my query is not roll backed although im setting the first parameter in the $this->db->trans_start(TRUE); as TRUE the queries are only rollback when i remove the $this->db-...

android google map is showing only one marker using volley library

I am using Google Map inside the "Fragment" using sqlite database connection through volley library. I have 4 location, but my map is showing only one marker. I don't know where exactly getting wrong. Where do I need to change in my code to...

How to list table names using primary key of a table

Hello all, I have approx 100 number database tables in db from that I want to list all the tables which is using primary key of a table as a reference in MySQL InnoDB?
Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: