Hi,
Are there certain chacters that a VARCHAR field can't store?
If I xor encrypt a #, I get non-alphanumeric characters:
Ex: 123456789123 may end up 1 YdR
Is this a problem to store properly, should I use a different field type other than
varchar?
Thanks,
Chris
);
- -
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.954.9133
- -Original Message-
From: Chris [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 12:10 PM
To: mysql
Subject: Fields
Hi,
Are there certain chacters that a VARCHAR field can't store?
If I xor
: Error on delete of '/usr/local/var/g
umby.pid' (Errcode: 13)
020206 14:38:36 mysqld ended
---
Anyone have any ideas on how I should troubleshoot?
Thanks
Chris Mulcahy
__
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http
: Error on delete of '/usr/local/var/g
umby.pid' (Errcode: 13)
020206 14:38:36 mysqld ended
---
Anyone have any ideas on how I should troubleshoot?
Thanks
Chris Mulcahy
__
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http
, but
if my application writes the data beginning and ending with 's would that
solve my problem?
Thanks,
- Chris
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
mysqld_multi safe_mysqld
mysql_fix_privilege_tables mysqldump
Thanks alot!!
- Chris
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
Description:
On an unsuccessful INSERT DELAYED using mysql_query(), there is disagreement
between the two functions mysql_error() and mysql_errno(). Specifically,
mysql_errno() will return 0 (indicating no error), whereas mysql_error()
will return what really happened, e.g. Table 'foo'
Originator:chris
Organization:
MySQL support: none
Synopsis: make fail when --with-libwrap
Severity: critical
Priority: low
Category: mysql
Class: sw-bug
Release: mysql-3.23.49-max (yes)
Environment:
System: Linux mmp4.ust.hk 2.4.7-10 #1 Thu Sep 6 17:27:27
' AND pctlnum = '00021169'
and claimamt = 325.00;
You will find some but not all of the rows which match.
Fix:
No work around or fix known.
Submitter-Id: submitter ID
Originator:Chris Johnson
Organization:
MySQL support: none
Synopsis: Indexing of decimal columns fails
I get this message when I do a myisamchk on a table right after I use
phpMyAdmin or other mysql client tools.
What do I need to do to get the table to close properly? I have been
having to run myisamchk -r on the talbe every time I do something to it.
Thanks in advance,
Chris
Use the DISTINCT keyword and count the returned rows
- Original Message -
From: Jamie Burns [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 14, 2001 9:08 AM
Subject: surely an easy quick one
Hello again :o)
This is surely an easy quick one but my brain wont work!
I
Post your query
- Original Message -
From: Michael Paffrath [EMAIL PROTECTED]
To: MySql [EMAIL PROTECTED]
Sent: Tuesday, September 18, 2001 12:10
Subject: multiple select
hi!
i am rather new to mysql and i have problems with a multiple select
statement.
i have a search form where the
= '$kueche' ORDER by $order ASC LIMIT $start, $limit
Sorry if this does not answer your question
- Original Message -
From: Michael Paffrath [EMAIL PROTECTED]
To: MySql [EMAIL PROTECTED]
Sent: Tuesday, September 18, 2001 12:37
Subject: Re: multiple select
am 18.09.2001 12:30 Uhr schrieb Chris
I had a similar problem on a win2k system when I started using mySQL. I
changed the user and password in phpmyadmin's config.inc.php. Or you can
change it in the my.ini file.
This might be alot more complicated with a unix system.
- Original Message -
From: GUYOT Carole [EMAIL
mySQl-to-Access 1.1 works great but it's not free. The trial version only
converts 5 records.
It's at http://www.convert-in.com/demos/sql2accd.exe
Chris
- Original Message -
From: Troy Montour [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 17, 2001 22:56
Subject
Getting an error message in the log saying...
fp=(nil), etc, etc, possible bug
from ibuf0ibuf.c, line 2339
What're the possible reasons I could be getting this bug?
Oh, forgot...
MySQL-max 3.23.42
innodb
Red Hat 6.2(2.2.14-6.1.1.smp)
Intel 866Mhz, 512MB Ram, 20+ GB SCSI HDD
Thanks,
Chris
the innodb config out of the my.cnf the
mysqld starts up ok(albeit w/o all my data).
Thanks,
Chris
On Thu, 27 Sep 2001, Heikki Tuuri wrote:
Chris,
what is the exact error message? How do you know that
it comes from ibuf0ibuf.c, line 2339? Have you compiled
yourself?
Regards,
Heikki
be invalid
The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains
information that should help you find out what is causing the crash
011002 13:28:54 mysqld ended
//Log file ends
Thanks,
Chris
On Thu, 27 Sep 2001, Heikki Tuuri wrote:
Ok,
I
!
- Chris
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL
in developing a SyncServer project as well?
Thanks!
- Chris
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
to be able to update the database with the new image
through a script since it needs to be automated.
Does anybody have any ideas, and can this be done?
Thanks!
- Chris
-
Before posting, please check:
http://www.mysql.com
I have two tables that are exactly alike. What I want to do is fetch the
rows from each into one sortable result set. Example:
Table1
--
| Column1 | Column2 | Column 3 |
--
| 1| 2| 3|
telnet to the mysql port on the machine, and its available. I did a
perror on 22 and it tells me invalid argument.
What's going on??
Thanks,
- Chris
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
I know it runs on 3306 :)
I can telnet to the host on port 3306.
- Chris
On Sat, 14 Dec 2002, Grant Cooper wrote:
Mysql works on port 3306 by default.
for example, my mysql server is on 10.10.10.1 so you would use this command
to test your mysql server.
telnet 10.10.10.1 3306
you
Is there a way to store the time and date that a record was added within
MySQL? I want to show the time and date on some of my records and can't seem
to figure out an easy way to do it. Thanks!
-Chris
-
Before posting, please
/mysql/sql-bench' directory
make[1]: *** [install-am] error 2
make[1]: exit `/usr/local/mysql/sql-bench' directory
make: *** [install-recursive] error 1
[root@chris mysql]#
---
RPM installation is successful but source installation failed like
above.
Can you give me some help?
Thanks in advance
Hi Guys,
Quick question... I need to be able to send a query like:
select cd,fid,s_from,s_to from ima where '3355443200' between s_to and
s_from
Thats fine and all, but when I get my results I pull 2 records:
MA smith 335544320 352321535
BS mango 3355443200 3355445247
I must only
you can also convert the ip to an ip number and store it that way.
makes it easier so you don't have do deal with a octete'd number
:)
-Original Message-
From: Hassan Schroeder [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 23, 2003 1:57 PM
To: MySQL Mailing List
Subject: Re:
capability in several of
the tables and chose MyISAM.
Thanks,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SHOW COLUMNS FROM table_name LIKE 'Identifier'; should work.
It's all in here, jsut search the page for SHOW COLUMNS:
http://www.mysql.com/doc/en/Show_database_info.html
Chris
-Original Message-
From: Patricia LaRue [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 11:02 AM
Oh, sorry about that. I think I read it a bit too quickly...
You can't that I'm aware of, besides getting the table list and using an
external script to loop through them.
But, of course, I definitely could be wrong.
Chris
-Original Message-
From: Patricia LaRue [mailto:[EMAIL
be inserted without
problems.
Thanks
chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
=ascii_general_ci
0=collation_server
1=latin1_swedish_ci
Include the CREATE statement for your table as well.
CREATE TABLE my_table (location_id varchar(20) NOT NULL default '',name
varchar(50) NOT NULL default '',PRIMARY KEY (location_id)) TYPE=MyISAM
Chris wrote:
I think I have a problem
.
Chris wrote:
Sorry, I am unable to work the command line. I have used this script
instead.
$sql = show variables like '%char%';
$result = mysql_query($sql) or die(Couldn't Select .mysql_error());
$count = mysql_num_rows($result);
//echo $count;
while ($row = mysql_fetch_row($result)) foreach
I correct to assume changes to character sets must be done via command
line?
cw
Gleb Paharenko [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hello.
Chris, the collation is subordinated to the character set. You should
work with the character sets, and only after with collations
starmonkey wrote:
q: I want to pull a distinct list of content that have a category
(we have a content_categories table linking content ids with category
ids), BUT I want it to be able to work from multiple categories in an
AND fashion.
the table structure is, roughly:
content:
id
name
I want to create a SELECT statement using BETWEEN like:
SELECT * FROM mytable WHERE myfield BETWEEN value_1 AND value_2. The field
I'm applying my BETWEEN clause is a varchar.
Now, if value_1 and value_2 are numbers the select statement works as is. If
value_1 and value_2 are characters I need
Hi
Is mysql 4.0 still supported or EOL, as the recent advisory says users
of 4.0 should upgrade to 4.1 to patch the security problem.
Subsequently I have noticed a new 5.x release and new 4.1.x release
and no 4.0.x release.
Thanks
Chris
--
MySQL General Mailing List
For list archives: http
/delete.
May not be the best way, but it would work.
Chris
Marcus Bointon wrote:
I just noticed that a key field (emailaddress) in my db is case
sensitive when it should not have been, so now I've got a bunch of
what are effectively duplicate records. I'm having trouble picking
them out so I can
anyway.
Chris
FROM_UNIXTIME():
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html#id2724743
UNIX_TIMESTAMP():
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html#id2726862
Sebastian wrote:
i have this query:
SELECT COUNT(*) AS score FROM downloads WHERE date_add
Comments are inline.
Just a friendly reminder, you replied to an existing thread then changed
the subject to send this email. So people whose email clients thread
messages might not even be seeing your email if they don't look inside
the thread you originally replied from.
James wrote:
Because you're asking how many rows are in those tables and it has a reply?
Jason Pyeron wrote:
mysql select count(*) paths;
+---+
| paths |
+---+
| 0 |
+---+
1 row in set (0.00 sec)
mysql select count(*) files;
+---+
| files |
+---+
| 0 |
+---+
1 row in set
Greetings,
We have a few queries that we use against our product database. We pull these
results, and only display 50 rows per page via our web interface (then use
next and back page links). An example query is:
select distributer.short_desc,
distributer.sku,
distributer.avail_code,
On Tuesday 30 August 2005 02:30 pm, [EMAIL PROTECTED] wrote:
Chris [EMAIL PROTECTED] wrote on 08/30/2005 01:51:34 PM:
Greetings,
We have a few queries that we use against our product database. We pull
these
results, and only display 50 rows per page via our web interface (then
use
should be:
*.*
Chris
Todd Cary wrote:
I have created a table, sfyc and as root I issued the following:
grant all on * to todd identified by 'my_password' with grant option;
However, todd cannot access sfyc with
mysql -u todd -p sfyc
And the mysql db contains the following:
user table
head that seems the way to go, if anyone else cna do
it better please speak up.
Chris
Donnie Lynch wrote:
Hi,
I'm pretty much an SQL newbie, so apologies in advance if this is
basic stuff. That'll teach me for skipping the databases class in
college...
I just created an app using a table
You might do something like:
SELECT t1.* FROM t1 LEFT JOIN t2 ON(t1.field1=t2.field1 AND field2={fieldvalue}) WHERE
{all kinds of limits} AND t2.field1 IS NULL LIMIT 0,20;
the LEFT JOIN/WHERE idfield IS NULL will join the table and then lists
rows in table 1 that don't exist in table 2
Mark van
a session,
but not after quitting and starting a new one.
Are these issues others have run across?
Please tell me I don't have to go back to holding
down the arrow key to edit statements!
Apologies if this has been addressed already...
-chris
--
MySQL General Mailing List
For list archives: http
. Why is it doing that?
Has it got something to do with the way my query is worded?
Thanks in advance,
Chris
=EXPLAIN
get it to reproduce the problem. The database was just created and
populated, so it couldn't have been DB degradation.
Any ideas?
Chris
+-++--+--+-+-+--+---
---+
| table
In 4.0.2 SHOW DATABASES became a privilege, and if you don't have that privilege then
you can see only 'your own' databases.
Maybe your privileges were changed during the upgrade?
http://www.mysql.com/doc/en/Show_database_info.html
Chris
-Original Message-
From: Dickon Newman [mailto
a temporary table that won't
conflict with others). Temporary tables are dropped as soon as the connection is
dropped.
Chris
-Original Message-
From: William IT [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 29, 2003 5:01 PM
To: [EMAIL PROTECTED]
Subject: Multiuser Programming
I am doing
No, 4.0.2 is older than your version, just check the privileges, and set any
of them to 'N' where you don't want them (if any of them are set). It's just
a possible cause/solution.
Chris
-Original Message-
From: Dickon Newman [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 30, 2003 5
IF I understand you correctly, you should be able to do this:
UPDATE employees SET
userid=substring(per_email_address,1,instr(per_email_address,'@')-1);
Chris
-Original Message-
From: news [mailto:[EMAIL PROTECTED] Behalf Of Jason Joines
Sent: Wednesday, November 05, 2003 9:14 AM
:
SELECT
group_id,
name,
IF(1=userid,'SELECTED',' ')
FROM groups
ORDER BY group_id
Chris
-Original Message-
From: Geeta Rajaraman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 7:03 AM
To: [EMAIL PROTECTED]
Subject: MySQL sub
If it's below 4.0 then you can't use subqueries at all, subqueries were
(will be) introduced in 4.1.
That query is just a standard query, but the third item will return the
value of 'SELECTED' if the userid is equal to 1 and ' ' otherwise.
Chris
-Original Message-
From: Geeta Rajaraman
That second query, byt itself, should have done it, were you logged in as
testuser when you tried to run it?
Chris
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 5:26 PM
To: [EMAIL PROTECTED]
Subject: GRANT TO SELECTED COLUMNS
' AND Host='%'
Chris
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 6:56 PM
To: [EMAIL PROTECTED]
Subject: RE: GRANT TO SELECTED COLUMNS
Hi Chris/Lists,
In fact, I was able to login using both ways, here's what I did.
1. mysql -u
(not decimal points to
specify, and the nubmers would be stored as numbers) and sorting it the way
you want would be much easier and faster.
Chris
-Original Message-
From: Agrin, Nathan [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 10:44 AM
To: [EMAIL PROTECTED]
Subject: Sorting
['PHP_SELF'] (recommended) or turn register_globals on.
http://us3.php.net/manual/en/reserved.variables.php
Chris
-Original Message-
From: Mario Miyojim [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 10:18 PM
To: [EMAIL PROTECTED]
Subject: Needing help about PHP+mysql on RedHat 9
As far as I know, DELETE's make gaps in the table (you could remove these by
optimizing). If you INSERT into a table with gaps, your INSERTed row will
try to fill the gaps created by that. Maybe it works backwards in filling
the gaps?
-Original Message-
From: Jeff McKeon [mailto:[EMAIL
That won't do what it looks like he wants.
GROUP BY can't do that :( I wish it could.
This issue recently came up for me, and I initially was using Temporary
table, but then had to switch to a 'pregrouped' table so I could retrieve
data properly.
-Original Message-
From: Peter Sap
be getting good results with having because the rows you want are
the first in the group and are being chosen, but you'll find that if they
aren't first that group won't return at all.
Chris
-Original Message-
From: Peter Sap [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 20, 2003 11:57 PM
.
-Original Message-
From: Chris Nolan [mailto:[EMAIL PROTECTED]
Sent: Friday, November 21, 2003 9:46 PM
To: [EMAIL PROTECTED]
Subject: Using MySQL with a custom-built server
Hi all,
I've just been contacted by a potential client that wants me to build a
product for them of the following type:
1
Wouldn't this also work?:
mysql -u root -p -e CREATE TABLE t$date(...) yourdatabase
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Friday, November 21, 2003 12:46 PM
To: Julian Zottl; Andy Eastham; Mysql List
Subject: RE: DB design question - shell scripting...
you could try encasing the name with backticks:
CREATE TABLE `My Table`(`My Column` INT);
-Original Message-
From: joffrey leevy [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 22, 2003 6:09 PM
To: [EMAIL PROTECTED]
Subject: question about column names
Hi all:
How does one get
for, could you clairfy some more?
Chris
-Original Message-
From: rmck [mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 4:52 PM
To: [EMAIL PROTECTED]
Subject: create own auto increment number
I have a request to create an auto increment field
that increments like so:
1-112403
2-112403
3
PHP and MySQL Web Development, by Luke Welling and Laura Thomson
It's an excellent book.
-Original Message-
From: Richard Bewley [mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 6:53 PM
To: [EMAIL PROTECTED]
Subject: FW: How To Learn php and mysql.
The best way to learn is by
to
www.networkshastrihall.com , it resolves to 202-63-167-192.exatt.com .
You would need to be connecting to MySQL from the computer
www.networkshastrihall.com sits on to be able to connect.
Chris
-Original Message-
From: ads mysql [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 17, 2003 7:44 AM
and switch_connect.switch2_port . Problems are
much easier to define and solve if you simplify them down to the basics. If
you're able to do what you want with those values Then you can add the
complexity of JOINing to other tables and you'll know when it 'should work'
and not.
Chris
-Original Message-
From
as a MySQL variable. The user being able to guess at
column names in the database isn't usually a good thing for security
reasons.
Chris
-Original Message-
From: Paul Fine [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 17, 2003 8:17 AM
To: [EMAIL PROTECTED]
Subject: Variable names
You're trying to do a Sub-query, Sub-queries aren't supported until version
4.1.x
You could do a simple join/group to get these results:
SELECT
cities.id,
cities.name,
COUNT(images.city_id) as number_of_images
FROM cities
LEFT JOIN images ON(images.city_id = cities.id)
GROUP BY cities.id
You need to set up the initial privileges. Just follow the directions here:
http://www.mysql.com/doc/en/Default_privileges.html
Note: you shouldn't need to run mysql_install_db if you installed the rpm.
(I think)
-Original Message-
From: James Marcinek [mailto:[EMAIL PROTECTED]
Sent:
.
Chris
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 21, 2003 4:29 PM
To: [EMAIL PROTECTED]
Subject: setup.exe
I downloaded MySQL but is unable to find the setup.exe file so that I can
install it on my computer. Where can I locate this file
I'm fairly sure that the ONLY limitation is the size of the table files, adn
those depend on the OS.
http://www.mysql.com/doc/en/Table_size.html
Chris
-Original Message-
From: Andres Montiel [mailto:[EMAIL PROTECTED]
Sent: Monday, December 22, 2003 9:57 PM
To: [EMAIL PROTECTED]
Subject
where and how do I indicate that there is a problem
insert a row into the table 'message'?
I don't understand you there.
INSERT INTO message(thread_topic, thread_body) VALUES ('This is a
topic','This is the body.');
That should work just fine.
-Original Message-
From: Caroline Jen
I've only used it on a 100,000 row table. It can get a little hairy writing
the queries though.
Chris
-Original Message-
From: Schulman, Michael [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 01, 2004 7:14 PM
To: 'Fredrick Bartlett'; [EMAIL PROTECTED]
Subject: RE: Time series
As far as I
I'm fairly sure there is *no* way to do it. COMMIT says 'I want this data in
the database' not 'I think I want this data in the database'
Chris
-Original Message-
From: karthikeyan.balasubramanian
[mailto:[EMAIL PROTECTED]
Sent: Thursday, January 01, 2004 11:37 PM
To: [EMAIL PROTECTED
I am just a user (not an administrator) and would like to know what
privileges I have with my MySQL user account. Is there a SELECT command I
can construct that will list these privileges?
Thanks,
Chris
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
Never place friendship
.?
I tried this but I couldn't get past mysql_query
Chris
Paul DuBois [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
At 20:24 -0500 1/8/04, Chris wrote:
I am just a user (not an administrator) and would like to know what
privileges I have with my MySQL user account. Is there a SELECT
UPDATE EMAIL_TEST_LIST SET EMAIL_DATE = curdate();
-Original Message-
From: Ligaya Turmelle [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 08, 2004 10:42 PM
To: [EMAIL PROTECTED]
Subject: is it possible...
Is it possible to have an update statement that uses curdate()?
Example:
Are there any know issues or bugs with MySQLGUI running on Solaris 8
thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Is there a method I can use to log into a remote mysql server through something such
as telnet to pass queries on my database?
All you need to do is :
SELECT LAST_INSERT_ID();
The way it's written, you are doing the LAST_INSERT_ID() function call a
number to times equal to the amount of rows in arp3_cam
-Original Message-
From: Anderson [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 21, 2004 6:37 PM
To: [EMAIL
I don't think he wants to return a Value of 'Tuesday', he wants to return
the value of the column NAMED Tuesday.
So instead of
SELECT Tuesday FROM inventoryRoom WHERE inventoryid='1';
He's trying to specify the Tuesday column with DAYNAME('2004-03-23');
I have no idea if that's possible.
In 4+ you can use SQL_CALC_FOUND_ROWS flag
http://www.mysql.com/doc/en/SELECT.html
-Original Message-
From: Steffan A. Cline [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 28, 2004 8:47 AM
To: MySql
Subject: Getting count(*) with LIMIT in SQL
I have been tinkering with finding the
Hi Guys,
Iv got a script that iv been working on written in perl which interfaces to
mysql via the dbi module..
The script only does two selects within the entire script, so I didn't think
it would be too taxing on the machine.
Turns out that when the script is executed around 100 times a
4.0.18 is the latest 4.0.x release.
4.0.3 4.0.9 4.0.10 4.0.18
4.0.3 != 4.0.30
-Original Message-
From: Lou Olsten [mailto:[EMAIL PROTECTED]
Sent: Monday, April 19, 2004 1:44 PM
To: [EMAIL PROTECTED]
Subject: Getting an older version of MySQL
Hi,
I'm currently running some
`
GROUP BY mycat;
then
SELECT myval, myotherrows, mycat
FROM `mytemptable`
LEFT JOIN mytest USING(myindex,mycat)
note: I haven't tested the above code, it's just an example of the theory
Chris
-Original Message-
From: Noah Spurrier [mailto:[EMAIL PROTECTED]
Sent: Wednesday
, it may not work as is.
SQL is really *meant* to have sub-queries, so the temp table solution is
just a work around until sub-queries make it into the production version of
MySQL. At least, that's how I understand it anyway.
Chris
-Original Message-
From: Noah Spurrier [mailto:[EMAIL
This is a PHP question, not MySQL.
http://www.php.net/mysql_data_seek
-Original Message-
From: Scott Swaim [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 21, 2004 2:47 PM
To: Mysql
Subject: re-using a results set
I have a form that does the following
? while
What query are you using to search?
With the FullText indexes you have only two match options are possible:
MATCH(specs) AGAINST . . .
and
MATCH(manufacturer) AGAINST . . .
If you're trying to search both at the same time you need a FULLTEXT
index of (specs,manufacturer)
Chris
Robb Kerr wrote
change these). It only works in the Unix MySQL client.
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
Best Regards
Alejandro
On the same server just do this:
SELECT dbname.tablename.columnname,db2name.table2name.column2name FROM
dbname.tablename, db2name.table2name; (I think you get the idea)
As far as I know you can't select data across multiple servers.
Chris
--
MySQL General Mailing List
I think I fixed it, at least as best I could. still same result:
[EMAIL PROTECTED] ~]$
[EMAIL PROTECTED] ~]$
[EMAIL PROTECTED] ~]$ su - mysql
Password:
-bash-3.1$
-bash-3.1$ mysql -u root -p
snip
mysql quit
Bye
-bash-3.1$ exit
logout
No no no.
AS the MYSQL user:
cat /tmp/abc.txt
Now, would someone please explain *why* this worked and all my other attempts
didn't? Was it because of file permissions? or the linux user id? or that I
put a passwork on the mysql root account? or that I changed the ownership of the
data file? or that I took out some spaces on the data
wang shuming wrote:
Hi,
SQL like
select *,(select f1 from (select f1,date from table1 t1 where
t1.f1=table1.f1 order by date desc limit 1 ) t2 ) lastf1
from table1
shows table1.f1 not found, mysql 5.0.37 .
Break up your query and work out which table1 it's talking about,
Ratheesh K J wrote:
Hello all,
I have a requirement of maintaining some secret information in the database.
And this information should not be visible/accessible to any other person but
the owner of the data.
Whilst I know that encryption/decryption is the solution for this, are there
any
Ratheesh K J wrote:
Ok.. Will it be secure if the data is encrypted. mysqldump will show
encrypted data right.
mysqldump will show whatever the database table does - it just grabs
that info and puts it into a file. If it's encrypted in the table,
that's what mysqldump will show.
Actually I
24 HOUR)
AND '2007-03-23 23:59:59';
Chris
Rob Desbois wrote:
I am having issues with type conversion not working as expected per the
documentation.
I am using in MySQL 5.0.27 for x86/Windows.
The documentation at
http://dev.mysql.com/doc/refman/5.0/en/type-conversion.html states
1 - 100 of 2034 matches
Mail list logo