0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 5 years have passed since last update.

mysqlの使い方

Posted at

###起動
mysql -u mysqlユーザ名 -p[password] DB名

Ctrl + r で履歴を遡れる

###データベースを確認
show databases;

DB使用

use [データベース名]

テーブル閲覧・しよう

show tables;
select ~~ from [テーブル名];

更新

update [テーブル名] set [カラム名] = [変更後の値] (where [カラム名] = ~~);

###ページをスタイリッシュに
pager less -n -i -S

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?