Databases Forum

An equipment company wishes to create a database to support the hiring of tools and machinery to clients. The company has three types of equipment: power tools, such as drills and vacuum cleaners, plants such as excavators and scaffolding. Each piece of equipment is identified by a number. Power tools …

What is best way to get one row from a mysql table (with many columns) so I can use several several fields from that row for calculations in a C program? After executing a succesful SELECT command using mysql_query, is there an alternative to using mysql_store_result?

i have 3 tables : users, deposit, withdraw **table users :** id , username, referral 1. 1, a1, null 2. 2, a2, a1 3. 3, a3, a2 4. 4, a4, a1 5. 5, a5, a2 **table deposit :** id, users_id, amount, status, approve_date 1. 1, 1, 10000.00, approve, 2022-10-01 14:52:53 …

So, I have made a table called `supplies_table` and inside the table is `id`, `name`, and `files`. And I also made an upload button where it can upload a pdf BLOB file into the `files` column. Yes, it can upload a pdf file in the `files` column but the problem …

Hey Peeps, Hope all are doing well. Happy to be a part of this community. So am fairly new in the programming world and exploring a few job opportunities in this field. Coming to my query, So was going through this list of questions, although concepts seem easy to understand …

I’m working on a blog post about this topic. I’d love to hear your suggestions! * What book(s) should someone read to come up to speed? * Why do you recommend that one? Note that the books don’t have to be peculiar to Redis. For example, someone suggested *Designing Data-Intensive …

i am running ubuntu 22.04 and php 8.1 / MariaDB , i am missing somthing here in my code just can't see it. the premise of the code is to look at the TrolleyID Field and if it's '00000' basically echo's "BAD-READ" else it's 'GOOD-READ' any help would be great …

Good day every body. I want to develop a database program that will be used in school to input information about students and all the staff of the school. I want the program to be able to retrieve any required information and also display the total number of students in …

Hello all, I would like to set a time after 2 requests that someone can make a request again does anyone have an example for this. thanks in advance

Hi, I want to write a program whose input is the names of the companies and when adding the name of each company, it will take various information from that company of different types, 1- TextBox (daily production rate), 2- CheckBox (select product features), 3- OptionButton (the gender of the …

Hello I am building a database (i prefer MongoDB) that i will store over 100 mil ipv4 and ipv6 records for logging purposes. Data sample : 1.1.1.1 -> 0x1010101 1.2.3.4 -> 0x1020304 34.53.63.25 -> 0x22353f19 255.255.255.255 -> 0xffffffff 0001:0001:0001:0001:0001:0001:0001:0001 -> 0x10001000100010001000100010001 1111:1111:1111:1111:1111:1111:1111:1111 -> 0x11111111111111111111111111111111 2345:0425:2CA1:0000:0000:0567:5673:23b5 -> 0x234504252ca1000000000567567323b5 2345:0425:2CA1::0567:5673:23b5 -> 0x234504252ca1000000000567567323b5 …

Hello , i am using vb6.0 can some one help me with my problem. I want to summarize a database with multiple name and display it into one data where the date is same today. thank you for any one would response. for example. below is a table where multiple …

I need to get a set of results from the db (server) but at times I would get the same result back and I would like to cache the result instead of making the same call to the db. Any ideas?

I am new here. I passionately need the help of python gurus here to help solve this my statistics analytics problem. I want to write a python code that prompts for an imput. Then saves the new input data into a table of numbers at the last position while it …

I am building a ipv4/ipv6 geo ip **MongoDB** database and i will have millions (100+) of ips Structure will of the database will be [ { _id: 58fdbf5c0ef8a50b4cdd9a8e , ip: '34.53.63.25', ip_hex: '0x22353f19' , type: "ipv4", data : [ { country : "CA", region : "region1" city : "city1", blacklisted …

hello, i hope someone can help me i have a table ip in my database if there is 5 times in it he has to forward it in php to another page. thanks in advance

Hi Everyone! I am new here, and the main purpose of joining this community is getting some help. Actually, I am designing a PHP website where I need to fetch US vehicles data into PHP. I have already used this source to get the vehicle's dataset from here https://www.back4app.com/database/back4app/car-make-model-dataset. Still, …

# Introduction # If you're like most data scientist, analysts, or developers, you probably spend a lot of time worrying about your ever-growing store of data. After all, it's the lifeblood of your business. You need to ensure that it's properly stored and accessible when you need it. This article …

# Introduction # As we move into 2022, businesses will continue to look for ways to become more data-driven. This means that knowing how to use Structured Query Language, commonly called SQL or 'Sequel', will remain an essential skill for data scientists, analysts, and developers. In this post, we'll provide …

import net.proteanit.sql.DbUtils; import javax.swing.*; import javax.xml.transform.Result; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.*; public class EmployeeRegistriation { private JPanel Main; private JTextField txtName; private JTextField txtSalary; private JTextField txtMobile; private JButton saveButton; private JTable table1; private JButton updateButton; private JButton deleteButton; private JButton searchButton; private JTextField txtId; private JScrollPane tabla_1; public …

Hello, I am fairly new to VBA development trying to upgrade my employee training database in VBA from a single listbox with single line select/add/edit capability to one that pulls employee data from listbox1, searches training available by job title in listbox2, and combines the data into listbox3 also adding …

so we were trying to make a simple log in form and our professor simply told us to copy the codes he wrote:  i copied it but i got a red line under line 20 and 21 . I dont know what to do, no one is responding to …