Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > SQL 必知必会笔记15创建和操纵表

SQL 必知必会笔记15创建和操纵表

WBOY
Release： 2016-06-07 17:39:05
Original
1010 people have browsed it

创建表的两种办法： 使用DBMS 提供的交互式创建和管理数据库表的工具； 直接用SQL 语句创建。 表创建基础 创建表示例： Products 2 ( vend_id CHAR ( 10 ) NOT NULL , 5 prod_name CHAR ( 254 ) NOT NULL , 6 prod_price DECIMAL ( 8 , 2 ) NOT NULL , 7 pro

创建表的两种办法：

  • 使用DBMS 提供的交互式创建和管理数据库表的工具；
  • 直接用SQL 语句创建。

    • 表创建基础

    创建表示例：

    Products 2 ( vend_id CHAR(10) NOT NULL, 5 prod_name CHAR(254) NOT NULL, 6 prod_price DECIMAL(8,2) NOT NULL, 7 prod_desc VARCHAR(1000) NULL 8 ); ，

    Related labels：
    Jianhe Must know manipulate notes
    source：php.cn
    Previous article： SQL Server客户端工具到底使用的是哪个provider呢？ Next article： SQL索引学习-索引结构
    Statement of this Website
    The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
    Latest Articles by Author
    Latest Issues
    The query and formula form the entire table, with new columns, where the new columns are formulas involving other conditional column values EDIT: The formula should be the "value" column - the "value" column wi...
    From 2024-04-06 21:23:40
    0
    2
    530
    Sudoku checker not working? Can anyone help me identify the error? I tried everything on the online editor but still get the error. But when I do this on VSC...
    From 2024-04-06 21:21:07
    0
    1
    474
    How to solve the mysterious white space at the bottom of the page in CSS I'm trying to build a simple webpage using Bootstrap and D3, but I don't know how to get r...
    From 2024-04-06 20:22:15
    0
    1
    454
    Problems encountered when using opentbs to generate odt files: values ​​of the same key are displayed in the same row instead of separate columns. I'm using a library called OpenTbs to create odt using PHP, I'm using it because columns a...
    From 2024-04-06 20:18:18
    0
    1
    483
    for loop randomly goes from 1 to 0 Basically, every time the page is refreshed, the for loop has the potential to change from...
    From 2024-04-06 16:48:14
    0
    1
    393
    Related Topics
    More>
    Popular Recommendations
    Popular Tutorials
    More>
    Related Tutorials
    Popular Recommendations
    Latest courses
    Latest Downloads
    More>
    Web Effects
    Website Source Code
    Website Materials
    Front End Template