Which tool to use for developing Pl/Sql on MySQL?

2010-07-15 Thread alba.albetti
Hi, beginning to work with MySQL I've found there exist two similar tools for browsing the db and developing in Pl/Sql and they are SQL-Front and MySQL Query Browser. Fot not wasting time in learning both can anyone tell me which of these is generally used wordwide? So I make practice with the

Why is MySQL always linked to Php?

2010-07-15 Thread alba.albetti
Browsing the Web I've seen that usually companies look for developers working on MySQL and Php. Why are the two things linked? I mean I've not found any requests for just a MySQL developer or DBA (as for example it happens for Oracle), but it's always requested a MySQL/Php expert. I ask for it

How to define the initial space for a table

2010-07-14 Thread alba.albetti
Is it possible in MySQL to define the initial space that the table is going to use and the space for its growth? I usually work on Oracle where the syntax is: create table MYTABLE (...fields...) tablespace MYTABLESPACE (initial 2M next 1M); that means Oracle reserves a data block of 2Mb for

How to become a DBA on MySQL

2010-07-13 Thread alba.albetti
Hi, I'd like to know which are the main tasks for a DBA, so in addition of the on-line tutorial of MySQL, is there anyone telling me whether there exists some tutorial (better if in PDF) where it's possible to undestand and learn all you need for managing the MySQL DB as DBA? I mean I'd like to

Sql Front or Query Browser?

2010-04-12 Thread alba.albetti
Sorry but for working on MySQL (I want to write query and stored procedure) are there any differences between Sql Front and Query Browser? I haven't undestood it they are the same thing or not? Could you advise me where to download both of them? Thanks! -- MySQL General Mailing List For list

How to watch stored procedures

2010-04-09 Thread alba.albetti
Since I work on MySQL by using phpMyAdmin, is there anyone saying to me if and how it's possibile to see the code of a stored procedure that I've created? For example on Oracle I use sql-developer but with phpMyAdmin is it possible to see the whole code of a procedure or of a trigger after

Problem with installing MySQL

2010-04-08 Thread alba.albetti
I've just installed MySQL on Windows 2000. I've opened the MS-DOS windows and I've written C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql2010 After the enter the prompt says Enter password: and I've given enter and I get mysqladmin: connect to server at 'localhost' failed