Questions tagged [mysql]

MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). DO NOT USE this tag for other DBs such as SQL Server, SQLite etc. Those are different DBs which all use their own dialects of SQL to manage the data.

Filter by
Sorted by
Tagged with
0
votes
0answers
4 views

how to pass arguments from Python to mysql and get a response from mysql based on those arguments?

I have a python script. This is where I am getting the arguments from the command line. ''' def main(): parser = ArgumentParser(description='Rating of films') parser.add_argument('-n', '--number', ...
0
votes
0answers
3 views

Sqoop: Communications link failure

I get the following error when I connect to MySQL via Sqoop Please help me to determine what is the cause of this issue OR am I missing something in the command. Thanks! SERVER DETAILS : HOSTNAME: ...
0
votes
0answers
10 views

Need to remove leading zero in mysql table where there are two leading zeros

I have a mysql database table called Products that contains some 14 digit GTIN barcode numbers in a column called GTIN, some of which have two leading zeros. I only need these numbers to be 13 digits ...
0
votes
0answers
21 views

Create clone table without index

I want to create a cloned table(tableA_cloned) from original table(tableA). But don't want to create index/key other than PK and unique key. I have a list of tables, so manually writing/editing create ...
0
votes
0answers
3 views

Cannot see size of tables growing after adding hundreds of rows of data in MySQL PHPMyAdmin

I'm on Ubuntu 18.04 and I've installed XAMPP. I've been checking folders and files for growing size inside /opt/lampp/var/mysql/ after adding hundreds of data inside my table and the size didn't ...
-1
votes
0answers
9 views

Stored Procedure Prepared Statement - MySQL - create temporary table from prepared statement [duplicate]

My previous question was closed as a duplicate, where I wasn't even given the chance to respond on any extra information required. For more information on the original question: Stored Procedure ...
0
votes
0answers
18 views

In mySql how to ignore past time when i compare any present or any datetime with any column having datetime?

Sql query to ignore past time and show records when i compare with present datetime with datetime column. My query: select * from appoinments WHERE (date(app.start_time) = date(NOW())) start_time is ...
-1
votes
0answers
16 views

Login PHP app. Doubts with mysql and pass hashed [duplicate]

First of all, my English is not very good, sorry if I make grammatical mistakes. I am a newbie to the php language, I have recently started studying it. My application is simple, a login window with ...
0
votes
1answer
11 views

How to create a JSTree view with context menu with create, rename, delete, drag'n'drop with PHP/Laravel? This is the Full solution

My project needed a file treeview to upload documents and I was using a theme forest template with jstree included in a page. So I've decided to use it but it was necessary to connect it to the ...
0
votes
1answer
27 views

Query two tables ORDER BY date

So I have two tables that displays values like a Facebook look-a-like feed. They both have a datetime column named date, but I want them to order them together by date DESC. I think join is the ...
0
votes
2answers
27 views

SQL result from table a but name from table b

My request is quiet simple however I can't find it (maybe I can't goolge correctly). I have Table A and Table B Table A: ID length 1 50 2 45 2 20 and Table B ID name 1 apple 2 orange I want ...
0
votes
0answers
7 views

Can MySql-8.0.23 32 bit with MySql-8.0.23 64 bit be clustered together

I have three machines mac 64 bit, linux mint 64 bit and debain-10 32 bit. I want to install MySql l8.0.23 on those machines and cluster them. But I am not sure if in a cluster I can have a mix up 32 ...
1
vote
3answers
40 views

how to fetch songs based on multiple conditions from joined tables

I have two tables songs and song_clubs. The schema is below:- songs schema id available_for song_name status 1 all Song 1 1 2 selection ...
-1
votes
0answers
27 views

Do MySQL triggers execute concurrently?

I have a question if it is safe to use triggers in the case of matching bids and offers as they are sent to the database. There is a trigger on the bids_table table. When a bid is inserted the trigger ...
0
votes
1answer
9 views

contains function for String in presto Athena

I have a table with ORC Serde in Athena. The table contains a string column named greeting_message. It can contain null values as well. I want to find how many rows in the table have a particular text ...

15 30 50 per page
1
2 3 4 5
41499
久草视频新免费_日韩视频一中文字暮_欧美三级片