package main
import (
"database/sql"
"fmt"
"log"
"time"
_ "github.com/go-sql-driver/mysql"
)
type Users struct {
Id int
Username string
Password string
Email string
First_name string
Last_name string
Created_at time.Time
Super_user bool
}
func main() {
db, err := sql.Open("mysql",
"root:Megamind@1@(127.0.0.1:3306)/note?parseTime=true")
if err != nil {
log.Fatalln("Couldn't connect to the database")
}
var user Users
row := db.QueryRow("select password from users where username=$1", "someone"
)
row.Scan(&user.Id, &user.Username, &user.Password, &user.Email,
&user.First_name, &user.Last_name, &user.Created_at, &user.Super_user)
fmt.Println(user)
}
Data available in the database
mysql> select * from users;
+----+---------------+--------------------------------------------------------------+---------------------------+------------+-----------+---------------------+------------+
| id | username | password | email | first_name | last_name | created_at |
super_user |
+----+---------------+--------------------------------------------------------------+---------------------------+------------+-----------+---------------------+------------+
| 3 | someone |
$2a$10$a0g.eIGEHoVnD/s55YCePeL5BxCPYDF58nP2gb.TmYKwCuV5E7gP. |
a...@gmail.com | NULL | NULL | 2020-06-22 01:24:43 | NULL | | 4 | oneanother
| $2a$10$VMo4iuvruCA/yQlkfMI2QOMWo2H2jIiyyoYprKQtQMT4U7UWb78CS |
z...@one.com | NULL | NULL | 2020-06-22 01:26:48 | NULL | | 5 |
davetweetlive |
$2a$10$oD0YKBkTvJQVPF4rilEVYemjRtwNF3ATGlVLUOVGZzR5lNx5fRl3. |
p...@gmail.com | NULL | NULL | 2020-06-22 01:45:34 | NULL |
+----+---------------+--------------------------------------------------------------+---------------------------+------------+-----------+---------------------+------------+
3 rows in set (0.02 sec) mysql> exit
--
You received this message because you are subscribed to the Google Groups
"golang-nuts" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to golang-nuts+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/golang-nuts/3633877f-affd-4b8d-becd-4975b8423c48o%40googlegroups.com.
