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
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
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
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
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
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,
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
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
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
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
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
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
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
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
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
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
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
, 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
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 *
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
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
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:
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:
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
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
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
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
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
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
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:
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
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
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
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
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
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
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
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
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
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:
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
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
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
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
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
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:
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-
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
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-
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
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:
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
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
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
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
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
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
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
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
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
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)
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
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
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
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:
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
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
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
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:
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:
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
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
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
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:
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,
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
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]
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
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
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:
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
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
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
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
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
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
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
-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
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:
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
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
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
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
. 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
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:
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
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
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
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
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 - 100 of 158 matches
Mail list logo