Category "mysql"

SSL connection error when trying to connect to mysql Aurora via the mysql CLI

I will preface by saying I can connect to the DB instance when I'm not trying to go over SSL. I am following this guide here http://docs.aws.amazon.com/Amazo

Inno Setup Script For MySQL 5.7 silent install

I want to silent install MySQL 5.7 from Inno Setup so i have use this link, but this for MySQL 5.5 not for 5.7. I have MySQInstallerConsole form command prompt

How to use window functions to get the cumulative count of two columns based on the value from one column?

I'm trying to get the cumulative count of previous records for two player columns where the player ID exists in in one of the previous columns. As an example I'

How can Select date(dd/mm/yyyy) in ascending order in sql

I want To Select stockDate in ASC Order My Table Structure is.:-

Authentication plugin error when connecting to mySQL

I am learning PHP and just installed Sequel Pro. I am trying to make a connection but it is giving a long error but last line says MySQL said: Authentication p

Table doesn't exist After Creating a Temp Table

Hi I am creating a temp table and insert a record using CREATE TEMPORARY TABLE temp_table_extension_details ( `Id` int NOT NULL,

Retrieve last inserted id with Mysql

Good day, I am willing to retrieve the id value of a freshly inserted row in Mysql. I know there is mysqli_insert_id function, but: I can't specify the table Ma

Variable retrieved from json data doesn't seem right

I retrieve data from mysql server and one of the fields is an int value (1 or 0 ) and it's printed right (1 or zero ) but when I try to apply an if condition on

Single Large Transaction VS Multiple Small Transaction

I am designing a system where users can select/ insert/update/ delete multiple rows of multiple tables multiple times (n times in a loop based on some logic, th

WAMP Virtual Host not working

I am using a wamp version 2.5 My Apache is 2.4.9 PHP: 5.5.12 MySQL: 5.6.17 I have these configurations: On my httpd.conf # Virtual hosts Include conf/extra/h

failed to open file in mysql database

i downloaded employees database from github that recommend mysql in its website but it has error in importing . how can i fix it? i dont think it is corrupt dat

Sequelize does not include attributes (MySQL)

i am trying to create select with "custom" attribute. Everything is working fine except that the "custom" attribute is not included. Query is generated correctl

I'm trying to link between Firebase Authentication and MySQL using a new scenario

I want to take your opinion about this weird scenario before applying it. I'm using FirebaseUI. The users' table ID NAME EMAIL PHONE_NUMBER PHOTO_URL CREATED S

Can I put arbitrary text in SQL comments when using ODBC?

Consider a table defined by CREATE TABLE Example (id INTEGER) and an INSERT statement for adding tuples to Example, having a single quote in a SQL comment:

how to see if database exists with PDO [duplicate]

So I recently decided to switch to PDO due to the mysqli prepared statement complexity and irregularities. This was my mysqli function to test

How to solve MySQL error which occurs while loading image

When I am opening a local connection in MySQL, an error occurring while loading image search_sidebar.png.How can I solve this problem in MySQL? I have attached

Update database table through jsp to jsp

View.jsp this jsp to fetching the data from the database. <form method="post" action="updatedemo.jsp"> <table width="50%" border="1" align="center"

PHP: Calling MySQL Stored Procedure with Both INPUT AND OUTPUT Parameters (NOT "INOUT")

From PHP I would like to call a stored procedure in MySQL. The procedure takes input and output parameters -- not "INOUT" parameters. For a simple example, sa

How to run Sequelize migrations inside Docker

I'm trying to docerize my NodeJS API together with a MySQL image. Before the initial run, I want to run Sequelize migrations and seeds to have the tables up and

Endless loop in mysql_secure_installation

After installing mysql-server, I did sudo mysql_secure_installation in order to secure the server deployment. I indicate that I would like to setup VALIDATE PA