sql tag

625 questions


1 answers
42 views
0
I'm trying to link mysql in c#, but I don't know what the problem is.

When compiling the Insert function, it doesn't seem to be open.The select function causes a compilation error.What's the problem?using System;using System.Collections.Generic;using System.Linq;using S...

2 years ago

1 answers
40 views
0
How do I insert the Bitmap file into mysql?

I am creating a mobile community application application.Currently, I logged in with Facebook and received the profile picture in Bitmap format.I want to save the member's information in mysql, but I ...

2 years ago

1 answers
117 views
0
Can the charset setting of the web page and the charset of the server and db be different?

We are currently creating a web page with mysql, phpapache on the hosting server.The charset of the server and mysql is set to utf-8.But the page files on the web page are set to euc-kr.The Web was cr...

2 years ago

1 answers
106 views
0
Find the best Database connection module in Python.

I'm a beginner at Python.I'd like to add a database module (mysql) and do this and that. https://pypi.python.org/pypi?%3Aaction=search&term=mysql&submit=searchIf you look here, you can see a l...

2 years ago

1 answers
72 views
0
1. Where is the exact location to implement the db connection, release code? 2. How to process user information security, such as db or email access information

1.var mysql = require('mysql');var conn = mysql.createConnection(dbconfig.connection);conn.connect(function(err) { if (err) { console.log('Error connecting: ' + err.stack); return; } console.log('conn...

2 years ago

2 answers
34 views
0
What do you call this skill(?) in mysql?

Hello.I have a question to ask.First of all There is a function to take a test in the program I'm making.You can take the test several times.And I'd like to save the test scores in the database with t...

2 years ago

1 answers
149 views
0
How do I change java.util.Date to java.sql.Date?

Input is being processed using the java.util.Date class. You want to use this data to create an SQL query. Therefore, you must convert to an object in the java.sql.Date class.However, we found that th...

2 years ago

1 answers
72 views
0
Postgresql cannot be sorted in Korean order.

SELECT * FROM table_name ORDER BY title but the title cannot be sorted in Korean order and can be sorted as it pleases.

2 years ago

1 answers
40 views
0
MAMP can't do mysqli

<?phpdefine(HOSTNAME,localhost);define(USERNAME,root);define(PASSWORD,root);define(DB_NAME,testDB);$conn = new mysqli(HOSTNAME, USERNAME, PASSWORD, DB_NAME);if($conn->connect_errno) { echo(<b...

2 years ago

3 answers
35 views
0
To count the number of rows in a table

Hello!When I want to know the total number of mysql's table Using count (*) is too slow when there is a lot of data...select TABLE_ROWS from information_schema.tables where table_name = 'table name';Y...

2 years ago
« - 43 - »

© 2024 OneMinuteCode. All rights reserved.