660,820 questions
-5
votes
0
answers
31
views
Problem while writing code using the Head First Python 2e book. I can't log in with my own ID
I followed the author of the book mentioned in the title step by step.
I created a database vsearchlogDB
and wrote:
grant all on vsearchlogDB.* to 'vsearch' identified by 'vsearchpasswd';
and exited.
...
-2
votes
0
answers
14
views
Laravel model - INSERT IGNORE [duplicate]
I have a database table in my database called "meetings" and a corresponding eloquent model called Meeting.
I am trying to do an INSERT IGNORE into the table.
I can do "Meeting::...
- 143
0
votes
0
answers
53
views
I want to implement real time countdown in SQL
[this is the output 00 minutes](https://i.sstatic.net/9Qte4SBK.png)
I used events that trigger if 30 minutes passed, automatically setting the status to no action if the employee did not approve.
...
- 9
-4
votes
0
answers
31
views
When i import a csv file on dbeaver i get an error that name value on row 2427 is too long? [closed]
I import the csv file by right-clicking on database name and then clicking on import data. I then choose the file I want to import and click next. Then I click proceed and it gives me the following ...
- 1
-3
votes
0
answers
40
views
word in paragraph cannot be found in mysql despite working individually [closed]
So let me break it down , i am creating a chatbot where the user can input any kind of paragraph and the bot divides it into words and search for those words inside a ready made mysql database
for ...
0
votes
0
answers
50
views
Fetch data in two tables mysql [duplicate]
I am trying to fetch data between 2 tables but I am not getting any result!
Here is my code
SELECT daily_data.DataCount, handled.hand_over
FROM daily_data
JOIN handled ON handled.id = daily_data.id
...
1
vote
1
answer
50
views
mysql pivot without nulls or spaces
I have a working procedure which shows asset names in named zonename columns -
DECLARE pivot_columns TEXT;
DECLARE sql_query TEXT;
-- Step 1: Generate the pivot columns dynamically (for each ...
- 205
-3
votes
0
answers
51
views
Unable to update image name in MySQL database [closed]
I am trying to update an image in MySQL database but each time I do try to update, other fields (i.e. location) of the is updated but the image name becomes blank.
Below is the code for updating:
if (...
1
vote
1
answer
57
views
are Sub query operators ( ALL and ANY) really needed, why do we need them instead of min,max and in operator
we are using subquery operator ( ALL & ANY ) along with a relational operator,
so instead of that we can just use MIN or MAX in case of numbers and IN in case of characters.
I want to know if ...
1
vote
1
answer
47
views
Roll back a commit?
Note: This question focuses on web apps utilising MySQL's transactions - commit and rollback. Even though the code samples below use Python, the problem itself is not limited to the choice of ...
- 1,336
0
votes
0
answers
51
views
Are there any jOOQ conventions on how to batch-insert 1 to n relations to the database?
I regularly face the use case in our backend application that it needs to save a lot of data at once that is scattered around multiple tables, but mostly its a 1 to n relationship, or recursive data ...
- 1
1
vote
1
answer
67
views
How to apply spatial index in my situation without using 'or' and 'union all'
I've been refactoring using the spatial index at Haversine,
I wanted to write a sql statement that checks posts within 10km with the point value (0,90) for information without distance, but I ...
- 13
0
votes
0
answers
48
views
MySQL / phpMyAdmin: Merge Two Tables by Matching IP — Add numberoftime for Existing IPs, Insert New Rows for Unique IPs [duplicate]
I have 2 tables 'error1" and 'error2' with the very same architecture
error1
id
IP
numberoftime
1
127.127
56
2
100.100
47
error2
id
IP
numberoftime
1
90.90
56
2
100.100
32
I would like to merge '...
- 1
0
votes
1
answer
41
views
How can I list all records for a joined table but filter by it at the same time?
Let's say I have the following structure:
Courses
ID
name
1
Math
2
History
Students
ID
name
CourseID
1
Bob
1
2
Alice
1
I want to make a query which lists all the students in a course, but filter ...
- 6,800
-1
votes
0
answers
26
views
SQLSTATE[HY000] [2002] Connection refused PDO with docker [duplicate]
I have a small docker project running, which contains an nginx server, 2 database servers ( one local, one for tests). It generates a webpage, which I access via http://localhost:8012/ 8012 being my ...
- 2,704