[Solved] Indexing database tables for "WHERE LIKE '%string%'" queries in MySQL
Answers in Database Development | By August R. Garcia
Published
Regular indexes are basically irrelevant...
MoreRegular indexes are basically irrelevant if you need string matching within arbitrary positions in a string (rather than only at the start). The...[Solved] SQLite: "Error: near line 27: near "IGNORE": syntax error"
Answers in Database Development | By August R. Garcia
Published
This is the line that caused the error t...
MoreThis is the line that caused the error to be thrown: INSERT IGNORE INTO things (name, created_at, updated_at) VALUES ("Some String", 1563893034,...
Last ReplyGROUP BY allows the only aggregation. If you want to remove all duplicated rows, use SELECT DISTINCT. But DISTINCT command also so slow for lar... Ali,
GROUP BY allows the only...
Best method to store an array in a MariaDB/MySQL database?
Answers in Database Development | By Some Guy
Published
Last ReplyIf you want to store array and/or object data as a string (i.e., in a single DB field), it is possible to encode it as JSON: http://php.n... August R. Garcia,
If you want to store arra...
Last ReplyI'll line-out the very basic necessities to become a database developer. You need to learn SQL and be proficient in MySQL. A bachelor's degree is very... roxblade,
I'll line-out the very ba...
Last ReplyFirst off is the Requirement Capture and Analysis. This is where we collect requirements. Along with users, we also take into consideration the variou... roxblade,
First off is the Requirem...
[MySQL/MariaDB] How to write a query to insert to a pivot table/map for a many-to-many relationship without constantly looking up IDs for the two tables?
Answers in Database Development | By Some Guy
Published
Last ReplyYou should be able to do this: INSERT INTO post_tag (post_id, tag_id) VALUES ( (SELECT id FROM posts WHERE name="Some Fucking Post&quo... August R. Garcia,
You should be able to do...
How to fix "ERROR 1170 (42000): BLOB/TEXT column 'some_column' used in key specification without a key length?"
Answers in Database Development | By Some Guy
Published
Fix for "Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: Backlog?"
Answers in Database Development | By Some Guy
Published
[MySQL/MariaDB] How to unset/undefine a function? Solution to "ERROR 1304 (42000): PROCEDURE handlerdemo already exists?"
Answers in Database Development | By Some Guy
Published
What is the difference between SDLC and waterfall model?
Answers in Database Development | By Some Guy
Published
Last ReplyDefinitions: DBMS: Database Management System DDLC: Database Development Lifecycle For reference, DDLC does not refer to the Absolutely H... August R. Garcia,
Definitions:
What is the difference between delete and truncate?
Answers in Database Development | By Some Guy
Published
I am a little new at this and am unclear...
MoreI am a little new at this and am unclear on how functions actually work. I know delete deletes things, and truncate shortens things, but I do not get...