Re: odbc

ODBC does not need to be installed on the server machine. It is only needed on the client. So, it is possible to use Access to connect to the MySQL server even though the ODBC is not installed on the server. Just install MyODBC on the client machine and tell Access to connect through ODBC. You may

Re: Automatic conversion from `char` TO `varchar`

Hi Michael, > >>The manual says > >> > >> > >>>The following problems are known and will be fixed in due time: > >>>[...] > >>>All string columns, except BLOB and TEXT columns, automatically have > >>>all trailing spaces removed when retrieved. For CHAR

Which one is better: CHAR or VARCHAR?

Hi, I've a column of type VARCHAR(10) where I know the data would be 10-char in length - always. Apart from the fact that VARCHAR saves space as compared to CHAR, is there any performance benefit? If yes, is it significant enough? Thanks. Hassan

Re: Which one is better: CHAR or VARCHAR?

Char is more efficient when selecting but less efficient when storing (wastes space). It is a trade off so there really isn't a "right" answer. Do some experimenting and see what works best for you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: HTML in Longtext

The double quotes have meaning in HTML. You might be confusing the parser. Try replacing your double quotes with ". -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

inser woes

This has to be something silly, but I can not see it. Any help greatly appreciated: use newshop; insert into products set storeid=2, deptid=5, groupid=66, prodid='C2BUWS1028', prodtitle='Antique Circle 6/20; 1/2inches-lg Pearl Buttons & Novelty Buttons', proddesc1='3 buttons per card; 1/2

Problem with LPAD() function

I think there is a bug in LPAD() function. Just try to run this query: SELECT LPAD(12, 3, '0'); This will correctly return 012 as expected. But when I run SELECT LPAD(512, 3, '0'); It doesn't return 512, instead it returns special characters. With that situation I

Re: inser woes

Hi Doug, I think you need to quote "imgsml=C2BUWS1028.jpg," like imgsml='C2BUWS1028.jpg', take care, /Johan [EMAIL PROTECTED] wrote: This has to be something silly, but I can not see it. Any help greatly appreciated: use newshop; insert into products set storeid=2, deptid=5, groupid=66, pr

Re: New grant tables

Check the User `table` of the `mysql` database If the Password column is 45 characters long, it has changed it. Hope I remember it correctly. Thanks Emery - Original Message - From: "Scott Haneda" <[EMAIL PROTECTED]> To: "MySql" <[EMAIL PROTECTED]> Sent: Sunday, January 04, 2004 03:37 S

group_concat() alternative for mysql < 4.1?

Hi all! I'm wondering - are there any alternative to the function group_concat() for mysql servers prior to 4.1? The reason for asking is that I'm building a library database, where each book can have n numbers of authors, where n >= 0. In listings I want to get all the authors of one book as

Looking for a good SQL statement.... (I need some help)

Hi I have one table called noms like this: | id | int(11) | | PRI | [NULL] | auto_increment | | reference| varchar(255) | | component| varchar(255) | the relation between reference and component is hierarchical like reference - > component reference

Re: Problem with LPAD() function

"Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote: > I think there is a bug in LPAD() function. > > Just try to run this query: > SELECT LPAD(12, 3, '0'); > This will correctly return 012 as expected. > > But when I run > SELECT LPAD(512, 3, '0'); > It doesn't retur

Storing currency values

Hello. I’ve spent some day(s) probing the web to find a solution to this problem: A table-column for storing currency –> float(10,2). As my users are punches the currency value like this “255,55”, with a comma as decimal point, MySQL stores this value as zero (0.00). I quess the reason fo

Re: New grant tables

i dont think that, cauz 'Password' field in 'user' table was always 16 char long and still is. In fact, check for the no. of privs in 'user' table. if it is 21 or 14, as in 3.23.x it was 14 and in 4.0.17 is 21. Hope that helps Nitin - Original Message - From: "Director General: NEFACOMP"

What full-text improvements are next?

Hi, Sorry, I guess this is yet another question for Sergei! :-) Since the full-text search TODO in the manual is a little vague (and hasn't been updated much) and it was kind of a "surprise" when multi-byte character-set support was added to 4.1 a couple months ago, I'm wondering what "surprises"

Re: 4.1.1 FTS 2-level?

Hi, - Original Message - From: "Sergei Golubchik" To: "Steven Roussey" Sent: Wednesday, December 10, 2003 7:44 AM Subject: Re: 4.1.1 FTS 2-level? > Hi! > > On Dec 09, Steven Roussey wrote: > > Does Mysql 4.1.1 have the two level index system integrated into it for full > > text searches?

Re: Which one is better: CHAR or VARCHAR?

If the data is 10-char in length always, CHAR is better performance-wise. - Original Message - From: "Hassan Shaikh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, January 11, 2004 6:34 PM Subject: Which one is better: CHAR or VARCHAR? Hi, I've a column of type VARCHAR(10) w

Re: Which one is better: CHAR or VARCHAR?

Hi Hassan, In a case like that where you know the data will always be a certain length, CHAR is definitely better. VARCHAR will actually waste space (1 byte) when the data is always a certain length. And yes, if using the CHAR allows your table to have fixed-length rows, there will be a speed im

Re: What full-text improvements are next?

While on the subject of wishes for FullText enhancements, there is one I would like to add to the wish list: the ability to make certain punctuation characters into "letters" for the purpose of FullText searches. The main reason is to put video timecodes, which are in the form 12:34:56:01 int

Re: Automatic conversion from `char` TO `varchar`

Hi, - Original Message - From: "Michael Stassen" Sent: Sunday, January 11, 2004 5:10 PM Subject: Re: Automatic conversion from `char` TO `varchar` > > Martijn Tonies wrote: > > > Hi, > > > >>The manual says > >> > >> > >>>The following problem

Re: query efficiency

Hi Dan, Just run the UPDATE with all the column you want to update. :-) MySQL won't update the ones that haven't changed (which may have been said). Don't waste time trying to determine whether you should include a column in the UPDATE or not. The only time it could be an issue is if you're se

mysqld crash on FreeBSD-Alpha (64 Bit)

>Description: mysqld 4.0.17 crash on FreeBSD 5.1-current-alpha >How-To-Repeat: Any acces over IP (not domain socket) crashes mysqld: #/usr/local/bin/mysqladmin: connect to server at 'install' failed error: 'Lost connection to MySQL server during query' syslog: install mysqld[78066]: warnin

Re: Storing currency values

Hi Asbjørn, try to use "replace" function: http://www.mysql.com/doc/en/String_functions.html update YourTable set YourMoney = REPLACE('255,55', ',', '.') where ... ; Best regards, Mikhail. - Original Message - From: "Asbjørn Konstad" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: M

I'm using 4, host using 3!!!

I am using version 4 of MySQL and the people who I am told to use to host the site are running 3 on the server I will be using. I am not using any real complex table structures eg: autoincrement, date, timestamp, medium int, small int, indexes. I have to do a dump of data to install on remote s

Speeding up queries by avoiding ORDER BY clauses

Hi, I am trying to speed up the full text searching on my MySQL database. I currently have one table that has approximately 90,000 rows added to it each 24 hour period in batches of up to 200 rows constantly. These rows are will be kept for approximately 60 days, however I am currently working

Re: I'm using 4, host using 3!!!

* Matthew Stuart > I am using version 4 of MySQL and the people who I am told to use to > host the site are running 3 on the server I will be using. This is probably not so unusual. 3.23.x hopefully, and x should be as big as possible...: 3.23.47 was the last version released in 2001, 3.23.54 was

Passwords query

I have been given these passwords for a MySQL db on a remote server. I have to dump the records to this volume on the remote and I am not sure what these passwords mean to me. SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER username_master password SELECT,INSERT,UPDATE,DELETE username_runtime pass

Re: Storing currency values

Just convert the format of the input in your program before saving the value. In VB/ASP us can do: replace(255,55,",",".") -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Storing currency values

* Asbjørn Konstad > I’ve spent some day(s) probing the web to find a solution to this problem: > > A table-column for storing currency –> float(10,2). > > As my users are punches the currency value like this “255,55”, > with a comma as decimal point, MySQL stores this value as zero (0.00). > > I qu

Re: Passwords query

These look like the security permissions for 3 MySQL user entries. The first one is the administrator account which can do pretty much anything. The second looks like an account used by a program. The third looks like it can be given to individual users as it can only looks at records, not chan

metric conversions

I recieve measurements for a product sometimes in inches, sometimes in centimeters. These are stored in table1 int not null primary key, measurement1 int, measurement2 int, type varchar(255) I need to extract data from this table and store it in another table with all measurements converted to

hierarchical records, I need some help!! ;(

Hi I have one table called noms like this: | id | int(11) | | PRI | [NULL] | auto_increment | | reference| varchar(255) | | component| varchar(255) | the relation between reference and component is hierarchical like reference - > component reference

Re: metric conversions

Hi, > I recieve measurements for a product sometimes in inches, sometimes in > centimeters. > > These are stored in table1 > int not null primary key, measurement1 int, measurement2 int, type > varchar(255) > > I need to extract data from this table and store it in another table with all > measure

User quotas, how?

Hiya all! I'm curious about if there's a simple way to manage user quotas in a MySQL database? F.x. user one can have 10MB data in the database and user two can have a maximum of 5MB? Anders Norrbring -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

Re: metric conversions

* Richard Davies > I recieve measurements for a product sometimes in inches, sometimes in > centimeters. > > These are stored in table1 > int not null primary key, measurement1 int, measurement2 int, type > varchar(255) > > I need to extract data from this table and store it in another > table with

Re: hierarchical records, I need some help!! ;(

Victor, First: don't ask the same thing twice. > I have one table called noms like this: > > > | id | int(11) | | PRI | [NULL] | auto_increment | > | reference| varchar(255) | > | component| varchar(255) | > > the relation between reference and component is hierarch

Re: metric conversions

You could do something like (don't copy and paste, this is just for you to have an ideia - i didn't understand your calculations with 0.063 and others...): SELECT IF (metric="cm", expression_in_centimeters, expression_in_inches) , ...other_fields FROM ... where "metric" is the name of the tab

Re: Passwords query

these are definitely MySQL connection identities. Each with specific (different) privileges. You can connect to the database directly with these. - Original Message - From: "Matthew Stuart" <[EMAIL PROTECTED]> To: "MySQL email support" <[EMAIL PROTECTED]> Sent: Monday, January 12, 2004 6:

Optimization help

Hi all - I have a speed problem that I don't understand. I've been pretty active with DB's for a few years, but I'm no expert, so let me know if I'm missing the obvious. I have Paul DuBois' MySQL book (New Riders edition) and Descartes and Bunce's Programming DBI book on my desk, so feel free

Question about Mysql C API v 3.22 and 3.23

Hello, I am attempting a change in my use of mysql C API to use 3.23.54 instead of 3.21 and I am finding that the mysql_real_connect function is failing to run (it crashes the program). My mysqld version is also 3.22.27. Anyone know whether this is a bug in that version of the C API? Thank You,

Re: Optimization help

I think... you don't have an index on the "Incident" field itself, just on (Date, Incident, Type, Task) which means that it concatenates those fields and orders the result - thus this may be virtually useless if you're looking for a specific incident within a large date range. Since your query

Re: inser woes

:( Thank you - my only defense - it was 04:00, I think I looked at it too long and got hung up on the line 2. Doug On Mon, 12 Jan 2004, Johan Hook wrote: > Hi Doug, > I think you need to quote "imgsml=C2BUWS1028.jpg," like > imgsml='C2BUWS1028.jpg', > > take care, > /Johan > > [EMAIL PROT

Re: Question about Mysql C API v 3.22 and 3.23

At 8:51 -0600 1/12/04, Joe Johnson wrote: Hello, I am attempting a change in my use of mysql C API to use 3.23.54 instead of 3.21 and I am finding that the mysql_real_connect function is failing to run (it crashes the program). My mysqld version is also 3.22.27. Anyone know whether this is a bug i

COMP_ERR is missing in windows binary distribution zip file of 4.1.1a

Hello mysql, subj. It's inconvenient, because one should get source distribution and compile this tool. -- Best regards, Viktor mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.

Problem with MySQL and Solaris 9 sparc

> > Hi, my name is Carlos Flores, and i have solaris 9 on ultra 10 > > workstation, but > > i can not up this daemon, with /opt/sfw/mysql/bin/mysqld_safe & i try > > to up this > > daemon, but always begin but in second line tell me: mysql ended, and > > i try with > > mysql_install and anyone opti

Re: Optimization help

On Jan 12, 2004, at 08:09 AM, Douglas Sims wrote: I think... you don't have an index on the "Incident" field itself, just on (Date, Incident, Type, Task) which means that it concatenates those fields and orders the result - thus this may be virtually useless if you're looking for a specific inc

Resetting Auto_Increment

Hi, The following does not work for InnoDB tables. The manual says "The next AUTO_INCREMENT value you want to set for your table (MyISAM). " ALTER TABLE AUTO_INCREMENT = ; Any suggestions for InnoDB? Thanks. Hassan

Re: Resetting Auto_Increment

On Mon, 12 Jan 2004, Hassan Shaikh wrote: > Hi, > The following does not work for InnoDB tables. The manual says "The next > AUTO_INCREMENT value you want to set for your table (MyISAM). " > ALTER TABLE AUTO_INCREMENT = ; > > Any suggestions for InnoDB? Insert a row with a custom value, then de

my.ini file for two instances of MySql - need help

Hello, I need to get two instances of Mysql running on the same machine. It's a windows 2000 server. The existing MySQL is 3.23 and is running in another directory. It appears to be used for LiveStats. I need to install version 4 and have them both running. What do I need to add to the my.in

Re: my.ini file for two instances of MySql - need help

At 16:48 + 1/12/04, Rich Brant wrote: Hello, I need to get two instances of Mysql running on the same machine. It's a windows 2000 server. The existing MySQL is 3.23 and is running in another directory. It appears to be used for LiveStats. I need to install version 4 and have them both run

RE: my.ini file for two instances of MySql - need help

Here is an example of what I used: [mysqld] # set basedir to your installation path basedir=C:/mysql # set datadir to the location of your data directory datadir=C:/mysql/data # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that

field reference question

Is there an abstract way to refer to field names in a result set? For example: select ID, Name, Price from Products order by field(1) where "field(1) would be the abstract way of referring to the specific field to sort on. It's for a function that allows me to display tables and sort by colum

backup my database

Hi there. Do u know how can i backup my database? (create && insert) __ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- MySQL General Mailing List For list archives: http://lists.mysql.com/m

Mysql 4.1.1a

Hello mysql, Table-level privileges do not work at all... (on Windows) -- Best regards, Viktor mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: field reference question

On Mon, 12 Jan 2004, Ed Lazor wrote: > Is there an abstract way to refer to field names in a result set? > select ID, Name, Price from Products order by field(1) > where "field(1) would be the abstract way of referring to the specific field to sort > on. ORDER BY # Where # is the number of the c

RE: my.ini file for two instances of MySql - need help

Thanks, Chris, but how do I refer to the sencond instance of MySQL, the version 4? That's what's not clear to me. I did read the section in the manual, but it doesn't explain how to refer to seperate instances. THanks! From: "Chris L. White" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> T

Re: backup my database

On Mon, 12 Jan 2004, Alaios wrote: > Hi there. Do u know how can i backup my database? > (create && insert) http://www.mysql.com/doc/en/Backup.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem creating sp

I'll be trying to work with sp on win32/5.0.0-alpha-max-debug; I take the mysql's page example to test but makes an error: mysql> delimeter | -> create function hello (s char(20)) returns char(50) -> return concat('Hello, ',s,'!'); ERROR 1064 (42000): You have an error in your SQL syntax.

RE: my.ini file for two instances of MySql - need help

> Hello, > > What do I need to add to the my.ini file? Can anyone post a typical setup > of this as an example? I install with mysqld-nt-max --install servicename servicename in those cases are MysQL40, MySQL41 and MySQL50 Those are the relevant rows: [mysqld] [mysql40] basedir = C:/mysql/4.0

Re: my.ini file for two instances of MySql - need help

> # If you specify no service name, the server uses the default service name of MySQL > and the server reads options from the [mysqld] group in the standard option files. > # If you specify a service name after the --install option, the server ignores the > [mysqld] option group and instead read

RE: my.ini file for two instances of MySql - need help

Ok, Thanks Tobias! I'm all set. And I actually found the relevant info in the manual. Sorry for the bother, all. From: Tobias Asplund <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: "'Rich Brant'" <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: RE: my.ini file for two instances of MySq

Strange ORDER BY question

Okay I have a field in my db called MemberLevel in this field you can be one of 5 levels. Platinum Gold Silver Paying Non-Paying now my question is, how would I ORDER BY MemberLevel and get it to come out in the above order? I have been racking my brains for a week on this one and any he

Can't create Database

Ok got MySQL running and I have MyODBC installed as well. In any event. I have the test database and I can see it. I need to create a new database and it is not letting me do that. It tells me access denied for user ' ' @' localhost. I used the syntax mysqladmin create database . Have I done s

Recreating InnoDB tables from .frm

I'm cleaning up a user-error where the innodb data files were deleted without a useful backup. I need to reconstruct the tables and still have the frm files. Is this possible? A significant amount of time was put into these tables' structures and I hate to lose that effort... Yes the users are

RE: Strange ORDER BY question

From: Lewis, Jason [mailto:[EMAIL PROTECTED] > Okay I have a field in my db called MemberLevel in this field > you can be one of 5 levels. > > Platinum > Gold > Silver > Paying > Non-Paying > > > now my question is, how would I ORDER BY MemberLevel and get > it to come out in the above

Space Column

I am beginning in mysql, and I do not obtain to create a table with a space column. some friend could help me? mysql> CREATE TABLE g1 (p1 GEOMETRY); Error 1064 : -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PRO

Re: Automatic conversion from `char` TO `varchar`

Martijn Tonies wrote: Hi Michael, The manual says The following problems are known and will be fixed in due time: [...] All string columns, except BLOB and TEXT columns, automatically have all trailing spaces removed when retrieved. For CHAR types t

wildcards the field

Hi, I'd like to use a mysql database as a lookup to authorize people to edit a webpage. The idea is that people would go to a main login page for authentication and then when they visit a page they are authorized to edit, they see an "edit this page" link. What I'm envisioning is a really bas

Re: Strange ORDER BY question

On Mon, 12 Jan 2004, Lewis, Jason wrote: > Okay I have a field in my db called MemberLevel in this field you can be one of 5 > levels. > > Platinum > Gold > Silver > Paying > Non-Paying > > > now my question is, how would I ORDER BY MemberLevel and get it to come out in the > above order? I have

Re: Resetting Auto_Increment

You got to be kidding! I am sure there's a better solution. Hassan - Original Message - From: "Tobias Asplund" <[EMAIL PROTECTED]> To: "Hassan Shaikh" <[EMAIL PROTECTED]> Cc: < Sent: Monday, January 12, 2004 9:43 PM Subject: Re: Resetting Auto_Increment > On Mon, 12 Jan 2004, Hassan Sh

RE: Strange ORDER BY question(SOLUTION)

Didn't know if anyone else might need this but I was given the solution. SELECT * FROM tablename ORDER BY MemberLevel='Platinum' DESC, MemberLevel='Gold' DESC, MemberLevel='Silver' DESC, MemberLevel='Paying' DESC, MemberLevel='Non-Paying' DESC; Thanks again Mike! Jason -- MySQL General

Foreign key contraints, on delete cascade not working?

I created the following .sql file to demonstrate a problem I'm having. According to the manual: If ON DELETE CASCADE is specified, and a row in the parent table is deleted, then InnoDB automatically deletes also all those rows in the child table whose foreign key values are equal to the refere

RE: Strange ORDER BY question(SOLUTION)

From: Lewis, Jason [mailto:[EMAIL PROTECTED] > Didn't know if anyone else might need this but I was given > the solution. > > SELECT * FROM tablename > ORDER BY MemberLevel='Platinum' DESC, > MemberLevel='Gold' DESC, > MemberLevel='Silver' DESC, > MemberLevel='Paying' DESC, > MemberLevel='N

How to move data between tables in a database?

Hello, I would like to move data between tables in mysql within the same database, I am not sure what the best way to go about it is. I do not need to move all the data in the tables, just the output of some select statements. I am using Perl DBI and MySql 4.0.15-standard on RedHat 8.0. I guess I

Installation-related question -- inter host communication

Hi. I have MySql 3.23.49 on machine A. I have apache on machine B, and wish to ultimately run queries on databases on machine A using perl/DBI as CGI from Apache. Machine B was wiped and rebuilt from the RH9 up, but has no Mysql on it at all. My goal is to share the load a bit. Do I need to pu

Re: How to move data between tables in a database?

"Syed Ali" <

Table Joins

Hi, I have 2 identical tables and wish to join them. I am a complete novice and thought it was simple! Here is the code that I am using with asp.net select Date, Payroll, First, Last, Rank, Number, Division, Reason, ImpDate from all_by_Payroll, payinc where "+ DropDownList1.SelectedItem.Value +

Re: Automatic conversion from `char` TO `varchar`

Hi Michael, > >>>Indeed. Nevertheless, I'm right at this one :-) > >> > >>I defer to your expertise on SQL standards. Regardless of the standard, > >>however, mysql does not pad CHARs with spaces. Thus, CHARs and VARCHARs > >>are identical from the client's point of view, so silently changing >

What Does This Mean

It says I am not allowed to connect to the mySQL server. I am trying root and admin and it won't let me in. Have I done something wrong and what do I check? Chris L. White Network Administrator Coe-Truman Technologies, Inc. Email: [EMAIL PROTECTED]

Re: How to move data between tables in a database?

On Mon, Jan 12, 2004 at 12:54:55PM -0500, Syed Ali wrote: > Hello, > > I would like to move data between tables in mysql within the same > database, I am not sure what the best way to go about it is. > I do not need to move all the data in the tables, just the output of > some select statements.

Addition to Last Post on Connecting to MYSQL

Also It keeps telling me that the host is not allowed to connect to the MySQL server, funny thing is the host that is trying to connect is the actual machine that MYSQL is on? Chris L. White Network Administrator Jr. Coe-Truman Technologies, Inc. Email: [EMAIL PROTECTED]

Re: Bug in Boolean mode fulltext searching.

Hi! On Jan 07, [EMAIL PROTECTED] wrote: > >Description: > Boolean mode fulltext searching returns zero hits for valid queries. > >How-To-Repeat: > Create a database with a Text column. Add a fulltext index on it. > Try to search for multiple words with AND or phrase syntax. >

Re: Space Column

Just enclose the column name in backticks (upper left key on your keyboard just below ESC). Be warned that if you do this you will ALWAYS have to refer to this column using the backticks. It would be MUCH better to remove the space from the name. You might consider using an underscore instead.

Re: Strange ORDER BY question(SOLUTION)

* Mike Johnson > From: Lewis, Jason [mailto:[EMAIL PROTECTED] > > > Didn't know if anyone else might need this but I was given > > the solution. > > > > SELECT * FROM tablename > > ORDER BY MemberLevel='Platinum' DESC, > > MemberLevel='Gold' DESC, > > MemberLevel='Silver' DESC, > > MemberLe

Re: Can't create Database

It looks like you didn't specify a user. Try this: mysql -u root -p It will prompt you for the password that you set up for the root account. After you enter it you will get a mysql> prompt. Now type: create database newdatabase; This will create a new database called newdatabase. You can l

Re: Space Column

* [EMAIL PROTECTED] > I am beginning in mysql, and I do not obtain to create a table > with a space column. > some friend could help me? > > mysql> CREATE TABLE g1 (p1 GEOMETRY); > Error 1064 : The error message got lost in the mail. Beware that spatial support is introduced in mysql version 4.1,

Re: What Does This Mean

Did you set a password for the root account? MySQL comes with a root user that (initially) has no password and all privileges. Most setup instructions have you assign a password to the root account pretty early on. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql T

Re: What does this Mean

C:\MySQL\bin>mysql show ERROR 1045 (28000): Access denied for user: 'ODBC'@'localhost' (Using password: YES) C:\MySQL\bin>mysql show -u root ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using password: YES) C:\MySQL\bin>mysql show -u root -p Enter password: *

Re: Automatic conversion from `char` TO `varchar`

you seem to have mixed single and double quotes. this might be your problem - Original Message - From: "Hassan Shaikh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, January 10, 2004 7:06 AM Subject: Automatic conversion from `char` TO `varchar` > Hi, >

Re: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

Thanks for responding randy. so I checked my my.ini file and the address is set to 127.0.0.1. I checked the database error file and it was empty. I posted the my.ini file down below. Any other suggestions ? When I try to startmysql through the MSDOS prompt it says C:\Program Files\EasyPHP1-7\

Re: mysql.sock

Mike Mapsnac wrote: I got such error message ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/ mysql/mysql.sock' (111) Thanks Right. This means that you're using the mysql command-line tool, and it's trying to talk to MySQL through the /var/lib/mysql/mysql.sock file, but

Mysql Socket Error

Hello Friends, We are using free bsd, mysql 4.0.15. We are using this system since more than a year now. We have a autoresponder script which has mysql database. Since a month or so we are noticing that mysql gives the mysql.sock error and the only option which remains is to reboot the entire s

Re: What does this Mean

Chris L. White said: > C:\MySQL\bin>mysql show > > ERROR 1045 (28000): Access denied for user: 'ODBC'@'localhost' (Using > password: > > YES) > > > > C:\MySQL\bin>mysql show -u root > > ERROR 1045 (28000): Access denied for user: 'root'@'localhost' (Using > password: > > YES) Your musql setup requi

Re: Mysql Socket Error

Birju Shah wrote: Hello Friends, We are using free bsd, mysql 4.0.15. We are using this system since more than a year now. We have a autoresponder script which has mysql database. Since a month or so we are noticing that mysql gives the mysql.sock error and the only option which remains is to reb

Re: metric conversions SOLVED

On Monday 12 Jan 2004 13:20, Richard Davies wrote: (B (BThank you to everyone who offered advice on this problem I knew it was easy (Bbut couldn't see how to do it. (B (BThanks again. (B (B> I receive measurements for a product sometimes in inches, sometimes in (B> centimeters. (B> (B> T

Rounding to nearest one sixteenth of an inch.

Does anyone have any ideas on how to round a number in the form float(3,4) to the nearest sixteenth of an inch. eg ending in .0625, .125 .1875 .25 .3125 etc I haven't found anything in the manual about this, maybe normal people don't want to do this. -- Regards Richard -- MySQL General

RE: What Does This Mean

You know what is even more screwed up now. I did this command and when it prompted me for the password I just hit enter and wallah look what I got. But I am sure there is other stuff messed up now: C:\MySQL\bin>mysql -u root -p Enter password: ** ERROR 1045 (28000): Access denied fo

Re: Rounding to nearest one sixteenth of an inch.

In the last episode (Jan 12), Richard Davies said: > Does anyone have any ideas on how to round a number in the form > float(3,4) to the nearest sixteenth of an inch. > > eg ending in > .0625, > .125 > .1875 > .25 > .3125 ROUND(myfield*16)/16 should work. -- Dan Nelson [EMAIL

Re: Rounding to nearest one sixteenth of an inch. (Solved)

On Monday 12 Jan 2004 22:23, you wrote: (B> Richard Davies wrote: (B> > Does anyone have any ideas on how to round a number in the form (B> > float(3,4) to the nearest sixteenth of an inch. (B> (B> Multiply by 16, round, divide by 16. (B (BObvious really, (Bupdate table1 set field1 = (round

JOIN types

Hey all, I've read the pages in the MySQL manual that explain the types of JOINs many times, but still think I'm missing something. I usually was always using INNER JOIN in all my join queries, and in a few cases LEFT JOIN (in cases I wanted the rows in one table that were not in the other one

  1   2   >