Why not login to Qiita and try out its useful features?

We'll deliver articles that match you.

You can read useful information later.

138
107

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 1 year has passed since last update.

MySQLใฎใŠใ™ใ™ใ‚ไพฟๅˆฉใ‚ฏใƒฉใ‚คใ‚ขใƒณใƒˆใƒ„ใƒผใƒซ

Last updated at Posted at 2019-07-18

ใƒ‡ใƒผใ‚ฟใƒ™ใƒผใ‚นใฎGUIใ‚ฏใƒฉใ‚คใ‚ขใƒณใƒˆใƒ„ใƒผใƒซใฃใฆใŸใใ•ใ‚“ใ‚ใ‚Šใพใ™ใ‚ˆใญใ€‚
ใ€Œๆผขใฏ้ป™ใฃใฆใ‚ณใƒžใƒณใƒ‰๏ผใ€ใฃใฆๆ–นใ‚‚ใ„ใ‚‹ใ‹ใจใฏๆ€ใ„ใพใ™ใŒใ€็งใฏไพฟๅˆฉใชใƒ„ใƒผใƒซใฏ็”จ้€”ใซๅˆใ‚ใ›ใฆไฝฟใ„ใŸใ„ๆดพใงใ™ใ€‚
๏ผˆใ‚‚ใกใ‚ใ‚“ใ‚ณใƒžใƒณใƒ‰ใ‚’็Ÿฅใ‚‰ใชใใฆใ‚‚ใ„ใ„ใจใ„ใ†ๆ„ๅ‘ณใงใฏใชใ„ใงใ™๏ผ‰

ไปŠๅ›žใฏMySQLใฎใŠใ™ใ™ใ‚ใ‚ฏใƒฉใ‚คใ‚ขใƒณใƒˆใƒ„ใƒผใƒซใฎใ”็ดนไป‹ใงใ™ใ€‚

Mac็‰ˆ

Sequel Aceใ€€โ˜…ใ‚ชใ‚นใ‚นใƒก

็งๅ€‹ไบบ็š„ใซใฏMacใ ใจใ“ใ‚ŒใŒไธ€็•ชไฝฟใ„ใ‚„ใ™ใ„ใงใ™ใ€‚
่ปฝใใฆๅคงไฝ“ใฎๆฉŸ่ƒฝใฏใคใ„ใฆใ„ใพใ™ใ—ใ€dumpใชใฉใ‚‚ๅ–ใ‚Šใ‚„ใ™ใ„ใงใ™ใ€‚
https://sequel-ace.com

โ€ปไปฅๅ‰ใฏSequel Proใ‚’ๅˆฉ็”จใ—ใฆใ„ใพใ—ใŸใŒใ€
2021/06/01็พๅœจใงใ€้–‹็™บใŒๆญขใพใฃใฆใ„ใ‚‹ใŸใ‚ไน—ใ‚Šๆ›ใˆใพใ—ใŸใ€‚
็พ็ŠถใฏๅพŒ็ถ™ใ‚ขใƒ—ใƒชใฎSequel Aceใฎไฝฟ็”จใ‚’ใŠใ™ใ™ใ‚ใ—ใพใ™ใ€‚

ๅŸบๆœฌ็š„ใซใฏSequel Proใ‹ใ‚‰ใƒ•ใ‚ฉใƒผใ‚ฏใ—ใŸใƒ—ใƒญใ‚ธใ‚งใ‚ฏใƒˆใฎใ‚ˆใ†ใชใฎใงUI/UXใ‚‚ใปใผๅŒๆง˜ใซ้•ๅ’Œๆ„Ÿใชใไฝฟ็”จใงใใพใ™ใ€‚
Sequel Proใงไฝœๆˆใ—ใŸใ‚ณใƒใ‚ฏใ‚ทใƒงใƒณใฎใŠๆฐ—ใซๅ…ฅใ‚Šใ‚‚plistใจใ—ใฆExportใ™ใ‚ŒใฐSequel Aceใฎๆ–นใงimportใงใใพใ—ใŸใฎใงไน—ใ‚Šๆ›ใˆใ‚‚ๅฎนๆ˜“ใงใ™ใ€‚
ใพใŸMac App Storeใงใ‚‚ๅ…ฌๅผใซใ‚ณใƒณใ‚นใ‚ฟใƒณใƒˆใซใ‚ขใƒƒใƒ—ใƒ‡ใƒผใƒˆใŒใ•ใ‚Œใฆใ„ใ‚‹ใฎใงๅฎ‰ๅฟƒ้ขใ‚‚้ซ˜ใ„ใงใ™ใ€‚

MySQL Workbench

Windows็‰ˆใ‚‚ใ‚ใ‚‹ใฎใงไฝฟใฃใฆใ„ใ‚‹ๆ–นใฏๅคšใ„ๅฐ่ฑกใงใ™ใ€‚


Windows็‰ˆ

HeidiSQLใ€€โ˜…ใ‚ชใ‚นใ‚นใƒก

่ปฝใใ€ใ‚ฏใƒฉใƒƒใ‚ทใƒฅใ™ใ‚‹ใ“ใจใ‚‚ใปใผใชใ„ใ€ใ‚ทใƒงใƒผใƒˆใ‚ซใƒƒใƒˆใฎๅ‰ฒใ‚Šๅฝ“ใฆใ€csvใฎใ‚คใƒณใƒใƒผใƒˆใชใฉ
ๆง˜ใ€…ใช้ซ˜ๆฉŸ่ƒฝใŒๅคšใๅ€‹ไบบ็š„ใซใฏใ™ใ”ใ้‡ๅฎใ—ใฆใ„ใพใ™ใ€‚

Navicat

ๆœ‰ๅ„Ÿใซใชใ‚‹ๅ‰ใฏใ‚ˆใ‹ใฃใŸใ‚“ใงใ™ใ‘ใฉใญใƒผใ€‚

MySQL Workbench

WindowsใจMacไธกๆ–นใ‚ใ‚‹ใฎใฏไธ€ใคใฎ้ญ…ๅŠ›ใงใ™ใญใ€‚

A5:SQL Mk-2

ERๅ›ณใ‚’ไฝœๆˆใงใใ‚‹ๆ็”ปๆฉŸ่ƒฝใŒใ‚ใฃใŸใ‚ŠๅฎŸใƒ†ใƒผใƒ–ใƒซใ‹ใ‚‰ใƒชใƒใƒผใ‚นERๅ›ณ็”ŸๆˆใŒใงใใŸใ‚ŠใจไพฟๅˆฉใŒใชๆฉŸ่ƒฝใŒใ‚ใ‚Šใ€windowsๆดพใฎไบบใซใฏๆ นๅผทใ„ไบบๆฐ—ใŒใ‚ใ‚‹ๅฐ่ฑกใงใ™ใ€‚
ๅ€‹ไบบ็š„ใซใฏใ€ใชใ‚“ใ‹UIใจใ‹ไฝฟใ„ๅฟƒๅœฐใŒใ‚ใพใ‚Š็›ธๆ€งใŒ่‰ฏใใชใ‹ใฃใŸใงใ™โ€ฆใ™ใฟใพใ›ใ‚“


ใƒ–ใƒฉใ‚ฆใ‚ถ็‰ˆ

phpMyAdmin

ใ‚ใพใ‚Šไฝฟใ†ใ“ใจใฏใชใ„ใ‹ใ‚‚ใ—ใ‚Œใพใ›ใ‚“ใŒใ€ใƒ—ใƒฉใƒƒใƒˆใƒ•ใ‚ฉใƒผใƒ ้–ขไฟ‚ใชใใƒ–ใƒฉใ‚ฆใ‚ถใงไฝฟ็”จใงใใ‚‹ใฎใงใ€ไฝฟ็”จ็’ฐๅขƒใซใ‚ˆใฃใฆใฏๅ‘ใ„ใฆใ„ใ‚‹ๆ™‚ใ‚‚ใ‚ใ‚‹ใ‹ใ‚‚ใ—ใ‚Œใพใ›ใ‚“ใ€‚

ERๅ›ณใ‚’ๆ›ธใใƒ„ใƒผใƒซใฏใ€็•ชๅค–็ทจใ€‘

wwwsqldesigner

A5:SQLใฏERๅ›ณใ‚’ๆ›ธใๆฉŸ่ƒฝใŒใ‚ใฃใŸใ‚ŠใจไธŠ่จ˜ใง่จ˜่ผ‰ใ—ใพใ—ใŸใŒใ€็งใฏๆœ€่ฟ‘ใฏไปฅไธ‹ใฎใƒ„ใƒผใƒซใ‚’ใ‚ˆใไฝฟใ„ใพใ™ใ€‚
dockerใ‚‚ใ‚ใ‚Šใพใ™ใ—ใ€Webใ‚ตใƒผใƒ่ตทๅ‹•ใ—ใฆๅฎŸ่กŒใ™ใ‚‹ใ“ใจใ‚‚ใงใใ‚‹ใฎใงไพฟๅˆฉใงใ™ใ€‚

138
107
3

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
a-nishimura

@a-nishimura(aki)

ใƒ•ใƒชใƒผใƒฉใƒณใ‚นใ€‚ใƒ—ใƒญใ‚ฐใƒฉใƒžใ€‚ไธปใซweb็ณปใฎใ‚ฝใƒ•ใƒˆใ‚ฆใ‚งใ‚ขใ‚จใƒณใ‚ธใƒ‹ใ‚ขใงใ™ใ€‚

Linked from these articles

Comments

Showy1
@Showy1(Sho Y)

MySQLใ‚ฏใƒฉใ‚คใ‚ขใƒณใƒˆใƒ„ใƒผใƒซใฎใพใจใ‚ใ‚’ใ€ใ‚ใ‚ŠใŒใจใ†ใ”ใ–ใ„ใพใ™ใ€‚
Sequel Pro ใฏ้–‹็™บใŒๆญขใพใฃใฆใ„ใ‚‹๏ผˆ https://github.com/sequelpro/sequelpro ๏ผ‰ใจๆ€ใ†ใฎใงใ€
ๅพŒ็ถ™ใ‚ขใƒ—ใƒชใฎ Sequel Ace ็ญ‰ใ‚’็”จใ„ใŸๆ–นใŒ่‰ฏใ„ใ‹ใ‚‚ใ—ใ‚Œใพใ›ใ‚“ใ€‚
ๅ‚่€ƒ๏ผš
https://qiita.com/ucan-lab/items/b1304eee2157dbef7774

2
a-nishimura
@a-nishimura(aki)

@Showy1 ใ•ใ‚“

ใ‚ณใƒกใƒณใƒˆใ‚ใ‚ŠใŒใจใ†ใ”ใ–ใ„ใพใ™๏ผ
่ฟฝ่จ˜ใ•ใ›ใฆใ„ใŸใ ใใพใ™๏ผ

0
kzkskmt
@kzkskmt

sequel aceใฏ่‡ดๅ‘ฝ็š„ใชใƒใ‚ฐใŒ่ฆ‹ใคใ‹ใฃใฆใŠใ‚Šใ€็พๆ™‚็‚นใงfixใ•ใ‚Œใฆใชใ„ใฎใง้ฟใ‘ใŸๆ–นใŒใ„ใ„ใงใ™ใ€‚
https://github.com/Sequel-Ace/Sequel-Ace/issues/1797#issuecomment-1872130886

0

Let's comment your feelings that are more than good

Qiita Advent Calendar is held!

Qiita Advent Calendar is an article posting event where you post articles by filling a calendar ๐ŸŽ…

Some calendars come with gifts and some gifts are drawn from all calendars ๐Ÿ‘€

Please tie the article to your calendar and let's enjoy Christmas together!

138
107

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

Login to continue?

Login or Sign up with social account

Login or Sign up with your email address