LoginSignup
0
0

More than 3 years have passed since last update.

@kyanonbolt(Mac queen)

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
Sign upLogin
0
0