comparing versions of sql - MySQL Database

Jim Maas

I'm taking up a new position and have never used sql before although use
and code in lots of other languages. When doing a bit of survey I find
many many versions of commercial and public versions of sql. Can anyone
tell me if the syntax is generally similar or are they completely
different. If I invest time learning mysql on XP or Linux will that be
useful if I end up using something like Oracle later on? The only one I
would avoid is MS.... like things that work occasionally.

Thanks for all advice and if there is a web page or summary somewhere
else please pass this on to me.

Thanks and Very Best Regards

Jim

ja****@btintern et.com

Jul 19 '05 #1

Subscribe Reply

1601

Aggro

Jim Maas wrote:

I'm taking up a new position and have never used sql before although use
and code in lots of other languages. When doing a bit of survey I find
many many versions of commercial and public versions of sql. Can anyone
tell me if the syntax is generally similar or are they completely
different. If I invest time learning mysql on XP or Linux will that be
useful if I end up using something like Oracle later on? The only one I
would avoid is MS.... like things that work occasionally.

If you don't have any experience in sql, then using MySQL would endeed
help with learning Oracle or other database later. The basic syntax and
functionality of databases is always similar. Most of the queries you
write for MySQL might work on Oracle without changing them at all.

Also the most important thing to learn, how databases are used in
general, is similar on all platforms. After you have learned that and
the basic syntax, it should be pretty easy to do basic operations on any
database.

What is different between databases are usually some functions that
database provides to help with queries. These functions can do anything
from solving mathematical problems to working with strings. Usually
there is no harm in learning functions for one database. That just helps
you to find similar functions on another database.

Jul 19 '05 #2

Aggro

Jim Maas wrote:

I'm taking up a new position and have never used sql before although use
and code in lots of other languages. When doing a bit of survey I find
many many versions of commercial and public versions of sql. Can anyone
tell me if the syntax is generally similar or are they completely
different. If I invest time learning mysql on XP or Linux will that be
useful if I end up using something like Oracle later on? The only one I
would avoid is MS.... like things that work occasionally.

Jul 19 '05 #3

Aggro

Jim Maas wrote:

I'm taking up a new position and have never used sql before although use
and code in lots of other languages. When doing a bit of survey I find
many many versions of commercial and public versions of sql. Can anyone
tell me if the syntax is generally similar or are they completely
different. If I invest time learning mysql on XP or Linux will that be
useful if I end up using something like Oracle later on? The only one I
would avoid is MS.... like things that work occasionally.

Jul 19 '05 #4

Similar topics

2668

comparing nan "number"

by: BoÅ¡tjan Jerko | last post by:

Hello ! I need to know if the result of math formula is nan (Not a number). How can I do that? Thanks, B.

Python

297

comparing versions of sql

by: Jim Maas | last post by:

MySQL Database

2031

VS.NET Perfomance and speed question ( Comparing with C++ Apps)

by: HerrLucifer | last post by:

I am each day becoming more and more addicted to the new .Net framework because of its cool RAD facilities. However, performance and speed is extremely important for my application development. I have done many various tests to compare the performance speed of applications written in C++ 6.0 V.S. the same ones in VB.Net or VC#.Net . The result were quiet the same( i am not sure if i have go the right path!). But I know C++ exe files use...

.NET Framework

1419

Comparing 2 versions of C++ framework

by: Christophe Rhin | last post by:

I have two versions of the same C++ framework (> 200 000 lines). These two versions evolved apart during 2 years from the same starting point. My goal is two find "significant" differences between these two versions. A diff tool (like WinMerge, excellent) produces too many differences (spaces, new lines, comments, real changes, renaming, ...). Now I am using text processors to remove all trivial differences before going into WinMerge :...

C / C++

39763

Comparing dates using date function and arithmetic

by: bryan.seaton | last post by:

I have a delete statement that is not doing what I want it to do: Delete from LOG_TABLE where (DATE(LOG_TS)) < (DATE(CURRENT_DATE)- 21 DAYS); It is supposed to delete all records that are 21 days or older than the current system date. Instead it is deleting all new rows. LOG_TS is a timestamp but that should not matter since DATE returns just the date portion of a date or timestamp...right? I'm not a SQL guru but I can't see...

DB2 Database

22018

comparing two strcasecmp (stricmp) implementations

by: William Krick | last post by:

I'm currently evaluating two implementations of a case insensitive string comparison function to replace the non-ANSI stricmp(). Both of the implementations below seem to work fine but I'm wondering if one is better than the other or if there is some sort of hybrid of the two that would be superior. IMPLEMENTATION 1: #ifndef HAVE_STRCASECMP

C / C++

2644

Comparing Empty Value types

by: Dennis | last post by:

I have a public variable in a class of type color declared as follows: public mycolor as color = color.Empty I want to check to see if the user has specified a color like; if mycolor = Color.Empty then..... or if mycolor is Color.Empty then .......

Visual Basic .NET

13019

Comparing pointers

by: J Caesar | last post by:

In C you can compare two pointers, p<q, as long as they come from the same array or the same malloc()ated block. Otherwise you can't. What I'd like to do is write a function int comparable(void *p, void *q) that will take any two pointers and decide whether they can be compared or not. I really can't think how to do this - any suggestions?

C / C++

1926

Comparing version strings within two files

by: umamaheswarig | last post by:

file1 contains data like this: C-tree version v8.27.123 file2 contains data like this: some text...... Database version C-tree server v8.27.123

Perl

2274

jQuery Query about comparing jQuery references

by: Aaron Gray | last post by:

There does not seem too be anyway to test if two jQuery references are the same element. Given :- ... <div id="1"></div .... Then :- alert( $("#1") == $("#1"))

Javascript

8337

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8748

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8628

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7359

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

5650

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4175

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4335

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2754

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1739

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General