Posts by alastori • 114 points
7 posts
-
1
votes1
answer375
viewsA: Software to Create Mysql DB Relationship and Structure
If your intention is to use Mysql, the Mysql Workbench might be a good alternative. It is free (GPL license) and has good features for you to create the logical model and export as physical model or…
-
0
votes1
answer2351
viewsA: Failed to install Mysql Server 5.x on Windows 10 (64bit)
Mysql Installer for Windows will download the files according to the items you select in the initial installation steps. You probably can’t connect to the Internet. An alternative is to download the…
-
0
votes1
answer794
viewsA: Mysql auto timestamp insertion
Mysql will store datetime/timestamp types internally in binary format. The format that is displayed to you does not necessarily reflect the internal format. To work with datetime/timestamp types in…
-
2
votes1
answer196
viewsA: Is using specific data types like SMALLINT and MEDIUMINT instead of INT and marking columns with UNSIGNED an exaggeration?
Depends on the context. If we are talking about a prototype or tables that will be very large, it can be an exaggeration to spend a lot of time optimizing datatypes. However, if they are tables that…
-
2
votes1
answer1248
viewsA: Using Mysql with R in the Rmysql package
The easiest method of installing Rmysql on R for Windows is via install.packages. Do the following: Step 1: Normal installation of R for Windows https://cran.r-project.org/bin/windows/base/ Step 2:…
-
2
votes2
answers1100
viewsA: How to update or Insert in Mysql in the same query?
The statement REPLACE works as follows: If the new line does not yet exist, insert a new line. If the new line already exists, the REPLACE statement deletes the old line first and then inserts a new…
-
1
votes1
answer518
viewsA: How to upload data to Mysql faster?
The command load data infile loads data from a file very quickly CSV. Since you have foreign keys, you can turn off the check before executing the command and turn it on again later. It would look…