#sql - Questions and answers
30 questions,
2 pages,
20 questions on this page
3 points
EN
How can I set DATETIME type row value autocomplete? I need default value to be automatically added when the row is created. I'm working with MySQL Workbench.
1 answers
0 points
EN
How can I delete all users except the one with id = 1 which is admin from the users table? My users table: MySQL Workbench - table preview
1 answers
3 points
EN
What is the replacement for the CREATE OR REPLACE VIEW command (which I could use in MySQL) in MS SQL Server?
1 answers
0 points
EN
How to display indexes from a table using query in MySQL?
1 answers
0 points
EN
What is the difference between NOW() and CURDATE() functions in MySQL?
1 answers
0 points
EN
What's the difference between CAST() and CONVERT() functions in MySQL?
0 answers
0 points
EN
What is the difference between WEEKDAY() and DAYOFWEEK() in MySQL?
1 answers
6 points
EN
Both DATETIME and TIMESTAMP contain the date and time parts, so can you tell me what's the difference between them?
1 answers
0 points
EN
I'm doing date comparison in MySQL and I want to display date values without time. Example: I want to have 2020-01-01 instead of 2020-01-01 00:00:00. How to get rid of the 00:00:00 part? My code:
1 answers
0 points
EN
How to reset AUTO_INCREMENT value to start counting from 1 again?
1 answers
0 points
EN
How does GROUP BY statement with multiple columns work?
1 answers
3 points
EN
How to find the first row in a table when I don't have id column in MySQL?
1 answers
0 points
EN
Does the primary key have to be unique in MySQL?
1 answers
0 points
EN
Is there a way to comment / uncomment queries in HeidiSQL using a keyboard shortcut?
1 answers
0 points
EN
Why I can't see index created with CREATE INDEX query in Indexes tab in HeidiSQL? I've just created full_name_index with the following query: And it doesn't show up in the Indexes tab in here: However...
1 answers
0 points
EN
How can I check an existing table engine? I created the table some time ago and I don't remember which engine I specified when creating it.
1 answers
0 points
EN
Do you know how to view indexes of a table in MySQL?
2 answers
0 points
EN
Can you explain to me what does ENGINE=InnoDB; mean when creating a MySQL table? Example:
1 answers
0 points
EN
Is it possible to do a FULL OUTER JOIN in MySQL? I tried SQL syntax but it doesn't seem to work. My query: Error: MySQL - FULL OUTER JOIN error (HeidiSQL)
0 answers
Native Advertising
🚀
Get your tech brand or product in front of software developers.
For more information Contact us