> Is there a list off MySQL error-codes avalible?
> Something like Oracle's oerr. program?
perror
> We are having trouble with one of our MySQL databases. The error is:
>
> "Got error 124 from table handler."
chris@entropy:~$ perror 124
Error code 124: Wrong medium type
124 = Wrong index g
e if you had started mysqld with that parameter. To start with a
back_log of 200, you must do:
c:\>mysqld -O back_log 200
when mysqld is not running, then run mysqladmin variables to see if it
was updated.
--
Chris Bolt
[
Your question has been answered already.
http://marc.theaimsgroup.com/?l=mysql&m=99348999221821&w=2
> Hi All,
>
> I've been reading up on how to do joins on the mysql site.
>
> Is there not an inverse function for DISTINCT, so that I can pull out
> duplicate data as opposed to DISTINCT data...o
DELETE FROM mbtable WHERE timecolumn < DATE_SUB(NOW(), INTERVAL 3 MONTH);
> Hello,
>
> I've a messageboard. Now, I want to delete all messages older than 3
> months. Can I use a MySQL query to delete all messages or do I have to use
> mktime()?
--
> Hi!
>
> Does anybody know how do i change the 'root' password for mysql server?
>
> I installation guide they say that it's done by typing
> '/usr/local/bin/mysqladmin -u root -p password new-password', but how
> would i know the old passsword?
> Am i mising anything?
Leave out -p
-
MySQL doesn't support foreign keys. Did you bother checking the manual?
http://www.mysql.com/doc/M/i/Missing_Foreign_Keys.html
> Hello
>
> Does mysql support creating and dropping of foreign key constraints?
> i tried it.While creating foreign key constraints it doesn't dive
> any error
> but wh
Try looking in mysql\data\mysql.err or running mysqld --standalone, it may
provide more information.
> Hello everyone,
> I have mysql-3.23.39 installed on a Win2k Pro box (not sure why!). It had
> been running just fine, then all of a sudden stopped working.
> When I try a
> 'NET START mysql', I
> > Hi,
> >
> > I have mysql on NT4 (soon to be win2000). one question is that the
> > database files all reside under drive c. NT does not have symbolic
> > link
>
> I seem to recall Microsoft making a big deal out of the fact that they
> "invented" symbolic links and added them to Win2000. A
Why does it matter? They can't access them, so what harm is there?
> I am sure that it has been asked before. I am running a
> hosting company
> and I am running mysql on a win2k server.
> We don't want any customer to see other db's of any other customer, we
> just want them to see their
No. To rename a database, rename the directory in mysql's data dir. There is
no SQL command to rename a database.
> [mysql]
>
> is this how to change the the name of an existing populated db?
>
>
> RENAME DATABASE old_name TO new_name;
>
> TR
mysqldump databasename | gzip > databasename.sql.gz
transfer that file to the other server
mysqladmin create databasename
zcat databasename.sql.gz | mysql databasename
> Hi
>
> Is it possible to import a complete database from a server to another
> one?
>
> Thanks
>
> Eugénio
--
> Done, an email is now sent after an order is submitted. This is what it
> I have found a large number of files which have names like this
> www-bin.040
> www-bin.041
> www-bin.042
> www-bin.043
> www-bin.044
>
> which are using up huge amounts of disk space on my server.
>
>
> We do a few large daily and monthly downloads from an Oracle database
> server. Is there a way to exclude these specific queries from the
> update/binary log??
If the queries only affect one table or database, use the replication ignore
options listed here: http://www.mysql.com/doc/R/e/Replicat
> sorry im a mysql newbie...how do you bind mysql to two particular ip
> addresses? i have it bound to my loopback but would like to bind it a
> private ip but it doesn't seem to like the bind-address directive
> more than once.
Run two separate mysql daemons with a different --bind-address para
> Is it possible to join two columns from different databases
Yes.
> located on differents hosts?
No. Why do you want to do this?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lis
> Hi,
>
> I want to compress my tables but I gets an error:
>
> C:\mysql-data\dtim9t>myisampack wi_abbreviation.MYI
> Compressing wi_abbreviation.MYD: (7221 records)
> - Calculating statistics
> - Compressing file
> myisampack: Error on delete of 'wi_abbreviation.MYD' (Errcode: 13)
> Aborting: wi_
He wants to know the maximum, like on a search for mysql at google it says
"Results 1 - 10 of about 2,580,000." He wants to know that 2,580,000 number
without doing another query. I don't think that's possible.
> I'm not sure if I understand your problem. You should get exactly
> $end results if
> Just wondering how many accesses can MYSQL handle... let's say per hour.
> I have about 500 accesses per hour, 8 clicks per second... does anyone
> know about this issue? thanks
It really depends on what kind of queries you're running, your hardware,
your configuration, your operating system, e
> Group;
>
> There is something missing in my understanding of the php mysql_connect
> statement because I am getting a parse error as follows:
>
> http://cxkop.com/Jobs/job_list.php
> Parse error: parse error in
> /home/virtual/cxkop1365/home/httpd/html/Jobs/job_list.php on line 31
This is a php
> I create a table, one field is integer type.
> I don't know why the following statements work :
>
> select * from table1 where field1 = 3;
> select * from table1 where field1 = '3';
In the second case, MySQL automatically casts '3' to 3.
--
> umm when i declare a unique constraint on 2 fields in a table like so
>
> unique (col1,col2),
>
> if i insert data into the table will it check them individually or as a
> composite?
>
> for example if i inserted the values
> col1 | col2
>1, A
>1, B
>2, B
>
http://marc.theaimsgroup.com/?l=mysql&m=99257445520048&w=2 may help
> OK, another one here...
>
> On the very large table (at least 5 million rows) I need to index
> several columns. The mysqladmin -i60 processlist
>
> lists the state of the query as
>
> Repair with keycache
>
> for a ver
What error did you get? Did you try using NULL for the id, or leaving the
auto_increment column out of the insert (insert into table (PartNumber, ...,
StatusQtyWorked) values (...))?
> Hello,
> When I submit data it will not submit data into the
> database unless I put some kind of number in the
> > He wants to know the maximum, like on a search for mysql at
> > google it says "Results 1 - 10 of about 2,580,000." He wants
> > to know that 2,580,000 number without doing another query.
> > I don't think that's possible.
>
> Of course it is. That's what I do all the time. That's what I was
>
> 3. Is this a MySQL feature / bug or do other DBs support this?
It doesn't work in Postgres.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arch
Am I the only one getting these? Someone really needs to fix their mail
server...
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 13, 2001 4:10 AM
To: [EMAIL PROTECTED]
Subject: No valid command found
Your message does not contain a valid command
> Hello,
>
> I am still a beginner, but I am trying to learn MySQL. If you have a
> date field, and you are using the date field in your where clause, I
> understand how to use :
> WHERE date="-mm-dd"; I am trying to find out if there is anyway
> to use the wildcard character % in d
> C:\>mysql grant all on *.* to administrator@sara identified by "delboy"
Try this:
C:\>mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 463668 to server version: 3.23.39-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> grant a
> mysql> select vend_city+', '+vend_state+' '+vend_zip
> -> from Vendors
> -> order by vend_name
> -> ;
...
> 4 rows in set (0.01 sec)
>
> How do I do this in MySQL?
SELECT CONCAT(vend_city, ', ', vend_state, ' ', vend_zip) FROM Vendors ORDER
BY vend_name;
--
> $sql4 = "SELECT hits.hit_id as pixels from hits
> WHERE hit_id=LAST_INSERT_ID();";
>
> $result = mysql_query ($sql4, $connection)
> or die("error #" . mysql_errno() . ": " . mysql_error());
> $row = mysql_fetch_object($result);
> $pixels = number_format($row->pixels);
>
> It's staggering the dif
> hi all..
>
> this error came out after i make backup for my database using mysqldump
> what this error say is wrong... maybe my database is corrupt or
> crash or something like that.. any command can fix this error..?.
> any idea what i should do.
Please paste the output of typing "DESCRIBE
> Hi,
>
> I have looked through the documentation (http://www.mysql.com/docs)
> and the mailing list archives
> (http://www.geocrawler.com/lists/3/Databases/8/0/)
> and find no mention of a feature that I was hoping was available:
>
> * text or varchar columns that are automatically compressed/u
> SELECT * FROM listaemail WHERE id LIKE "%%" OR nome LIKE "%%" OR empresa
> LIKE "%%" OR email LIKE "%%" OR ativo LIKE "%%" ORDER BY nome;
>
> Time: 11 Lock_time: 0 Rows_sent: 30567 Rows_examined: 30568
>
> before anyone jumps out and points it out, it is far
> from being optimized. it should (an
>>> Database error: Invalid SQL: select id, subid from policy where
>>> id='2' and subid='0'
>>> MySQL Error: 1054 (Unknown column 'id' in 'field list')
>>> Session halted.
>
> the output look like this..
> mysql> desc policy;
> +++--+-+-+---+
> | Field
> I am currently trying to examine the benefits of continuing to
> use MySQL over Oracle. I need to know what MySQL's features are
> vs. those of Oracle.
http://www.mysql.com/information/crash-me.php
> Also I am looking for performance data.
Oracle prohibits benchmarks, so good luck finding the
> I need to build a search utility which can query records based
> on multiple text parameter,
> my table will have about 10 fields and users can search on
> 3-5 parameters in one query. is there any way to achieve this
> other than doing a full table scan.
http://www.mysql.com/doc/F/u/Fullt
> i have 2 mysql servers, i need to run a query that joins two tables
> from two databases on the two servers, how can i do this?
You can't.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
h
> Example I have a file name stored in database as: john's - song.mp3
>
> When I click on the link to the song in a web browser I get file not
> found.
http://www.php.net/rawurlencode
-
Before posting, please check:
http:/
> Lets say i have 10.000 rows in a table and im searching for only
> one record(one row).
>
> Which one is faster:
> SELECT ... LIMIT 1
> or just
> SELECT ..
The former, since MySQL stops after finding the first row. In the second
query, MySQL prepares the entire result set even if you on
> i have a problem in query. My field type is integer.
> The table is empty and i want to select max number from the
> field but it display error message.Then i try to change the type
> to char ,it's can but,
> the max is until 9 only.is there anyone can help me.
What query? What table? What er
> I am not sure if this has been addressed before, I think it would
> be neat if the list admin could put a [mysql] in the subject line
> for messages. I get a lot of email and it would help having that
> in the subject line. it would also help me in filtering my mail.
> Please let me know your c
> is there any way turn the following query to all ands instead of using an
> or?
>
> select f1,f2,f3 from table1 where (f1 ='monday' or f2 ='monday') and
> f3='34';
SELECT f1,f2,f3 FROM table1 WHERE 'monday' IN (f1, f2) AND f3 = '34';
--
> update cdrequest set albumfill = "hot shots II", releasedatefill
> = 20010708 where requstID = 2;
>
> i get:
> You have an error in your SQL syntax near '\"hot shots II\",
> releasedatefill = 20010708 where requstID = 2' at line 1
> I can't see any reason for the error.
Your web based inte
> I'm still testing out MySQL and I'm trying to find the my.cnf
> file referred to at
> http://www.mysql.com/doc/O/p/Option_files.html
...
> but none of these files seem to exist on my machine.
...
> MySQL came pre-installed on that machine. Is it possible (or, indeed,
> normal) that the
> How is that possible? Even if you do know someone's scrambled password,
> when you connect to the MySQL server pretending to be that user, it will
> ask you for their non-scrambled password. After you type it in,
> the server will scramble it and check that the scrambled value matches
> the sc
> Is there any way -- using either MySQL directly, or (ideally)
> using the DBI perl module -- to get a list of fields from a
> (possibly empty) table? (If the table is nonempty, you can
> just use a perl function to get the first record, and then
> apply keys() to the returned reference to get
> And is there some way to download the previous posts to this list? I
> found one list admin function that will download up to 100 posts
> concatenated into one email, but I'd like to be able to d/l them
> individually, with their own subject line and threading info. I just
> think it would be
> Go error 127 from table handler.. fixed itself in about 10 minutes..
> don't know what this is or why it happened.. anyone know?
>
> It happened while doing an update SQL command to a table.
> I'm not even sure what it means.. can't find any error codes.
Try running perror 127
---
> is it generally recommended / a good idea to have more than one PRI index
> in the same table? i've never seen that before until today while trying
> to track down bugs in someone else's system and noticed a table with 2 PRI
> indexes. will this cause any problems?
It shouldn't cause any prob
> I want to create a table with two Primary Keys. The first key is
> a category
> field, and the second is auto-incremented. Example: Key
> 1=Chapter name, Key
> 2 =section number. For example, (Chapter1, 1) (Chapter1, 2) (Chapter1, 3)
> then with a new Cheaper, I want to restart the auto-incre
> I'am having this error code (Error 12 from table handler) when i am trying
> to create an index on a table that has about 20 records (it's
> not a big table)...
> What does this error code means?.
chris@illusion:~$ perror 12
Error code 12: Cannot allocate memory
chris@illusion:~$
-
> now i changed the root password just fine
> but now i have to enter it every time i run mysqladmin
> even "mysqladmin version" reqires a "-p"
>
> tell me there's a simpler way
http://www.mysql.com/doc/C/o/Connecting.html
* You can specify connection parameters in the [client] section of th
> A quick question: How come the mailing list software
> doesn't add a reply-to header? Is this intentional to
> keep replies off the mysql list, and if so why?
http://www.unicom.com/pw/reply-to-harmful.html
-
Before posting, pl
> > I am looking build my own E-mail Server for my Domain and would like
> > some pointers
> >
> > Is there an E-mail Server that uses MySQL
>
> Exim, Postfix, and Sendmail can all use MySQL to varying degrees.
> There are probably others.
qmail; http://cr.yp.to/qmail.html, http://www.lifewithq
> SQL question which I am new to.
> How would I count the number of times a specific entry is in field. For
> instance I have a table that has the following two fields
> numberhostname
> 1 10.1.1.1
> 2 10.1.1.2
> 3 10.1.1.3
> 4
> I need to search a mysql database using wildcards. I know about the * and
> the _ wildcards (any number of any character and 1 character of any kind,
> respectively) but I need to match any number, any letter and thing like
> that.
>
> An SQL book claimed it could be done using brackets and rang
> Hello,
>
> I was working with Mysql an nerver had any problem, the suddenly from one
> moment to the other, some tables didn't work correctly any more.
> Any select
> command on them returns me :
> 1030: Got error 127 from table handler.
> But if I do a select command on a other table with a j
> Thankx for reply.
> But if I use Table Repair it says : The handler for te table
> doesn't support Check/Repair.
What does SHOW TABLE STATUS LIKE 'tablename'; say for the Type column?
-
Before posting, please check:
http:
> Im managing to do this, but I can see that the method im using is
> not as efficient as it could be. What I want to do is this
> Make a query which will grab the record in a table that has the
> highest ID number. The ID field is auto incremental so what its
> saying is that the record with
> I am currently using Slackware 8 (linux) and I have some problems. There
> is mysql package in the slackware installation, which I installed it but
> never manage to run it successfully. Everytime I type the following
> > safe_mysqld
> and I get the following message:
> > Starting mysqld da
Right now MySQL is getting really backlogged but I have no idea why. There
are 169 concurrently running queries, and 153 of them are in show the status
as "Opening tables". A processlist looks something like this (formatted by
Status, Seconds query has been running, and query):
Opening tables
> Have you also increased your master maxfiles as well? If not, you're not
> getting the number of file handles you expect you are. I'd also consider
> upgrading to 4.3, as it's much faster than 3.x.
>
> Try this --
> sysctl -w kern.maxfiles=16424
kern.maxfiles is already the same as .maxfiles
> I would like to find out what record in the table has
> the largest amount of characters. This way I could possibly
> decrease the varchar size (currently 100) to speed up the
> queries.
>
> My table is as below.
> CREATE TABLE competitor (
> CompetitorsName varchar(35) not null,
>
> I have been trying to get mysqld to run under 2 ip addresses
> (localhost and an external ip address). Using the bind-address
> option twice doesnt seem to work, nor does lisiting 2 ip addresses
> in the option. I hope mysqld has this functionality to be able to
> run under certain ip addre
> Is there a way to raise this limit? We have some tables with columns that
> are VARCHAR(200), and need to make a primary key based on combinations of
> these columns (in some cases, upto 4 columns), and MySQL complains for all
> of these table definitions that "Specified key was too long. Max ke
> I'm using 3.22.27 and am getting an error when I submit queries.
>
> I do a select * from table where...
>
> And it gives me:
>
> ERROR 1030: Got error 127 from table handler
chris@entropy:~$ perror 127
Error code 127: Unknown error 127
127 = Record-file is crashed
Run isamchk -r on the ta
> I am a newbie at this and I cannot find the damn answer to it! I want
> to display the table in an html format with PHP but I cannot get it to
> work! With MS SQL Server it was sooo easy! With PHP and mySQL it's a
> pain in the butt! I cannot find any documentation on this and I order 3
> bo
> quickie: can auto_increment wrap?
Only with ISAM tables which reuse deleted auto_increment numbers. MyISAM
tables will give you "Duplicate entry" errors if you hit the maximum.
-
Before posting, please check:
http://www.m
> > Only with ISAM tables which reuse deleted auto_increment numbers. MyISAM
> > tables will give you "Duplicate entry" errors if you hit the maximum.
>
> I hadn't realized this and tested it out in MySQL 3.23.43, but in my tests
> ISAM tables also returned a "Duplicate entry" error when I hit
> t
> It puts the messages in a tree and makes viewing pertinent threads
> a breeze,
My mail client puts messages in a tree and makes viewing pertinent threads a
breeze. And even with the archives:
http://marc.theaimsgroup.com/?t=10043869449&w=2&r=1
Doesn't look hard to me...
database,sql,quer
> Our brand new, fresh install of 3.23.46 won't let us set the
> password for the root user because one seems to already be set.
> Even after wiping the ...mysql/data/mysql directory clean and
> rerunning mysql_install_db, we still get an "Enter password:"
> prompt when attempting to set the root
> > regarding mysql_pconnect() we haven't tried that, but the nature of
> > the site suggests it would need like 500 apache deamons connected
> > all the time. And that's a lot of sort buffers and stuff beeing
> > allocated for each one of those ?
Not if you disable keepalive requests, which I do
> I am looking to update a record in a table, but take the
> exsisting value and adding the new value to it...
>
> I.e.
>
> Exsisting record = 150, new record being inputed = 250 for a
> total of 400 to be entered into the database.
UPDATE table SET row = row + 250 WHERE id = #;
---
> Here's the simplified query:
>
> SELECT members.name, group.id, group.name
> FROM members
> LEFT JOIN members AS group
> ON group.id = members.group_id
> WHERE members.id = 6
>
>
> And here's the error I get:
>
> You have an error in your SQL syntax near 'group ON group.id =
> me
> #2 All I have read on the web/books suggests that this is what to do
> $result = mysql_query ("SELECT title, description, url, author,
> date_format(datefield, %M %D %Y') FROM documents");
>
> This just leaves out all dates.
You may want to try:
$result = mysql_query("SELECT title, descrip
> Is it possible to update a field with the result of a select.
> For example:
Try:
SELECT @newbalance := ordr_order.total_cost - sum(ordr_payment.amount) FROM
ordr_order LEFT JOIN ordr_payment on ordr_payment.ordr_order_id =
ordr_order.id WHERE ordr_order.id = 1;
UPDATE ordr_order SET balance =
> when as root I give command
> /usr/bin/safe_mysqld &
> It gives me following messages:
> Starting mysqld daemon with databases from
> /var/lib/mysql and on the next line it says
> mysqld ended.
What does /var/lib/mysql/`hostname`.err say?
--
> Of course, the SAME spam we saw before appears again. No surprise.
> Does anyone still believe this will go away by itself? It won't -
> it will only get worse - unless the list administrators actually
> *do* something about it! The filters DO NOT WORK.
Is there any reason why the list can't ju
http://www.mysql.com/doc/R/e/Replication_Features.html
Replication will be done correctly with AUTO_INCREMENT, LAST_INSERT_ID, and
TIMESTAMP values.
> This sounds encouraging, but are there any known problems with the MySQL
> replication model currently available?? Would the slave servers have t
Yes, I know from experience, it's the best way to do it.
And if you need to get the number generated by an auto_increment column in
an insert, you can use last_insert_id() (or mysql_insert_id() with php).
> Thank you Chris with this info! This will greatly help me out, so as I see
> it now, ther
> >I've recently moved from MS-SQL Server 7.0 to mySQL. In MSSQL I
> >used to give the default value 'GetDate()' for a field in the
> >database with the datetime datatype. In mySQL I tried using Now().
> >But when I insert a new row the datetime field is taking :00:00
> >00:00:00 value
Have you tried:
select concat("blah", x, "bleh") from y group by x;
> Hi All,
>
> when I use a distinct on varchar fields, does mySQL truncate the value
> of the string to some set value.
> This two queries give me a completely different number of rows and I am
> not sure how to influence the
select ip, mac from ipmac group by mac having count(*) > 1;
> I have a table with IP/MAC address combinations and I want to track
> which MAC address might have used an IP address other than the one
> originally assigned.
>
> Is there some way that I can query my table for duplicate MAC
> addres
Have you looked at mysql_error() ? Are you sure $select_ is a valid php
variable name?
> Oi,
>
> I cannot get my head around that.
> I got a QS that worked fine, then I edited the PHP-script, not the part
> which is now causing errors, and it does not work anymore. That
> is strange,
> if there w
http://www.mysql.com/doc/C/o/Connecting.html
Scroll to the bottom, where it describes adding your password to .my.cnf in
your home directory.
> I actually wanted to disable passwords completely.
>
> so when I type mysql the mysql> comes up.
>
> Tom
-
This is not a bug. Why don't you just select * from abc where field2 = 'I am
the first';? Or:
mysql> select *, min(field2) from abc group by field1;
+--++-++
| ID | field1 | field2 | min(field2)|
+--++-+---
Add ORDER BY postdate DESC to the end of the query.
> I'm creating a Blogger-like system for my website and I have it check for
> posts within the last 14 days using the following command:
>
> $result = mysql_query("SELECT * FROM data WHERE TO_DAYS(NOW()) -
> TO_DAYS(postdate) <= 14",$db);
>
> Ho
> SQL STATEMENT:
>
> SELECT
> players.playerid,name,
> count(goals.goalid) AS goals,
> count(penalties.penaltyid) AS penalties
> FROM players
> LEFT JOIN goals ON (players.playerid=goals.playerid)
> LEFT JOIN penalties ON (players.playerid=penalties.playerid)
> GROUP BY players.playerid
> The one we tried was:
>
> $SQL = " SELECT * FROM cvtemplate WHERE employment_type =
> '$employment_type'
> AND location = '$location' AND related_discipline =
> '$related_discipline',
> MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree,
> wxcdfour AGAINST
> ('$keywords') AS score FROM cvt
With windows, you can use "type filename.sql | mysql ..."
> Maybe he's running in some windows version??
> It seems to me that your example using std-in is the easiest. I would
> suggest also writing a perl program but in this case I thing your
> example is
> right on. Then again if he's using
> Is there a simple way to force mySQL to always return dates and
> datetime in
> ISO
> long format, without the '-', ':' and spaces? (in a TIMESTAMP(14) like
> format)
>
> I always want 20010517 rather than 2001-05-17,
> and 20010517130500 rather than 2001-05-17 13:05:00
Use ints and bigints?
Create another table with an id column and a code column, and for each code
insert a column with the id of the row in the original database and the
code. Then do an SQL join to search. For example:
mysql> create table example (id int(11) NOT NULL auto_increment, blah
varchar(100), PRIMARY KEY(id)
Does the table have an auto_increment column? If so:
select * from table where autoinccolumn = LAST_INSERT_ID();
> I wrote a program to keep inserting rows to the databases. But I
> want to check the LAST row I inserted. Is there any good way to do it??
--
Perhaps in your case it would be better to use another table and do a join?
> Hi!
>
> In order to save space in our database, we designed our tables to use
> enumerated datatypes. For one column, we have about 2,800
> different values,
> each of which is about 30-40 text characters long. Now,
I think you're using it incorrectly. It should be:
grant insert on test.* to testuser@localhost identified by 'testpassword';
> I have successfully installed MySQL 3.23.38. I can start the server
> and log in as root. When I try to grant new users using:
>
> grant insert to test.* for testu
Only way I can think of is to use a temp table:
CREATE TEMPORARY TABLE test (fruits varchar(100) not null) TYPE=HEAP;
INSERT INTO test SELECT DISTINCT fruits1 FROM table;
INSERT INTO test SELECT DISTINCT fruits2 FROM table;
SELECT DISTINCT fruits FROM test;
DROP TABLE test;
However this can be s
> You can start the MySQL daemon with:
> cd /usr/local/mysql ; /usr/local/mysql/bin/safe_mysqld &
...
> [root@stupidsiteforjerks mysql-3.23.38]# /usr/local/mysql/bin/mysqladmin
> -u
> root -p password 'new-password'
> Enter password:
> /usr/local/mysql/bin/mysqladmin: connect to server at 'localho
Make your auto_increment primary key something bigger than a TINYINT
> ive run into some trouble with a table not taking more then 128
> rows. I just use MySQL from my webpage, with PHP, and its all
> done by my host, so im a novice here. Anything i can do to get
> the table to accept more the
http://www.mysql.com/doc/F/u/Fulltext_Search.html
Search for the word MySQL produces no results in the above example. Word
MySQL is present in more than half of rows, and as such, is effectively
treated as a stopword (that is, with semantical value zero). It is, really,
the desired behavior - a n
You can also download Junction from
http://www.sysinternals.com/ntw2k/source/misc.shtml#junction which does the
same thing.
sql
> Hello Tom,
>
> If you're using Windows 2000 it has junction points. It's almost the
> same as symbolic links in UNIX. Except it works only for directories.
>
> Try
1 - 100 of 164 matches
Mail list logo
