Databases Forum

The web application will have a database that consists of millions (over 20mil ... maybe 100mil or more) of hosts (ipv4,ipv6 and domains) and additional data to each host like blacklist, uptime, history, geo data (country, region, city, isp). I could, of course, use other RMDBS system like MySQL, Oracle, …

Hello all, We have just launched a startup. Now, we are looking for a simple web-based relational database system where we can easily add tables and connect them to one another through foreign keys. For example, we would want to create a suppliers database in which we could perform a …

package sadbinproject; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; import java.util.logging.Level; import java.util.logging.Logger; import javax.swing.JOptionPane; /** * * @author Notebook */ public final class admission_panel extends javax.swing.JFrame { /** * Creates new form admission_panel */ public admission_panel() { initComponents(); Connect(); } Connection con; PreparedStatement pst; public void Connect() { …

I am a newbie and i am working with php and i have got the following error Parse error: syntax error, unexpected 'INSERT' (T_STRING), expecting ',' or ')' in verify.php on line 9 CODE SNIPPET:  

Hello friends, I am new to this site, this is my first post, My question is.. How to calculate the one rows value for next row value? [code=sql]select @rownum:=@rownum+1 "sl.no", b.bus_activity_desc "Type",r.trn_no, o.Office_name,o.Address,o.Address2,o.Address3, DATE_FORMAT(r.trn_date,GET_FORMAT(DATE,'EUR')) as trn_date, l.Account_id , if(r.trn_type=6,r.total_trn_value,0) "Credit", if(r.trn_type=7,r.total_trn_value,0) "Debit", if(r.trn_type=6 ,@cbal:=(r.total_trn_value+@cbal),@cbal:=(@cbal-r.total_trn_value)) "Closing Balance" from(select @rownum:=0) s, office_master …

Hello. I am trying to check if a table definition (the default value on a constraint) is equal to UTC Time by using the following query: IF NOT EXISTS((SELECT object_definition(default_object_id) AS definition FROM sys.columns WHERE name = 'ModifiedDate' AND object_id = object_id('dbo.WorkflowAudit')) == GETUTCDATE()) However, you can not compare a …

Illustrate a database for the video club using a recent video club entities

I have an access Database with Chinese and German words. How can I had their audio prononciation wich I get from Forvo or Google translate?

I have managed to get blog posts displayed from each blog category but I want to limit it to 1 article from each blog category but unsure how to do it in the sql query I have, below is what I have so far (SELECT BP.postID,postTitle,postSlug,postDesc,postDate,postImage FROM blog_posts BP, blog_post_cats …

Create a table with following rules and regulations ma 1)Id should b identity 2)Name should allow only starting Letter with a to p 3)city should not allow Chennai,cbe, Salem 4) department should allo only cse,it,ece, 5) college default should b anna university 6) per should above only 70% 7) year …

I have a SQLite database that for some insane reason stores dates as the number of days since 1899-12-31. I want to create a view that will display the date as an actual date. I can calculate a specific date from a specific day number as select date('1899-12-31','Localtime','+44386 day') as …

Find product who hasn't had any sales in first three months of the year?

I have three tables: First table is 'user': user_id | Name | ---------------------- 1234354 | Abu Bakar | 2543353 | Ali | 3342342 | Aliza | 4234243 | Ali | 5234324 | Mike | Second table is 'meeting': meeting_id | meeting_name | meeting_startDate | meeting_endDate | room_name | ---------------------------------------------------------------------------------- 1 …

Hi Guys, Im not sure how to word the title of this question, but i have a table called "daily_recyclables". Inside this table, i have multiple columns of recyclable materials (example copper, stainless steel, brass etc etc) In my PHP application, i have a statistic card (like below) that is …

Our database is running into problems, as many transactions are waiting for locks held by other transactions. Here is what each transaction is waiting for: · T1 is waiting on T4 · T5 is waiting on T8 · T2 is waiting on T7 · T6 is waiting on T2 · …

Hi all, I am working on a website that requires two queries from a table at the same time. They must select a row based on the id, and then another random one not including the row just selected. I currently have: $query = $pdo->prepare('SELECT title, content FROM cards WHERE …

 

I have the following table: my_contacts which contains the following columns: [CODE]contact_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, frist_name VARCHAR(20), interest VARCHAR(20)[/CODE] [CODE]-----------+-----------+---------- contact_id | fisrt_name | interest + ---------------------------------- 1 | smith | swim + 2 | mark | dance + ----------------------------------[/CODE] I need to move the interests column …

A balanced tree is one of the data access techniques in a database. How does it work? How data can be inserted in. How data can be deleted from it; how data can be updated? And how data can be reviewed? By giving an example explain all of them. Your …

Consider the following database Room (room_no,room_name,room_type,charges) Guest(Guest_code, Gname,city) The relationship is as follows: Room-Guest: one-to-one. room_type can have values as either ‘AC’ or ‘NonAC’. Q 2) A Create the above database in PostGreSQL and insert sufficient records.

I want connect microsoft sql server database using servername,username,password,port number and service name to asp.net api 2019. This code segment I'm using SqlConnection con = new SqlConnection(@"server=10.d.13.2q0; database=sdssdsd; Integrated Security=False; User ID=lmgdgdfdfddgs; Password=sdsdsdsds"); please help me. what is the correct code

I am starting an online business with an American lady. I don't know anything other than her phone number. So want to verify her records.

Would you mind if I troubled you for some help? I’m working on an NDA’ed project and we’ve been asked to try and address a problem which is currently causing some pain. Imagine there was a merger between two blue-chip communications/media companies, and Company A was offering discounted deals to …

I want to split database access and permissions with another person. The problem is we don't know how we can make sure we both have the same rights and permissions to operate the database. So if anything goes wrong for example, one wants to change the password of the database …

I have a database where there is an table `wm` for water meters : +------+---------------+ | Code | name | +------+---------------+ | wm1 | water meter 1 | | wm2 | water meter 2 | | wm3 | water meter 3 | +------+---------------+ and another table c`ounters` where there are …

I have a snippet that inserts data in a row in a MySql database. If that data already exists the existing row should be updated. In my case, I continue to get insert only. What is wrong with this snippet? $page = basename($_SERVER['SCRIPT_NAME']); $ip_address = $_SERVER['REMOTE_ADDR']; include_once("includes/connection.php"); $sql=mysqli_query($con, "SELECT visits …

Like the title says, I'm trying to coloring an empty cell in bounded datagridview. I've got this code to coloring a cell with specitic value and is working well. This code is in the DatagridviewCellFormattingEventargs. If e.ColumnIndex = 5 AndAlso e.Value <= Date.Now.ToShortDateString Then e.CellStyle.ForeColor = Color.DarkGreen e.CellStyle.Font = New …

Good evening everyone, I created this file to be able to print the data from the database on the screen. Everything ok but all the data contained in the database appear on the same line. I would like them to print like this: nome email titolo dataeora msg nome email …

Hi guys im using VisualStudio2017 to make a chat program from a youtube video i keep getting an error and wondered if one of you might be able to help me out. Exception thrown: 'System.InvalidOperationException' in MySql.Data.dll The code: Imports System.Security.Cryptography Imports System.IO Imports MySql.Data.MySqlClient Module Con_Add Public usernamefriend As …

create table dummy{id int ,invoice int } insert into dummy values(191,10),(192,11),(193,0); I have to update 193 with invoice 13 but i want to fetch max invoice and then increment invoice by 1 for 193 . i had tried update dummy set invoice=(select max(invoice) from dummy)+1 where id=191. It wont work …

Hi. I'm trying to set up an AMP system on my machine. It's called UwAmp. Anybody there to tell me how to setup the MySQL in this thing? Thank you

Good day, I am actually a young programmer, who wants to develop a webpage that enables someone to take a practice test. It was given to me as an assignment that determines if I will remain a programmer. I know little about PHP codes but none in Mysql. I came …

Hi everyone I am wondering if someone can help me understand why the Sub-Query's SELECT statement ended up producing the column name 'Code' vs. the initial SELECT statment call 'local_name' in the below screenshot Thanks in advance! 

Hi All, I am having an issues with an SQL query and I can't quite work out how to resolve it. I have searched Google for the answer but can't seem to find the solution there either. Basically I have a database andin one of the tables it has a …

Hello Could I please ask for assistance? I need a file that I am able to download that holds all the streets and postal codes of the Ireland.

Looking for directions. Where would one go to find a downloadable excel sheet, listing the streets of Algeria city?

I have a table with the following fields: CREATE TABLE text ( drawing INT NOT NULL, blockID INT NOT NULL, entityID INT NOT NULL, style INT, txt VARCHAR(255) NOT NULL, attrib INT); My csv file contains the data: 19 1CB2 E49 2 CLIENT MODULAR 1C2A 19 1CB3 E4B 2 CLIENT …

Hi. I'm trying to write a game in PHP. Now a weird item shows up in my database. http://www.leondegroot.nl/files/mysql_nieuw.png "Nieuw" means "New". Do you have any idea what this is and how to delete it? Thanks, Leon

ERROR 1054 (42S22): Unknown column 'Firstname' in 'field list' I'M gettin the above error when I enter: mysql> insert into people (fname, lname) -> VALUES (Firstname, Lastname); Here's the table: mysql> desc people; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | fname …

Hi there, Not sure if I am in the right place, but I wanted to ask where I can access a csv file for all the streets in Belgium?

Hi all, I have a question about updating two values in a sql table using a subquery. My database is called books and the below table books too: id title author location_id 11 Tera Netrear 4 14 Disser Bubu 1 15 Tenno Puoio 4 16 Oban Tyrone 5 18 Sisnobi …

Hello. I am making a database using SQLite. Then I need to make an API with functions that returns information about that database. Then I need to print out a report. However, when I try to return an answer to a query using inputs, nothing is returned. I either get …

please provide me sql query for below output sum query please help me 

Hi, can someone help me solve this please I have tried so hard but can't figure it out? In past years, approximately 20% of all U.S. families purchased potato chips at least once a month. You are interested in determining the fraction of all U.S. families that currently purchase potato …

I would like to develop an attendence regiater for my company. i would like to use,Mongodatabase,node.js and javasscript am i the register should the availble on an link. am i in the right track

Hi all, I have assigned a column called "friendshipstatus" as a default value =0 in addfriends table that user can add other users to it to be friends as the code bellow which will give any users added as friend in addfriendss table the "friendshipstatus" value of 1 <?php include …

I'm trying to create a trigger that does two things, first take an ip that's in dot notation and run inet_aton on it and put the result in another field. Second, checks a lookup table to identify an ip range that the result of the first action falls into and …