117 Recommended Topics

Remove Filter
Member Avatar for
Member Avatar for ALI_418

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 …

Databases
Member Avatar for rproffitt
0
73
Member Avatar for Komlika_1

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.

Databases
Member Avatar for john_111
1
2K
Member Avatar for Udara_1

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

Databases asp.net sql
Member Avatar for rproffitt
0
121
Member Avatar for zain_11

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.

Databases
Member Avatar for Dani
0
39
Member Avatar for Andrew_77

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 …

Member Avatar for rproffitt
0
297
Member Avatar for Stefce

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 …

Databases
Member Avatar for rproffitt
0
67
Member Avatar for kevinG73

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 …

Databases sql
Member Avatar for Geek-Master
1
189
Member Avatar for feehoy

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 …

Databases mysql php
Member Avatar for feehoy
0
115
Member Avatar for Luc001

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 …

Databases sql vb.net
Member Avatar for M.Lingo
0
352
Member Avatar for darkbox

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 …

Databases mysql php
Member Avatar for darkbox
0
82
Member Avatar for Phillip_8

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 …

Databases mssql mysql vb.net
Member Avatar for rproffitt
0
323
Member Avatar for rchawdhari

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 …

Databases mysql
Member Avatar for M_41
0
267
Member Avatar for Xozz

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

Databases microsoft mysql
Member Avatar for john_111
0
512
Member Avatar for messiahjoseph39

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 …

Databases mysql php web-design
Member Avatar for NeighborDave228
0
179
Member Avatar for squigworm

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! ![Query_SUB_QUERY_question_.png](https://static.daniweb.com/attachments/2/9db9bca69fea80f23ce39603536c5590.png)

Databases sql
Member Avatar for Dani
1
65
Member Avatar for sols4comp

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 …

Databases mysql sql
Member Avatar for pritaeas
0
111
Member Avatar for DioneH

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.

Databases php
Member Avatar for DioneH
0
113
Member Avatar for BreighA

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

Databases microsoft-office php
Member Avatar for BreighA
0
121
Member Avatar for larry29936

I have the following query which has died after running over an hour on my local mysql 8 server: UPDATE download LEFT JOIN lookup ON download.ip_address between lookup.start_ip AND lookup.end_ip SET ref = ( SELECT lookup.id FROM lookup WHERE download.ip_address between lookup.start_ip AND lookup.end_ip); All ip fields are IPV4 and …

Databases mysql sql
Member Avatar for pritaeas
0
272
Member Avatar for davecoventry

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 …

Databases sql
Member Avatar for davecoventry
0
407
Member Avatar for Xozz

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

Databases mysql
Member Avatar for Xozz
0
77
Member Avatar for lewashby

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 …

Databases mysql
Member Avatar for Dani
0
13K
Member Avatar for johnnysnowman38

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?

Member Avatar for rproffitt
0
443
Member Avatar for Violet_82

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 …

Databases sql
Member Avatar for Violet_82
0
352
Member Avatar for misstj555

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 …

Databases api python sqlite
Member Avatar for John_165
0
416
Member Avatar for nishita_1

please provide me sql query for below output sum query please help me ![93852217_246197733117734_2443195689677619200_n.jpg](/attachments/large/4/5009c5b4125b294842ffd7cf1d839caa.jpg)

Databases mssql mysql php sql
Member Avatar for Santanu.Das
0
319
Member Avatar for ami_2

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 …

Databases microsoft-office
Member Avatar for rproffitt
0
142
Member Avatar for loveboat

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

Member Avatar for loveboat
0
127
Member Avatar for R_4

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 …

Databases mysql php sql
Member Avatar for Dani
0
439
Member Avatar for larry29936

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 …

Databases mysql
Member Avatar for larry29936
1
251

The End.