数据库课程设计试用1.工具篇

怎么打开ｍｙｓｑｌ命令行？（×）

cheers！我能打开MySQL命令行了！！！！！

数据库连接不上？

端口３３０６被占用，于是解除占用，结果出现了２００３错误
原来是之前设置的端口不一致，设置端口均为３３０７，成功连接上去

连接之后尝试使用

PHP storm用法:

Use Basic Completion Ctrl+空格 within HTML, CSS and other files to complete image file names.

Use Emmet to speed up the HTML, XML, or CSS development.
In the Settings/Preferences dialog Ctrl+Alt+S, go to Editor | Emmet and select the Enable Emmet checkbox on the Emmet | HTML, Emmet | CSS, or Emmet | JSX page.
You can use Ctrl+Q(View | Quick Documentation), Ctrl+P(View | Parameter Info), Ctrl+B(Navigate | Declaration), and similar shortcuts not only in the editor but also in the suggestions list while using code completion.使用代码完成时，您不仅可以在编辑器中使用Ctrl+Q（查看|快速文档）、Ctrl+P（查看|参数信息）、Ctrl+B（导航|声明）和类似的快捷键，还可以在建议列表中使用。

In the Live Templates settings, use speed search to find templates with certain text in the template abbreviation, body or description.
Start typing the desired text, and the list of available templates will shrink to show the matching templates only:在Live Templates设置中，使用speed search查找模板缩写、正文或描述中包含特定文本的模板。
开始键入所需的文本，可用模板列表将缩小，仅显示匹配的模板

Press Ctrl+Shift+F7(Edit | Find Usages | Highlight Usages in File) to quickly highlight usages of a certain variable in the current file.
Press F3 and Shift+F3 to navigate through the highlighted usages.
Press Esc to remove highlighting.
按Ctrl+Shift+F7（编辑|查找用法|突出显示文件中的用法）快速突出显示当前文件中某个变量的用法。按F3和Shift+F3在突出显示的用法中导航。按Esc键删除高亮显示。

To quickly wrap a code block in useful constructs, select it in the editor and press Ctrl+Alt+T(Code | Surround With).
The list of available options or wrappers is context-sensitive and depends on the language. For example, you can surround html blocks with tags, and so on.
要在有用的构造中快速包装代码块，请在编辑器中选择它，然后按Ctrl+Alt+T（代码|环绕）。可用选项或包装器的列表是上下文相关的，并且取决于语言。例如，可以用标记围绕html块，等等。
Adjust the PhpStorm tool windows layout to make better use of your screen area.
Toggle between the vertical and side-by-side placement of the tool windows by pressing Ctrl+Click (on Windows and Linux) / ⌘+Click (on macOS) on the splitter.
调整PhpStorm工具窗口布局以更好地利用屏幕区域。
通过按Ctrl+Click（在windows和Linux上）在工具窗口的垂直和并排放置之间切换/⌘+单击拆分器上的（macOS）。

To close all editor tabs, right-click a tab and select Close All Tabs.
To close all tabs except the active one, press Alt (on Windows and Linux) / ⌥ (on macOS) and click the Close button on the active tab.

To quickly find and run an inspection, press Ctrl+Alt+Shift+I and start typing the name of the inspection or its group. Choose an inspection from the suggestion list and specify the scope.要快速查找并运行检验，请按Ctrl+Alt+Shift+I，然后开始键入检验或其组的名称。从建议列表中选择检查并指定范围。
You don’t need to invoke quick documentation explicitly Ctrl+Q. If you hover your mouse pointer over the desired symbol, the quick documentation popup window will show automatically.
To enable this feature, select the Show quick documentation on hover checkbox on the Editor | Code Editing page of the Settings/Preferences dialog Ctrl+Alt+S.
您不需要显式地调用快速文档Ctrl+Q。如果将鼠标指针悬停在所需的符号上，快速文档弹出窗口将自动显示。
要启用此功能，请选中“设置/首选项”对话框Ctrl+Alt+S的“编辑器代码编辑”页面上的“悬停时显示快速文档”复选框。

The Extract Constant refactoring creates a constant that holds the selected expression as the value and replaces its occurrences with the references to this newly created constant.
To invoke this refactoring, select an expression to be replaced with a constant and press Ctrl+Alt+C(Refactor | Extract | Constant).
提取常量重构创建一个常量，该常量将所选表达式作为值保存，并用对新创建常量的引用替换其引用。
要调用此重构，请选择要替换为常量的表达式，然后按Ctrl+Alt+C（重构|提取|常量）。

When using basic code completion Ctrl+空格, you don’t need to type the upper-case letters in CamelHump names. It is enough to type the initial letters of the camel names in lower case, and they will be smartly recognized.
使用“基本代码完成”Ctrl时+空格, 您不需要在驼峰名称中键入大写字母。用小写字母输入骆驼名字的首字母就足够了，它们会被巧妙地识别出来。
To enable this behaviour, clear the Match case checkbox in Settings/Preferences | Editor | General | Code Completion.要启用此行为，请清除设置/首选项|编辑器|常规|代码完成中的匹配大小写复选框。

The Code | Move Statement Up/Down actions are useful for reorganizing code lines, for example for bringing a variable declaration closer to the variable usage.
Select a code fragment and press Ctrl+Shift+向上箭头 or Ctrl+Shift+向下箭头.
The following picture shows the initial location of a code fragment:
代码| Move语句的上/下操作对于重新组织代码行非常有用，例如用于使变量声明更接近变量的用法。
选择代码片段并按Ctrl+Shift键+向上箭头 或Ctrl+Shift组合键+向下箭头.
下图显示了代码片段的初始位置：


To quickly run all methods in a test class, click in the gutter and select Run ‘’:
To run a single method, click in the gutter.
要快速运行测试类中的所有方法，请单击檐槽并选择运行“”：
要运行单个方法，请在檐槽中单击。

To open a file in the editor at a particular line, press Ctrl+Shift+N(Navigate | File), start typing the filename, choose from the suggestion list, and then type : followed by the line number.要在编辑器中的特定行打开文件，请按Ctrl+Shift+N（导航|文件），开始键入文件名，从建议列表中选择，然后键入：后跟行号。

Using options in Settings/Preferences | Editor | Reader Mode settings you can configure how to display code and comments in read-only files and libraries to make them easier to read and understand.
You can enable inlay hints, font ligatures, adjust line height, toggle rendered view of comments, and so on.
使用设置/首选项|编辑器|读卡器模式设置中的选项，您可以配置如何在只读文件和库中显示代码和注释，以使它们更易于阅读和理解。
可以启用镶嵌提示、字体连字、调整行高、切换注释的渲染视图等。

Press Ctrl+F to display the search pane. Press Ctrl+R to add another field where you can type the replace string.
In the Find in Files dialog, you can switch to replace by pressing Ctrl+Shift+R. Similarly, press Ctrl+Shift+F to hide the Replace with field and switch to regular search.
按Ctrl+F以显示搜索窗格。按Ctrl+R添加另一个字段，您可以在其中键入替换字符串。
在“在文件中查找”对话框中，可以按Ctrl+Shift+R切换到替换。同样，按Ctrl+Shift+F隐藏替换为字段并切换到常规搜索。

Enter “/” in the search field of the Search Everywhere (Shift twice) window to search for a list of settings, their options, and plugins.在search Everywhere（Shift两次）窗口的搜索字段中输入“/”，以搜索设置、选项和插件的列表。

To add data from the CSV file, drag the file to the tables node of a data source or to the table.
You can view CSV and TSV files as text or as a table.
要从CSV文件中添加数据，请将该文件拖到数据源的“表格”节点或表格中。
您可以将CSV和TSV文件视为文本或表格。