1,079 Recommended Topics
Remove Filter  | |
 | How can I identify and delete unused MySQL indexes? I have a large table that has somehow accumulated way too many indexes over the years, and I'd now like to identify and delete indexes that are no longer used by the application. Databases mysql |
| | I ran into a bit of a snag in my code, and I'm trying to make heads or tails as to whether this will work. From within my PHP script, can I write to a database using a MySQL connection in the middle of a transaction with a different connection? … |
 | A script that was working fine on 100 records per batch choked when I fed it 1,000 records. It gave: mysql.connector.errors.OperationalError: 1040 (08004): Too many connections So I went ahead and made sure to connect.close() everywhere that I opened a connection, and the script made it much further but eventually … Databases database-design mysql python |
| | This week I'm working on the data warehousing capabilities of my application. Now most people here who have built more than a couple of applications can tell you how useful it is to include a datestamp on records or requests as they come in. The advantages are numerous. So much …  |
| |    here is three Sql table name of them - 1. orders 2.order_item 3. target_value I am trying Two way here is may two code : 1 SELECT I.target_id as Iid, I.target_date as Idate, I.customer_name as Icust, I.target_product as Icat, I.target_pay as Ipay, I.target_rec as Irec, I.active as … |
| | Okay, so I'm in need of some career advice, because honestly I'm at a point where I don't really know how to proceed in the future. Databases career data-science engineering |
| | Recently made a decision for an app I'm working on to accumulate data in batches AND THEN to insert it into the database with one statement rather than adding 1,000 records through one thousand separate inserts. Is this done better through file or memory? If I write the segments of …  |
| | What are some ways to improve MySQL performance on queries against large tables that include the HAVING BY clause. It's my understanding that anything in there doesn't benefit from table indexes. Databases mysql |
| | Basic background information Mariadb Ver 15.1 District 10.11.6 MariaDB Glarea cluster, one with three nodes: Node1:192.168.18.78 Node2: 192.168.18.79 Node3: 192.168.18.80 Among them, Node1 node was restarted after a power outage of 1 hour, and after executing the system ctl start mariadb, it was stuck for a long time (running for … Databases mariadb mssql open-source peer-to-peer queue |
| | This is the error message: >>> %Run -c $EDITOR_CONTENT Traceback (most recent call last): File "<string>", line 6 image = cv2.imread(“C:\Users\Audun Nilsen\Pictures\pica.webp”) ^ SyntaxError: invalid character in identifier >>> This is the code: import cv2 # OpenCV for image processing image = cv2.imread(“C:\Users\Audun Nilsen\Pictures\pica.webp”) Databases |
| | Hey Gang! OK today I am having trouble with my transaction processing application implemented in python/MySQL. Here is some "working" testing code. import psycopg2 from psycopg2 import Error import binascii from binascii import unhexlify import mysql.connector as mysql sql='''CREATE PROCEDURE testprocedure(OUT tacos INT) BEGIN show tables; SET tacos := 1 … |
| | Hey! I've been asked to store some data from a client in mysql in an encoded format using python. Nothing could be easier, right? I will later need to decode the same data using mysql exclusively. Given that constraint, I thought that base64 would be the go to since nearly … |
| | More programming fun! OK this time around I'm trying to create a table with the statement, CREATE TABLE tablename ( recnumber SERIAL PRIMARY KEY, recordvalues VARCHAR ( 500 ) NOT NULL, datecreated DATE ) And it basically works, and I can add records using the dba account. However when I … Databases postgresql |
| | How do I create a table in postgres that's associated with a specific database? Obviously from the command line one can do Create table tablename (); But how do I make sure that the table is associated with the correct database? CREATE table dbname.tablename(); is giving me the error: ERROR: … Databases postgresql python |
| | My textbox datatype is DateTime. Using the click event of a button, this code is placed following MyTableBindingSourceAddNew() Dim CurrentDateTime As DateTime = DateTime.Now.ToString("dd.MM.yy hh:mm:ss") Me.SaleDateTextBox.Text = CurrentDateTime I then update table with TableAdapter. On my form I have a dropdown combobox in a toolbar, display member being "SaleDate" This … Databases visual-basic  |
| | I'm working on an SQL query for a complex reporting system that involves multiple tables and joins. However, the query's performance is not meeting my expectations, and I suspect that the way I've structured my joins might be inefficient. Here's a simplified version of my query: SELECT orders.order_id, customers.customer_name, products.product_name, … Databases database-design dataset mysql sql |
| | Sometimes you need to delete duplicate rows in a database :) In the future, set UNIQUE keys when you need them :) In the example below, we have a table appropriately named `TABLE_NAME` and there are multiple rows that have the same value for the `duplicate_field` field. In this example, … Databases mysql |
 | [URL="http://www.ibm.com"]IBM[/URL] researchers have [URL="http://www.zurich.ibm.com/news/07/asme.html"]unveiled[/URL] prototype 3D visualisation software that will enable doctors to interact with their medical data in pretty much the same way they interact with their patients. The technology, known as the Anatomic and Symbolic Mapper Engine (ASME), uses an avatar representation of the human body which the … Databases google machine-learning |
| | 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 … Databases database-design sql |
| | 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? Databases mysql |
| | 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 … |
| | The job you’re applying for says, “Redis experience required.” Are you ready for the questions a hiring manager is likely to ask? Here’s [how to prepare for the job interview](https://redis.com/blog/redis-interview-questions/)... as inspired by Lord of the Rings. Nominally the article is written for someone getting answers ready for Redis-specific questions, … |
| | 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 … Databases |
| | 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 …  |
| | 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 … Databases microsoft-access vb.net  |
 | 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 … Databases gui microsoft-office sql  |
| | 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 … Databases mongodb |
| | 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 … Databases listview |
 | 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 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 … Databases client-server data-structure mongodb |
| | 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 … Databases python |
| | 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, … Databases dataset microsoft-office php |
 | # 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 … Databases java java-swing mysql |
 | 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 … Databases microsoft microsoft-office |
 | 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 … Databases |
| | hii how can i make self join and sum data in other table by username i have table like this members (id, username, referral) ref_bonus (id, username, bonus) members id | username | referral ---------------------- 1 id1 id2 2 id2 null 3 id3 id2 ref_bonus id | username | bonus … Databases  |
| | 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, … Databases mongodb oracle postgresql |
| | 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 … Databases |
| | HELP! We are a volunteer-driven not-for-profit offering motorcycle safety training and skill development with a huge database issue as described below. We cannot identify any of our volunteers that can tackle our database issue...here it is, can you volunteer your time to help us? We would be glad to hear … |
| | 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() { … Databases java java-swing oracle  |
| | 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 … Databases mysql  |
| | |
 | 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 Databases microsoft-access mysql sql |
The End.