Most consumer-facing web startups these days use one of the major open source databases, either MySQL or PostgreSQL, to some degree. If you want to prove your worth, it’s a good idea to get down to the nitty gritty and gain some understanding about these databases’ internals.

Please explain to me:
1. What databases indexes are and how they work.
2. Do I need to index a column that is in different table in SQL server?

I am an employee working in a small company for Unix DBA support. We used to shutdown the Unix services and instances. When I try to shut down oracle instances, I am getting an error as “ORACLE_SID=FLEXCJ: is not an identifier”. Can anyone check the attached screenshots and guide me in rectifying the error?

Hey guys…

I am at the most divesting risk of my life. Please help me. Our MySQL database is running okay, but still we are getting the following error from our client end software.

There was an error connecting to the database:

Can’t connect to MySQL server on ‘127.0.0.1’ (10061)

Hi,

Hi,

Hi,

I have some concern here regarding MySQL database. I am in the process of creating a new database with a name 'ragnarok' when an error message came to my sight that I can't figure out what went wrong on the way.

Execution Error

            Error while executing query.

                CREATE DATABASE ‘ragnarok’

                MySQL Error Number 1044

Hi,

Ok let’s sort out this problem if you can. I have software which runs with SQL Server. I didn’t have access to that software database. Actually I can still access its password, so I can generate reports from it. Yesterday I was working on the software and was trying to get a report  from it about the whole day's work  and then the SQL Server automatically gave this error as in the image that there was an error with reading results of the SQL statement.

Good Evening!

Please provide me a solution to this problem.

I was performing some addition and subtraction from dates in the SQL server database while this error occurred. I have faced this error for the first time. As far as I understand, it may be caused because I was adding non-numeric values along with the dates and was subtracting alphanumeric values from the dates. But it's my need that I have to add and subtract in this way.

Hi everyone,

Please read this error message and reply for its solution. While I was working on a Software named as Koha, a library software, I got this error. It appeared when I searched one of the books I entered in the software from Marc. After this error, I can’t find my books in that software and it’s a very big loss of mine because I have worked for 6 months to enter books into that software and now just due to this error of communication failure with SQl Server, I am unable to search out any of the records of my books.

 I am trying to connect to a MySQL server using a Java program. I always get this error when trying to connect:

SQL Exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '????????????????' at line 1

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '????????????????' at line 1

I'm lost and have no idea what else to do because I'm just a newbie. Please help.