Felix,
Is is it possible to write an aggregation function which returns
more than one row?
Yes - if I have understood your requirement correctly.
It would have been helpful if you had given some idea of the
application/what you want to achieve. Here's an example from out of my
imagination:
Hi George,
I am about to start the planning process in moving my FileMaker/Lasso/PHP
site over to MySQL/PHP.
Before I get too far down the road, should I be using InnoDB or MyISAM
tables? The service is initially going to be hosted on WinNT but may move
over to Linux later.
=main response,
Hi Justin,
I'm after a little help/advice with indexing...
I have a table for measuring hits on each page within a site:
year month page hits
basically, my php script looks for a row matching this year (2002), this
month (12) and this page (something.php). if it finds it, increment by 1,
/which is the 'industry standard' approach).
=however the ultimate answer to your question is: if it works for you/your
users, then it is 'right'!
Thanks again, Beauford
=hope it helps you along your way to MySQL expertise,
=dn
- Original Message -
From: DL Neil [EMAIL PROTECTED
- Original Message -
From: [EMAIL PROTECTED]
To: DL Neil [EMAIL PROTECTED]
Sent: Tuesday, December 03, 2002 1:05 PM
Subject: Re: Re: Select and count duplicates
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter
Sam, heads up!
MySQL list members don't want this = spam!
=dn
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, December 03, 2002 4:54 PM
Subject: TimeDate in SQLServer7
Hi
I am inserting a Time like 06:00 from my code to a Date/Time
Thanks for the quick response. Excellent support
=you must have some 'magic touch'!
=a bunch of us held a conversation on the list trying to run this fault
down, and culminating in a bug report. We weren't even acknowledged... Quite
dispiriting. Obvious suggested work-around was to get
if
it is a bug please?
Thanks!
Haksun
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 01, 2002 3:39 PM
To: Haksun Li; [EMAIL PROTECTED]
Subject: Re: mysql join problem (bug?)
Hi Haksun,
Cross-join works perfectly on 3.23.53-max-nt
Hi Kath,
Are the MySQL machine, the Linux machine, and the client you are using all
the same machine?
Which timezone is Linux set to?
Which timezone is your local/client machine in, and/or set to?
Please advise,
=dn
hi, which date does mysql use to calculate CURDATE()? I have a master
database
Hi Beauford,
You are on the right track. Yes you should remove the songs to a separate
table. If you merely duplicate the first example (below) in two tables you
have created a one-to-many relationship between the Album table and the
Songs table - one album has many songs on it. Your query code
Alex,
This is a specialised question! Unfortunately, in my experience, it comes
down to the phrase YMMV (your mileage might vary) and thus requires you to
experiment with your data/machine combinations/etc - good job MySQL makes
this quite easy!
Can I assume that you have done your (manual)
maps filter fodder: MySQL
Hi Terence,
Is there a way to sort records based on a particular column, varchar(3),
which contains days of the week, mon, tue, wed, thu, fri, sat, sun
I need the order to be mon, tue, wed, thu etc.
Select day_of_week from my_timetable
order by
??
?
?
?
?
?
?
- Original Message -
From: DL Neil [EMAIL PROTECTED]
To: Beauford.2003
Select * from employees left outer join dept on employees.emp_DepId =
dept.dep_id where dept.dep_id is null
(Subselect would be easier if MySQL supported it!)
Likely easier to write, but equally likely to be more expensive to run
(on any tbl of realistic size)
NB Comment only pertinent as
RD,
How can I set auto-increment in mysql to start counting at say 5
rather
than 1
The manual is your friend.
Enter auto_increment into the search facility. Read 6.5.3 CREATE TABLE
Syntax - which illustrates the answer, or move on to the better description
in the next 'hit' 6.5.4 ALTER
Hi Haksun,
Cross-join works perfectly on 3.23.53-max-nt under Win2000 SP2, both from
command line and MySQL Control Center 0.8.6-alpha.
Regards,
=dn
Hi all,
I found this join problem using mysql 3.23.53-max-nt (on WinXP).
It works fine on MySQL 3.23.52-log (on Linux).
Could someone
Is it possible for mySQL to recognize and compare dates written in this
format: MM/DD/YY?
=the short answer is yes and no: yes it can be done by combining various
SQL/MySQL functions, but no there is no easy 'built-in' method.
I know standard date format for mySQL is YYY-MM-DD, but I need to
Jim,
Situation.. main table in a relatively small database. Table contains
approx 370K rows. Table is indexed on the unique identifier. New table,
fresh import of clean data.
Querying on a single field... run from the command line, returns 3 rows,
run from phpMyAdmin, returns 3 rows.
Grant,
I need help. I am building a database for a small college that wants to be
able to update their program information for each department through an
web/gui program.
I've decided to use, MYSQL, Apache, PHP and FreeBSD as the OS. (I built my
web page this way)
Here's my QUESTION!
Tim,
Normally PHP/MySQL doesn't run as mine, even if that is your Windows login
name - but it is possible...
Use command line.
Log on as root.
Check localhost privileges for user mine.
(good coverage in the manual)
Regards,
=dn
I have been trying to get mysql db to run but keep
getting access
Chandra,
I need some help in finding the time/day difference
as i want to know the session times
is there a way/function to calculate time difference
in mysql
Self help - from the foot of each list msg:
-
Before posting,
to sleep on it. Thanks
for
your input. I'm a one man team developing this and I've been sinful. This
is
the time God's going to punish me if this blows up in my face. hehe.
=one man...sinful???
No, I'm not going there...
=dn
- Original Message -
From: DL Neil [EMAIL PROTECTED]
To: Grant
pswd, I trust this is not an Internet-facing
machine!
=Idle curiousity: what will the gulf db contain?
=Regards,
=dn
--- DL Neil [EMAIL PROTECTED] wrote:
Tim,
Normally PHP/MySQL doesn't run as mine, even if
that is your Windows login
name - but it is possible...
Use command line
Mark,
Are you working from the command line or using a tool (which)?
MySQL version nr?
Are you running WinMySQLadmin (the traffic lights in the System Tray)?
=dn
I'm running MySQL as a service on win2k and trying to insert data into a
database. Each time I try to do this I receive the
Hey Alex
select captain from stats where captain 0 and number = '23' group by
number;
this returns a 1 for any player with the number that matches being a
captain, however it display a 1 is it possible to make that 1 displayed as
a
C on my page?
MySQL allows an IF() within the SELECT
group by number
This returns 'C' whenever the captain field is 1 and '' (empty string)
otherwise.
--jeff
- Original Message -
From: Alex Behrens [EMAIL PROTECTED]
To: DL Neil [EMAIL PROTECTED]; MYSQL
[EMAIL PROTECTED]
Sent: Sunday, November 24, 2002 3:53 PM
Subject: Re
Guenter,
Nice piece of analysis!
As it happens WinMySQLadmin v1.4 under Win2000 fares little better,
apparently gobbling up VM until... (Bug Report posted 20Nov2002 shortly
after midnight UTC - as yet unacknowledged)
[won't attach here (not correct list procedure), so will forward private
copy
Hi Trask,
Can anyone tell me how to set the following parameters in mySQL 3.23? I'm
new to MySQL and am setting up a BBS. MySQL is installed and running OK.
Database Server Hostname / DSN:
Database Name:
Database Username:
Database Password:
Prefix for tables in database:
Welcome to a
Hello Tarik,
The DISTINCT option will sort this out for you.
=dn
I got two tables containing following data :
table1
--
id
--
2
3
2
2
table2
--
id | label
--
1 | one
2 | two
3 | three
4 | four
I would like to select table2's rows that got at less one
'broken' the sample
code.
=when you've had a 'play', come back and let us know how much things are
improved,
=dn
On Wed, 20 Nov 2002 DL Neil wrote :
Pallavi,
mysql load data infile pet.txt into table pet;
ERROR 1105: File './test/pet.txt' not found (Errcode: 2)
mysql load data infile
Simon,
I have been asked to support/bug-fix a Windows based web site using MySQL.
I have used MySQL on Linux/FreeBSD for 3/4 years, but never on Windows.
How does MySQL compare on Linux and Windows for stability and performance ?
=congratulations. Your relief appears in the phrase, MySQL is
Pallavi,
mysql load data infile pet.txt into table pet;
ERROR 1105: File './test/pet.txt' not found (Errcode: 2)
mysql load data infile pet.txt into table pet;
Query OK, 8 rows affected (0.00 sec)
Records: 8 Deleted: 0 Skipped: 0 Warnings: 4
mysql select * from pet;
Hi Warren,
I wrote in a little while ago about getting unique visits to a website
listed by day. Martin Waite came up with a very nice formulation, which
does wonders!
However, I have done something that is now yielding inconsistent results.
The screen shot is basically like this:
Day by
I have just updated from MySQL 3.23.51 to 4.0.4 on my Win2000 Prof SP2
portable, and shortly afterwards noted some runaway problem was consuming
memory. Left long enough, Windows eventually starts bleating about its
amount of virtual memory; obviously things start to thrash, and apps
gradually
Michael,
Thank you for your alert.
In the same way that you did not ask the original question, I did not write
the part attributed to 'me'!
There is no such address [EMAIL PROTECTED]
The only address in this sub-domain subscribed to [EMAIL PROTECTED] is
[EMAIL PROTECTED]
I have reduced myself to
MySQL/Open source campaigners and 'evangelists' may be interested in BBC
coverage
of a report by the Commission on Intellectual Property Rights (CIPR):
http://news.bbc.co.uk/1/hi/sci/tech/2253270.stm. It talks of medical,
agricultural, industrial, and IT/educational disadvantages placed in front
Hi Chuck,
or take a look at the LEFT() function.
=dn
Try :
SELECT * FROM yourtable WHERE word LIKE 'D%';
Regards,
Jocelyn
- Original Message -
From: Chuck PUP Payne [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, September 08, 2002 2:42 AM
Subject: Have A problem
Hi Erick,
i have a date/time column. i insert into it using now(). works fine.
now i want a query where data/time is either today or yesterday.
how should i do it?
Calculate the date required (yesterday and/or today) and then add a time
component of midnight (all zeroes) to make up a
that happened during the last one day/24-hours -
both yesterday's and today's 'hours'!
Q: Which is 'right'?
A: Depends which suits Erick's requirement!
Regards,
=dn
- Original Message -
From: DL Neil [EMAIL PROTECTED]
To: Erick Papadakis [EMAIL PROTECTED]; mysql
[EMAIL PROTECTED
Hello Javier,
I am developing an aplication where I need format the date for inserting
into mySQL.
=what language is your application written in?
=dn
With DATE_FORMAT I can format the mySQL date to my date, but I haven't
found a good way to format my date to the mySQL date.
My format is
Howdy Matthias,
update vbooth_data set optionText='Not at all, I'm waiting for the other
shoe
to drop' where (pollID='34' AND voteID='3');
When I hit Enter, it gives me this prompt:
'
Two things:
1 (the ) is because it is waiting for the end of the string - you have an
apostrophe opening
Scott,
MySQL is available in two 'flavors': source code and (binary) executables.
Which one did you intend to download/install?
Which OpSys are you using?
Please advise,
=dn
The instructions that I have to install MySQL, tells me to cd to the bin
directory and run this command:
Dear Chugh,
Can we define sysdate or curdate as default date for a column of
datatype 'date' while creating a table?
The question is ambiguous:
- if a table is created with a column defined to be a TIMESTAMP data type,
then every time a row is INSERTed or UPDATEd, the current date will be
Hi Justin,
...the docs to be looking for examples.
I have three tables...
cd (id, title, etc)
artist (id, name)
cd_to_artist (cdid, artistid)
Given an artist id, I want to retrieve all cds related to that artist,
given
the information in the table cd_to_artist. The reason for the third
Tony,
What data type is the autoindex field/column?
=dn
I have a problem with MySQL. I am trying to insert data using INFILE, and
it works, except that it ALWAYS stop at 255 (autoindex) and will not go
any
further, either by manual insert or textfile insert. I am running MySQL
Marc,
Is there any record of a startup 'confusion' in the Event Viewer/logs?
Once the machine is started and sitting static, what do you see (of
MySQL/unidentified) in the Services list?
If there is some entry, use a DOS box to stop the service.
Then clear out any reference to the service from
Frederick,
ALTER TABLE will do the biz:
http://www.mysql.com/doc/en/ALTER_TABLE.html
Regards,
=dn
I would like to know if it is possible to configure mysql auto increment
field to start at a specific number or to configure the auto increment
field
with a character such as a letter inserted
Elias,
ALTER TABLE will do the biz: http://www.mysql.com/doc/en/ALTER_TABLE.html
Regards,
=dn
I would like to know if it is possible to configure mysql auo increment
feild to start from a specific number or configure it to have a specific
character such as a letter inserted infront of it.
Are there any mysql books in Latin?
Me sequelae datorum ordinatrum, scribo Paulus ExSilvaticus
- when you write the rest yourself you may find the following
useful/entertaining
Vocabula computatralia
Vocabula computatralia. A. abort 1. vt interrumpere 2. subst. interruptus,us
m. address 1.
Hi Andreas,
I'm just getting started with mysql so please bear with me. =8-}
I do a 3 table query like:
SELECT a.x, b.y, c.z
FROM a, b, c
WHERE a.b_fk = b.id AND a.c_fk = c.id;
That works so far.
In c can be rows which aren't active anymore.
There is a good_from and a good_until
Hello Serge,
I am having troubles with Load Data Infile and cannot figure out the
problem. I have a date field but the format is 'Jan 1 1986' rather than
mysql's default. So when I import I only get '-00-00' rather than the
date. How can I tell MySQL what the format is?
I have read
Joseph,
I need to know if there is a way to do a simple insert from a .txt file,
using insert and only populate one column. Its a streamline db and I want to
enter only a few of the columns.
I have exported all data into txt files at this point. I can not find any
mention on mysql's site
their data since I'm only one of many many people downloading
everyday. Is their no way for load data to do this automaticaly?
Serge.
On Tue, 20 Aug 2002 21:31:45 +0100
DL Neil [EMAIL PROTECTED] wrote:
Hello Serge,
I am having troubles with Load Data Infile and cannot figure out
Mark,
I'm a great believer in 'divide and conquor', so let's take your clear
statement of problem and knowing that we can't achieve it by brute
force/direct attack, let's break it down and solve it a piece at a time:
table contains title and date of records
a) sort so that records are listed by
Nick,
Understood - but did Carlos say that he is using PHP, and why use PHP when a
more efficient/quicker MySQL solution is available?
=dn
- Original Message -
From: nick gatsis [EMAIL PROTECTED]
To: DL Neil [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, August 12, 2002 9:06 AM
the information
you want that time. Then you just call the results
from the table (you have them ready) and dont ask the
server to work for it.
If you know an other solution, i'll be happy to learn
it.
Cheeres
--- DL Neil [EMAIL PROTECTED] :
Nick,
Understood - but did Carlos say
Gloria
in a database on adjunct faculty.
Well, I set my table up withalphnumeric codes and most stats software
want those mutliple choices as numbers.
=which is why most people design to enter such data as number codes (1~5)
rather than alpha.
So I need to change the things already
Obiajulu,
Please refer to previous response and the as yet unanswered question within.
I have the following values in my db table:
Id. regdate
001040-1467
011910-2002
021700-1789
031550-2002
041600-1700
051900-2000
...
How
Hello Christopher,
I need to ask for some help and I can't find anything in the manuals. I
am writing a php based app that as one of it's functions keeps an
employee time sheet. The times are stored in a mysql database with 2
columns - time_in and time_out. What I need to do is subtract
job_time= 21500
Any pointers?
-Chris
On Saturday, August 10, 2002, at 09:36 AM, DL Neil wrote:
Hello Christopher,
I need to ask for some help and I can't find anything in the manuals. I
am writing a php based app that as one of it's functions keeps an
employee time sheet. The times
Bhavin,
Is there a way to have DB-A and DB-B such that DB-A is the master and DB-B
Can't help you with the replication question - but here is a replication
answer - have everyone in your installation repeat after me: the DBA is
your master! (and say it again...and again...)
=dn
List fodder:
Steve,
For some reason the below statement is not working. Can anyone tell me
why?
Select EDIT_LOCK from ordmaster where EDIT_LOCK + INTERVAL 10 MINUTE
now()
AND ORDER_NO = '5' AND EDIT_LOCK 0;
-EDIT_LOCK is a MySQL (ver 3.23.49-max) time field, allows nulls, default
is
NULL.
If this
Jefferson,
I'm writing a web application in PHP to do referee scheduling for soccer
games. For each game (a single row in a table) I have a cell for
referee. The cell stores an integer that I can do a join on with another
table of people. I need a way to prevent people from being able to
Ollie,
Ahh, all this talk of old-timers writing merges to cut their teeth in the
'new' field of data processing... it brings on a wave of tender memories -
however looking back, I find that even nostalgia ain't what it used to be!
The earlier response works (assuming key behavior), and is a good
Mark
Does anyone know if it's possible to insert mutilple records into 1
table
in one query?
yes
Something like -
insert into mytable (id,name,job_number,job_date) values
('1','Mark','AA1','2002-04-15')
insert into mytable (id,name,job_number,job_date) values
Mark,
Is it a two-fer-one sale today?
I'm now trying to UPDATE the three records with one query.
Once the data is INSERTED into the db with this -
insert into mytable (id,name,job_number,job_date) values
('1','Mark','AA1','2002-04-15'),
('2','Mark','AA2','2002-04-16'),
Mark,
Earlier joke rebounds - pardon me whilst I wipe the comedic egg from my
face...
That the thing see, the form(using GET instead of POST) sends data
with
the new dates like this:-
id=1name=Markjob_number=AA1job_date=2002-5-19
id=2name=Markjob_number=AA2job_date=2002-5-21
Hi Jocelyn,
I wonder how works DISTINCT when using it with the following join.
Ex :
mysql SELECT DISTINCT topic FROM
searchmainhardwarefr7,searchjoinhardwarefr7 WHERE
searchmainhardwarefr7.numreponse=searchjoinhardwarefr7.numreponse AND
(mot='test') AND date = '2002-03-24' ORDER BY date
Hi gordon,
This is NOT needed as of now..
(just future-thinking on my part),
Hi there... Im just experimenting with a new database,
i'm wondering..
Is there a way in which I can create a column in a
mysql table to be a unique number/reference.. - once
set, I dont need to keep
Hi Ben,
I have a database table which includes a timestamp(14) field.
I would like to construct an SQL statement that pulls out records
between
two dates, based on this field (i.e. time is not important, date is).
So a user input 01/01/2001 - 01/01/2002 and I want to retrieve
all
records
? (perhaps a bug ?)
Regards,
Jocelyn Fournier
- Original Message -
From: DL Neil [EMAIL PROTECTED]
To: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Sunday, April 14, 2002 5:54 PM
Subject: Re: How does DISTINCT really work ?
Hi Jocelyn,
I wonder how
Hi everyone,
Apologies, I'm coming very late into this conversation, but perhaps I
can disperse some of the confusion...
Rob's original question:
*
I'm curious about how MySQL deals with time zones.
Our machines are located in the GMT time zone, and recently rolled over
to
British Standard
] [EMAIL PROTECTED]; DL Neil
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: 14 April 2002 18:46
Subject: SV: How does DISTINCT really work ?
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
Hi Roger,
consider this select statement as an example:
SELECT d_person.dispname, d_title.title
FROM d_person, d_title, s_first, s_last, t_person, l_first, l_last
WHERE
t_person.dperson_id = d_person.dperson_id AND
t_person.dtitle_id = d_title.dtitle_id AND
I'm quite sure it does not matter if I write
t_person.dperson_id = d_person.dperson_id AND
or
d_person.dperson_id = t_person.dperson_id AND
but please tell me if it does... :o)
Logically there is no difference, however prevailing wisdom suggests
that you put the
Stéphane,
Answers:
There are nine different states (and there are 12 months).
*
The main problem is the layout and the order of the results set. I will
have
9 state (provinces) and I would prefer the month to be the columns. The
ideal results would look like this, Please note I have only
Stéphane,
I have INVOICE table here is the layout:
+-+---+--+-+-+--
--+
| Field | Type | Null | Key | Default |
Extra
|
+-+---+--+-+-+--
Nicklaus,
Now that we've got you warmed up: are you able to recommend any online
tutorials/references which cover the interfacing of VB/M$ Office
products (macros/VBA) to MySQL?
Please advise,
=dn
Absolutely. I must tell you that we have MUCH fewer problems using VB
with
MySQL than we do
Daniel,
Was reading an article last night on tree structures and linked list
structures at searchdatabase.com.
As to simple, no linked lists are not, and for that reason not a good
topic for a first foray into the world of databases.
Why don't you work through one of the 'intro to dynamic web
Jeff,
What i want to do seems simple, but i can not for the life of me
figure out
how to do it.
Tables: These tables are not related in any way.
A
--
1
2
3
4
5
B
--
1,Bob
3,Jack
7,Janet
8,Gary
9,Kelly
I would like to combine tables A and B with a SELECT statement to get
Daniel,
I have a question about determining which case
occurred when there are no matches - using two tables.
Scenario:
- two tables, one for photos, and one for collections
- zero or more photos can belong to a collection
- the database may not know the collection_id requested
Hello Maxim,
There's a bit of confusion in this discussion: Do you (a) want to have
several databases running on the db-server, and all set to different
time zones, or (b) want each client to see db-stored times stated in
his/her local timezone?
(a) AFAIK (and I claim no special expertise here)
Anoop,
I need to build a small database for my school project.Is there a way
I can interface GLADE to MySQL?
A confusion of tools - further research needed.
GLADE (as in GTK) will interface to various scripting/programming
languages.
Various scripting/programming languages will interface to
David, Steven,
I think this is what you want?
select * from table order by date_column ASC; ( for ascending order..)
select * from table order by date_column DESC; ( for descending
order..)
Replace 'table' with the name of your table and date_column with the
name of the column that
Mark, Peter,
The query below assumes that the user will search of FirstName and none
or more of the other fields - which was not how the question reads (to
me).
To answer the question it would be useful to know how you are accessing
MySQL - are you using PHP (as per example code below) for
Nick,
This is pretty familiar to me because I'm analyzing the behavior of
people
in on-line discussions, so I'm gathering such data.
Which begs the questions:
- in what way are you analyzing behavior? and
- in what way are you analyzing this list-community?
=dn
MySQL list busting
Mark,
Tutorials: Start at the PHP home page and look for the links page.
DevShed would be a good start.
Regards,
=dn
- Original Message -
From: Mark Stringham [EMAIL PROTECTED]
To: DL Neil [EMAIL PROTECTED]; Peter Lovatt
[EMAIL PROTECTED]; MySQL [EMAIL PROTECTED]
Sent: 28 March 2002 19
~!
Ok here's what I trying to do. I am trying to design a little
browser/ip
tracking page and I need an SQL statement that will allow me to group
IPs
that hit the site in 5 minute intervals (well I just want the interval
thing
to work cuz I'll prolly want to make this like 30 minutes or a
Hello Markus,
There -has- to be an easy solution to this, but I just can't for
the world figure it out.
I have a table called members(id,membernum,firstname,lastname)
and a table called paid(id,membernum,year,paid).
How on earth do I select the members in table members that are
-NOT- in
Hi GEORGE,
I would like to ask a simple question about the way
MySQL handles string variabels. Say i have a variable
whose value is foo and I want to change it to foobar.
Instead of doing it the 'typical' way, I would like to
ask whether there is any mysql command that will allow
me to
Hi GEORGE,
The typical way refers to the update syntax. Ideally,
I would like to be able to do something like that:
- read the value of the variable through a read
statement.
-Specify the value to be appended.
-Do the task.
Could you please help me out with that?
I would like to ask
Hi Christian,
i'm working on a project for managing used motorcycles. for security
reasons
i setup two identical tables. both with the same attributes.
ID,UNIID,Manufacurer... one of the tables is named Com and the other
Prv.
till now i used to search either Com or Prv. but i want to look
Jan,
i wonder if its possible to perform multiple WHERE statements in one
mysql SELECT statement like:
SELECT * FROM table WHERE field1=3D'one' AND field2=3D'two' OR
field3=3D'three';
it works with as many AND and
it works with OR but not together
is there something like brackets or other
Hi Jari,
have not figured out if one can do character changes with mysql, any one
know how to do the following for fields in a table
Altering all the x-characters to character y ?
=You sure can. Manual reference: 6.3.2 String Functions
REPLACE() will find the x-characters and replace them all
Hi Jari,
have not figured out if one can do character changes with mysql, any
one
know how to do the following for fields in a table
Altering all the x-characters to character y ?
=You sure can. Manual reference: 6.3.2 String Functions
REPLACE() will find the x-characters and replace
Hi Andrew,
Let me first say that I am used to using mysql through PHP rather than
command line . . .
And, as I understand it mysql does not support any sort of timers.
I need to use a Unix command like cron to automate either a mysql
command or php script to output a selection from a few
Hello Wout,
Appareantly it's impossible to insert a string, consisting entirely
out of
spaces, in a textual field (I've tried varchar(19) and char(2) types,
they
both don't work). MySQL doesn't complain about it, but it trims the
strings
down to the empty string. If I try a select searching
Brent,
What's the best way to timestamp records if records are to be exported
and
then re-imported to another web server in a different time zone? Data
will
be exported as comma delimited data. All of the combined records
should
reflect the same instant in time, and not have the web site in
Hi MySQL,
I record some stock data into MySQL, I'm looking for the correct
syntax for a SELECT statement.
SELECT min(Tmin) FROM quotes WHERE low=min(low)
In short, I want the time of the occurance of the low for the day,
Tmin is time column. Once the low is achieved, all the remaining
Hi Alexander,
I am interested if there any URL I can read more about text type
fields
in MySQL.
I had an argument with a friend who said that if I use text type in a
table it will make the system to work to slow.
But I realy needed this text field because I wanted to store text more
than
1 - 100 of 307 matches
Mail list logo