256 Kilobytes

Databases Comments

Type CommentsResponses to top-level threads. Category DatabasesDiscuss database design and development, such as relational and NoSQL technologies like MySQL, MariaDB, and MongoDB.

Profile Photo - August R. Garcia

Reply to 150 Oracle DBA Interview Questions

Comments in Databases | By August R. Garcia

Published

Profile Photo - August R. Garcia

dear

Moredear
🗨 1
🐏 0
👁 7
Profile Photo - Default

Reply to List of 100 MySQL Interview Questions for DBA

Comments in Databases | By Abhishek

Published

Profile Photo - Default

Sorry August R. Garcia  you can see...

MoreSorry August R. Garcia  you can see doc from this link https://www.thedbadmin.com/list-of-100-mysql-interview-questions/
🗨 2
🐏 0
👁 5
Profile Photo - August R. Garcia

Reply to List of 100 MySQL Interview Questions for DBA

Comments in Databases | By August R. Garcia

Published

Profile Photo - August R. Garcia

Dead link removed (500 error). <br...

MoreDead link removed (500 error). 
🗨 2
🐏 0
👁 5
Profile Photo - Default

Reply to [PostgreSQL vs MySQL] Which DB has the best performance?

Comments in Databases | By Abhishek

Published | Last Update

Profile Photo - Default

both are the best top databases but it d...

Moreboth are the best top databases but it depends on what you want to do and what your application does. --Abhishek Mod Edit: Spam link removed. Al...
🗨 1
🐏 0
👁 433
Profile Photo - Univa

Reply to When to Use Apache Cassandra vs MongoDB?

Comments in Databases | By Univa

Published

Profile Photo - Univa

Cassandra can handle massive amounts of...

MoreCassandra can handle massive amounts of unstructured data. In cases where your database needs to rapidly scale with minimal increase of administr...
🗨 1
🐏 0
👁 417
Profile Photo - Univa

Reply to [SQL Server] Difference between datetime and datetime2?

Comments in Databases | By Univa

Published

Profile Photo - Univa

DATETIME2 has a date range of "0001 / 01...

MoreDATETIME2 has a date range of "0001 / 01 / 01" through "9999 / 12 / 31" while the DATETIME type only supports year 1753-9999. Also, if you need to,...
🗨 1
🐏 0
👁 378
Profile Photo - Univa
Profile Photo - Univa

Imagine a table called purchases that re...

MoreImagine a table called purchases that records purchases made by customers at stores, i.e., it's a many to many, and the software needs to know which c...
🗨 1
🐏 0
👁 401
Profile Photo - Univa
Profile Photo - Univa

504 Gatetimeout is an HTTP Error, not a...

More504 Gatetimeout is an HTTP Error, not a database error. The database takes too long to collect your data. You probably have to increase max_execution_...
🗨 1
🐏 0
👁 503
Profile Photo - Univa

Reply to How to fix &quot;Operand should contain 1 column(s)&quot;?

Comments in Databases | By Univa

Published

Profile Photo - Univa

This error can occur if you accidentally...

MoreThis error can occur if you accidentally use commas instead of AND in the ON clause of a JOIN. FOR EXAMPLE: JOIN joined_table ON (joined_table.c...
🗨 1
🐏 0
👁 415
Profile Photo - Univa
Profile Photo - Univa

Try out the following steps to overcome...

MoreTry out the following steps to overcome this issue: Find mysql related entries from system sudo find / -name mysql Remove all mysql related en...
🗨 1
🐏 0
👁 423
Profile Photo - August R. Garcia

Reply to Selicting database with the MySQL command line?

Comments in Databases | By August R. Garcia

Published | Last Update

Profile Photo - August R. Garcia

USE database_name;

MoreUSE database_name;
🗨 2
🐏 0
👁 391
Profile Photo - -alxl_

Reply to Selicting database with the MySQL command line?

Comments in Databases | By -alxl_

Published

Profile Photo - -alxl_

Yes you can select a database from the c...

MoreYes you can select a database from the command line for MySQL. I recommend you refer to the MySQL documentation and the MySQL community for specific d...
🗨 2
🐏 0
👁 391
Profile Photo - roxblade

Reply to How do I install Oracle 11g?

Comments in Databases | By roxblade

Published

Profile Photo - roxblade

On Windows, use the Oracle Universal Ins...

MoreOn Windows, use the Oracle Universal Installer. Extract the downloaded zip. Open the setup.exe file. Select the Oracle Database 11g and click Next. Us...
🗨 1
🐏 0
👁 380
Profile Photo - roxblade

Reply to Best MariaDB/MySQL GUI?

Comments in Databases | By roxblade

Published

Profile Photo - roxblade

Yes, phpMyAdmin is the universal option....

MoreYes, phpMyAdmin is the universal option. But more often than not, you might requre a GUI/native software.In that case, it depends on taste really. Als...
🗨 2
🐏 0
👁 419
Profile Photo - roxblade
Profile Photo - roxblade

Yes, it's a fork in some ways. Michael "...

MoreYes, it's a fork in some ways. Michael "Monty" Widenius was the person behind it. He also was in the original team that developed MySQL and also the c...
🗨 1
🐏 0
👁 378
Profile Photo - roxblade
Profile Photo - roxblade

Multiple occurrences of the same value a...

MoreMultiple occurrences of the same value are allowed in MUL keys. So, there are two primary kinds of keys -- PRI and UNI. PRI are primary keys and UNI i...
🗨 1
🐏 0
👁 1,143
Profile Photo - August R. Garcia

Reply to Best MariaDB/MySQL GUI?

Comments in Databases | By August R. Garcia

Published

Profile Photo - August R. Garcia

PHPMyAdmin is a pretty good option.In pa...

MorePHPMyAdmin is a pretty good option.In particular, if you're working with web development in any kind of way, you're going to constantly run into it, s...
🗨 2
🐏 0
👁 419
Profile Photo - August R. Garcia
Profile Photo - August R. Garcia

Assuming you're asking for a raw que...

MoreAssuming you're asking for a raw query to run on a MariaDB or MySQL database: Get a list of all of the unique IP addresses:...
🗨 1
🐏 0
👁 352
Profile Photo - Hash Brown
Profile Photo - Hash Brown

You're probably trying to get the va...

MoreYou're probably trying to get the value from an array with object syntax. Most database data is handled in arrays, not objects. If you are d...
🗨 1
🐏 0
👁 383
Profile Photo - Hash Brown
Profile Photo - Hash Brown

These errors are kind of generic and don...

MoreThese errors are kind of generic and don't point to anything specific. In general you want to start off: Make sure you're using the c...
🗨 1
🐏 0
👁 445
Profile Photo - Hash Brown
Profile Photo - Hash Brown

Go into your script or config file and f...

MoreGo into your script or config file and find your database credentials. Look for "localhost" and replace it with "127.0.0.1"....
🗨 1
🐏 0
👁 3
Profile Photo - August R. Garcia
Profile Photo - August R. Garcia

More<?php $date = date('Y-m-d H:i:s'); More/related information: https://www.sitepoint.com/community/t/php-equivalent-of-mysql-now-in-th...
🗨 1
🐏 0
👁 310
Profile Photo - August R. Garcia
Profile Photo - August R. Garcia

If you are getting this error while conn...

MoreIf you are getting this error while connected to a remote terminal via SSH (such as to a web host), there may be a non-root account that you are meant...
🗨 1
🐏 0
👁 280
Profile Photo - August R. Garcia
Profile Photo - August R. Garcia

This error can occur if you are missing...

MoreThis error can occur if you are missing If your insert statement does not specify the number of columns correct. Example of incorrect statement:...
🗨 1
🐏 0
👁 290
Profile Photo - Hash Brown
Profile Photo - Hash Brown

Hello,

MoreHello, Trunication is basically where you're going to lose some of your data by inserting it. This is cause by trying to pass in data which is...
🗨 1
🐏 0
👁 300
Profile Photo - Hash Brown

Reply to ORA-00979: not a group by expression - solutions?

Comments in Databases | By Hash Brown

Published

Profile Photo - Hash Brown

Hello,

MoreHello, ORA-009779 is a fairly straight forward error. You have not included any code so I'll have to explain what it's likely to be... I...
🗨 1
🐏 0
👁 331
Profile Photo - Hash Brown
Profile Photo - Hash Brown

Hello,

MoreHello, This is really easy, the column name you have refferenced (rabbit_name) does not exist. Check the spelling, or add the column to the tabl...
🗨 1
🐏 0
👁 1
Profile Photo - Hash Brown

Reply to What is &quot;mysqli_fetch_assoc&quot;?

Comments in Databases | By Hash Brown

Published

Profile Photo - Hash Brown

Hello,

MoreHello, Firstly and most importantly, mysqli is dead. It's very easy to mess up and ship code with security issues. You should look at PDO (PHP...
🗨 1
🐏 0
👁 300
Profile Photo - August R. Garcia
Profile Photo - August R. Garcia

Try this:

MoreTry this: INSERT INTO post_tag (post_id, tag_id) VALUES ( (SELECT id FROM posts.id WHERE title = 'Some blog post'), (SELECT id...
🗨 1
🐏 0
👁 4
Profile Photo - August R. Garcia

Reply to Can you have a number in a MySQL DB name?

Comments in Databases | By August R. Garcia

Published

Profile Photo - August R. Garcia

Yes, numbers in MySQL/MariaDB database n...

MoreYes, numbers in MySQL/MariaDB database names work fine. The 256 Kilobytes database, for example, is callled 420_smoke_weed.
🗨 1
🐏 0
👁 242