a command in mysql to tell it to
go to my user directory or home directory.
Thanks
--Mike
__
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com
--
,
DateNextQtyComplete VARCHAR(10) NOT NULL,
StatusQtyWorked VARCHAR(10) NOT NULL,
ID INT(5) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (ID)
);
Does anyone know why the auto_increment doesn't work?
I'm using mysql Ver 8.0 Distrib 3.22.32, for
pc-linux-gnu on i686
Thanks yo
Crazy its working this morning. Must of had some kind
of hickup, but I swear yesterday it was not working.
=)
Thanks.
--- Rolf Hopkins <[EMAIL PROTECTED]> wrote:
> In what way doesn't it work? Works fine for me.
>
> - Original Message -
> From: "Mike Mi
ommmand it returns 0 records.
Can someone help me with this statement.
Thank you -- Mike
This is my data.
+---+++
| Host | ID | TheDate|
+---+++
| 192.168.0.140 | 1 | 2001-07-23 |
| 192.168.0.140 | 2 | 2001-07-23 |
| 192.168.0.140 |
ersion: 3.22.32
and i'm logged in as user root.
Thank you
--Mike
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/?.refer=text
1.Fuel)='NL'));
..And here is the error I get.
ERROR 1064: You have an error in your SQL syntax near
'(BillOfMat
LEFT JOIN ItemMaster ON BillOfMat.CompNum =
ItemMaster.ParentNum)
O' at line 3
Thank you for your help
--Mike
_
each record. My question is should I
break this up into a couple of tables so that each
table will have say 50,000 records and I can just
search through them with dates.
Thanks for any help.
--Mike
__
Do You Yahoo!?
Get personalized email addresses
|
|rat |
|hampster |
+--+
I've tried the following but its not producing what I
need.
select * from table_1,table_2;
select * from table_1 where ID IN (select ID from
table_2);
select * from table_1 UNION select * from table_2;
Any help would be great
Thanks for your help
-
I have a SELECT statement for MS SQL that is
SELECT TOP 1 id FROM menu_links ORDER BY id desc
and need to convert it to MySQL. I cannot find what will do that.
Help is greatly appreciated.
TIA
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
I guess I had the LIMIT in the wrong location.
Thanks for the help!
Mike
"Mike Wexler" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Mike wrote:
>> I have a SELECT statement for MS SQL that is
>>
>> SELECT TOP 1 id FROM menu_links ORDER BY
I'm compiling my mysql server from source.
I have started noticing this as of 4.1.10 - in fact, I was running
4.1.12 and it's changed the LinuxThreads detection (since LT does not
exist on amd64) - and 4.1.12 kept locking up after only a few minutes
of uptime consistently.
Once I figured this ou
If you are using v4 of php this will never work
On Tue, Jun 1, 2010 at 10:24 AM, memo garcia wrote:
> Hi all,
>
>
>
> I have the following script:
>
> Load data
>
> Local infile ‘myData.csv’
>
> Into table myTable
>
> Fields terminated by ‘,’
>
> Enclosed by ‘’
>
> Lines terminated by ‘\r\n’
>
>
Cameron Mann cybera.ca> writes:
>
> Hi all,
>
> I've encountered a problem with MySQL 5.6.23 on CentOS 7.0 and would
> greatly appreciate any advice on what to do next.
>
> Synopsis:
>
> 1. Fresh install of CentOS 7.0 using minimal install ISO
> 2. yum update -y
> 3. rpm -i http://dev.mysql.c
>Description:
When running the statements below, MySQL errors out with:
ERROR 1062 (23000) at line 5: Duplicate entry '1' for key 1 during SELECT
>How-To-Repeat:
drop table if exists t;
create table t (f int not null);
insert into t values (1),(1);
select 1 from
t straight_join
t as t2
I would like to move from 32-bit to 64-bit MySQL within the next year.
Unfortunately, there is not a lot of documentation on migration or anything
else regarding 64bit MySQL.
My current setup consists of one master and two slaves (all using 32bit and
MySQL 5.0). I am looking to add a 64bit slave t
On Fri, Apr 25, 2008 at 11:45 AM, Olaf Stein <
[EMAIL PROTECTED]> wrote:
> As long as you use dumps to restore your databases on the new 64bit system
> (instead of the binary files) you should be fine
>
> Olaf
>
I have so much data that we can't take a mysqldump of our database. The
directory tar
olumns but I
> would not try it.
> Why cant you take a dump, you can do it table by table, you will have some
> downtime though.
>
> One option might be to use a 64bit slave and make that the master and then
> add more 64 slaves.
>
>
>
> On 4/25/08 11:57 AM, "Mike&
e a dump, you can do it table by table, you will have
> > some
> > downtime though.
> >
> > One option might be to use a 64bit slave and make that the master and
> > then
> > add more 64 slaves.
> >
> > On 4/25/08 11:57 AM, "Mike" <[EMAIL
On Thu, May 22, 2008 at 9:20 AM, Tom Brown <[EMAIL PROTECTED]> wrote:
>
> Hi
>>
>> I had master-master working fin in dev - i move them to prd now and so
>> change the hostnames, on starting i see this error
>>
>> 080522 11:53:40 mysqld started
>> 080522 11:53:40 InnoDB: Started; log sequence n
On Thu, May 22, 2008 at 10:41 AM, François Beausoleil <[EMAIL PROTECTED]>
wrote:
> Hi all!
> I must be stupid or something. I can't find what my problem is.
>
> I searched this list, and did find a couple of hits, but nothing that
> seemed fully relevant. This one in particular was interesting:
=mysql
>
> so i would have thought it would not try and replicate that db ? Although i
> did not need that in my previous configuration.
>
> Any thoughts ?
>
>
Well if your master ever fails and you make the slave your new mater you
will be missing your mysql database. User mostly will be missing, which
might not be a big thing in your situation. Are there any other logs
before and after?
Mike
On Thu, May 22, 2008 at 5:36 PM, Salah Nait-Mouloud <
[EMAIL PROTECTED]> wrote:
> Hi all.
>
> I have 2 MySQL servers.
> One master and one slave.
> In order to add new slave server, and because i can't stop the master one,
> i
> have tried this:
>
> http://forums.mysql.com/read.php?26,99846,102058
On Fri, May 23, 2008 at 8:13 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Files is owned by mysql, but the point is, these relay-log files are not
> present.
> Before setting up the slave, i cleaned up all files.
>
If you want the logs back you could use RESET MASTER maybe.
http://dev.mysql
>
> regards
> anandkl
>
>
> On 5/23/08, Mike <[EMAIL PROTECTED]> wrote:
>>
>>
>>
>> On Fri, May 23, 2008 at 8:13 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>>
>>> Files is owned by mysql, but the point is, these relay-log f
On Fri, May 23, 2008 at 12:08 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Hi Mike,
> Since i have done a fresh backup from master (with master db down), and
> copied over the same to slave. Then why is the slaving looking for old
> relay-log. I also did the "RESET SL
Did you start from position Exec_Master_Log_Pos 1? Can you tell us the
command you used to get this going?
Mike
On Mon, Jul 28, 2008 at 4:14 PM, Bryan Irvine <[EMAIL PROTECTED]> wrote:
> I'm having an issue setting up a slave Where it doesn't seem to start:
>
>
Do you have the original mysql> show slave status\G; off the master?
I have a feeling you have the position wrong. I about 100% sure you have
the position wrong because it happened to me.
if you don't have it do a show slave status\G; and try to remember which one
you took.
Mike
On
accumulated so far. Then run "change master to master_host='192.168.1.161',
master_user='slave2', master_password='slave2;"
that is assuming your user name and password work. This will start over
again but since you at position 98. You will catch up to the master in
>No setup file is included in the ZIP mysql-4.1.1-alpha-win.zip
>Do you know why ??
It is alpha software, expect an installer with the final version. In the meantime just
extract the zip file into a directory and it should run.
--
MySQL General Mailing List
For list archives: http://lists.mys
>I made a mistake of not giving a name to an index.
>alter table sometable add index ( field1, field2 )
>I would like to remove this index but I can't figure it out.
If you perform SHOW INDEX FROM tablename; what do you get as the key_name? Try
dropping it based on what you see.
--
MySQL Gene
not set the column to NOT NULL then there are three possible values: Yes, No,
and NULL.
NULL simply means no value. Sometimes it is appropriate, sometimes it is not. In the
case of a Yes/No ENUM column I would say that in most cases the column should be set
NOT NULL.
Regards,
Mike Hillyer
www.
habit for using mysql_real_escape_string on any
components of my query that are dynamic. So if I have the user enter a name to search
for I would do:
$query = "SELECT * FROM mytable WHERE username = '" .
mysql_real_escape_string($userdata) . "'";
You should escape
you do not necesscarily see a performance
boost by using stored procedures for everything, in fact a MySQL server handling a lot
of stored procedures could very well show poorer performance than a proper n-tier
application.
Regards,
Mike Hillyer
www.vbmysql.com
--
MySQL General Mailing List
Fo
vance.
They do indeed, I have a nice certificate on my wall, a couple of MySQL pens in my
drawer, some MySQL stickers on my monitor, and my daughter plays with the MySQL
beachball (of course they may have changed the souveniers but I am sure you will get
the certificate.
Regards,
Mike Hillyer
>I want to have all the items into a recorset with only one query like
>Select id, reference, component from NOMS where reference = '4'
>but i want not only the primary relations, i want all relations.
>Could somebody help a newbie like me?
It can also help to change the way you look at the r
able or a bunch of smaller
identical tables it would be a tradeoff of speed vs. complexity. Normalization can go
a long wat to helping.
Check out: http://www.vbmysql.com/articles/normalize.html
Regards,
Mike Hillyer
www.vbmysql.com
--
MySQL General Mailing List
For list archives: http://lists.
.
--
Regards,
Mike Hillyer
Webmaster/Moderator
http://www.vbmysql.com
Read my blog at: http://www.vbmysql.com/mike/blog
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can anyone point me to docs on installing MySQL on Red Hat 9 on an Intel box?
Thanks,
-m
===
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Where can I find more info on converting and what can be converted.
Thanks
Mike Benzel [EMAIL PROTECTED]
Promote your Product with a Free SkyWiremeeting!
SkyWire Meeting - Internet Training from you PC or our Server.
Sorry Nils sent in hast.
(B
(B-Original Message-
(BFrom: Mike [mailto:[EMAIL PROTECTED]
(BSent: Friday, July 11, 2003 9:08 PM
(BTo: 'Nils Valentin'
(BSubject: RE: What's up with this GATOR crap? - HOWTO Clean it out
(B
(BI think the answers given are valid bu
hi.
I have a rather childish question on tables and auto increment fields.
Scenario: I have a table with an field. The
deal is that everything works fine (I'm talking about the auto
incrementation part)
until I choose to delete a row. This creates a gap in the primary key field.
And my question i
hi.
I have a rather childish question on tables and auto increment fields.
Scenario: I have a table with an field. The
deal is that everything works fine (I'm talking about the auto
incrementation part)
until I choose to delete a row. This creates a gap in the primary key field.
And my question i
>As for a book, I recommend the one on PHP and mySQL web development by Luke
Willing and Laura Thompson.
>Good luck!
>Richard
I would second that reccomendation. Luke Welling and Laura Thompson have a really good
book. ISBN 067232525X.
--
MySQL General Mailing List
For list archives: http://l
>wanted to know if one can write a Function or a procedure in a mysql 4.0.12..???
This is not going to be supported until MySQL 5.
>Also about this data dump, i went to C:\ and typed mysqldump test. .. this thing ran
>for quite some time but where was the dump finally could figure that out ..
Hi All;
I inherited an old Access database at work which was not at all normalized. I then
managed to normalize the schema, but I am running into problems. First let me show you
the two tables I need to query:
--
# Host: 10.1.1.14
#
I don't know if this will help, but I had these links left over from some
work I did a few years ago...
http://www.itl.nist.gov/fipspubs/fip6-4.htm
http://www.itl.nist.gov/fipspubs/co-codes/states.htm
On Wed, 2 Jun 2004, David Blomstrom wrote:
> I have a big database focusing on U.S. countie
name and description from album ,
img_path from images, and caption from img_caption for any paticluar
album row.
Thanks in advance for the help,
Mike
-
Before posting, please check:
http://www.mysql.com/manual.php
mysqlÄúºÃ:
È«¹ú¶À¼ÒÃâ·ÑÇÀ×¢. cn¶¥¼¶ÓòÃû £¡
±¶ÊܹØ×¢µÄÖйú¹ú¼Ò¶¥¼¶ÓòÃû(.CN), CNNIC½«ÔÚ2003Äê3ÔÂ17ÈÕ¿ª·ÅÖ±½ÓÒÔ.CN½áβµÄ¹úÄÚÓòÃû
Äþ²¨Íø»ùÈí¼þÓÐÏÞ¹«Ë¾ÏÖÔÚÍƳöÈ«¹ú¶À¼ÒÃâ·ÑÇÀ×¢»î¶¯,¸Ï¿ìÇÀ×¢ÄãÐÄÒÇÒѾõÄÓòÃû.
.CN¶¥¼¶ÓòÃûµÄÕýʽע²á¼Û¸ñΪ260Ôª/¸öÿÄê¡£
Äþ²¨Íø
final resort, would be to make a PHP script to output (what will be) the
emails to a browser, download the file, have a seperate program actually
send the emails -- however I suspect this too might take up too much of PHPs
time, and too much bandwidth.
Has anyone tried to do something like th
OS - FreeBSD 4.7 Release
MySQL 3.23.54
Have an odd error. When reinstalling MySQL, I needed to add something's,
it says the hostname is wrong, I did a make clean and tried make
reinstall --force and everything else I can find. Never had this error
before! Nothings been changed since it was install
not all units will have 9 items. Most units will have less than 9 items.
Any help would be greatly appreciated,
Thanks in advance,
Mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
mysqlÄúºÃ:
È«¹ú¶À¼ÒÃâ·ÑÇÀ×¢. cn¶¥¼¶ÓòÃû£¡
±¶ÊܹØ×¢µÄÖйú¹ú¼Ò¶¥¼¶ÓòÃû(.CN), CNNIC½«ÔÚ2003Äê3ÔÂ17ÈÕ¿ª·ÅÖ±½ÓÒÔ.CN½áβµÄ¹úÄÚÓòÃû
Äþ²¨Íø»ùÈí¼þÓÐÏÞ¹«Ë¾ÏÖÔÚÍƳöÈ«¹ú¶À¼ÒÃâ·ÑÇÀ×¢»î¶¯,¸Ï¿ìÇÀ×¢ÄãÐÄÒÇÒѾõÄÓòÃû.
.CN¶¥¼¶ÓòÃûµÄÕýʽע²á¼Û¸ñΪ260Ôª/¸öÿÄê¡£
Äþ²¨Íø»ùÈí¼þ
ults I would like.
Thanks in advance for any help,
Mike
sql,mysql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-ma
32:59 /usr/local/libexec/mysqld: Shutdown Complete
030201 16:32:59 mysqld ended
I have removed and reinstalled Mysql, checked permissions, made sure
nothing else is running on that port tried safe_mysqld and still got the
same error.
Any hints would be great!
Mike Benzel [EMAIL PROTECTED] f
16:32:59 /usr/local/libexec/mysqld: Shutdown Complete
030201 16:32:59 mysqld ended
I have removed and reinstalled Mysql, checked permissions, made sure
nothing else is running on that port tried safe_mysqld and still got the
same error.
Any hints would be great!
SQL DATABASE
Mike Benzel [
www.astatech.com and ZEOS components.
-Original Message-
From: Liu Qianghua-qch1942 [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 11:50 PM
To: [EMAIL PROTECTED]
Subject: How to connect to mysql server without myODBC
All,
I want to develop application with Delphi which can c
table_name;
to format my time column, But it didn't work.
Thanks in advance for the help,
Mike
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.319 / Virus Database: 178 - Release Date: 1/28/02
--
Hello,
Removing the quotations worked. Thanks for the help.
Mike
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, February 09, 2002 5:54 PM
Subject: Re: My SQL TIME_FORMAT
> Hello mike
table_name;
to format my time column, But it didn't work.
Thanks in advance for the help,
Mike
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.319 / Virus Database: 178 - Release Date: 1/28/02
--
Hello,
Removing the quotations worked. Thanks for the help.
Mike
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, February 09, 2002 5:54 PM
Subject: Re: My SQL TIME_FORMAT
> Hello mike
You need to create a symbolic link
ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
or
ln -s /tmp/mysql.sock mysql.sock
Do a search to find where it's at first though
locate mysql.sock
Mike
-Original Message-
From: Intrex [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 02, 2002
Don't know what web server your using, but I use apache's .htmaccess feature
to control user access. Works good for me, and its pretty easy to setup.
Mike
- Original Message -
From: "Siulun A Sze" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday
Thanks for the info! I sent your link off to a friend in ca who's looking
for such a site. I think it would be of great help if MySQL site had a list
of hosting providers as well.
Cheers
M;)
-Original Message-
From: System Administrator a.k.a. The Root of the Problem
[mailto:[EMAIL PROT
Great work!! I have been digging around for the same thing for awhile and
now I can finish a job I had been on.
Thanks
M;)
-Original Message-
From: BD [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 23, 2002 5:13 PM
To: Ricardo Striquer Soares
Cc: [EMAIL PROTECTED]
Subject: Re: ER Prog
The full error is probably access for Host denied. Look at
http://www.mysql.com/doc/A/c/Access_denied.html for the answerer and search
the new's group archives on how to GRANT the HOST access to the database.
-Original Message-
From: TH Leung [mailto:[EMAIL PROTECTED]]
Sent: Sunday, Mar
http://www.mysql.com/support/arrangements.html is pretty clear on what you
need...
M;)
-Original Message-
From: nagendra [mailto:nagendra%bartronicsindia.com]
Sent: Sunday, March 24, 2002 7:05 PM
To: [EMAIL PROTECTED]
Subject: Regarding Licence
Hai,
I have one doubt regarding Licenc
Look in the mysql manual on joins.
http://www.mysql.com/doc/J/O/JOIN.html
There is also some articles on this subject at
http://www.onlamp.com/onlamp/general/mysql.csp
Mike
- Original Message -
From: "Alex Behrens" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sen
I would check the value of $position to make sure it's what you want.
Mike
- Original Message -
From: "Alex Behrens" <[EMAIL PROTECTED]>
To: "Ron Jamison" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, March 27, 2002 9:14 PM
Subje
I don't think mysql has a feature like that. Check the manual at
www.mysql.com.
I think you will need to make another table to count the hits per category.
Then do a join between the two tables to get the results you want.
Mike
- Original Message -
From: "Alex Behrens" &l
DATE_ADD(date,INTERVAL expr type)
DATE_SUB(date,INTERVAL expr type)
ADDDATE(date,INTERVAL expr type)
SUBDATE(date,INTERVAL expr type)
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Dat
e_and_time_functions
Mike
- Original Message -
From: "Edilson Vasconcel
Graig,
I've been using mysql for about a year now on a linux machine and it has not
crashed or had any corrupted tables in that time. I believe mysql is just as
good in stability and safety of data has it is in speed.
Mike
- Original Message -
From: "Scalper" <[EM
Being the Sys Admin for the Boise Family YMCA in USA Idaho I say thanks for
sharing MySQL rocks! To bad the H. O'Loughlin CEO dud didnt hear it
Wish I knew who his client was so they could hear it to and dump him.
-Original Message-
From: João Paulo Vasconcellos [mailto:[EMAIL PROTECTED]]
>From the limited info given, I'd say you need to use the WHERE clause in
your SELECT statement.
SELECT * FROM blank WHERE something=something
Mike
- Original Message -
From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]>
To: "MySQL Mailing List (E-
>From my limited experience. I believe your gonna have to split that one
field of alpha and numeric into two fields one for the alpha info and one
for the numeric info. Then you can sort the information the way you want.
Mike
- Original Message -
From: "Luc Foisy" <[EMAI
http://www.php.net/links.php
Mike
- Original Message -
From: "Luigi Stefano Sona" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 10, 2002 12:12 PM
Subject: a little help for a beginner
> Hello,
> where can I find a simple php to generate
't been able to get it to work. Any help would be greatly
appreciated.
Thanks in advance,
Mike
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
---
%S %w');
-> '22 22 10 10:23:00 PM 22:23:00 00 6'
mysql> select DATE_FORMAT('1999-01-01', '%X %V');
-> '1998 52'
Mike
- Original Message -
From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]>
To: <[E
SELECT DATE_FORMAT(date column,'%W %M %Y') as date FROM table;
Mike
- Original Message -
From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]>
To: "Mike" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, April 11, 2002 7:53 AM
Su
Sorry, Do you mean to use the date in a WHERE clause? I've use php's date
function to supply a date for a WHERE clause in a sql statement.
Mike
- Original Message -
From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]>
To: "Mike" <[EMAIL PROTECTE
Those are nice guidelines and will do my best to keep in them But, no joke,
I got an E-mail from [EMAIL PROTECTED]
that the subject start's out massey,darling! Now I know I'm cute but:)
Cheers
M;)
-Original Message-
From: Robert Alexander [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 1
use ORDER BY ASC or DESC
$Query = "SELECT * from $TableName ORDER BY DESC";
Mike
- Original Message -
From: "Jule Slootbeek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 6:38 PM
Subject: pri
Sorry, I forget the column name for the ORDER BY
> $Query = "SELECT * from $TableName ORDER BY column_name DESC";
Mike
- Original Message -
From: "Mike" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Jule Slootbeek" <[EMAIL PROTECTED]>
FROM table1 LEFT JOIN table2 ON table1.id=table2.id
-> LEFT JOIN table3 ON table2.id=table3.id;
mysql> SELECT * FROM table1 USE INDEX (key1,key2)
-> WHERE key1=1 AND key2=2 AND key3=3;
mysql> SELECT * FROM table1 IGNORE INDEX (key3)
-> WHERE key1=1 AND key2=2 AND key3=
Should be able to find the right rpm's from your Linux distribution's
website. Just a guess here but www.redhat.com.
Mike
sqp,mysql
Balteo wrote:
> Hello,
>
> I am trying to install mysql from RPMs. My installation guide requires:
>
> -Mysql server
> -
J. Flechnter,
Here are some paths from an rpm install that I did with RedHat.
/usr/share/mysql/
/etc/my.cnf
/var/lib/mysql/
Mike
J. Flechtner wrote:
> Greetings,
>
>I am new to mysql. I have performed a fresh Red Hat install (7.2)
> with all packages available. In an attem
Dra. Silvia Andreasi,
SELECT * FROM table WHERE begin_date_column <=2000-01-25 and
2001-01-30<= end_date_column;
begin_date_column and end_date_column have to be date type columns.
Mike
sql,mysql
Dra. Silvia Andreasi wrote:
> Hi,
>
> How can I get the columns betwe
Questions:
- Do I use root account to install the software?
Yes to compile the source or do an RPM as seen below.
See http://www.mysql.com/doc/L/i/Linux-RPM.html
- What account do I use to create Innodb?
Same - I am guessing here but I do all installs as root then give the needed
permissions to
Please start here http://www.mysql.com/doc/index.html This is your new best
friend.
//Please don't kill me. I want to learn about databases. I hear MySQL is a
//good start. I have RedHat Linux and I've download and (I believe)
installed
//mysql.
Please read http://www.mysql.com/doc/I/n/Inst
For the code you posted
> mysql_connect("localhost", "kryste", "***");
> $result = mysql(mydatabase, "select * from Bidder");
> $num = mysql_numrows($result);
> $i = 0;
Try $num = my
fairly certain that the above returns nothing because of the multiple
pic.pic_id's in the query. But I don't know what to do get it
working(Redesign? or Is there something I could change in the query?)
Thanks in advance for any help,
Mike
sql,mysql
---
Outgoing mail is certified Virus
Thanks for the help. Got that to work no problem.
Mike
- Original Message -
From: "Harrison C. Fisk" <[EMAIL PROTECTED]>
To: "Mike" <[EMAIL PROTECTED]>
Cc: "mysql list" <[EMAIL PROTECTED]>
Sent: Thursday, June 13, 2002 5:48 PM
Subject: Re
cause this? The records that it can't find are recently
added records. But I've added some since then using the same software
and there's no issues.
MySQL version 3.23.49-max-nt
Thanks in advance,
Mike Tiffee
---
Have you tried something like this,
SELECT iSession FROM O_Sessions GROUP BY iUser ORDER BY iSessions DESC;
Mike
- Original Message -
From: "Robo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 16, 2002 3:39 PM
Subject: ??? Simple sql-question
o_sessions GROUP BY iuser;
+--+--+
| iuser | isession | ssession
+--+--+
|41 |2 | wanted
|42 |4 | wanted
|43 |6 | wanted
+--+--+
Mike
mysql
- Original Message -
From: "Matthew Scarrow"
Do a locate mysql.sock it's there. Do a search on the newsgroup at
http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b
On mysql.sock
M;)
On Sat, 2002-08-24 at 21:34, Roger Young wrote:
>
>
> I'm trying to install the binary mysql-3.23.52 under Linux (Slackware
> 8.2 distribution, kernel 2.4.18).
>
Her you go, this one Reads the Database table, Change the DB parts to yours
and have fun.
Here is a good start as well
http://www.devshed.com/Server_Side/PHP/DB_Basics/
";
echo "UserSite
#1Site #2Site
#3";
// with a while loop
// this loop will iterate as many times as there are recor
My Logs get pretty hefty with my PHP MySQL site, is there a Max log size or
something that will start another log file by date or when a certain size is
reached it's cleared. Had to ask
Cheers
-Original Message-
From: Gerald Jensen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001
>>>
>>> To request this thread, e-mail <[EMAIL PROTECTED]>
>>> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
>>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>>-
>From PHP
PHP 4.0.6 [755Kb] - 23 June 2001
(CGI only, MySQL support built-in, packaged as Windows installer to install
and configure PHP, and automatically configure IIS, PWS and Xitami, with
manual configuration for other servers. N.B. no external extensions
included)
---
Take a look at http://www.devshed.com/Server_Side/PHP/PHP101_4/ there are
also some other good reference material there on this.
Cheers
-Original Message-
From: Rolf Hopkins [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 01, 2001 7:54 PM
To: help; [EMAIL PROTECTED]
Subject: Re: Mysql er
1 - 100 of 1448 matches
Mail list logo
