Re: NEWBIE to mysql

2003-02-10 Thread Gurhan Ozen
You need to separate the fields with a comma.. Do: name varchar(50), message varchar(255) See: http://www.mysql.com/doc/en/CREATE_TABLE.html Gurhan On Fri, 2003-02-07 at 19:52, Wileynet wrote: Can anyone tell me why I keep getting an ERROR 1064 with this command ? I just would like to create

Re: SQL Query

2002-11-16 Thread Gurhan Ozen
First of all, don't do this in mysql . If you got a dump of the database, using cut utility u can easily extract the second field in the delimited by the comma.. and then split them into different columns in the table when you want to insert them into the mysql database. If you are still

Re: mySQL references

2002-09-21 Thread Gurhan Ozen
Hi Michael, This is kind of vague request:) MySQL will just store data, the efficiency of searching is mostly depend on how good the database design is, and how good your search program is. However, MySQL offers a unique feature called fulltext searching capability which will make your life so

Re: how do I add 2weeks to a datetime?

2002-09-07 Thread Gurhan Ozen
Are you even reading the manual before posting questions? http://www.mysql.com/doc/en/Date_and_time_functions.html SELECT NOW() + INTERVAL 14 DAY AS exp_date; Gurhan On Fri, 2002-09-06 at 21:40, Clemson Chan wrote: hi guys, I have a column expire_date DATETIME. How do I add 2 weeks to

Re: How to read table names within database?

2002-09-06 Thread Gurhan Ozen
The command show tables; will give you what you want. See: http://www.mysql.com/doc/en/SHOW.html Gurhan On Fri, 2002-09-06 at 02:42, Mark Worsdall wrote: Hi, I notice that lots of mysql gui's all can find out the contents (tables) of any given database, how do they do this? Is it an

Re: stocking pictures in mysql database ?

2002-09-06 Thread Gurhan Ozen
Hi, You have to use LOAD_FILE() function to load a file into a blob column. See:http://www.mysql.com/doc/en/String_functions.html Gurhan On Fri, 2002-09-06 at 04:57, navarra/mail.satori.fr wrote: Hello, How can i stocking pictures in mysql database ? i've tried to open a file as binary,

Re: Locked out of my own database...

2002-09-06 Thread Gurhan Ozen
Restart mysqld with --skip-grant-tables option and reset password and flush privileges.. See: http://www.mysql.com/doc/en/Resetting_permissions.html Hope this helps.. Gurhan On Fri, 2002-09-06 at 10:37, Adam Cripps wrote: I'm locked out of mysql database - it seems that all my users can't

Re: Using mySQL in Batch mode

2002-09-05 Thread Gurhan Ozen
You have to do in your command shell, not mysql shell... Go to run , type cmd and then type mysql batch-file .. Gurhan On Thu, 2002-09-05 at 16:12, Horacio Santoyo wrote: Hello mySQL users, I'm a new mySQL user, just installed it two days ago. I have a quick question... I have a .sql

RE: mysql max

2002-09-05 Thread Gurhan Ozen
Mysql-Max binaries are the binaries complied with InnodB support and InnoDB tables support transactions. So if you do something that has to be transaction-based, then you'd use mysql-max. Gurhan On Thu, 2002-09-05 at 16:17, Edward Peloke wrote: So is there really any benefit to using MySql

Re: Unix commands

2002-09-05 Thread Gurhan Ozen
You can't do it.. The only way i could suggest , actually kind of workaround is, set the pager to the command you would like to execute. Say you wanna see the output of command ls, then do mysqlpager ls; and then just execute a query, it will print the output on the screen. Then just do

Re: mysql FULLTEXT Searches

2002-07-22 Thread Gurhan Ozen
Yes you can do it utilizing fulltext search in boolean mode... SELECT * from list WHERE MATCH (cols) AGAINST ('pipp*' IN BOOLEAN MODE); See: http://www.mysql.com/doc/F/u/Fulltext_Search.html Gurhan - Original Message - From: Patrick Sherrill [EMAIL PROTECTED] To: mySQL List [EMAIL

Re: Surrounding Rows

2002-07-22 Thread Gurhan Ozen
Hi, Can you please explain what is the algorithm here? Say you have zip code 12345, do you need all rows thats have zipcodes between 12340 and 12350, and vice versa? We can't help without knowing what do you mean by surrounding . Gurhan - Original Message - From: Jan Peuker [EMAIL

Re: Surrounding Rows

2002-07-22 Thread Gurhan Ozen
SELECT code FROM zip WHERE (zip 12345-5) AND (zip 12345+5); Does this work out fine for you?? Note that it will work only if the zip field is integer... Gurhan - Original Message - From: Jan Peuker [EMAIL PROTECTED] To: Gurhan Ozen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent

Re: two mysql questions

2002-07-02 Thread Gurhan Ozen
As long as you need to create InnoDB table you have to use MAX binary... Check out phpmyadmin, it is totally free and operating system-independent since it runs from the server and can be used through the web browser.. Take a look at it at : http://www.phpmyadmin.net/ Gurhan - Original

Re: Root pass

2002-06-30 Thread Gurhan Ozen
Hi shawn, You have probably have % in the user and host of the user table, so mysql client let you in without a username. To be able to use mysql database, you have to login as the root user. Just type, mysql -u root -p and see if you can login in that way. Besides, you have to restart mysqld

Re: need you expertise

2002-06-30 Thread Gurhan Ozen
Hi, If you are sure that the user hasv exists in mysql, then either type mysql -u hasv -p so that the mysql client will prompt you for a password, or in your home directory, create my.cnf file and type [client] password=yourpassword Gurhan - Original Message - From: Hugo Veiga [EMAIL

Re: text formatting

2002-06-30 Thread Gurhan Ozen
This should be handled before the data is even inserted into mysql. Have your scripting language that you use in the form handle this to have the resume formatted in the way you'd like and then have it insert the data into mysql. Gurhan - Original Message - From: Blue Presley [EMAIL

Re: text formatting

2002-06-30 Thread Gurhan Ozen
, that would be appropriate for pre-formatting? thx, blue - Original Message - From: Gurhan Ozen [EMAIL PROTECTED] To: Blue Presley [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, June 30, 2002 6:02 PM Subject: Re: text formatting This should be handled before the data is even

Re: long table scroll down

2002-06-26 Thread Gurhan Ozen
mysql pager more See: http://www.mysql.com/doc/m/y/mysql.html Gurhan - Original Message - From: Anil Garg [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 4:15 PM Subject: long table scroll down Hi, for viewing long tables. in my sql query when i say SELECT *

Re: copying the structure of a table to a new table

2002-06-24 Thread Gurhan Ozen
Other than all previous comments, you can also do , SHOW CREATE TABLE tablename; and then copy+paste it with a different tablename. Gurhan - Original Message - From: Phil Schwarzmann [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 24, 2002 5:06 PM Subject: copying the

Re: advantages mysqldump -T option

2002-06-24 Thread Gurhan Ozen
Check this out: http://www.mysql.com/doc/m/y/mysqldump.html According to the above page, -T option creates a table_name.txt file for each given table, with its CREATE TABLE syntax and the data for its content in the file Gurhan - Original Message - From: Rachael LaPorte Taylor

Re: MySQL Bug - bug list rejected

2002-06-23 Thread Gurhan Ozen
I don't think this is a bug, you probably choose TINYINT datatype for the column, and the maximum value a TINYINT column can have is 127, so anything over 127 will automatically be changed to 127 silently by MySQL. Choose an appropriate column datatype for your field. See:

Re: Strings query question

2002-06-23 Thread Gurhan Ozen
SELECT id, songname FROM tablename WHERE TRIM(BOTH ' ' FROM songname)=One; See: http://www.mysql.com/doc/S/t/String_functions.html Gurhan - Original Message - From: [EMAIL PROTECTED] To: Jan Peuker [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, June 23, 2002 8:58 AM Subject: Re:

Re: Sub-selects

2002-06-20 Thread Gurhan Ozen
Take a look at: http://www.mysql.com/doc/T/O/TODO.html and http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html You can do what you want to do easily by using an API (PHP, Perl, etc.) Is it possible for you to use an external program, or does it have to be SQL only? Gurhan - Original

Re: escape characters

2002-06-20 Thread Gurhan Ozen
Yes... You can just use \' to denote single quotes.. See: http://www.mysql.com/doc/S/t/String_syntax.html Gurhan - Original Message - From: Theodore Morse [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 20, 2002 11:48 AM Subject: escape characters Hello everyone! I have

Re: Creation query problem!!

2002-06-20 Thread Gurhan Ozen
Yes it is.. For a list of reserved words, see: http://www.mysql.com/doc/R/e/Reserved_words.html Gurhan - Original Message - From: Peter Lovatt [EMAIL PROTECTED] To: Me [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 20, 2002 2:29 PM Subject: RE: Creation query problem!! is

Re: ORDER BY BY ?

2002-06-18 Thread Gurhan Ozen
SELECT * FROM tablename ORDER BY lastname, firstname; Gurhan - Original Message - From: César Aracena [EMAIL PROTECTED] To: 'MySQL General' [EMAIL PROTECTED] Sent: Tuesday, June 18, 2002 7:04 PM Subject: ORDER BY BY ¿? Hi all. Is there any possible way for me to arrange a SELECT

RE: Alias WHERE

2002-05-29 Thread Gurhan Ozen
See: http://www.mysql.com/doc/P/r/Problems_with_alias.html Gurhan -Original Message- From: Massimo Colurcio [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 5:09 PM To: mySQL List Subject: Alias WHERE It seems I cannot use an alias in WHERE clause, but I can use it in ORDER

RE: WHERE MATCH () AGAINST ('%$search_string%');

2002-05-23 Thread Gurhan Ozen
Hi Wilbert, The error tells it all.. To be able to use FULLTEXT search you have to have FULLTEXT index on the column(s) that you want to perform FULLTEXT search.. See: http://www.mysql.com/doc/F/u/Fulltext_Search.html Gurhan -Original Message- From: Wilbert Enserink [mailto:[EMAIL

RE: newbie - Old Samp_db question

2002-05-23 Thread Gurhan Ozen
you probably need to supply username and passwword to be able to access to the mysql server? See: http://www.mysql.com/doc/B/a/Batch_mode.html Gurhan -Original Message- From: Eugene McQuade [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 9:43 AM To: [EMAIL PROTECTED] Subject:

RE: mysql load data question

2002-05-23 Thread Gurhan Ozen
Yes it is ... See: http://www.mysql.com/doc/P/r/Privileges_provided.html Gurhan -Original Message- From: Taylor Lewick [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 4:46 PM To: [EMAIL PROTECTED] Subject: mysql load data question What priviledge does a user need in order to

RE: Union does not work

2002-05-22 Thread Gurhan Ozen
Sub-selects are not permitted in MySQL yet.. See: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html Gurhan -Original Message- From: Dan Liu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 11:58 AM To: Subject: Union does not work Hi, Could anybody tell me why the

RE: Union does not work

2002-05-22 Thread Gurhan Ozen
is implemented in 4.0.0. IF you have 3.x.x it won't work... Gurhan -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 12:31 PM To: Dan Liu; Subject: RE: Union does not work Sub-selects are not permitted in MySQL yet.. See: http://www.mysql.com

RE: Backslash BUG?

2002-05-22 Thread Gurhan Ozen
MySQL is doing the right thing, \' will mean single-quote character, so you will have to close it with another one. If you want to enter just a backslash do '\\' . See: http://www.mysql.com/doc/S/t/String_syntax.html Gurhan -Original Message- From: Bruno Batarelo [mailto:[EMAIL

RE: date_format question

2002-05-22 Thread Gurhan Ozen
Yes, there is .. You can use %D (note that it is capital D) instead of %e to get what you wanna get. See: http://www.mysql.com/doc/D/a/Date_and_time_functions.html Gurhan -Original Message- From: Lee P Reilly [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 5:51 PM To: MySQL

RE: change default root user name?

2002-05-22 Thread Gurhan Ozen
Hi, You should be able to do it with a tweak.. You can create a user and give all the priviliges to that user in the user table of mysql database, and then takeaway the privileges from the user root. Would that work for you? Gurhan -Original Message- From: Jeff Field [mailto:[EMAIL

RE: Installing / Running

2002-05-22 Thread Gurhan Ozen
How did you try to connect it??? IS your mysql server running? If yes is the mysql.sock location correct? Gurhan -Original Message- From: Glenn Hancock [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 4:48 PM To: MySql Subject: Installing / Running I have installed MySQL on my

RE: Duplicate Record

2002-05-22 Thread Gurhan Ozen
The answer is there ... : http://www.mysql.com/doc/L/O/LOAD_DATA.html Gurhan -Original Message- From: Wong Zach-CHZ013 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 8:18 PM To: Wong Zach-CHZ013; '[EMAIL PROTECTED]' Subject: RE: Duplicate Record -Original

RE: select in select

2002-05-21 Thread Gurhan Ozen
You can use JOIN... See: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html Gurhan -Original Message- From: van den Heuvel, Frank [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 8:47 AM To: '[EMAIL PROTECTED]' Subject: select in select Hello, I would like to do this

RE: Securing a Non-Secure Installation

2002-05-21 Thread Gurhan Ozen
There is no secure, nonsecure installation. You usually take security measurements after the installation.. The security mesaure you take before installation is to create a group and user called mysql to have appropriate permissions on the datadirs, socketfiles, etc. See:

RE: Need help

2002-05-21 Thread Gurhan Ozen
Use perror program to see what the error code means.. perror 145 Error code 145: Unknown error 145 145 = Table was marked as crashed and should be repaired Repair your table.. see: http://www.mysql.com/doc/R/E/REPAIR_TABLE.html Gurhan -Original Message- From: Bertrand TACHAGO

RE: Sorting a varchar field...

2002-05-17 Thread Gurhan Ozen
SELECT ... FROM tablename ORDER BY varcharcolumn+0; Gurhan -Original Message- From: Maksim Rogov [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 9:44 AM To: [EMAIL PROTECTED] Subject: Sorting a varchar field... Hi, I am new to the list :) Have a question, I have not been able

RE: How to limit database size?

2002-05-17 Thread Gurhan Ozen
The database's table files will be in the data directory where all the table files for the databases are kept. If the partition or the hard drive where the data directory is residing on is out of space then the MySQL server will throw an error for not having enough space .. Gurhan

RE: Query question average per hour per agent

2002-05-17 Thread Gurhan Ozen
SELECT COUNT(DISTINCT(submitter)) AS submitters, HOUR(created) AS hourcreated, COUNT(*) AS sum-per-hour FROM remedy WHERE (created='2002-4-25' AND created='2002-04-30') GROUP BY HOUR(created); Is this what you want? Gurhan -Original Message- From: Graeme B. Davis [mailto:[EMAIL

RE: STRING TO NUMBER

2002-05-16 Thread Gurhan Ozen
MySQL do it for you:) Quoted from the online documentation is: MySQL automatically converts numbers to strings as necessary, and vice-versa: mysql SELECT 1+1; - 2 mysql SELECT CONCAT(2,' test'); - '2 test' If you want to convert a number to a string explicitly, pass it as the

RE: table type airline?

2002-05-16 Thread Gurhan Ozen
SHOW CREATE TABLE tablename; or SHOW TABLE STATUS LIKE 'tablename'; gives you what you want... See: http://www.mysql.com/doc/S/H/SHOW_TABLE_STATUS.html http://www.mysql.com/doc/S/H/SHOW_CREATE_TABLE.html Gurhan -Original Message- From: Taylor Lewick [mailto:[EMAIL PROTECTED]] Sent:

RE: Mysql Load Data question

2002-05-16 Thread Gurhan Ozen
Everytime you have something to ask, first point your browser to : http://www.mysql.com/doc/ Type in the keywords (in this case LOAD DATA) The first url in the resultset will be : http://www.mysql.com/doc/L/O/LOAD_DATA.html which is what you are looking for. Gurhan -Original Message-

RE: Column Header/ Column Description

2002-05-15 Thread Gurhan Ozen
That's why there is a seperate area called documentation . why let MySQL software run slower and/or eat up more memory space with a useless feature. You can always document your specifications in a document, it doesn't have to be stored on the tables themselves. If you really want that

RE: Simple SQL

2002-05-15 Thread Gurhan Ozen
Peter, Please give us more insight on this. Is the column where you store dates (or months) is a date datatype column?? If yes you can just do SELECT ... FROM table_name ORDER BY MONTH(column_name); It'll help to see your table structure to help you. Thanks. Gurhan -Original Message-

RE: Error writing file

2002-05-15 Thread Gurhan Ozen
Hi Bradley, Use perror program to see what the error code means.. # perror 28 Error code 28: No space left on device Seems like you ran out of space.. Gurhan -Original Message- From: Bradley Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 5:01 PM To: [EMAIL

RE: RE: MySQL Locales

2002-05-14 Thread Gurhan Ozen
You mean inserting the entries in Greek?? I would say install phpMyAdmin, and insert the entries thru your browser when the browser encoding is Greek ... Gurhan -Original Message- From: Lekeas GK [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 10:46 AM To: [EMAIL PROTECTED] Cc:

RE: limitation in mysql

2002-05-14 Thread Gurhan Ozen
Actually there is a maximum table limit , for MyISAM tables .. and that is 8 million terabytes, if you can ever reach that : The limitations in MySQL is limited by the OS limits... See: http://www.mysql.com/doc/T/a/Table_size.html Gurhan -Original Message- From: Inbal Ovadia

RE: RE: MySQL Locales

2002-05-14 Thread Gurhan Ozen
Yes you can.. http://www.phpmyadmin.net/documentation/#intro Gurhan -Original Message- From: Lekeas GK [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 11:51 AM To: Gurhan Ozen Cc: [EMAIL PROTECTED] Subject: Re: RE: MySQL Locales That's a good idea, but if you have something

RE: shutting down mysql

2002-05-14 Thread Gurhan Ozen
mysqladmin [...] shutdown http://www.mysql.com/doc/m/y/mysqladmin.html Gurhan -Original Message- From: Taylor Lewick [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 12:51 PM To: [EMAIL PROTECTED] Subject: shutting down mysql I looked through the documentation, and I see how to

RE: RAND and MySQL version!

2002-05-14 Thread Gurhan Ozen
You can't do ORDER BY RAND() prior to version 3.23... On your 3.22.32 version do something like: SELECT column_name*0+RAND() AS rnd FROM table_name WHERE IsActive=1 ORDER BY rnd LIMIT 1; Gurhan -Original Message- From: Soheil Shaghaghi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May

RE: .my.cnf question

2002-05-13 Thread Gurhan Ozen
Yes, but that file would only have user specific information such as your password in addition to the gloabl variables read from the gloab options file ... If you want to have server specific global variables in your my.cnf file in your directory, than you need to start mysqld with --defults-file

RE: OUTFILE and DESCRIBE

2002-05-13 Thread Gurhan Ozen
You can do it using tee command in your mysql shell. See: http://www.mysql.com/doc/m/y/mysql.html Gurhan -Original Message- From: Rutledge, Aaron [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 11:26 AM To: Mysql List (E-mail) Subject: OUTFILE and DESCRIBE Sorry to bother the

RE: MySQL Locales

2002-05-13 Thread Gurhan Ozen
Yes, Just add default-character-set=greek line in your /etc/my.cnf (or whereever the global server specificationa are read) . Gurhan -Original Message- From: GEORGE KONSTANTINOY LEKEAS [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 2:07 PM To: [EMAIL PROTECTED] Subject: MySQL

RE: Multiple MySQL server for one db

2002-05-13 Thread Gurhan Ozen
You can run two different servers pointing to the same data dir, but for what you are asking you should use replication.. See: http://www.mysql.com/doc/R/e/Replication.html For redundancy , you have to write scripts.. See: http://www.mysql.com/doc/R/e/Replication_FAQ.html Gurhan -Original

RE: Problem with DDL

2002-05-13 Thread Gurhan Ozen
when is a reserved word. If you really wanna have it as a column you have to put it in between backticks, i.e. `when` . Unless you absolutely have to , don't use reserved words as your column, table names for sake of clarification. See: http://www.mysql.com/doc/R/e/Reserved_words.html Gurhan

RE: Stupid - I just can't get it (NOT IN or NOT EXISTS)

2002-05-13 Thread Gurhan Ozen
MySQL doesn't support Sub-Selects yet... http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html Gurhan -Original Message- From: John Doe [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 4:49 PM To: [EMAIL PROTECTED] Subject: Stupid - I just can't get it (NOT IN or NOT EXISTS)

RE: Stupid - I just can't get it (NOT IN or NOT EXISTS)

2002-05-13 Thread Gurhan Ozen
No the manual is right and Nick is right too. I think you need to take your reading skills to a next level before cursing at the manual. If you read the manual carefully, you would see that the manual first gives the sub-select queries which MySQL is yet to support and then gives an alternative

RE: password function

2002-05-12 Thread Gurhan Ozen
You need to use PASSWORD() function.. INSERT INTO table VALUES('0', 'username', PASSWORD('passwd'), 'email'); See: http://mysql.com/doc/M/i/Miscellaneous_functions.html Gurhan -Original Message- From: Jule [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 12, 2002 8:37 PM To: [EMAIL

RE: Newbie Question

2002-05-12 Thread Gurhan Ozen
Hi, There is not enough information in your email to help you.. IS your mysql server running ? Also you may wanna scrutinize this page: http://www.mysql.com/doc/P/o/Post-installation.html Gurhan -Original Message- From: Kevin Queen [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002

RE: newbie help

2002-05-09 Thread Gurhan Ozen
Are you trying to load data FROM a text file, or are you trying to load data INTO a textfile? You said I just created a database and tried to LOAD 1 line of data from a text file. but then you stated i need to INTO OUTFILE ... If you wanna load data from a text file into a table, look at:

RE: Pretty Simple MAX Value question...

2002-05-09 Thread Gurhan Ozen
Hi Andrew, IT is working as it is supposed to , MAX() only returns one row with the highest value. IF you wanna get 100 highest values, just order the rows by id and limit the result set to 100. SELECT id FROM table WHERE DATE = '20020509' ORDER BY id LIMIT 100 Gurhan -Original

RE: newbie question:count() and display details

2002-05-07 Thread Gurhan Ozen
You may want to use GROUP BY clause to get a count of the results .. See: http://www.mysql.com/doc/G/r/Group_by_functions.html For example, to retrieve the number of row where nation is German do: SELECT COUNT(*) AS mycount, nation FROM memberscopy WHERE nation='German' GROUP BY nation; Gurhan

RE: Exporting Data from web page

2002-05-07 Thread Gurhan Ozen
Hi Dave, This won't have purely SQL only solution , you can use SELECT .. INTO OUTFILE .. syntax to create a file and you can zip the file with a random name and link to that zip file.. This will force the explorer to save the file. If you just let it stay as a text file, the browser won't

RE: RE: Converting text files to MySQL

2002-05-07 Thread Gurhan Ozen
Christy, You need to edit the defaults file for your MySQL server. It is by default, /etc/my.cnf , unless another one is specified when mysqld is started. The four files that you have mentioned comes with MySQL downloads to be used as an example... See:

RE: Using RAND()

2002-05-07 Thread Gurhan Ozen
You have to have MySQL 3.23 or greater.. http://www.mysql.com/doc/M/a/Mathematical_functions.html Gurhan -Original Message- From: Cummings, Shawn (GNAPs) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 11:33 AM To: [EMAIL PROTECTED]; Ulf Harnhammar Cc: [EMAIL PROTECTED] Subject:

RE: RE: Converting text files to MySQL

2002-05-07 Thread Gurhan Ozen
To: 'Gurhan Ozen'; [EMAIL PROTECTED] Subject: RE: RE: Converting text files to MySQL Thanks, Gurhan. I don't seem to have a my.cnf - the only cnf files I have are the four samples - so can I just use one of the sample ones, change the name, and add the local-infile =1 line? -Original Message

RE: Using RAND()

2002-05-07 Thread Gurhan Ozen
recordset. Pete Kelly - Original Message - From: Gurhan Ozen [EMAIL PROTECTED] To: Cummings, Shawn (GNAPs) [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, May 07, 2002 5:11 PM Subject: RE: Using RAND() You have to have MySQL 3.23 or greater.. http://www.mysql.com/doc/M

RE: Error 28

2002-05-06 Thread Gurhan Ozen
You can use perror error_code to see what that error code is perror 28 Error code 28: No space left on device Seems like you ran out of space? Gurhan -Original Message- From: Scott Raley [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 8:44 AM To: [EMAIL PROTECTED] Cc: [EMAIL

RE: Access denied irregularities

2002-05-06 Thread Gurhan Ozen
Make sure that the user + host combination you are giving has privileges in the MySQL server you are trying to connect. You may wanna check user table in the mysql database. Gurhan -Original Message- From: Nick Wilson [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 6:30 AM To:

FULLTEXT search bugs in 4.0.1 alpha?...

2002-05-06 Thread Gurhan Ozen
Is there anyway to see what bugs have been reported for fulltext search in 4.0.1 alpha ? I know that Jeremy Zawodny has mentioned that a few bugs were found in fulltext search in 4.0.1 , but didn't tell what they were. I have installed 4.0.1 and ran it as second mysqld in my web server,

RE: Every user can access the databases

2002-05-06 Thread Gurhan Ozen
GRANT ALL PRIVILEGES ON databasename.* TO user IDENTIFIED BY 'password'; http://www.mysql.com/doc/G/R/GRANT.html Gurhan -Original Message- From: Dennis [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 9:52 AM To: [EMAIL PROTECTED] Subject: Every user can access the databases I

RE: FULLTEXT search pattern syntax

2002-05-06 Thread Gurhan Ozen
Hi.. Rewrite it as: WHERE MATCH (some_text_field) AGAINST ('red pepper' IN BOOLEAN MODE) AND MATCH (some_text_field) AGAINST (green bean' IN BOOLEAN MODE); Gurhan -Original Message- From: Vadim P. [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:07 PM To: [EMAIL PROTECTED]

RE: please help: search database - code attached

2002-05-06 Thread Gurhan Ozen
Get rid of percentage signs in your keyword... See: http://www.mysql.com/doc/F/u/Fulltext_Search.html Gurhan -Original Message- From: Shehryar Shafiq [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 12:46 PM To: [EMAIL PROTECTED] Subject: please help: search database - code

RE: Too Many Connections

2002-05-06 Thread Gurhan Ozen
Hi, Change the max_connections variable's value to a higher value. By default it is set to 100. You can see what yours is set to with SHOW VARIABLES command. See: http://www.mysql.com/doc/T/o/Too_many_connections.html http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html Gurhan -Original

RE: Can't create/write to file

2002-05-06 Thread Gurhan Ozen
Check your permissions and fileowners one more time. You definitely have permissions problem.. Make sure that all the datafiles are owned by mysql. Gurhan -Original Message- From: Marko Palikko [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 1:00 PM To: [EMAIL PROTECTED] Subject:

RE: Two database servers, same physical server

2002-05-06 Thread Gurhan Ozen
Hi, To run multiple mysqld servers, you at least have to specify a different port number, different socket file path, different pid and error log file to get it started. Different mysqld servers may point to the same database. To do this, just define the necessary information for your new

RE: MySQL to Excel ?

2002-05-01 Thread Gurhan Ozen
Hello Jay, I will give you a couple ideas.. I have never tried these options to do this job but they should work. First option is, you can use SELECT ... INTO OUTFILE syntax. Excel uses tab character as the column delimiter and new line character as the row delimiter if you import a txt

RE: CREATE and DROP Privileges

2002-05-01 Thread Gurhan Ozen
I don't think there is a way to do it.. But if you have control on the table names he is creating, you can just have a certain prefix on each table he creates and give appropriate permissions on databasename.prefix* to the user. Or else, you can create a different database exclusively to be used

RE: CREATE and DROP Privileges

2002-05-01 Thread Gurhan Ozen
in your SQL syntax near '* . blah Checking the manual, I'm not sure I can do this ?? Regards, Chris -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: 01 May 2002 15:44 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: CREATE and DROP Privileges I

RE: MYSQL question - Urgent

2002-04-30 Thread Gurhan Ozen
restrict yourself to the area you are living in, this list is a global user list of MySQL :) Make sure to visit the following pages: http://www.mysql.com/doc/L/i/Linux-RPM.html http://www.mysql.com/doc/I/n/Installing_binary.html http://www.mysql.com/doc/P/o/Post-installation.html Gurhan Ozen MCI

RE: Mandatory Fields

2002-04-30 Thread Gurhan Ozen
DEpending on the table layouts you can use NOT NULL, UNIQUE, ENUM(), column types and definitions.. See: http://www.mysql.com/doc/C/R/CREATE_TABLE.html http://www.mysql.com/doc/C/o/Column_types.html Gurhan Ozen MCI WorldCom Quality Assurance Team [EMAIL PROTECTED] ph: 703-449-4754 Vnet: 228

RE: lost root password trouble

2002-04-30 Thread Gurhan Ozen
Are your databases in /var/lib/mysql ?IT is trying to startup with reading databaseses from that path but i think it can't.. Also check the error log file to see what's going on. Gurhan -Original Message- From: Nick Wilson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 1:33

RE: lost root password trouble

2002-04-30 Thread Gurhan Ozen
: Re: lost root password trouble -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Gurhan Ozen declared Are your databases in /var/lib/mysql ?IT is trying to startup with reading databaseses from that path but i think it can't.. Also check the error log file to see what's going

RE: Results relevance

2002-04-29 Thread Gurhan Ozen
Hi, You can just do SELECT MATCH(column name) AGAINST ('searchstring') AS relevance FROM tablename; There is an example at: http://www.mysql.com/doc/F/u/Fulltext_Search.html Gurhan -Original Message- From: Mouratidis [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 6:38 AM To:

RE: Not secting empty strings

2002-04-29 Thread Gurhan Ozen
Have you tried ... WHERE columnname=''; ?? Gurhan -Original Message- From: Andrew Kuebler [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 12:55 PM To: [EMAIL PROTECTED] Subject: Not secting empty strings I want to query records that do not contain empty strings and null values

RE: What is the best way to do this

2002-04-29 Thread Gurhan Ozen
You can write a program to do this.. Just query the table one , and tokenize the string returned and query the second table for each token with LIKE clauses and wildcards in a loop. Gurhan -Original Message- From: Javier [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 12:53 PM

RE: Results relevance

2002-04-29 Thread Gurhan Ozen
into a percentage somehow. No. The values returned by a FULLTEXT search are simply non-negative floating-point numbers. The larger the number within a result set, the higher the relevance, but that doesn't map onto percentage. - Original Message - From: Gurhan Ozen [EMAIL PROTECTED

RE: Follow-up DELETE ISSUE

2002-04-29 Thread Gurhan Ozen
Hi Andrew, If you carefully looked at that page, you'd see that MySQL doesn't support nested queries with a couple exceptions and that the query you are trying to run wouldn't work in MySQL. The bottom half of the page is dedicated for the workarounds for your problem. Gurhan -Original

RE: Results relevance

2002-04-29 Thread Gurhan Ozen
. The larger the number within a result set, the higher the relevance, but that doesn't map onto percentage. - Original Message - From: Gurhan Ozen [EMAIL PROTECTED] To: Mouratidis [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, April 29, 2002 3:58 PM Subject: RE

RE: help!!

2002-04-25 Thread Gurhan Ozen
Hi kapachov, The maximum number of tables MySQL DB can have depends on your OS. The maximum number of connections it can have is stored is max_connections variable. By default it is set to 100, but you can of course change it .. Do a SHOW VARIABLES LIKE 'max_%'; to see what it is set to.. See:

RE: how to get support help?

2002-04-25 Thread Gurhan Ozen
Hi Clay Loveless, As response to your loveless messages, I would like to browse : http://www.mysql.com/support/index.html . I have seen many times where people helped others for the matters that were not documented on this list. Besides, when people are pointing help-seekers to a documentation

RE: ERROR 1045: Access denied for user: 'root@localhost'

2002-04-25 Thread Gurhan Ozen
MySQL 'root' user has got nothing to do with Unix 'root' user. Quoted from http://www.mysql.com/doc/C/h/Changing_MySQL_user.html is Note that accessing MySQL as root, by supplying -u root on the command line, has nothing to do with MySQL running as the Unix root user, or, indeed, as another Unix

RE: Access denied when connecting to database from PHP

2002-04-25 Thread Gurhan Ozen
Hi, When you connect from command line, you are logging as user@localhost .. In your example, you said user@mybox thru PHP is not able to log in, I would say check what hosts are allowed for that user in the user table.. See: http://www.mysql.com/doc/A/c/Access_denied.html Gurhan -Original

RE: Not Liked!

2002-04-25 Thread Gurhan Ozen
Your query reads: SELECT * FROM books WHERE title LIKE '%php%' AND NOT title LIKE '%perl%' whereas it has to be ... AND title NOT LIKE '%perl%'; I think you need to make some changes in your PHP code for the in the case block for - . Gurhan -Original Message- From: Jonathan David

RE: defaults

2002-04-25 Thread Gurhan Ozen
You can just add DEFAULT keyword followed by the default value in the column definition and use it either when creating a new table or altering a table to add/set a default value to its column(s).. See: http://www.mysql.com/doc/C/R/CREATE_TABLE.html

  1   2   >