sql tag

625 questions


1 answers
115 views
0
I made a login form with HTml, but I don't know how to sign up and put it in db.

I made a login form with HTml, but I don't know how to sign up and put it in db.How can I make it easier?

2 years ago

1 answers
38 views
0
Sum of 20 digits in MySQL

Hello, I'm a beginner developer.In MYSQL, if you add up to 20 characters of 300 digits, as shown below,substring('12111111111111111111122111111111111111111211111111111111111112111111111111111111121111...

2 years ago

1 answers
47 views
0
html grammar in php grammar, how to solve it easily when mixing php grammar in html grammar

I'm practicing how to use php, html, and mysql to sign up for a web page Php Grammar HTml Grammar Mysql Grammar is not that difficult, but like the example below,Combination? It's so hard to mix itSom...

2 years ago

1 answers
104 views
0
Oracle is converting to mysql, but the query is too complicated.

Converting from Oracle to mysql...select days.mdate , ifnull(login_cnt,0) as login_cnt , ifnull(logout_cnt,0) as logout_cnt from ( select '2016-06-16' as mdate from ts_user where limit 1,1 ) days left...

2 years ago

1 answers
79 views
0
sqlite SQL Date Query Question

I want to select a date range in sqlite, but it doesn't work normally. SELECT * FROM test WHERE date BETWEEN 11/1/2011 AND 11/8/2011;How do I send a query?

2 years ago

1 answers
53 views
0
An internal error occurs when writing postgis, django in postgresql. How do I resolve the error that I can't load the library?

Running python3 manage.py migrate in django django.db.utils.InternalError: could not load library /usr/lib/postgresql/9.5/lib/postgis-2.2.so: /usr/lib/liblwgeom-2.2.so.5: undefined symbol: GEOSClipByR...

2 years ago

1 answers
33 views
0
It's a really easy SQL query. I don't know how to squeeze it crying

Books, book numbers, publishers, and year of publication are included in the relationship. (Basic key is book number) I would like to print out the name of the publisher that has published more than 1...

sql
2 years ago

1 answers
159 views
0
Developing node.js. What is the advantage of not using Sequelize (ORM) when using DB?

Developing node.js. I have two years of experience in mssql.Initially, the db part was developed using the mysql module.But I found out that it's called Sequelize.js, so I've been using it.It was a li...


1 answers
38 views
0
If you say mysql.server start, you die immediately. Help me.

I'm using MacBook Pro Retina Elkepitane.I installed mysql with brew and ran it, but it didn't work, so I started mysql.server. And thenERROR! The server quit without updating PID file (/usr/local/var/...

2 years ago

1 answers
42 views
0
[Node.js] If logged in, if not.

Hi, everyone. Recently, I've been implementing a page with node.js.If I log in this part, I want to change it to log out. I have no idea how. The advice to use cookies didn't help much.I am using pass...

2 years ago
« - 44 - »

© 2024 OneMinuteCode. All rights reserved.