Our Databases forum encompasses everything related to data storage, both for the web and other uses.

13 6 5 5 4 3 3 3 3 2
Member Avatar
Hi all, I wanted to procedure to return number of days and weekdays between two dates. This is what I came up with and it seems to work ok, but I'd like to read what others think. And if there's already a single line function for this, oops. Also, I'm …
by RudyM 31 in Databases ()
Member Avatar
Hi Dw. I'm trying to install MySQL and its my first time to install MySQL. I've downloaded the latest version which is version 5.7.12 and when I try to install its says "Beginning configuration step: Stopping Server [if necessary] Ended configuration step: Stopping Server [if necessary] Beginning configuration step: Writing …
by Mr.M 32 in Databases ()
Member Avatar
Hi everyone! So we have a web application that some of our clients use to manage their account. Part of that means they can manage activities that their registered employees do. Right now we have a table that logs all of a customer's employees activities, even if they don't use …
by zachattack05 56 in Databases ()
Member Avatar
Hi Dw. What is the correct way to write an sql query like this? ... in vb.net. My problem is that on my database I have some usernames repeated but they differ by their passwords. Each record has a different information. When I tried this it will just return the …
by Mr.M 32 in Databases ()
Member Avatar
Sorry i dont know how to explain this properly, but what i'm trying to get across is how do i get sql to select a data type (i dont think thats wording it properly, sorry) which only appears once? Thanks ;p
by pleasehelplmao in Databases ()
Member Avatar
I'm in a Java class we are using netbeans to create a program. I have the code in and it builds but it will not run. Can anyone assist
by lo022 in Databases ()
Member Avatar
I have a database in mysql which contains of four tables (Student, Units, Offering and Enrols_in) and i want to create an enrolment page where students can enrol in units which will be offered in each semester. Student names will be entered in the database and they will use their …
by naithsleeray in Databases ()
Member Avatar
Can anyone explain me what are the main difference between a null value and blank value in database. It important please help me out. thank you.
by dharam_05 in Databases ()
Member Avatar
I have been cracking my head on this mater in the past couple of days. I am faced with a situaton where i need to write a MySQL equivalent of PHP code to loop through sql select results. The Php code looks like this ... How can one write sql/mysql …
by Amaina in Databases ()
Member Avatar
Hello , I wanted to ask if for this statement in mongo: ... the equivalent in postgresql is: ... Thanks!
by glao in Databases ()
Member Avatar
I have the query below: ... It is giving me an error near the parenthesis, what is wrong with my sintax? I ran the different pieces of the query individually so I could see if the expected results were being returned, and it seems fine. But when I put them …
by Samyx 36 in Databases ()
Member Avatar
Hello, I have to install Oracle Developer 2000 R2.1 on a Windows 8.1 (x64) machine to run an application developed by a third party developer, but my installation keeps on crashing. Tried running in Windows XP SP3 compatibility mode still same result. The error is as follows: "D2KQT10.ins(54): 'Statement' expected …
by lordrt 34 in Databases ()
Member Avatar
Hi, I have installed Oracle 11g (latest version 11.2.0.1.0) on my system. During the installation it didnt ask me to set username or any password. I'm unable to start sql plus because i dont have the username and password. Can anyone tell me what is the default username and password …
by VenusCrystal in Databases ()
Member Avatar
I need help creating a database for my website. I want the user to be able to sign into their personal account and add comments, have their own profile page, and add friends. My friend is creating a Garry's Mod (video game) server and I was gonna design the website …
by McAdams12 in Databases ()
Member Avatar
Apparently I don’t know how to insert a row into a MySQL data base using PDP and I would like to know what I am missing This PHP PDO script does not insert data into a database. I would like to know why. It does not error out but the …
by rouse in Databases ()
Member Avatar
so i have a combox that will tell you that which data will appear like "name", "contacts","website","email" and data will appear in gridview but i want to filter the data in gridview example in name if you type a all data starting with a will appear and everything starts with …
by Cj_4 in Databases ()
Member Avatar
MySQL Stored Routines: Another Useful Scenario I discussed MySQL stored routines within MySQL. Now I’m back with another guide on MySQL stored routines. And this time it’s a more concrete case; one that you may run into yourself in the future (or maybe you already have)! Let’s jump right on, …
by Bob Hensley 20 in Databases ()
Member Avatar
Using PHP / MySql... I have a transaction table and a record is automatically inserted when someone Initiates a transaction, and then is updated later in the process, based on the recID. I want / need to keep the recIDs filled with completed transactions without any skips in the ID …
by showman13 35 in Databases ()
Member Avatar
Is it possible to select values from 2 columns in order to calculate another column in the database table?
by BabaRoro in Databases ()
Member Avatar
Hi, I am new to SQL Server and what I am trying to do is convert my working SELECT Query to an UPDATE Query to update the data. I have looked for a tool or examples but cant find any information that can point me to the correct path. ... …
by lmalave in Databases ()
Member Avatar
Hello, I have the below case. ... So, I want to insert into TM_TABLE_2.NITEMID the value of TM_TABLE_1.NID where TM_TABLE_2.NORDERCODE = TM_TABLE_1.NORDERCODE, keeping in mind that its possible to have more records inside TM_TABLE_1 than TM_TABLE_2 so I just want to insert NID's from TM_TABLE_1 into TM_TABLE for row's with …
by fo2sh -4 in Databases ()
Member Avatar
Hello All, Is there any provision to ignore the trigger when i update a row in a table. Thanks, Loges
by logesmca in Databases ()
Member Avatar
I'm trying to delete a database in phpMyAdmin which is in localhost of Windows 7 Professional 64bit system. Since I am not an IT or database professional, I'd appreaciate any help with non-techy steps. :-) When I attempt to delete the database I receive the error: DROP DATABASE 'enfold-2016' 1010 …
by Ricardo_1 in Databases ()
Member Avatar
getting syntax error into insert i don't know why :( Private Sub Button1_Click(By Val sender As System.Object, By Val e As System.EventArgs) Handles Button1.Click ...
by Cj_4 in Databases ()
Member Avatar
Hi all, I will be building a web application that does a personnel data lookup, unfortunately using SSN. So I’ve been searching for how encrypt this data so that I do not use plaintext SSN in the application to accomplish this. I found this article: ... . Does this mean …
by RudyM 31 in Databases ()
Member Avatar
How do I write a SQL query involving a time stamp? QUOTE_ID is a character string CREATE_DTG is a date time type RETENTION_LEAD_TRACK is a table This sql statement ... throws this error ...
by complete -2 in Databases ()
Member Avatar
Hi guys! Pls help me make a water billing using c#.. I dont know how to start.. :(
by Gudger in Databases ()
Member Avatar
I have been trying two save data into mysql database using hibernate but it have been giving me an error. Could someone give a solution to this. Following is the servlet code and hibernate configuration ...
by Jelo in Databases ()
Member Avatar
Hai. i'm beginner in php. Can someone help me to insert the calculated value into database. I'm trying to insert calculated value into database but it doesn't work. This is my code. ...
by Ayuni_1 in Databases ()
Member Avatar
Hi to all ! I need your help. Actually I have enrolled in final year project and chosed Data Warehouse. According to the project scenario I made dimension tables and fact tables. Before making star schema, I want that you check my dimension and fact tables. I am giving you …
by Saboor Siddique -3 in Databases ()
Chat Log Latest Posts