Welcome Guest ( Log In | Register )



2 Pages V  < 1 2  
Reply to this topicStart new topic
> Mysql - So Hard, Come in here if you think MySQL is soo hard!
Rating 4 V
yordan
post May 16 2008, 10:19 PM
Post #11


Way Out Of Control - You need a life :)
Group Icon

Group: [MODERATOR]
Posts: 1,886
Joined: 16-August 05
Member No.: 7,896



QUOTE(ahaslam @ May 14 2008, 07:03 PM) *
now it's easy peasy but its hard when it dosnt work lol tongue.gif

Please try go stay serious, we don't appreciate non-technical terms like "lol" here. rolleyes.gif
QUOTE
data bases are easy in theend as long as you have all the pass words host address ect.

That's the minimum level of security, needing hostnames, usernames and passwords in order to access the data.

Go to the top of the page
 
+Quote Post
docduke
post May 17 2008, 12:20 AM
Post #12


Member - Active Contributor
Group Icon

Group: [MODERATOR]
Posts: 99
Joined: 8-January 08
Member No.: 27,477



SQL is actually a very interesting, if old, computer language design. Borrowing from Wikipedia:
QUOTE
During the 1970s, a group at IBM's San Jose research center developed the System R relational database management system, based on the model introduced by Edgar F. Codd in his influential paper, A Relational Model of Data for Large Shared Data Banks. Donald D. Chamberlin and Raymond F. Boyce of IBM subsequently created the Structured English Query Language ...


Note the word shared. If you ever need an environment with really large bandwidth servers, you will be glad you use something based on SQL. It is designed to minimize the data transfer between the database and the requesting computer.

In 1989, my wife was working on a Master's in Computer Science, and she jumped at the opportunity to go to a seminar given by Codd. He had just come out with a new book. He was famous in her circles for Codd's 26 Rules of relational database design.

She heard he had added a few rules. She wondered, "Was it 30, maybe 36?" It turned out to be 126, and the talk was one of the more opaque she attended (No connection to OpaQue! rolleyes.gif ) Anyway, the bottom-line message is that SQL has been thoroughly studied, and optimized in an environment where data transfer is costly. It is worth using, and MySQL makes it free and easy!
Go to the top of the page
 
+Quote Post
Yaoersd
post May 25 2008, 02:54 PM
Post #13


Newbie [ Level 1 ]
Group Icon

Group: Members
Posts: 1
Joined: 25-May 08
Member No.: 30,562



You will get used to it...
Go to the top of the page
 
+Quote Post
sparkx
post May 25 2008, 03:28 PM
Post #14


Sparkx
Group Icon

Group: [HOSTED]
Posts: 321
Joined: 11-October 06
From: Dana Point, CA, USA
Member No.: 16,496



Actually to be honest I thought MySQL was pretty easy. Simply connect to a database then you can get all the results simply by using an * and arraying the tables. The only trouble I have ever had (and I’m still having so if you have an answer please tell me) is connecting to a MySQL server from an external location for example a clients download. Other then that I had no problem learning MySQL. You should use this site if you need help with it: here. It is very simple and good to use just for documentation purposes or if you forget the format of something. The only thing to watch out for is MySQL injection or hacks. I believe the website above has a basic solution for them if you are using PHP.

Good luck at learning MySQL and don't forget it is less complicated then you think. By the way one nice thing about MySQL is that it is almost identical in every language ex PHP, Java and C++.

Sparkx

Also wutske I have never seen a MySQL code that complicated... I wish I would have known about the sooner, probably would have made my life a lot easier then when I was trying to loading two or more tables with lots of statements (that was fun...).

yaoersd just a suggestion, try making longer posts, they look better on hosting applets.
Go to the top of the page
 
+Quote Post
darkken
post Jul 2 2008, 10:07 PM
Post #15


Newbie [ Level 2 ]
Group Icon

Group: Members
Posts: 10
Joined: 2-July 08
Member No.: 31,263



Just remember it is just hard to think in terms of DBs. Once you get the hang of mysql it becomes really easy. Just learn sql language a little bit and the rest comes easy. If you consider php to handle mysql i would also consider using phpMyAdmin. It works great for creating and managing tables so you can query them later.
Go to the top of the page
 
+Quote Post

2 Pages V  < 1 2
Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. MySQL Realtime Replication(3)
  2. Error In Installing MySQL Server(6)
  3. Recover Tables From A MySQL .frm File(6)
  4. Mirror My MySQL Database To Another Mysql Server(4)
  5. How To Connect MySQL With Flash?(8)
  6. MySQL, Multiple Tables(22)
  7. Access -> Mysql(8)
  8. Is It A Good Practice To Store Image Or Other Binary Files Directly In A Mysql Database(4)
  9. Navcat For MySQL(7)
  10. Permission Problem With Mysql Database Creation(8)
  11. Mysql And Php(15)
  12. Problems With Php Saving Data Into Mysql(6)
  13. Login System Using A Mysql Db(4)
  14. What Is Mysql With Mysqli(6)
  15. Can I Use Openoffice Base To Connect To Mysql?(1)
  1. Mysql Question...(6)
  2. Oracle Vs. Mysql Vs. Postgresql(9)
  3. Installing Mysql?(17)
  4. Mysql Query Question(3)
  5. Lost Connection To Mysql ,..., System Error: 111 In(3)
  6. Subqueries In Mysql(1)
  7. Apache Php With Mysql On Windows [solved](9)
  8. Not Understanding Mysql(4)
  9. Mysql Script Help(3)
  10. Mysql Problem(1)
  11. Sun Bought Mysql(6)
  12. Mysql Backup With Another Address?(4)
  13. I Have An Error With My Mysql Connection(7)


 



- Lo-Fi Version Time is now: 6th July 2008 - 09:57 AM