Koppelingen in nieuw tabblad openen
  1. 123

    A MySQL script is a file containing a series of SQL statements that can be executed together. This is useful for automating database tasks, such as creating tables, inserting data, or performing backups. MySQL scripts are typically written in plain text files with a .sql extension.

    Creating a MySQL Script

    To create a MySQL script, you can use any text editor to write your SQL statements. Here is an example of a simple MySQL script that creates a database, a table, and inserts some data:

    -- Create a new database
    CREATE DATABASE IF NOT EXISTS mydatabase;

    -- Use the new database
    USE mydatabase;

    -- Create a new table
    CREATE TABLE IF NOT EXISTS customers (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL
    );

    -- Insert some data into the table
    INSERT INTO customers (name, email) VALUES ('John Doe', '[email protected]');
    INSERT INTO customers (name, email) VALUES ('Jane Smith', '[email protected]');
    Gekopieerd.

    Executing a MySQL Script

    Feedback
  2. Stack Overflow
    https://stackoverflow.com › questionsDit resultaat vertalen

    command line - How to run SQL script in MySQL?

    20 jan. 2012 · mysql -u root -proot -D database -e "source …

    • Recensies: 2
      Praktijkvoorbeeld
      mysql> source \home\user\Desktop\test.sql;
      How to execute a SQL file using MySQL command line tool?15 jan. 2013
      How to execute a MySQL command from a shell script?
      Meer resultaten bekijken
    • W3School
      https://www.w3schools.com › mysqlDit resultaat vertalen

      MySQL Tutorial - W3Schools

      Well organized and easy to understand Web building tutorials with lots of examples of how to use HTML, CSS, JavaScript, SQL, Python, PHP, Bootstrap, Java, XML and more.

    • Nanyang Technological University
      https://www3.ntu.edu.sg › ... › MySQL_Intermediate.htmlDit resultaat vertalen

      An Intermediate MySQL Tutorial - Scripting, Data Types, Examples

      Learn how to create and run MySQL scripts, use comments, specific codes, identifiers, literals, and data types in this tutorial. See examples of SQL statements, syntax, and output for various …

    • MySQL Tutorial
      https://www.mysqltutorial.org › mysql-administration › ...Dit resultaat vertalen

      How to Execute an SQL File in MySQL - MySQL Tutorial

      In this tutorial, you will learn various ways to execute an SQL file in MySQL using the mysql command-interface and source command.

    • TutorialsPoint
      https://www.tutorialspoint.com › how-to-run-sql-script-in-mysqlDit resultaat vertalen

      How to run SQL script in MySQL? - Online Tutorials Library

      To run SQL script in MySQL, use the MySQL workbench. First, you need to open MySQL workbench. The snapshot is as follows − Now, File -> Open SQL Script to open the SQL script. …

    • Mensen vragen ook naar
      Feedback
    • thelinuxcode.com
      https://thelinuxcode.com › run-sql-script-mysql-terminalDit resultaat vertalen

      How to Run a SQL Script in MySQL from the Terminal

      27 dec. 2023 · SQL scripting allows automating multi-step workflows for convenient database administration and application development. In this guide, you learned various methods for …

    • Devart
      https://www.devart.com › dbforge › mysql …Dit resultaat vertalen

      How to Run a SQL Script or File in MySQL & MariaDB

      Learn how to run a SQL script or file in MySQL and MariaDB using the command line or GUI. Follow simple steps and boost productivity. Try …

    • MySQL
      https://dev.mysql.com › doc › connector-net › en › ...Dit resultaat vertalen

      MySQL :: MySQL Connector/NET Developer Guide :: 6.8 Tutorial: …

      Depending on the nature of the script, you may need control of the delimiter used to separate the statements that will make up a script. The most common example of this is where you have a …

    • sebhastian
      https://sebhastian.com › mysql-runnin…Dit resultaat vertalen

      MySQL - How to run SQL file or script from the …

      2 nov. 2021 · Learn how to use the mysql command line client to run SQL files or scripts from the terminal, either while connected or not connected …

    Inhoud is gegenereerd met AI. Meer informatie