mysql 的基础知识_MySQL

这边博客，纯为了摘录 mysql 常用的一些操作，如果你已经懂了，可以忽略，谢谢。

最基本的mysql操作

1、查询mysql 的版本和当前时间信息

select version(),current_date,current_time,current_timestamp;

执行一条新的命令 将一个多行命令中，等待下一行的输入。 等待下一行的输入，其以 ’ 结束 等待下一行的输入，其以 ”结束 等待下一行的输入，其以 ` 结束 等待下一行的输入，其以/*结束(注释）

2、查看数据库 show databases;

Related labels：

mysql information blog basic knowledge

source：php.cn

Previous article：php连接不上mysql但mysql命令行操作正常的解决方法_MySQL Next article：MySql中游标使用总是多循环一次的解决方法_MySQL

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

• BlackRock Labels BTC a Unique Diversifier
  2024-09-20 15:51:33
• Internet Computer (ICP) Price Prediction: Will ICP Price Hit $24?
  2024-09-20 15:47:32
• Worldcoin (WLD) Price Prediction 2022-23
  2024-09-20 15:45:32
• Top Meme Coins to Invest In Today
  2024-09-20 15:39:32
• Floki (FLOKI) Price Prediction: Will the Revamped Marketing Help Floki Catch Up on October Gains?
  2024-09-20 15:38:32
• Next Cryptocurrency to Explode: 5 Coins to Add to Your Watchlist
  2024-09-20 15:27:32
• Dogecoin: From an Internet Meme to a Digital Currency with a Billion-Dollar Market Capitalization
  2024-09-20 15:26:32
• ZChains Unveils a Series of Exciting Updates and Launches to Enhance Its Ecosystem
  2024-09-20 15:12:32
• How to download the Apple version of Little Fox Payment Platform
  2024-09-20 14:53:01
• How beginners trade on MetaMask and its advantages and disadvantages
  2024-09-20 14:51:01

Latest Issues

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

How to query multiple select elements stored in database Querying areas of expertise (stored as an array of any selected items) does not work. I'm ...

From 2024-04-04 13:18:46

0

1

304

modal counter I'm trying to create a modal with a +/- counter. However, I think since the state is in th...

From 2024-04-03 14:16:44

0

1

298

Uncooperative Boolean logic I'm running into an issue with my website that I've been trying to fix for at least a few ...

From 2024-04-02 13:34:26

0

1

319

Custom hook (like) macros in React? I've only recently begun to understand what macros are in a Lisp context. My understanding...

From 2024-04-02 13:15:12

0

1

349

Related Topics

More>

• mysql modify data table name
• MySQL creates stored procedure
• The difference between mongodb and mysql
• How to check if mysql password is forgotten
• mysql create database
• mysql default transaction isolation level
• The difference between sqlserver and mysql
• mysqlforgot password