[Solved] Indexing database tables for "WHERE LIKE '%string%'" queries in MySQL

Answers in Database Development | By August R. Garcia

Published 2 years agoWed, 07 Aug 2019 21:08:27 -0700

Regular indexes are basically irrelevant...

[Solved] SQLite: "Error: near line 27: near "IGNORE": syntax error"

Answers in Database Development | By August R. Garcia

Published 2 years agoTue, 23 Jul 2019 09:06:38 -0700

This is the line that caused the error t...

Does GROUP BY remove duplicates?

Answers in Database Development | By Some Guy

Published 2 years agoSun, 13 Jan 2019 04:21:55 -0800

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 2 years agoThu, 06 Dec 2018 22:55:02 -0800

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...

How do I become a database developer?

Answers in Database Development | By Some Guy

Published 2 years agoSun, 13 Jan 2019 04:22:05 -0800

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...

What are the 5 phases of SDLC?

Answers in Database Development | By Some Guy

Published 2 years agoSun, 13 Jan 2019 04:22:15 -0800

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 2 years agoThu, 31 Jan 2019 21:12:37 -0800

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 2 years agoSun, 13 Jan 2019 04:22:55 -0800

Fix for "Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: Backlog?"

Answers in Database Development | By Some Guy

Published 2 years agoSun, 13 Jan 2019 04:22:45 -0800

[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 2 years agoSun, 13 Jan 2019 04:22:35 -0800

What is the difference between SDLC and waterfall model?

Answers in Database Development | By Some Guy

Published 2 years agoSun, 13 Jan 2019 04:22:25 -0800

How to have a LEFT JOIN only get row?

Answers in Database Development | By Some Guy

Published 2 years agoSun, 13 Jan 2019 04:21:45 -0800

What is DDLC in DBMS?

Answers in Database Development | By Some Guy

Published 2 years agoFri, 11 Jan 2019 18:48:34 -0800

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 2 years agoSun, 16 Dec 2018 09:27:17 -0800

I am a little new at this and am unclear...