save the
file to disk - both appear to be required to open the RPM.
Right-click should give you a list of options.
Also shift-click should *force* the save operation.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676
If you are using MyODBC, then the suggestions regarding a 'client prior
to 4.1' *DO* apply to you. MyODBC is built against 4.0.x, so you must
follow the instructions for connecting with a pre-4.1 client. Either
that or downgrade the server to 4.0.x.
--
Daniel Kasak
IT Developer
NUS
parent_id is null
then 0
else
if parent.grandparent_id='Fred'
then 1
else 0
end
end
) as CountChildren
which should also work ( untested but looks right ). I use this when I
get a couple of layers of if() statements - it's a lot easier to unders
#x27; statement,
and change 'none' to a numeric zero ( 0 ).
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
nt.id=child.parent_id
group by parent.id;
The 'left join' is important if you want to return a count even if there
are no children.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 798
you figure
out what's up with your prepared statements ).
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
w-queries.log. That would be a good one to look at too.
Dan
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General
wn a lot.
Without seeing any of your config files or queries, there's not much
more to be said.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: h
7; '--prefix=/'
'--with-extra-charsets=complex' '--exec-prefix=/usr'
'--libexecdir=/usr/sbin' '--libdir=/usr/lib' '--sysconfdir=/etc'
'--datadir=/usr/share' '--localstatedir=/var/lib/mysql'
'--infodir=/usr/share/
fix that problem. Now I have the only purpose to time the write
processes per cronjob :-(
P.S: The reading at same time is no problem while writing is on, If I read
from web-interface in the tables.
Thanxx for help
mit freundlichem Gruß / kind regards
Daniel Beuter
SIEMENS
I&S IT PS 221
art should let me kill all these processes.
(but not always)
-Ursprüngliche Nachricht-
Von: KSTrainee [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 16. August 2004 14:56
An: Beuter Daniel
Betreff: AW: Mysql-Prozesse lassen sich nicht mehr killen :-(
Hallo,
ein Hinweis vorweg: Bitte nur
möglich den mysqld neu zu
starten
Was kann ich tun um die Zombies ohne reboot zu beenden.
Benutze fedora core1 und
mysql Ver 12.22 Distrib 4.0.20, for pc-linux (i686)
mit freundlichem Gruß / kind regards
Daniel Beuter
SIEMENS
I&S IT PS 221 OP4
Network Solutions
Werner von Siemens Str. 60
91
I am by no means a phpMyAdmin guru, but the version I have (2.5.7) has
an option for it, accessible by clicking on the "Databases" link from
the main page. I suspect, however, that they will give you a single
database that you will not have the DROP DATABASE privilege for and
that you will
I've just made it through the MySQL Certification Study Guide and have
found it to have pretty good coverage of tuning as well as other
subjects. There are probably more in-depth sources available, but it
might be a good place to start.
- Dan-o
On Aug 9, 2004, at 12:42 AM, Eko Budiharto wrote:
Another use for binary columns is for case-sensitive text such as
passwords. If you store text in a CHAR, VARCHAR, or TEXT column,
comparisons will not be case-sensitive unless you use the BINARY
keyword. An example (from section 6.3.22 of the Language Reference:
mysql> SELECT "a" = "A";
I'm unable to get the 4.1.3 server to start automatically at startup or
even manually unless I'm logged in as root. I'm on an iBook G4. I
downloaded and installed the
mysql-standard-4.1.3-beta-apple-darwin7.4.0-powerpc binary and the
associated startup item. I've done this successfully with
/ xterm back. If you don't use the "&" at the end, the
mysqld_safe process will run in the foreground and will remain 'tied' to
the console you started it from ... so if you close the console / xterm
you may kill the mysqld_safe process.
--
Daniel Kasak
IT Developer
You need to use the 'GROUP BY' clause:
SELECT offerid, resellerid, MIN(price) FROM A GROUP BY resellerid;
Cheers,
Dan
On Jul 30, 2004, at 2:37 PM, Haitao Jiang wrote:
Hi, there
Maybe this question is not MySQL specific, but I just wondering if
MySQL has any way to doing this:
I have a table A like
ave
*incredibly* painless updates to ALL parts of your system. If you run
anything else and you try to upgrade glibc, for example, you are a
damned fool! So basically you can install Gentoo on your system and
keep it current without re-installing everything.
--
sig
Daniel Kasak
IT Developer
NUS
Is there a way of getting the number of updated rows without using the API
calls?
TIA
Dan
ECTED]
Sent: Friday, July 16, 2004 11:35 AM
To: 'Daniel Cummings '; '[EMAIL PROTECTED] '
Subject: RE: Show Index Into Cursor?
You will have to put the value in a resultset and scroll through the
resultset. Natively you can do this with MySQL 4.0.x but you could use a
programming
Is there a way to force the results of
"Show Index From "
Into a table?
TIA
Dan
UserId From Roles
This was just to determine how MySql was translating the parameter. It
turned out to be a double in this new table.
Dan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 15, 2004 7:00 AM
To: Daniel Cummings
Cc: [EMAIL PROTECTED]
S
I'm using SqlPassthrough In VFP 8.0
I"ve got a Sql statement that looks like this.
This following fails:
Update User
Set Active = True
Where UserId = ?pnUserId
pnUserId is 222 in this instance.
The following works fine:
Update User
Set Active =
y
available in client libraries that are compiled against MySQL-4.1 or
newer, and MyODBC-3.51.x is not.
According to the comments at the bottom of my bug:
MyODBC 3.53 is near completion but no date has been set yet.
ie you will be waiting for quite some time.
--
sig
Daniel Kasak
IT Developer
noDB: log sequence number 0 1299172664
InnoDB: Doing recovery: scanned up to log sequence number 0 1299172664
InnoDB: Last MySQL binlog file position 0 1398, file name ./screamer-bin.265
040709 14:05:45 InnoDB: Flushing modified pages from the buffer pool...
040709 14:05:45 InnoDB: Started
/usr/sbin/m
:
- MySQL server 3.23.55
- Linux version 2.4.22
- Red Hat Linux 7.3 2.96-110 #3 SMP
- 4GB RAM
- 4 Xeon processors
Thanks in advance
Daniel Eliav Sharvit
_
Help STOP SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?
eld
properties'. In it, there should be a check box called 'Auto Increment'.
Select the field you want, and click the check box.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 992
haven't used it for quite some time...
It's not free. I don't know of any free ER tools. Or at least none I've
found and investigated were good enough to remember.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
:
date('m/d/Y', $row10['modified']);
$row10['modified'] is the timestamp from the mySQL database I want to convert from. Thanks in advance.
You want to use MySQL's date_format, eg:
date_format(modified, '%m/%d/%Y')
From memory anyway. Check the do
Hi all.
I'm pleased to announce the first public release of my first open-source
project: a Perl class to automate the synchronization of data from a
database server ( via DBI ) with fields on a Glade-generated form ( for
a Perl / Gtk2 app ). MS Access users take note: an alternative is on the
tegrity"
but I still dont know how to do it after reading the documentation for some times
So anyone ever face such issue??
Thanx
Flame
Don't like InnoDB?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 99
you can get that on the mysql-client package
On Wed, 30 Jun 2004 00:35:13 -0500, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I'm installing the php-mysql-4.3.6-1.3.i386.rpm and it's complaining about a
> dependency libmysqlclient.so.10. My mysql server version is 4.0.20.
>
> Can an
owed all the documented steps but the lack of
diagnostics makes this very difficult.
Thanks in advance,
Daniel Eliav Sharvit
_
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/jun
Hi Everyone,
I used MySQL 4.1.0 and I've just upgraded to 4.1.2.
I have noticed that several character sets and collations are just disappeared somehow
from the new version. I have checked it with the 'show collation' and 'show character
set' command.
Is there any switch or configuring option t
f Family Practice
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.704 / Virus Database: 460 - Release Date: 6/12/2004
Daniel Godefroy
3445 Ridgewood, 109 73, Rue Lambert
Montreal
With a join and group by I think you have HAVING.
>>Hi all
>>
>>how to do this in MySQL? Returning only records with COUNT > 5?
>>
>>SELECT
>> `groups`.`groupsDescr`,
>> `roles`.`roles_Agroup`,
>> `roles`.`rolesDescr`,
>> COUNT(`roles`.`rolesDescr`) AS TOTAL
>>FROM
>> `roles`
>> INNER JOIN
Try back ticks around it. `DESC'
> Dear Friends.
>
> when Creating the follow table
>
> CREATE TABLE CONHEC_DBF (CON CHAR (7) ,
>SER CHAR (2) ,
>NUMNF CHAR (8) ,
>SERNF CHAR (2) ,
>LOJA CHAR (2) ,
>PAIDF CHAR (12) ,
>QUANT REAL (6,0) ,
>NOP CHAR (10) ,
>TRAN CH
echo $updatequery to screen and see what the sql looks like.
> I am trying to update a table from results generated from a select query,
> but can't seem to get the queries running right. The select query works
> fine, but when I try to use the results for an update it error out. Here
> is
> my
After the phpmyadmin login I got the same error.
In the phpmyadmin config files I had to set the local IP address that
phpmyadmin was on.
> Dear Michael,
>
> I want to use PHP, Apache, mySQL and phpMyAdmin for evaluation but I m not
> able to get this rite.
>
>
> I am trying to instal MySQL with
I like the web site www.phpbuilder.com ... lots of great articles.
> Hi All,
>
> Can someone recommend a good book for learning PHP/MySQL?
>
> TIA,
> Kay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
10 seconds !?Unless that query is huge and without indexes, it should
run MUCH quicker.
> I'm using Oracle 8.0.5 and MySQL 4.1.1a
>
> I'm not optimizing Oracle nor MySQL, because I don't want future users
> messing with optimizations.
> I access through JDBC drivers. Oracle usually needs 10 se
etty simple script ) the more I think there's something up with DBI.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
How about an HTML meta tag refresh set at 20 minutes.
>>This may be slightly off-topic, apologies if so but I was wondering if
>>anyone could point me in the right direction.
>>
>>I'm currently storing applications from a web site into our mysql DB, our
>>client has a web-based backoffice. He has
0;
}
$pk = $dbh->last_insert_id();
The statement executes successfully, and the data is inserted. However
the above line that fetches the last_insert_id value from MySQL always
returns undef. The table has an auto_increment column. What's going on?
Dan
Nitin wrote:
Hi all,
What will be the best way to implement auto increment field. I dont want to use auto
increment feature, as it only appends the numbers but doesn't check for the values
deleted. Suppose, following are the values in table
1abc
2bcd
3cde
..
..
..
9xyz
,
doesn't make any sense.
Any thoughts much appreciated.
You're not viewing the data in MySQLCC are you?
It only shows the first 1000 records.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2
your help,
I've been looking online as well but thought this may be quicker. Take care.
Thanks again.
Daniel
Emmanuel van der Meulen wrote:
Hello all,
Does anyone have an estimate of when MySql 4.1 will be released for
production.
MySql.cm says soon.
Please advise, would that likely be weeks/months?
Kind regards
Emmanuel
Months. I'd say at least 6 months.
--
Daniel Kasak
IT Developer
NUS Consu
queries on the same connection. Anybody writing server-side applications
using the C api, please beware of this issue. I can suggest a few
workarounds if anybody else out there is having the same problem with their
C program.
Daniel
Daniel Whitener wrote:
Hello all,
I'm getting the erro
e stuff
if you ask me. Anyway you can safely ignore it if you're not importing
data from a fixed-width file. For more info see 'load data infile'.
The backticks are there to aid MySQL in parsing the string later in case
you have used reserved words or strange characters.
--
One simple option would be to add a footnote column. And add in your code, if
footnote column is NOT NULL then add a * on to population and
show footnote at the bottom.
population footnote
100 null
200*yada yada
>>Suppose I have several columns of numberals - are
cl.id = w.client_id
> WHERE cl.name = 'Some Company';
>
> Just in case you are using mysql 4.0 or earlier...
Thanks very much! This is what I need :)
Also, while I'm at it, any book recommendations for getting to know MySQL
better?
Thanks again :-)
-Daniel
--
MySQL
ome Company")' ORDER BY id DESC;
Thanks for any help :)
-Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
affic to the MySQL database. The source is
available if anybody thinks my poor coding is the problem.
Any help or ideas will be greatly appreciated.
Thanks in advance!
Daniel Whitener
basic config info is below. I can provide more details if needed...
I'm using suse 9.1
uranus:~ # uname -a
Using phpmyadmin, when I select Export, and click the checkbox "Save as File", it
prompts where for where and what file name.
>>I'm trying to figure out how to get my MySQL databases
>>online. Someone told me to EXPORT my databases as SQL
>>files, then go into my online websites's phpMyAdmin
>>p
Yes Local.
SELECT databasename.tablename.columnname
> Hi, two questions:
> Is it possible to select data from different Databases on the same
> server?
> Is it possible to select data from different Databases on Different
> servers across the network?
>
> I searched for information on how to do
I remember something setting mine up. The phpMyAdmin.ini (I think) had to
have the correct IP address of the machine/database it was running on.
My machines internal address was 192.168.2.100, but the INI setting had to
be the outside resolved IP 24.16.xx.xx if running it from outside.
> Hello:
his matter, and also a
detailed explanation on which is to prefer and why.
Cheers
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
$sql_2 )");
$sth->execute($sql_3);
CAUTIONARY NOTE!!
I'm just learning Perl myself. The above code is NOT tested.
But you should be able to get the idea anyway :)
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9
#x27;t ideal if you have foreign keys set up.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
Fo
I found it interesting. Thanks Eric.
>>(reconstructed from archives i accidentally deleted the copy in my mailbox
>>>Daniel Clark writes:
>>>I don't see how LIMIT would make a difference. LAST_INSERT_ID() only
>>>returns one record.
>>>Bu
I don't see how LIMIT would make a difference. LAST_INSERT_ID() only returns one
record.
But it's worth trying in a big loop to get timing numbers.
>>I have a rather simple straightforward question that I was not able to find
>>in any of the documentation.
>>I am in the process of writing an
> Hi, How can I make a query that looks for a city that has a " ' " in
> the name? For instance, I am looking for the name S'ARENAL, but the
> query below does not work:
>
> SELECT intl_localidades.id, intl_localidades.codigo_pais,
> intl_localidades.localidad_es,intl_zonas.zona,intl_paises.pais_es
try using explain
>
>
> Hi All,
>
> How can we optimize MySQL queries, plz define easy method
> comparing as well as better performance for data retrieval.
>
> Regards:
> aaziz
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://l
Hello. Quick easy question I think? I display a INT value to a page (php) by
querying mysql. I want to be able for someone to put a new number and add to
that record. How would I go about doing this. Would this be a mysql command
or a php thing? Thanks in advance.
Jonas Oreland wrote:
Hi Daniel,
Daniel Ek wrote:
I really thought that MySQL tried to produce MySQL cluster for common
hardware and with the design principle; more nodes with common
hardware, insted of few nodes with extreme hardware.
we do.
I will probably never work for a company that can
acts
with common hardware (if at all possible) or knows other solutions that
you can make high availability and share the load to the DB servers
please give me some suggestions.
Cheers
Daniel
PS.
For those who would like to know more about the GFS:
(http://www.google.s
Victor-
It's a little misleading. It looks like it's going to do a full table scan
of the Monday table.
Dan
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 25, 2004 6:18 AM
To: 'Daniel Cummings '; '[EMAIL PROTECTED]
Hi there, this is a bit of black art, but I would like to setup locks on
inserting back queries and updates on MyIsam tables which need fulltext
search and other tables are Innodb. I am having issues with this query
LOCK TABLE complaint_threads as ct WRITE, complaint_info as ci WRITE;
For some wi
These are two simple stock quotes tables that contain a symbol and a close
amount.
Explain
Select Monday.Symbol, Friday.Close, Monday.Close
From Monday Force Index(Symbol) Inner Join Friday Force Index(Symbol) ON
Monday.Symbol = Friday.Symbol
Symbol is a VarChar(20) in both ta
monsterjoin" in the first sentences of my mail that takes time. The odd
part is that it doesn't seem like the machine sets the limit. Does
anyone know what could make a difference?
I thank you very much for taking the time and effort and looking and
hopefully answering my mail
Regards
Danie
monsterjoin" in the first sentences of my mail that takes time. The odd
part is that it doesn't seem like the machine sets the limit. Does
anyone know what could make a difference?
I thank you very much for taking the time and effort and looking and
hopefully answering my mail
Regards
Danie
Hi all.
I've noticed that if I do a 'group by xxx' I get the results sorted by
xxx ( when I'm only grouping on 1 field ).
It seems to happen that way every single time.
Is this faster than doing both a 'group by' and 'sort by', and is it
something I can
We want to convert a 200+ meg table to a heap table. We've gotten pretty
good performance converting from InnoDb to MyIsam table but converting to a
heap table would give an even bigger performance boost.
Does making a heap file this large make any sense?
Are there size limitations to heap
Hi all.
Over the last 2 days, both my home and work email addresses have been
hit with a sudden surge in spam, and the content in both cases is the
same. Another strange thing is that my home address got basically none -
until now.
I'm assuming my addresses have been harvested from this list, as
Sid Taleb wrote:
When I query I don’t see the value of some primary key, I don’t
understand why, Can you tell me?
Yes. There is a problem somewhere.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2
hild record should be entered *after*, from a 'sub' form. Try
anything else and you're asking for problems.
Dan
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EM
We have one query which takes approximately 2 minutes. MySql seems to be
unresponsive to any other threads until this query has completed.
Are there some settings that aid with this kind of problem?
TIA
Dan
from 97 to 574. I am running 4.0.13 on
MAC OS/X 10.3 and the table is an INNODB table.
Has anybody else ever seen this?
Regards
Andy
Yes that's normal behaviour for an InnoDB table.
It's in the docs somewhere.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highw
Possibly two rows?
Can you change the where clause?
WHERE CartID=999 OR ProdID=333
> I have a simple query:
> SELECT * FROM cart
> WHERE CartID=999 AND ProdID=333
>
> The primary key is made of both CartID and ProdID, both integers.
>
> The query will not return the record in question
>
> This r
Joshua Beall wrote:
Hi All,
Is there a way to automatically optimize a table anytime data is changed. I
have a table that only has changes made to it occasionally (average over a 1
week period is probably 1 row is updated each day), and I would like it to
automatically optimize the table, rather t
should be the other
way other.
Either way, it's a little dodgy, but the above way is better.
Dan
--
signature
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL
Sasha Pachev wrote:
Based on what I've seen so far, JFS and XFS do not yet have a solid
track record of stability with MySQL. This does not mean they could
not be good - I just do not trust them yet. I do vaguely remember a
support case when a very strange corruption happened on either one of
Thomas Nyman wrote:
Hi all
I'm a mysql beginner. I have my database up and running and can query
it via php and apache.
I would like to set things up so that MSExcel and or MSWord can query
the database and extract info from it. For this reason I downloaded
the and installed MyODBC-standard-3
nlighten us both.
If you don't need any features of InnoDB, I suppose it wouldn't be too
much of a hassle setting up merge tables - just in case.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 /
Victor Pendleton wrote:
Are you specifying either the socket or the host/port combination? What
types of error messages are you getting
Here is an example of it working and not working (with machine,
usernames omitted)
$ mysql -h -u -p
Enter password:
Welcome to the MySQL monitor. Commands
I am having problems authenticating to a machine where there are two
database instances running. The instance which listens on the standard
port allows me to authenticate correctly whereas the instance listening
on the non-standard port only works: if I am on the same box as the
database; or i
Hi there, I am having some issues between two tables and foreign keys.
Here is the two tables I have setup.
| complaints |CREATE TABLE `complaints` (
`complaintID` int(11) NOT NULL auto_increment,
`ticket_number` varchar(20) NOT NULL default '',
`complainant_name` varchar(100) NOT NULL defa
SELECT user_id, rep_nurse_1, rep_nurse_2
FROM Users
WHERE User_ID = 'x'
> I have a problem with a SELECT query. I have a users table and each user
> can
> be a Rep, Nurse or Administrator defined by User_Type. Each Rep has two
> Nurses allocated to them and the User_ID of the nurse is held in col
I see in MaxDB there is initcap() function.
http://dev.mysql.com/doc/maxdb/en/71/81738fb9b311d2a97100a0c9449261/content.htm
> I have a table with upper case text. I want to use a function in my
> select
> statement the puts this text in title case so "MORE FOO YOU WIBBLE"
> becomes
> "More Foo Y
The only "missing" data should be uncommitted transactions unless
you've changed InnoDB's default flushing frequency.
Cool. Thanks!
--
signature
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T:
lso, there's no need to use 'distinct' - you will only ever get one
record ( as far as I know ).
Actually, I don't think you need a 'from' clause either, ie it doesn't
affect the result. You only ever get the *very* last inserted ID
returned.
--
signature
Daniel Kas
table with the exact field lengths in the
'create table' definition, and then use 'load data infile' with the
options 'fields terminated by' and 'fields enclosed by' both empty
strings ( '' ).
Dan
--
signature
Daniel Kasak
IT Developer
NUS Consulting
. I've been meaning to learn up on the binary
logs, but never gotten around to it.
So anyway, should I bother with a restore? What's the chance of having
data corrupted / missing after a power 'failure' and recovery as above?
Thanks!
Dan
--
signature
Daniel Kasak
IT Deve
In Oracle you can reference the second field AVG() by the field #.
ORDER BY 2
> Thanks a lot for the replies. I have changed the query as follows:
>
> **
> SELECT
> DB_ESTABLISHMENT_NAME,
> AVG(DB_GRADE)
>
> FROM
> ESTABLISHMENTS ES LEFT OUTER JOIN GRADES
I believe you have to add your AVG() to your GROUP BY clause.
> I have a sql query as follows:
>
> **
> SELECT
> DB_ESTABLISHMENT_NAME,
> AVG(DB_GRADE)
>
> FROM
> ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON
> ES.DB_ESTABLISHMENT_ID=GR.DB_ESTABLISHMENT_I
I wonder if mysql isn't trying to process
where GMTBase > DATE_SUB(CURRENT_DATE, INTERVAL 2 DAY)
What about doing this date subtracting in PHP and adding the result to the
SQL statement.
> Hello folks,
>
> I'm usinng MySQL 4.0.17.
>
> I have a table something like:
>
> RuleID int,
> GMTBase da
Hum. I've never tried inserting without the field names.
> Serves me right to type this stuff instead of copying/pasting - my
> previous post was indeed wrong but also wasn't the exact code I used
> (yours was, with the single quote embedded in the doubles).
>
> It's been a very dyslexic week for
How about: (I reversed on set of quotes)
sqlstr = "INSERT INTO Jobs VALUES('" & txtSceneFile & "')"
> Err...what I meant to say here was "ascii code equivalent (chr(39)" (I
> tried single *and* double quotes). Sorry about that.
>
>
501 - 600 of 1341 matches
Mail list logo