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

Featured

How to Create a Simple Admin Page in HTML?

At first i'm a beginner and i have a simple project to do.   I'm trying to build a simple admin page that add some content to my website   This is not a big deal, but i need someone who can instruct my directly ...

Is It Possible to Put all Upcoming to Mobirise eMail to Separate Database?

I receive a huge amount of messages from my landing page, created in Mobirise website builder. It's a mess.   I want to put them in a separate database, so I could see them in an order. Is it possible? I didn't find an answer i...

How to Summarise Leave Time Proportionally and Correctly in MySql

In mysql database i created "leave" table:   CREATE TABLE `leave` ( `ID_LEAVE` int(11) NOT NULL, `ID_WORKER` int(11) NOT NULL, `BEGIN_DATE` datetime DEFAULT NULL, `END_DATE` datetime DEFAULT NULL ) INSERT INTO `lea...

How to Merge Two Tables on Coded Columns Using Python

 Hi guys!   I have two tables and I need to merge these two tables on columns left_on='A', right_on='B'. The problem is that 'A' column is coded 'B' column.   What would be the best optio...

How to Merge XML CTE's in SQL Server Using Common Refid Key

I have the following CTE's, and I'm trying to combine XML1 and XML2 CTE's in Sql Server by their common refid key. ;With TBL1_Fruits As (Select '1' as refid, 'Apples' as fruits, 'Red' a...

How to Insert Data Contained in Entry Widgets on a GUI Correctly into SQL DB Created in Python?

In the code below the str entry widgets that I use the get method to retrieve data from, have been created earlier in the code.   I have tried the following ways to solve the problem: turning the list into a tuple using a list ...

Why am I getting null values for lease_id in Rent?

Passing primary key values in the parent table to foreign key values in child table with parent insert and child insert being in separate stored procedures.   Parent is Lease table, the child is Rent table. I am getting null value...

How to insert this codes data to SQLite?

Need help in inserting the below code packet to SQLite: public class StepDetector { private static final int ACCEL_RING_SIZE = 50; private static final int VEL_RING_SIZE = 10; // change this threshold according to your sen...

java problem

  what is the problem here?please help me package help; import java.util.Date; import java.sql.*; import java.util.logging.Level; import java.util.logging.Logger; public class Help { public static void main(String[] args)...

images from database to jtable. Java

I have an app that contains a database using java sql, and has a jTable that displays the database info. It works fine, EXCEPT for when I am trying to store and display images to one of the columns. I used the  jTable1.setModel(DbUtils.resul...

Getting Foreign Key Constraint Fails Data Insertion Error in MySQL

I am trying to create to 2 tables and inserting data into them but I am getting this error Creating Athlete the table failed SQLSTATE[23000]: Integrity constraint violation: 1217 Cannot delete or update a parent row: a foreign key constraint fail...
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: