I opened PopSQL and the there is a red dot at my connection. If I go into it and test it, it tells me Unknown database 'giraffe'. I opened mySQL and typed 'show
I am trying to find the average number of rental books for each quarter. Rental(RegNum, DateBorrowed, DateReturned) Books(RegNum, BookName, Category) What i am
I have a table called products which has a varchar column called name encoded in latin1_swedish_ci. I'm trying to make a search query in order to filter product
I am looking for some help. I need to create a dependent dropdown based on the previous input. Everything works in my code, and it sends and receives data from
I'm working on a student project. I'm building an e-commerce website to sell soaps, and the error message I'm getting is the following. Fatal error: Uncaught E
I'm trying to make a secure connection with my database I wrote the following code: <?php // form filled? if (isset($_POST['submit'])) { $user = 'gebrui
I am running a MySql 8 DB and using Visual Studio 2017. Here is my VB code. Try With prm .Direction = ParameterDirection.Input .MySqlDbType
i have two 3 files 1 for the database and the others is for add the data and the index but my adddata.php doesn't catch the value and just ret
I am building a chat application like discord, I can successfully send a chat message, and i am trying to send emojis, files like image, pdf, docx, links. How t
after 4 days of tries and researchs over the web I can't make my wishes working. Any help would be appreciated !Performed on MYSQL WORKBENCH I got a DB made of
I have an API: https://baseballsavant.mlb.com/gf?game_pk=635886 I want to fetch the data from here (which is in JSON format) using a python code and create a ta
I want a select that if/exists it returns the 'link' value instead of regular output. so instead of '1' it returns the 'link' Is that possible? SELECT IF( E
I am trying out prepared statements, but the below code is not working. I am getting the error: Fatal error: Call to a member function execute() on a non-objec
I would like to configure PhpMyAdmin to access only one database through one user. I tried before to restrict access via .htaccess using this answer from 2013 b
I have a problem with my PHP and MySQL code. I was creating a private messaging system but unfortunately, each time I reload the page, the las
I have made a query on a data and it returns a result: [ RowDataPacket { 'COUNT(t.id)': 2 } ] How can I access it like the count number? I have tried result.COU
I have this table state num ------------------------- ca 20 ny 30 ca 50 ca 10 ny 70 ny 90 What I want is to p
I have installed a third party framework fate, and mysql has been installed inside this framework, at the following path: /data/projects/fate/common/mysql/mysql
I have following query to handle null value and flag those based on two table join however c.pure_proc_flag is null then 0 else 1 does not provide the result
conn = mysql.connector.connect(host="localhost", user="root", password="", database="Attendance") my_cursor = conn.cursor() my_curso