Yahoo Web Search

Search results

1. Top results related to create a database in mysql

   • Create a MySQL database in python

     Top Answer

     Answered Nov 17, 2015 · 10 votes

     Creating a database in Python.

     import MySQLdb-db = MySQLdb.connect(host="localhost", user="user", passwd="password")-c = db.cursor()c.execute('create database if not exists pythontest')db.close()

     Using the CREATE DATABASE MySQL statement.

     This is not common practice as it will attempt to create that database each time you run the script.

     Note - you can then use db.select_db('pythontest') to select that table and c.execute('create table statement') to create a table

     Check all answers on Stack Overflow

     1/5

   • Create a drop-down list that options fetched from a MySQL database in PHP

     In many scenarios, we may need to create a dropdown input that can display all the options consistent with the current state of the database. This form of input is used many times in real life and the following examples may help to understand the same.

     • A set of students who have unique registration numbers.
     • A set of branch names and their branch ids.
     • A list of categories to which a particular product must belong.

     In this article, we will create a drop-down with a list of categories to which a particular product must belong.

     Approach: In each of these examples, if we use a drop-down menu that fetches data from the database the user will be able to enter data more accurately and the UI will be more user-friendly. 

     We need the following

     • A database with a table of categories and another table of products with a foreign key to the category ID to which the particular product belongs.
     • HTML form that accepts the data.

     Steps:

     Database creation:

     • Switch on Apache and MySQL from the XAMPP control panel.

     Check the images on geeksforgeeks

     Click on “Start” buttons

     • Create a database “example_store” by clicking on the new button.

     Check the images on geeksforgeeks

     CLick on the “new” button to make a new database

     • Enter the database name and click “Create”.

     Check the images on geeksforgeeks

     Create a new database with name “example_store”

     • Click on the SQL tab and paste the following code and click “GO”.

     Check the images on geeksforgeeks

     To run SQL and prepare the database

     MySQL queries:

     -- Table structure for table `category`CREATE TABLE `category` ( `Category_ID` int(11) NOT NULL, `Category_Name` varchar(255) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;-- Dumping data for table `category`INSERT INTO `category` (`Category_ID`, `Category_Name`) VALUES(1, 'Category A '),(2, 'Category B');Table structure for table product...

     • The drop-down currently shows only Category A and Category B.If we add few more Categories in the Database, we get them displayed on the dropdown. After inserting more values in Table category.
     • On reloading webpage
     • Inserting a new Product: We can insert a product C1 in the following manner.
     • We get an alert message and the table product gets updated

     Check all answers on Geeksforgeeks

     2/5

   • Create multiple tables of the same type in a database (MySQL/MariaDB)

     Top Answer

     Answered Apr 26, 2013 · 0 votes

     build one you like - keep it empty...

     then:

     create table new_table as select * from existing_table;-

     Check all answers on Stack Overflow

     3/5

   • Create MySQL database with sql file import in a single line

     Top Answer

     Answered Jan 05, 2021 · 5 votes

     .sql files are generally LITERALLY just a sequence of SQL DDL/DML queries. If it was created by mysqldump, then it should contain EVERYTHING needed to recreate the database from the ground up, including the necessary create db and create table queries.

     if they're not there, you can manually add them to the top of the file yourself via simple file concatenation/modification, e.g.

     echo 'create database foo;' > new.sqlcat otherstuff.sql >> new.sqlmysql < new.sql

     Check all answers on Stack Overflow

     4/5

   • Also try

     create a database in mysql workbench	how to create a database in mysql using python
     command to create a database in mysql	how to create a database in mysql example
     how do you create a database in mysql	how to create a database in mysql using php
     create a database in mysql command line	how to create a database in mysql ubuntu

     5/5

   Show moreShow less

2. www.mysqltutorial.org › mysql-create-databaseMySQL CREATE DATABASE - Creating a New Database in MySQL

   www.mysqltutorial.org › mysql-create-database

   • Cached

   This tutorial shows you step by step how to use the MySQL CREATE DATABASE statement to create a new database in the MySQL server.

3. www.w3schools.com › mysql › mysql_create_dbMySQL CREATE DATABASE Statement - W3Schools

   www.w3schools.com › mysql › mysql_create_db

   • Cached

   The CREATE DATABASE statement is used to create a new SQL database. Syntax. CREATE DATABASE databasename; CREATE DATABASE Example. The following SQL statement creates a database called "testDB": Example Get your own SQL Server. CREATE DATABASE testDB; Tip: Make sure you have admin privilege before creating any database.

4. dev.mysql.com › 8 › en5.3.1 Creating and Selecting a Database - MySQL

   dev.mysql.com › 8 › en

   • Cached

   5.3.1 Creating and Selecting a Database. If the administrator creates your database for you when setting up your permissions, you can begin using it. Otherwise, you need to create it yourself: mysql> CREATE DATABASE menagerie;

5. dev.mysql.com › doc › refman15.1.12 CREATE DATABASE Statement - MySQL

   dev.mysql.com › doc › refman

   • Cached

   CREATE DATABASE creates a database with the given name. To use this statement, you need the CREATE privilege for the database. CREATE SCHEMA is a synonym for CREATE DATABASE. An error occurs if the database exists and you did not specify IF NOT EXISTS.

6. dev.mysql.com › doc › mysql-getting-startedMySQL :: Getting Started with MySQL

   dev.mysql.com › doc › mysql-getting-started

   • Cached

   May 21, 2024 · Creating a table inside a database. First, pick the database in which you want to create the table with a USE statement: mysql> USE pets Database changed. The USE statement tells MySQL to use pets as the default database for subsequent statements. Next, create a table with a CREATE TABLE statement:

7. www.mysqltutorial.net › mysql-create-databaseCreating Database in Mysql - MySQL Tutorial

   www.mysqltutorial.net › mysql-create-database

   • Cached

   You can create a database in MySQL in two methods: Using MySQL Command Line Client. Using MySQL Workbench. Let’s check these methods one by one. 1) Creating MySQL database using MySQL Command Line Client. For creating a new database via MySQL Command Line Client you need to follow the below steps:

8. www.databasestar.com › mysql-create-databaseHow to Create a Database in MySQL - Database Star

   www.databasestar.com › mysql-create-database

   • Cached

   Jun 9, 2023 · To create a new database in MySQL, you can use the CREATE DATABASE command. The simple version looks like this: CREATE DATABASE database_name; The full command has a lot more options you can set: CREATE DATABASE [IF NOT EXISTS] database_name [DEFAULT] { CHARACTER SET charset_name | COLLATE collation_name | ENCRYPTION {'Y' | 'N'} }