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:
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 hold
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: Time&Date in SQLServer7
> Hi
>
> I am inserting a Time like 06:00 from my code to a
- 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
hanges is 'enough'! (now apply
this to customer records and people changing addresses and you'll see
why/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'!
> Than
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
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 respon
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
> 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 a
??
> 3C3S??
> 4D4T??
> 5E 5V ??
>?
>?
>?
>
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
> > ord
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) homew
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
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
> databas
t;
> > > 1 4 1 4
> > >
>
>
> If that is the case, is this a Win-XP specific bug?
> Can someone running versions other than MySQL 4.0.5-beta on XP verify if
> it is a bug please?
>
> Thanks!
>
>
> Haksun
>
> > -Original Message
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
> 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 n
er mine.
=are you able to gain access at the command line (with mine/mine2)?
=BTW: now that we all know your 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,
&g
ata. Imagine that presented as a single screen-load and ask if it
seems appropriate for the application...
> That file idea of your is interesting I will have 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&
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 pos
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 acc
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 QUESTI
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.
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 foll
rom: "Jeff Kilbride" <[EMAIL PROTECTED]>
> To: "Alex Behrens" <[EMAIL PROTECTED]>; "MYSQL"
<[EMAIL PROTECTED]>
> Sent: Sunday, November 24, 2002 5:08 PM
> Subject: Re: displaying a letter based on a query value
>
>
> > select i
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 SELE
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 th
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:
Welco
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 sep
now (more securely) implemented has '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
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;
> +
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 MySQL
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:
>
> D
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 grin
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
o
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: H
e, anything that happened during yesterday morning would NOT be
included in such an expression.
It WILL pick up anything 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&#x
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 da
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 t
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
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
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: ./mysql_in
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
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 R
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
> 3.23
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
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 insert
> 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. (me
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
must
import this data once a day. I also will not be able to get them to
reformate 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&qu
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 ot
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
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
data in a database, you can sereate 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 N
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 PROTEC
ed, for
> example:
>
> time_in = 11:00
> time_out = 13:15
>
> 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
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 t
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
> .
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 alre
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
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
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.
>
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 goo
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=1&name=Mark&job_number=AA1&job_date=2002-5-19
> &id=2&name=Mark&job_number=AA2&job_date=2002-5-21
> &
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'),
> ('3','Mark
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
> ('2','Mark','AA2'
> > > 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
> > th
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
> l_first
ier Jocelyn [Presence-PC]" <[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.
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 Ti
first
query
> with DISTINCT ? (perhaps a bug ?)
>
> Regards,
>
> Jocelyn Fournier
>
> - Original Message -
> From: "DL Neil" <[EMAIL PROTECTED]>
> To: "Fournier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
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
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
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 B
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 incl
Hello Matt,
> I've got an SQL question. I have a database that contains Reviews of
some
> of a clients publications. The client is interested in generating some
> summary reports and I simply can't wrap my head around a single SQL
query
> (if that's possible) that will generate the information I'
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
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 My
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)
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
>
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
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 si
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 PROT
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, 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 examp
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
~!
> 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
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
> -N
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
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 li
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
>
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 mysq
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-characte
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
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
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 searchi
Greetings Edgar,
> I would just like to know if the following is normal:
>
> I created a file TRANSACTION_LOG.sql to create an InnoDB table with
MULTIPLE
> KEYs with one AUTO COLUMN.
>
> The file consists of the following SQL commands:
>
> drop table TRANSACTION_LOG;
> create table TRANSACTION_LO
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
1 - 100 of 319 matches
Mail list logo
