149 Recommended Topics

Remove Filter
Member Avatar for
Member Avatar for Dani

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
Member Avatar for toneewa
0
416
Member Avatar for mx_983

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 database mssql
Member Avatar for toneewa
1
51
Member Avatar for Audun

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 opencv
Member Avatar for Audun
1
51
Member Avatar for cored0mp

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 …

Member Avatar for Dani
1
32
Member Avatar for cored0mp

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 …

Databases mysql query sql
Member Avatar for cored0mp
2
175
Member Avatar for cored0mp

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
Member Avatar for cored0mp
1
89
Member Avatar for cored0mp

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
Member Avatar for Dani
1
126
Member Avatar for shane1961

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 database
Member Avatar for rproffitt
0
65
Member Avatar for Vandiun

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 mysql
Member Avatar for DGPickett
2
121
Member Avatar for Dani

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 duplicate mysql
Member Avatar for Usamatamimi
4
4K
Member Avatar for Steve_63

My site is on Apache, the host has enabled 'mod_unique_id' My CSP runs in the root .htaccess. My host has given me 2 lines of code to put in the CSP to make an unrecognisable base64 NONCE code each time it's needed - particularly for PayPal. What they sent (in …

Member Avatar for AndreRet
0
79
Member Avatar for happygeek

[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 ibm medicine
Member Avatar for Jose_52
0
609
Member Avatar for Layla_4

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 …

Member Avatar for Dani
0
156
Member Avatar for chuckc

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
Member Avatar for rproffitt
0
103
Member Avatar for RC_820

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 …

Databases database mysql query
1
88
Member Avatar for estherschindler

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, …

Databases database interview job
Member Avatar for rproffitt
2
56
Member Avatar for aibreansiyue

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 …

Member Avatar for gce517
0
128
Member Avatar for Alisha_8

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 database dbms
Member Avatar for rproffitt
0
188
Member Avatar for estherschindler

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 …

Databases books redis
Member Avatar for Vandiun
0
197
Member Avatar for varcore

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 …

Databases database php php-mysql
Member Avatar for Dani
1
100
Member Avatar for Ukpe

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 database
Member Avatar for john_111
0
97
Member Avatar for Vmr_574

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

Databases mysql php
Member Avatar for Dani
0
103
Member Avatar for niksirat

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 excel sql
Member Avatar for Reverend Jim
0
107
Member Avatar for sankar2000

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
Member Avatar for Dani
0
484
Member Avatar for Lieutenant_1

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 table
Member Avatar for Lieutenant_1
0
185
Member Avatar for mtyide

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?

Member Avatar for rproffitt
0
317
Member Avatar for sankar2000

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 dbms server
Member Avatar for rproffitt
0
288
Member Avatar for Felonely

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
Member Avatar for rproffitt
0
74
Member Avatar for Vmr_574

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

Databases phpmyadmin sql
Member Avatar for Dani
0
294
Member Avatar for EpifaniaPersons

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 excel import php table
Member Avatar for RayPalmer
1
342

The End.