> Hello
> where is the FROM for f1 table?
> Martin--
Why would there be any "FROM" for the f1 table? It's not needed in the result.
Anyway, I've come up with a query that actually seems to do what I'm looking
for;
SELECT a1.username FROM accountuser AS a1
LEFT JOIN payments AS p1 ON (a1.userna
Well... It did document it In my wiki... which is gone...
Nils
-Oprindelig meddelelse-
Fra: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sendt: fr 05-05-2006 21:57
Til: Nils Lastein
Cc: mysql@lists.mysql.com
Emne: Re: Determine version of *.frm, *.MYD and *.MYI
No backups?
And you com
I know it a 4.1... But as I compiled it my self it is not so easy to figure it
out And it might take a while to trial-n-error all 4.1.x
Nils
-Oprindelig meddelelse-
Fra: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sendt: fr 05-05-2006 20:28
Til: Nils Lastein
Cc: mysql@lists.mysql.com
E
that would make both
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
go to "No"
i only want to stop the Slave_SQL_Running and keep the Slave_IO running
so my show slave status would report the following:
Slave_IO_Running: Yes
Slave_SQL_Running: No
it happens if the mysql recives an update
Alan Williamson wrote:
>>I have made a user with the following command:
>>GRANT ALL ON *.* TO 'test'@123.123.123.123' IDENTIFIED BY 'h4x0r'
>
> Silly question Morten, and I am sure you have probably done it, but
> you are definitely running:
>
> % mysql> FLUSH PRIVILEGES;
You only need to FLUSH PR
gt;
> - Alkuperäinen viesti -
> Lähettäjä: "Mauricio Pellegrini" <[EMAIL PROTECTED]>
> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
> Kopio: "MySql List" <[EMAIL PROTECTED]>
> Lähetetty: Thursday, September 16, 2004 7:25 PM
www.innodb.com/order.php
>
> Order MySQL technical support from https://order.mysql.com/
>
>
>
> - Original Message -
> From: "Mauricio Pellegrini" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.myodbc
> Sent: Wednesday, September 15, 2004 3:46
t;
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Kopio: "MySql List" <[EMAIL PROTECTED]>
Lähetetty: Thursday, September 16, 2004 7:25 PM
Aihe: Re: SV: Mysql goes down when executing query
> Heikki,
>
> I've tried a different query this time but always
from https://order.mysql.com/
- Original Message -
From: "Mauricio Pellegrini" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, September 15, 2004 3:46 PM
Subject: Re: SV: Mysql goes down when executing query
> Thanks, but already have innodb_bu
Thanks, but already have innodb_buffer_pool_size=160M
and I've raised innodb_additional_mem_pool_size from 2M to 10M
And the problem remains the same.
Any sugestions?
Thanks
Mauricio
On Tue, 2004-09-14 at 18:05, Nickolai Nielsen wrote:
> Hi
>
> Try setting these variables in you conf:
> s
Hi
Try setting these variables in you conf:
set-variable = innodb_buffer_pool_size=128M
set-variable = innodb_additional_mem_pool_size=10M
you have to experiment with the size as it depends on how much ram you
hardware has.
Nickolai Nielsen
-Oprindelig meddelelse-
Fra: [EMAIL PROTECTED]
Hi
Try doing a "response.write conn" after you have made a connection with the
DSN
that should print out the connection string the DSN is using
i hope this help debug the problem
Nickolai
Paul Stearns wrote:
> Actually I can connect from the web server to the DB server using DSN (the
odbc tool
.
Nickolai
-Oprindelig meddelelse-
Fra: Nickolai Nielsen [mailto:[EMAIL PROTECTED]
Sendt: 10. juli 2004 16:28
Til: [EMAIL PROTECTED]
Emne: SV: MySQL/InnoDB crashes system
Hi
I still got this freeze problem, i have found out that this bug is related
to InnoDB, i converted the table that
Hi
I still got this freeze problem, i have found out that this bug is related
to InnoDB, i converted the table that gives problems back to MyISAM, and the
dump operation runs fine just as it did before, but as soon as i convert it
to InnoDB and dump this table my system freezes but not the first t
I have been using dbdesigner from fabforce. An excellent tool for visual
design. It also has a reverse engineer feature.
http://www.fabforce.net/dbdesigner4/
regards
/Jonas
Hi,
i created a database with around 20 tables. However i
created the tables by script writting all create table
statement
No I did not. Thank you very much!
Regards
Daniel
-Ursprungligt meddelande-
Från: Jeff Mathis [mailto:[EMAIL PROTECTED]
Skickat: den 5 mars 2004 00:48
Till: Daniel Ek
Kopia: [EMAIL PROTECTED]
Ämne: Re: Querying serveral databases (Views?)
in case someone hasn't answered you yet..
do
It works fine (with a little tweak).
SELECT DISTINCT CASE WHEN c1.winner_1 = c1.winner_2 THEN c1.winner_1 ELSE c1.winner_2
END AS winner FROM champions c1,champions c2 ORDER BY winner ASC
is what I wanted. Thank you very much! Btw, I can't help my webhotel is rotten and
only uses old versions.
Now UNION is implemented in MySQL 4.0.0. and as I stated earlier I run 3.23.58.
-Ursprungligt meddelande-
Från: Rodolphe Toots [mailto:[EMAIL PROTECTED]
Skickat: den 17 februari 2004 16:19
Till: Jonas Lindén; Carl Schéle; [EMAIL PROTECTED]
Ämne: SV: SQL-HELP
yeah
but that wont really do
yeah
but that wont really do it since the names are in two columns
so, there must also be a UNION included
do a union and then select distinct on the result from the union
that should do it (eller hur?)
-Ursprungligt meddelande-
Från: Jonas Lindén [mailto:[EMAIL PROTECTED]
Skickat: den 17
> >I get access denied (from mysql.exe and myodbc) when
> specifying no host
> >or % as host in the grant statement.
> >
> >
> >
> >>-Ursprungligt meddelande-
> >>Från: gerald_clark [mailto:[EMAIL PROTECTED]
> >>Skickat: den 2
as host in the grant statement.
-Ursprungligt meddelande-
Från: gerald_clark [mailto:[EMAIL PROTECTED]
Skickat: den 24 oktober 2003 15:11
Till: Datatal AB - Gauffin, Jonas
Kopia: [EMAIL PROTECTED]
Ämne: Re: SV: GRANT problem
What do you mean by ' doesn't work ' ?
Have you t
EMAIL PROTECTED]
> Ämne: Re: SV: GRANT problem
>
>
> What do you mean by ' doesn't work ' ?
> Have you tried connecting from another machine?
>
> Datatal AB - Gauffin, Jonas wrote:
>
> >>GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO @'%
What do you mean by ' doesn't work ' ?
Have you tried connecting from another machine?
Datatal AB - Gauffin, Jonas wrote:
GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO @'%'
IDENTIFIED BY ''; FLUSH PRIVILEGES;
yes. no diffrence. Specifying '%' or no host doesn't work for me.
--
MySQL
>
> GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO @'%'
> IDENTIFIED BY ''; FLUSH PRIVILEGES;
>
yes. no diffrence. Specifying '%' or no host doesn't work for me.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTEC
ry I can't be of more help
>
> Rory McKinley
> Nebula Solutions
> +27 82 857 2391
> [EMAIL PROTECTED]
> "There are 10 kinds of people in this world,
> those who understand binary and those who don't" (Unknown)
> - Original Message -
> From: &
yes, its gone in 4.0.16
> -Ursprungligt meddelande-
> Från: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
> Skickat: den 23 oktober 2003 21:12
> Till: [EMAIL PROTECTED]
> Ämne: Re: Tablecrash
>
>
> "Datatal AB - Gauffin, Jonas" <[EMAIL PROTECTED]> wrote:
> >
> > I got a table that cra
Jonas" <[EMAIL PROTECTED]>
> To: "Rory McKinley" <[EMAIL PROTECTED]>
> Sent: Thursday, October 23, 2003 11:45 AM
> Subject: SV: GRANT problem
>
>
> > Not sure if this will help - in your GRANT statement do you
> > not need to specify a h
> Not sure if this will help - in your GRANT statement do you
> not need to specify a host for the user e.g. GRANT.. to
> datatal @ your_host_name.?.
>
>
GRANT uses % as host if none is specified.
% = all hosts.
any other ideas?
--
MySQL General Mailing List
For list archives: http://
a 'FLUSH PRIVILEGES' after the GRANT-Statement ?
> If not, MySQL-Srver doesn't read the privileges-Table again.
>
> mfg
> Klaus
>
> -Ursprungligt meddelande-
> Från: Datatal AB - Gauffin, Jonas [mailto:[EMAIL PROTECTED]
> Skickat: den 23
Additional info:
the user is added to mysql.user with no privileges.
the user is added to mysql.db with insert,update,delete,select privileges on
phonewatch db.
When I try to connect to the db, "C:\mysql\bin\mysql phonewatch -h ts2test -u datatal
-pMYPASSWORD", I get "ERROR 1045: Access denied
"describe tablename"
return columns:
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
> -Ursprungligt meddelande-
Hello
> crashes occurs for some reasons like :
> - unclean tables ( tables are closed improprely),
> - hardware problems
> - something goes wrong in the system
> - know bugs
> Check that your tables are clean, before start using them.
MyODBC 3.51 is the only way that I access the database. (MyODB
hi!
maybe i can help here
this is how to do it:
open up 2 connection windows with your source and destination databases
then click on im/export in the menu
select "export tables"
select which database and check the table/tables you want to export
in the output section on the same dialog select whe
> > No, the last inserted id is just 1051 or something like that.
> > Must be something else.
> > Dunno where '2147483647' comes from.
> >
> > Is there a way to reset the auto_increment value or something?
> >
> First, check out with myisamchk if the table isn't crashed.
> Then you can use SET INS
Jacob,
Monday, November 25, 2002, 12:03:14 PM, you wrote:
> If I use UPDATE LOW_PRIORITY, will the client then have to
> wait for the
> update to finish or not?
Yes, it will wait.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.n
Venlig hilsen
Jacob Friis Larsen
[ JFL WebCom | www.webcom.dk | +45 7027 0767 ]
> -Oprindelig meddelelse-
> Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sendt: 25. november 2002 11:02
> Til: Jacob Friis Larsen
> Emne: Re: UPDATE LOW_PRIORITY database
>
>
> Your message can
> >Release: mysql-3.23.52 (Source distribution)
Update to 3.23.53a! That solved my problems.
/Nicklas
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
> I'm running mysql-3.23.49 on a redhat machine, mysql has stopped responding
> to remote connections ever since i rebooted it today.
> /var/log/mysqld.log says
>
> Number of processes running now: 1
> mysqld process hanging, pid 3062 - killed
> 021015 20:37:05 mysqld restarted
> /usr/libexec/my
Thanks to Dan Nelson and Mike Hillyer,
Indexing brought the search downto 2.03 sec compared to 3 min and 16 sec !
Thanks again.
Rgs
Steinar Kolnes
-Opprinnelig melding-
Fra: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sendt: August 14, 2002 1:14 AM
Til: Steinar Kolnes
Kopi: Mysql List
Emne:
ount++;
> > }
> > }
> > }
> > ==
> >
> > Please note that cat_list is given as a by-reference parameter.
>Otherwise
> > you'd be copying the whole array for each recursive function c
atabase at once (instead of calling a mysql SELECT statement for each
> branch of the tree).
>
> - Carsten
>
> > -Oprindelig meddelelse-
> > Fra: Carsten Gehling [mailto:[EMAIL PROTECTED]]
> > Sendt: 27. maj 2002 20:33
> > Til: [EMAIL PROTECTED]
> > E
database at once (instead of calling a mysql SELECT statement for each
> branch of the tree).
>
> - Carsten
>
> > -Oprindelig meddelelse-
> > Fra: Carsten Gehling [mailto:[EMAIL PROTECTED]]
> > Sendt: 27. maj 2002 20:33
> > Til: [EMAIL PROTECTED]
> > E
Have you tried to run the query in MySQL's console?
- Carsten
> -Oprindelig meddelelse-
> Fra: Rob Galvin [mailto:[EMAIL PROTECTED]]
> Sendt: 30. maj 2002 20:29
> Til: [EMAIL PROTECTED]
> Emne: ADO recordset is not returning rows in ASP page
>
>
> I have an active server page using an
branch of the tree).
- Carsten
> -Oprindelig meddelelse-
> Fra: Carsten Gehling [mailto:[EMAIL PROTECTED]]
> Sendt: 27. maj 2002 20:33
> Til: [EMAIL PROTECTED]
> Emne: SV: building tree view in mysql?
>
>
> Well you'll neew to do some coding in your application langua
Well you'll neew to do some coding in your application language. What are
you using to connect to MySQL? Perl? PHP? Java?
Tell me, and I'll give you an example where you only query the database once
(for optimum performance).
- Carsten
> -Oprindelig meddelelse-
> Fra: Sagi Bashari [mail
897
> 2 123
>
>
> I want to select in a query only these id that have nr=123 and nr=456.
> In the example its only id 1.
>
> regards Micha
>
> -Ursprüngliche Nachricht-
> Von: Jonny Stendahl [mailto:[EMAIL PROTECTED]]
> Gesendet: Mittwoch, 22. Mai
This is a simple SELECT statement:
SELECT id
FROM Table
WHERE nr=3D123
AND id = 3D456
this gives you probably one record, or you could use OR:
SELECT id
FROM Table
WHERE nr=3D123
OR id = 3D456
this gives you all records with nr 3D123 OR id 3D456
//
Jonny
> -Ursprunglig
Hi Rich,
Use the LIMIT 2 and sort the SELECT with ORDER BY family ID DESC
//
Jonny
> -Ursprungligt meddelande-
> Från: R.Dobson [SMTP:[EMAIL PROTECTED]]
> Skickat: den 21 maj 2002 14:57
> Till: [EMAIL PROTECTED]
> Ämne: returning top two values
>
> Hi,
> I have a table containi
> Fra: Richard Clarke [mailto:[EMAIL PROTECTED]]
> Sendt: 18. maj 2002 22:29
> Emne: 4.0.1 Bugs
>
>
> List,
> I wondered if any movement has been made to determine the cause of the
> following "bugs" that I have come across using Mysql 4.0.1.
>
> 1) selectunion causes a temporary table ful
You can download MySQL++ from www.mysql.com
- Carsten
> -Oprindelig meddelelse-
> Fra: Hisseine Dj. [mailto:[EMAIL PROTECTED]]
> Sendt: 6. maj 2002 17:24
> Til: [EMAIL PROTECTED]
> Emne: C++ API for Mysql
>
>
> Hello,
>
> Can someone tell me if there is an C++ API that works smooth with
You could use Kylix from Borland. It's a RAD tool - it's actually Delphi
ported to Linux.
- Carsten
> -Oprindelig meddelelse-
> Fra: Yvon Darang [mailto:[EMAIL PROTECTED]]
> Sendt: 6. maj 2002 15:31
> Til: [EMAIL PROTECTED]
> Emne: Newbie Question
>
>
> Hi everybody,
> Let's say I do not
> Fra: Nick Arnett [mailto:[EMAIL PROTECTED]]
> Sendt: 3. maj 2002 04:30
> Emne: Strategies for maintaining tables calculated from other tables?
>
>
> I'm finding that it's not quite as simple as I had imagined to maintain a
> table whose values are calculated by analyzing other tables. The sourc
> -Oprindelig meddelelse-
> Fra: Mike Hall [mailto:[EMAIL PROTECTED]]
> Sendt: 28. april 2002 12:28
> Til: [EMAIL PROTECTED]
> Emne: Fw: WHERE ignored
>
>
> Corrupt index, hmm? I'll check that in a moment - thanks.
After looking at your fault-free script, my best bet would also be a
corru
> -Oprindelig meddelelse-
> Fra: Mike Hall [mailto:[EMAIL PROTECTED]]
> Sendt: 27. april 2002 00:04
> No other scripts perform UPDATEs on that table, only INSERTs. But MySQL
> returned the correct data at 8:55 and again at 9:05. It was only
> when it ran
> at 9am that it appeared to ign
> Fra: Henning Olsen [mailto:[EMAIL PROTECTED]]
> Sendt: 19. april 2002 14:39
> Hey - can anyone help?
> I have a MySql-db in which I can only have 127 records.
> Using phpmyadmin to insert record number 128 (autoincrement) gets
> this message:
>
> INSERT INTO `kontakt` (`id`, `navn`, `adresse`,
> Fra: savaidis [mailto:[EMAIL PROTECTED]]
> Sendt: 17. april 2002 22:14
> Emne: a query from php doen't work
> I get a "Query failed" error on this:
> What could hapent?
Try to alter this line:
$result=mysql_query($buffer);
to look like this:
$result=mysql_query($buffer) or die($buffer."".my
select * from MEMBERS,FEE_PAYMENTS where FEE_PAYMENTS.price < '1'
and MEMBERS.memberID = FEE_PAYMENTS.memberID;
am I getting close? :o)
Mark
>The FEE_PAYMENTS table does not have one line corresponding to each line in the
>MEMBERS table.
>
>The members table can look like this:
>
>MEMBERS
>I
> Fra: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
> Sendt: 16. april 2002 09:52
> MySQL AB wants to satisfy as many users as possible. That means
> there may be
> more than one language available for writing stored procedures.
>
> For example, many mainstream databases currently support both Java an
> Fra: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
> Sendt: 16. april 2002 02:15
> I can disclose that there is actually some progress being made in stored
> procedures + triggers.
Ahh could you perhaps disclose a little more? :-) There's been a great
discussion on the choice of language, and I'm su
At 05:14 15/04/02 +0200, Carsten Gehling wrote:
>> Fra: Simon Byrnand [mailto:[EMAIL PROTECTED]]
>> Sendt: 15. april 2002 04:00
>
>> I'm currently running MySQL 3.23.40 on Redhat 6.2 and its working nicely.
>> It was installed from binary RPM's.
>>
>> I'm not trying to update to 3.23.49, but beca
> Fra: Simon Byrnand [mailto:[EMAIL PROTECTED]]
> Sendt: 15. april 2002 04:00
> I'm currently running MySQL 3.23.40 on Redhat 6.2 and its working nicely.
> It was installed from binary RPM's.
>
> I'm not trying to update to 3.23.49, but because the binary RPM's
> available
> require GLIBC 2.2 (Re
> Fra: Fournier Jocelyn [Presence-PC] [mailto:[EMAIL PROTECTED]]
> Sendt: 14. april 2002 19:22
> In fact what it's odd is when I use EXPLAIN, I don't see anywhere DISTINCT
> in the EXPLAIN result :
That's because the MySQL optimizer converts your distinct into a group by.
Read more here:
http:/
sql,query
I cant get the server to starts more than one thread. I have installed
the server from the port collections and im running freebsd 4.5 stable
Regards leo de geer
-
Before posting, please check:
http://www.m
TED]
> To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
> Subject: SV: MySQL on the Playstation2? (OT? You betcha)
>
> Hi,
>
> I'm in this list to get facts about MySql, not to spend time reading
> philosofical discussions. Please
>
> -Ursprungli
Hi,
I'm in this list to get facts about MySql, not to spend time reading
philosofical discussions. Please
-Ursprungligt meddelande-
Från: DL Neil [mailto:[EMAIL PROTECTED]]
Skickat: den 1 februari 2002 12:26
Till: Carsten Gehling; mySQL Mailing List
Ämne: Re: MySQL on the Playstation
Hi
The ">" that you see in the command prompt is only for decoration you can
easy change the look on you command prompt to show you something else. The
proper way to start your program is:
c:\mysql\bin\mysqld-max --standalone not the otherway.
Regards
Jonas Arvidsson
PS.
The look and apperance
Have you installed ncurses or termcap rpm's?
Jonas Arvidsson
-Ursprungligt meddelande-
Från: Steve Mansfield [mailto:[EMAIL PROTECTED]]
Skickat: den 9 januari 2002 13:48
Till: [EMAIL PROTECTED]
Ämne: More compile errors
Ok, I had a problem compiling Mysql 3.23.47 on RH 7.1. I kept gett
Thanks, but how secure is this. Is it possible for two computers to do
the "select" at the same time, i.e. get the new incremented value?
Computer one insert, computer two insert, computer one select, computer
two select?
If this is possible how can I solve this? To make the column that insert
th
I dont think you can do that, but if you create a table counter with one
number column and insert all the numbers from 1 to 10 or what number
would be appropriate, then you can left join your_table with counter on the
id = number column.
select * from counter left join your_table on counter.n
TEXT and BLOB types.
http://www.mysql.com/doc/B/L/BLOB.html
> -Ursprungligt meddelande-
> Fran: Hamzat kamal [mailto:[EMAIL PROTECTED]]
> Skickat: den 23 november 2001 09:56
> Till: [EMAIL PROTECTED]
> Amne: Is there any alternative to MEMO field in MYSQL database?
>
>
> Hi,
>
> I nee
You can join all three tables together
select d.members_id, m.name, old.name from data as d
left join members as m on m.members_id=d.members_id
left join oldmembers as old on old.members_id=d.members_id
If the members_id belongs to an old member, all fields from the member table
Can't you just make a check before you make a call to the DB?
if( member_id > 1000 )
// old member query here
else
// new member query here
-Ursprungligt meddelande-
Fran: Jerry [mailto:[EMAIL PROTECTED]]
Skickat: den 21 november 2001 21:24
Till: [EMAIL PROTECTED]
Amne:
No, that is not legal. From the manual:
"Default values must be constants. This means, for example, that you cannot
set the default for a date column to be the value of a function such as
NOW() or CURRENT_DATE."
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
-Ursprungligt meddelande-
F
Chapter 4 in the manual is a good place to start!
http://www.mysql.com/doc/M/y/MySQL_Database_Administration.html
-Ursprungligt meddelande-
Fran: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Skickat: den 21 november 2001 09:55
Till: [EMAIL PROTECTED]
Amne: Security of MySQL
Hello,
My
Hi Donna,
Try this. That was the way i've installed Mysql on my server.
rpm -ivh MySQL-3.23.44-1.i386.rpm
rpm -ivh MySQL-client-3.23.44-1.i386.rpm
Please notice, that you have to use the RPM command 2 times.
Regards
Frank
Denmark.
<--->
http://www.tuffy.dk
<--->
-Oprindelig meddelels
Hi,
I've had the same problem, and after i remembered i used a symbolic link to
solve this problem.
Try this
cd /tmp
ln -s /var/lib/mysql mysql.sock
Then try again to start Mysql.
Regards
Tuffy
<--->
http://www.tuffy.dk
<--->
-Oprindelig meddelelse-
Fra: mweb [mailto:[EMAIL P
ehh .. forgot a ")" on my sql.
the right one is below
SELECT whois_domain.domain
FROM whois_domain, filter
WHERE (whois_domain.record LIKE concat('%',filter.filter,'%'))
TK
> -Opprinnelig melding-
> Fra: abercrombie fitch [mailto:[EMAIL PROTECTED]]
> Sendt: 30. oktober 2001 13:35
> T
use :
SELECT whois_domain.domain
FROM whois_domain, filter
WHERE (whois_domain.record LIKE concat('%',filter.filter,'%')
TK
> -Opprinnelig melding-
> Fra: abercrombie fitch [mailto:[EMAIL PROTECTED]]
> Sendt: 30. oktober 2001 13:35
> Til: [EMAIL PROTECTED]
> Emne: LIKE '%%' with fields.
select floor('5') <= floor('6');
TK
> -Opprinnelig melding-
> Fra: Daniel James [mailto:[EMAIL PROTECTED]]
> Sendt: 30. oktober 2001 04:32
> Til: [EMAIL PROTECTED]
> Emne: Comparing strings as ints
>
>
> Hi Everyone,
>
> After staring blankly at the mysql manual for a long time, I
>
How about select max(floor(field)) from table ?
TK
> -Opprinnelig melding-
> Fra: Kraa de Simon [mailto:[EMAIL PROTECTED]]
> Sendt: 22. oktober 2001 08:44
> Til: Php-General (E-mail); MySQL (E-mail)
> Emne: Max int value of char field? How to find...
>
>
> Hello all,
>
> How can I find t
You can use NOW() to get the current timestamp:
mysql> select NOW();
+-+
| NOW() |
+-+
| 2001-10-18 12:49:29 |
+-+
But it would be easier to let MySQL calculate the elapsed time:
select
IF(TIME_TO_SEC(NOW()) - TIME_TO_SE
>> What privileges should I give my user so that I can do the
>> SHOW PROCESSLIST on all databases ?
> Process_priv
Should I then do :
GRANT PROCESS ON mysql.* to shark@'123.123.123.123' identified by
'sharkpassword';
-
Befor
I am not sure, but it seems like the newsgroup mailing.database.myodbc is the same as
this mailinglist? (Sorry if I create confusion, I am not quite sure I understand what
you ask for.)
Ann
- Original Message -
From: Jeremy Zawodny <[EMAIL PROTECTED]>
To: Christopher Raymond <[EMAIL
If you change you order by to
order by username, wucount desc, rank desc
Won't this group it the way you want it ??
Terje K
> -Opprinnelig melding-
> Fra: Solsberry, Glendon [mailto:[EMAIL PROTECTED]]
> Sendt: 19. september 2001 15:29
> Til: '[EMAIL PROTECTED]'
> Emne: Simple SELECT qu
Hi Leandro
This is a HPUX problem. This errormessage gives you the real problem :
: setrlimit couldn't increase number of open files to more than 60
you have to change the kernel settings to allow the OS to use more than 60
simultaneous open files.
if you use the "sam" program and choose "sam ker
Rename is for Tables (I think ...I am fresh, too. So fresh that I send it to you
privatly. Sorry about that!)
ALTER TABLE table1
CHANGE column1 coloum2 varchar(20) not null [or what ever datatype];
gives you what you want.
Ann
- Original Message -
From: Deryck Henson <[EMAI
On 22-Aug-2001 Johan Nilsson wrote:
>>> Is it possible for me to do a SELECT COUNT(*) and GROUP BY the
>>answers based
>>> on a INTERVAL e.g. HOUR?
>>>
>>
>>SELECT HOUR(time) as hour,count(*) as cnt FROM foo GROUP BY hour;
>>
>
> Thanks, but I wrote a bad test data =(
>
> +
>> Is it possible for me to do a SELECT COUNT(*) and GROUP BY the
>answers based
>> on a INTERVAL e.g. HOUR?
>>
>> the e.g. table data:
>> ++
>>| id | time |
>> ++
>>| 1 | 08:30 |
>>| 2 | 09:30 |
>>| 3 | 09:31 |
>>| 4 | 09:32 |
>> ++
>>
>> The answer I w
PhpMyAdmin writes : 3.23.40-log
Why -log, don't know ?...
Le jeu, 09 aoû 2001, vous avez écrit :
> What version of Mysql is it?
>
> > -Opprinnelig melding-
> > Fra: Patrice Garbe [mailto:[EMAIL PROTECTED]]
> > Sendt: 9. august 2001 19:45
> > Til: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > E
> -Ursprungligt meddelande-
> Fran: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
> Skickat: den 19 juli 2001 15:36
> Till: [EMAIL PROTECTED]
> Kopia: [EMAIL PROTECTED]
> Amne: Re: inheritance of privileges?
>
>
> Johan Nilsson writes:
> > Privileges question:
> >
> > I have a user in mysq
Hi
> Warning: Wrong parameter count for mysql_fetch_row() in
> /web/sites/94/ichmussweg/www.ichmussweg.f2s.com/gastebuch.php on line 54
>
> line 54 is the last one of the code extract starting with "while($row":
> $res=mysql_query("SELECT id as id, msg as msg,
> date_format(datum,'$datumsForma
INSERT INTO table1 (email)
SELECT email FROM table1, table2 WHERE table1.email <> table2.email;
the select is a "new" query, you have to join table1 and table2...
Regards,
Johan Nilsson
Software Developer
BeCon Mobile Internet AB, Sweden
Web: http://www.beconmobile.com
E-Mail: [EMAIL PROTECTED]
See section: "7.21.1 INSERT ... SELECT Syntax"
Regards,
Johan Nilsson
Software Developer
BeCon Mobile Internet AB, Sweden
Web: http://www.beconmobile.com
E-Mail: [EMAIL PROTECTED]
Office: +46 457 44184
Cellular: +46 709 798897
> -Ursprungligt meddelande-
> Fran: Martin Cabrera Diaubalick
Hi!
>> On Jul 19, Carsten Gehling wrote:
> > Finally I was able to produce a complete step-by-step to
> corrupt the index
> > ;-)
> >
> > mysql> insert into visitkort (kategori_id) values (108);
> > mysql> select last_insert_id();
> > mysql> update visitkort set navn = 'test5' where id = 1;
> > m
Johan Nilsson writes:
>
> sub queries are not yet implemented in MySql, but will be in 4.0...
>
>
> Regards,
> Johan Nilsson
>
Nope. In 4.1 ...
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ M
> -Ursprungligt meddelande-
> Från: rob anderson [mailto:[EMAIL PROTECTED]]
> Skickat: den 16 juli 2001 14:14
> Till: [EMAIL PROTECTED]
> Ämne: DELETING items
>
>
> I am trying to delete records from a table, where the 'id' to be
> deleted should only happen if a certain flag (status) exis
Sorry, never heard of it. I thouth OpenBSD was just one of those web
development packages that they throw MySQL into. Some of what I said still
applies, except I don't know whether or not you can use RPMs.
--On Saturday, June 23, 2001 21:06 +0100 Tomas Norre <[EMAIL PROTECTED]>
wrote:
>> W
On Mon, 30 Apr 2001, Wix,Christian XCW wrote:
> But why doesn't this work then:
> select name, tottid, distance, min(mintid) from loeb group by distance;
> (tottid seems to be random)
>
> mysql> explain select name, tottid, distance, min(mintid) from loeb group by
> distance;
> +---+--+-
But why doesn't this work then:
select name, tottid, distance, min(mintid) from loeb group by distance;
(tottid seems to be random)
mysql> explain select name, tottid, distance, min(mintid) from loeb group by
distance;
+---+--+---+--+-+--+--+---+
| tabl
Hiya Tyler
As everyone else has suggested, I do too. Read the MySQL-manual. Not from
the start to the end, but the parts that you need. I'd look up the syntax
for SELECT and then find out what is possible to do with it.
I'll also recommend you an article about MySQL/PHP which was the one getting
1 - 100 of 123 matches
Mail list logo