[MySQL] Note(2) AVG, COUNT, MAX, MIN, SUM
Today I record some commonly used instructions of SQL:
- AVG()
- COUNT()
- MAX()
- MIN()
- SUM()
Blog
[MySQL] Note(1) SELECT, FROM, WHERE, GROUP-BY, HAVING, ORDER-BY, LIMIT
The article records how to use the following SQL instructions of:
- SELECT
- FROM
- WHERE
- GROUP BY
- HAVING
- ORDER BY
- LIMIT
[Linux] Install CUDA and CuDNN on Ubuntu 18.04
If we want to use GPU for deep learning (for example, through Tensorflow or Keras), the installation environment is not really complicated, and it usually only takes a few hours to complete the environment in the first time.
Read More »[Linux] Install CUDA and CuDNN on Ubuntu 18.04
[PyTorch] Tutorial(7) Use Deep Generative Adversarial Network (DCGAN) to generate pictures
Today I want to record how to use Deep generative Adversarial Network (DCGAN) to implement a simple generate picture model. I wanted to demo with delicious snack pictures, but the effect was not very good, I downloaded half a million snack pictures in vain.
Finally, I used the official demo CelebA dataset.
Read More »[PyTorch] Tutorial(7) Use Deep Generative Adversarial Network (DCGAN) to generate pictures[PyTorch] Tutorial(6) Audio of Processing Module: torchaudio
Just as torchvision is a module in PyTorch that specializes in processing pictures, torchaudio to be recorded today is a module in PyTorch that specializes in processing audio.
[Kotlin] Print “Hello World”
Before introducing the program syntax, I think you need an environment that can run Kotlin, it is recommended to open it in a browser: https://developer.android.com/training/kotlinplayground
Read More »[Kotlin] Print “Hello World”
[C++] Tutorial(7): Functions
The functions can divide the code of different purpose in a program, and use the defined code repeatedly by calling the function if we need.
Read More »[C++] Tutorial(7): Functions[C++] Tutorial(6): Pointer and Reference
Pointer is a special data type in C++ that stores variable memory address. It is often used to build structure such as Linked List or to transfer large data memory address to improve program efficiency.
Read More »[C++] Tutorial(6): Pointer and Reference[C++] Tutorial(5): File Read and Write
Data is text format can be said to be one of the most basic data forms of computer system. For example, Linux operating system has many settings that are stored in text file for the convenience of users to adjust freely.
Read More »[C++] Tutorial(5): File Read and Write[C++] Tutorial(4): if-else, switch, loop and flow control
In the programming language, if-else allows us to make different responses according to different situations, loop allows the computer to do a large number of tasks of similar nature to automate operations, and flow control allows us in the loop, you can fast forward to next iteration, or even leave the loop early.
Read More »[C++] Tutorial(4): if-else, switch, loop and flow control