Category "mysql"

How can i list data from table in the database in a browser

I'm developing a web application using reactjs nodejs and mysql database. I want to list the data created in a table i created in the database in the browser

Cannot access mysql database after migrating from Homestead to Sail

I am trying to migrate a Laravel 8 project from Homestead to Sail. Sail seems to be set up correctly since I can get to my project's website locally. But I can'

how to move from sqllite database to mysql database?

i want to move from SQLite database M, MySQL database. if i understood correctly, so i can do it with changing the engine: engine = create_engine('sqlite:///foo

How can I change the type of database in phpmyadmin from mariadb to mysql?

I'm using phpmyadmin with xampp on both of my home and work machines. Some queries didn't work for me when I was working on one computer, but it worked on anot

Cannot read property 'source' of undefined when trying to add association in queryGenerator.SelectQuery in Sequelize ORM

I am trying to generate a query using QueryGenerator.selectQuery. let query = models.sequelize.dialect.QueryGenerator.selectQuery('table', { include: [{

Connector/net does not support server versions prior to 5.0 after downgrading connector/net and mysql server version

Hi I believe there have been some similar topics regarding connector/ net not supporting server versions prior to 5.0. I have been trying add in a connection

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'name' cannot be null

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'name' cannot be null (SQL: insert into products (name, type, img_url, updated_at, created_at) v

Reset MySQL root password using ALTER USER statement after install on Mac

I'm new to the whole Mac experience. I recently installed MySQL and it seems I have to reset the password after install. It won't let me do anything else. Now

Get only records created today in laravel

How do I use the created_at field to get only the records that were created today and no other day or time? I was thinking of a ->where('created_at', '>=

Note: Enabling the database statistics here might cause heavy traffic between the web server and the MySQL server

Note: Enabling the database statistics here might cause heavy traffic between the web server and the MySQL server. I got this error when I tried to add a

Error loading MySQLdb Module 'Did you install mysqlclient or MySQL-python?'

I am using windows 10 command line for a django project using python34 however, I am facing difficulties with SQL. I have already installed mysqlclient using

Find all employees who earn more than the average salary of all employees of their company

I have the following database scheema. employee (employee-name, street, city) works (employee-name, company-name, salary) company (company-name, city) manages (

Apache won't bind to ANY port (OS 10048)

I can't get the Apache service to start. When I try to start it from services I get the following events in event viewer. The Apache service na

backup files to google drive using PHP

I have a server and a domain name on GoDaddy. I want to create a backup for my files to be uploaded on Google Drive So that all my files and my database have

Missing comma before start of a new alter operation. (near "CHARACTER SET")

Mysql - phpmyadmin What's wrong with this query? ALTER TABLE `invoices` CHANGE `status` `status` ENUM('paid','due','canceled','partial','cheque') CHARACTER SE

mysql many tables, multiple columns group by

The table I have configured is as follows. TABLE CAT{ ID number primary key, CATNAME varchar2, ... } <Many-to-Many> TABLE CAT_CHARR{ CATID number

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.:-