DWE

show databases; use mysql; show tables; select * from component; describe component; create database sql_intro; show databases; use sql_intro; create table emp_details (Name varchar(25), Age int, gender char(1), doj date, city varchar(15), salary float); describe emp_details; insert into emp_details  values("Jimmy",35,"M","2005-05-30","Chicago",70000), ("Shane",30,"M","1999-06-25","Seattle",55000), ("Marry",28,"F","2009-03-10","Boston",62000), ("Dwayne",37,"M", "2011-07-12","Austin", 57000), ("Sara",32,"F","2017-10-27","New York",72000), ("Ammy",35,"F","2014-12-20","Seattle",80000); select * from emp_details; select distinct city from emp_details; select count(name) as count_name from emp_details; select avg(salary) from emp_details; select name, age...

  BASIC OF REDUX: ##### Create a project with react. Then, 1) npm run start 2) npm install redux react-redux 3) create actions folder inside src folder. Create index.js file inside actions folder. 4) create reducers folder inside src folder and create upDown.js file inside reducers folder. 5) create store.js file inside src folder. 6) In app.js write: ``` import React from 'react' import "./App.css" const App = () => {   return (     <>       <div className="container">         <h1>Increment / Decrement counter</h1>         <h4>Using react and redux</h4>         <div className="quantity">           <a className="quantity__minus" title='Decrement'><span>-</span></a>           <input type="text" name='quantity' className='quantity__input'/>         ...

 Try the following code in terminal of project folder:  npx clear-npx-cache Then, run:  npx create-react-app projectname

 This error occurs as because may be you have used the following code:  const MongoStore= require('connect-mongo')(session); and app . use ( session ({     secret : ' keyboard cat ' ,     resave : false ,     saveUninitialized : false ,     store: new MongoStore({ mongooseConnection: mongoose.connection }) })); Now this is happening as because syntax have been changed (see the documentation here: documentation ) Solution that worked for me:  Use this:  const MongoStore = require ( ' connect-mongo ' ); and,  app . use ( session ({     secret : ' keyboard cat ' ,     resave : false ,     saveUninitialized : false , //false means don't create a session untitl it is stored     // store: new MongoStore({ mongooseConnection: mongoose.connection })     store : MongoStore . create ({         mongoUrl : process.env. MONGO_URI     }) }));

 Write: app . engine ( ' .hbs ' , exphbs. engine ({ defaultLayout : ' main ' , extname : ' .hbs ' })); Instead of  app . engine ( ' .hbs ' , exphbs({ defaultLayout : ' main ' , extname : ' .hbs ' }));

  In the root directory: mkdir backend cd backend then type: npm init -y npm install express cors mongodb dotenv npm install -g nodemon write the following line in package.json after "main":"index.js" : "type":"module", Now, create server.js file inside backend folder. Write the following code in server.js file: // starts here import express from "express"; import cors from "cors" import restaurants from "./api/restaurants.route.js" const app = express(); app.use(cors()); app.use(express.json()); app.use("/api/v1/restaurants", restaurants); app.use("*",(req,res) => res.status(404).json({error: "Not found!"}) ); export default app; // ends here create .env file and write: RESTREVIEWS_DB_URI=mongodb+srv://ipritpritam:ipritpritam@cluster0.twcdr.mongodb.net/sample_restaurants?retryWrites=true&w=majority RESTREVIEWS_NS=sample_restaurants PORT=5000 then, create index.js in the backend ...

  Type 'powershell' in the command prompt and open by clicking 'run as administrator' and type the following command: Set-ExecutionPolicy RemoteSigned -Scope CurrentUser and press Y for yes That's it. Hopefully this will work.

 In your html file write: <! DOCTYPE html > < html lang = " en " > < head >     < meta charset = " UTF-8 " >     < meta http-equiv = " X-UA-Compatible " content = " IE=edge " >     < meta name = " viewport " content = " width=device-width, initial-scale=1.0 " >     < title >Custom Radio Button Design</ title >     < link rel = " stylesheet " href = " style.css " > </ head > < body >      < div class = " form-group " >          < label for = " gender " class = " text-light " >Gender</ label >          < div class = " radio inline " >              < input type = " radio " id = " radio-2 " name = " gender " value = " Male " >              < label for = " radio-2 " class = " radio-label "...

How to setup express project with other dependencies 1) Create a empty folder with a name of your project 2) Inside the folder, create a file called server.js 3) Now, in command prompt type npm init and press enter, just write the description of your choice and write the keywords of your choice or just press enter. It will create a package.js file inside your project folder. Now inside the package.js file write these: "scripts": {     "test": "echo \"Error: no test specified\" && exit 1",     "start": "nodemon server.js"   } Here you can see we have typed "nodemon" before server.js. 4) In command prompt write the following command: npm i express morgan nodemon ejs body-parser dotenv mongoose axios This will install express, morgan, nodemon, ejs, body-parser, dotenv, mongoose & axios inside the node_modules folder. What these does? express: to rapidly develop the node application morgan: morgan helps to...

1) composer require laravel/ui 2) php artisan ui vue 3) npm install && npm install vue-router vuetify 4) in welcome.blade.php's body write div#app 5) npm run watch (     for vue error:      in webpack use .vue() &     For getting Vue.use is not a function:     For those who would be in the same case, in your app.js file, you must replace  the line :     window.Vue = require('vue');     With :     window.Vue = require('vue').default; ) Reference:  https://www.youtube.com/watch?v=jPpsT6KFDl4&list=PL9fcHFJHtFabrQMoRlfit6kSxXZE5YWU9&index=1 Con...