Re: Error message on starting MySQL Server

2005-12-24 Thread SGreen
SOTL <[EMAIL PROTECTED]> wrote on 12/24/2005 06:22:25 PM: > Hi All > > New to MySQL in that I have never ran a database. > > I have Mandrake 10.1 in which I can not connect to because I do not have the > correct MySQL connector but MySQL server is working. Having spent over a week > looking

Error message on starting MySQL Server

2005-12-24 Thread SOTL
Hi All New to MySQL in that I have never ran a database. I have Mandrake 10.1 in which I can not connect to because I do not have the correct MySQL connector but MySQL server is working. Having spent over a week looking for the correct connector twice -last August and last week - I am well awa

Re: 2 questions

2005-12-24 Thread Octavian Rasnita
Hi, Here is the error: > mysql -u odbc database < zzz.sql ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL serv er version for the right syntax to use near '´¬¬ /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */' at

Re: NOT NULL and default: using mysqldump to upgrade from 4.0 to 5.0

2005-12-24 Thread Gleb Paharenko
Hello. The error should disappear if you perform the dump using --quote-names option. Alex Davies <[EMAIL PROTECTED]> wrote: >Hi, > >I have two servers and am trying to move the database from one to the other. > >The data is currently residing in a MySQL 4.0 database. The new server i

Re: 2 questions

2005-12-24 Thread Gleb Paharenko
Hello. > It gives an error near some special chars (because the file is not >ANSI). Please, could you provide the error message. Check if it disappears if you perform the dump with --quote-names option. > The second question is related to "explain". Is there a "explain" >function for upd

Re: I'm new to mySQL

2005-12-24 Thread John in Pueblo
On Saturday 24 December 2005 1:05 pm, James Lumb wrote: > Hi, > I am new to mySQL and have mac OS X. Please could any other Mac users or > anyone for that matter tell me the best way of connecting to a mySQL > database? > Should I use terminal or a program like PHPmyAdmin? > > Cheers, > James Jam

Re: I'm new to mySQL

2005-12-24 Thread John Meyer
On Saturday 24 December 2005 1:05 pm, James Lumb wrote: > Hi, > I am new to mySQL and have mac OS X. Please could any other Mac users or > anyone for that matter tell me the best way of connecting to a mySQL > database? > Should I use terminal or a program like PHPmyAdmin? > > Cheers, > James Jam

Re: New to MySQL

2005-12-24 Thread John Meyer
On Saturday 24 December 2005 1:05 pm, James Lumb wrote: > Hi, > I am new to mySQL and have mac OS X. Please could any other Mac users or > anyone for that matter tell me the best way of connecting to a mySQL > database? > Should I use terminal or a program like PHPmyAdmin? > > Cheers, > James Jam

RE: I'm new to mySQL

2005-12-24 Thread ISC Edwin Cruz
MySQL AB has a very good GUI tools Have a look in: http://www.mysql.com/products/tools/ You should try to use them, phpmyadmin also is good. For administration mysql-administrator To execute queries or create functions, procedures, etc mysql-querybrowser To migrate data from another RMDBS so use

I'm new to mySQL

2005-12-24 Thread James Lumb
Hi, I am new to mySQL and have mac OS X. Please could any other Mac users or anyone for that matter tell me the best way of connecting to a mySQL database? Should I use terminal or a program like PHPmyAdmin? Cheers, James _ Are y

NOT NULL and default: using mysqldump to upgrade from 4.0 to 5.0

2005-12-24 Thread Alex Davies
Hi, I have two servers and am trying to move the database from one to the other. The data is currently residing in a MySQL 4.0 database. The new server is running MySQL 5.0. Trying to import a table such as CREATE DATABASE /*!32312 IF NOT EXISTS*/ db17058c; USE db17058c; DROP TABLE IF EXISTS ad

Re: MySQL query question

2005-12-24 Thread Peter Brawley
Josh, >I have several tables, all with many-to-many joining tables. > users > users_teams > teams > teams_projects > projects Once again explicit join syntax clarifies matters: SELECT DISTINCT username FROM users INNER JOIN users_teams ON (users.id = users_teams.user_id) INNER JOIN teams ON

Re: MySQL query question

2005-12-24 Thread Hank
>since I'm not sure how users would > ever be directly associated with teams - I would have expected to find > players to be associated with teams - so forgive me if this doesn't > resemble very much what you're doing: Think corporate projects, not sports. Here's my take on the original query.. y

Fw: MySQL query question

2005-12-24 Thread Rhino
Oops, I meant to copy the mailing list on this reply. Rhino - Original Message - From: "Rhino" <[EMAIL PROTECTED]> To: "Josh Mellicker" <[EMAIL PROTECTED]> Sent: Saturday, December 24, 2005 9:24 AM Subject: Re: MySQL query question - Original Message - From: "Josh Mellicke

MySQL query question

2005-12-24 Thread Josh Mellicker
I have several tables, all with many-to-many joining tables. users users_teams teams teams_projects projects --- So, with a projects.id = 1, I want to get all the usernames of people on teams assigned to that project. SELECT DISTINCT username FROM users, users_teams, teams, projects_te

Re: Strange behavior with integer unsigned type...

2005-12-24 Thread Marko Domanovic
mysql 5.0.15-standard UPDATE SET = -1 when the is 0 gives me 4294967295 is integer(10) unsigned... maybe it would be more logical the expression to evaluate as 0, insted 2^32 .. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.

2 questions

2005-12-24 Thread Octavian Rasnita
Hi, I have used mysqldump with 5.0.15-nt and I have seen that it saves the file in UTF-8 format. This is OK, but if I try to run: mysql database < saved_file.sql It gives an error near some special chars (because the file is not ANSI). If I convert the file as ANSI, I can import the data from i