Skip to main content
658,067 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
-2 votes
0 answers
23 views

Sorry if this is a silly question. I'm running a local Wordpress website through WP engine with a MySQL database through AdminNEO on my browser and made a terrible mistake of deleting "root" ...
First Last's user avatar
  • 1
-4 votes
0 answers
108 views

I am building a time card calculator using HTML, JavaScript, Ajax, and PHP. Users can enter working hours for each day of the week, including: Start time (hours, minutes, AM/PM) End time (hours, ...
Nell Howard's user avatar
  • 1
Advice
0 votes
6 replies
90 views

Earlier, I set the time field, int type, to the default time value in unix format. When adding an entry, the time field accepts the time since 1970 in unix format. I'm trying to do the same with the ...
Дмитрий Варзанов's user avatar
  • 99
-5 votes
0 answers
54 views

I’m stuck on this since morning and would really appreciate some help. I created a new AWS RDS MySQL 8.4 instance. ✅ I can connect successfully using MySQL Workbench ✅ I can connect from a Node.js + ...
NITESH KUMAR's user avatar
  • 7
-3 votes
0 answers
50 views

I am using AWS RDS as and I have created a user with only SELECT permission. The user should not be able to get the dump but if some flags like: --single-transaction --skip-lock-tables --no-...
Sanchit's user avatar
  • 1
-2 votes
0 answers
85 views

I'm trying to run this code: annot <- getBM( filters = "ensembl_gene_id", attributes = c("ensembl_gene_id", "description", &...
Claire's user avatar
  • 11
-1 votes
1 answer
85 views

I currently have 3 tables: CREATE TABLE IF NOT EXISTS customers( ID int unsigned NOT NULL AUTO_INCREMENT primary key, first_name varchar(50), last_name varchar(50), email_address ...
Hearts's user avatar
  • 1
-11 votes
0 answers
113 views

Or this index parameter is "fire and forget" one? If I create a table in MySQL and then assign the FULLTEXT index to it its possible to assign a parser to such index. One can use WITH PARSER ...
Igor's user avatar
  • 6,448
-3 votes
0 answers
93 views

When I select the tab tabIndirizzi, I want the table display all the records from a MySQL table. The connection script is right because it works in other frames, but it doesn't display records in this ...
Albert's user avatar
  • 1
0 votes
0 answers
115 views

I am trying to combine data from two tables using a JOIN, but I am getting duplicate rows in the result instead of the expected output. Here are my tables: Customers CustomerID CustomerName Orders ...
Gaurav Sharma's user avatar
  • 7
-2 votes
2 answers
105 views

I added this row and MySQL showed 1 row(s) affected But even when I counted the rows before and after inserting the row, the count is the same. I believe it means the row was not inserted. Then why ...
VISHNUPRIYA's user avatar
  • 7
0 votes
1 answer
73 views

I am trying to run a Python / Flask / MySQL app but whenever I try to run it (using the command "python -m flask run"), it gives me this error: mysql.connector.errors.ProgrammingError: 1226 ...
Ian McInnes's user avatar
  • 49
0 votes
1 answer
75 views

I would like to left join multiple tables, and in the output have a column that is basically dependent on which table the join came from. So for example, if I have a single join: SELECT B.Name, A....
Andy K.'s user avatar
  • 407
-2 votes
0 answers
132 views

I have a vehicle rental database. I want to get the name, phone number, and total spending of clients who have rented a BMW or a Honda at the branch with the highest number of registered vehicles. My ...
Virginia García-Loygorri's user avatar
  • 13
-2 votes
3 answers
64 views

I'm using this query to identify misstyped usernames: SELECT * FROM import_bk WHERE ( bk_name = BINARY LOWER(bk_name) OR bk_name = BINARY UPPER(bk_name) OR bk_name REGEXP '[0-9]' ) But I always get ...
WeekendCoder's user avatar
  • 1,081

15 30 50 per page
1
2 3 4 5
…
43872