Pooly wrote:
Hi,
I try to convert a varchar to a char, but it doesn't seems to work.
From the manual: "...all CHAR columns longer than three characters are
changed to VARCHAR columns."
http://dev.mysql.com/doc/mysql/en/silent-column-changes.html >
--
Roger
--
MySQL General Mailing List
F
Manoj wrote:
Dear All,
I am trying to join two tables say a & b. Both tables have a set
of dates. I want to join the tables in such a fashion that I retrieve
all dates from table A. If table b has corresponding data (for that
date) then it will display it or else will display null. I am prett
Sérgio Júnior wrote:
> I’ve never worked with mysql db’s and I would like to start a new
> Project at work creating a new mysql db. I start read but I got lost
> so many times that I am seeking guidance help, someon to tell me
> first start with this and after do that. Is anyone available to give
Pat Adams wrote:
On Wed, 2005-08-24 at 06:11 -0500, John Gonzales wrote:
CREATE TABLE `journal` (
`journal_id` int(10) unsigned NOT NULL auto_increment,
[snip]
CREATE TABLE comments
(
comment_id INT,
comment_journal_id INT,
INDEX jrn_id (journal_id),
Here you are defining an index name
Vladimir B. Tsarkov wrote:
After the execution of the script:
we will get:
1
and no empty lines.
If you want to output the same data, that was written using a textarea field
of a form, you should use the "" tag.
In one word: kiss. Converting the data before inserting it in the
database,
Chris Spencer wrote:
I'm on Fedora Core 4. When I right-click on a table in
Mysql-administrator and choose "Edit table data" nothing happens, and I
get this in the console:
(mysql-administrator-bin:4628): glibmm-CRITICAL **:
unhandled exception (type Glib::Error) in signal handler:
domain: g-e
[EMAIL PROTECTED] wrote:
I did not expect that null was not not-equal to 1.
Any comparison with NULL returns NULL:
mysql> select null<>1,null>1,null<1,null=1;
+-++++
| null<>1 | null>1 | null<1 | null=1 |
+-++++
|NULL | NULL
Schalk Neethling wrote:
Greetings
What might be causing the 1064 error in the following query?
SELECT mem_number, first_name, last_name, area_represented,
joining_points + E-Model Challenge + SA Pro Model + Star Model Challenge
+ Eastern Cape Classic + SA Model Super Star + KZN Model GP + Mpum
Andrew Braithwaite wrote:
Hi All,
I have a strange error when trying to insert into a table with 2
'double' fields. It inserts into the 1st field OK but fills the 2nd one
with nines. See below for a complete recreate.
[...]
| lon | double(7,6) | YES | MUL | NULL|
Jacek Becla wrote:
Hi,
Does anyone know how to execute SQL statements from a text file
such that the summaries "X rows in set (X.YZ sec)" are printed
for each query?
Neither of these do it:
mysql < batch-file
mysql -e 'source batch-file'
If you add verbosity using the parameter -vv (or -v
C.R.Vegelin wrote:
Hi All,
I have a "simple" problem and hope you can help me.
I have an input table Updates with various fields, incl. Month and MonthlyValue.
The field Updates.Month ranges from 1 to 12.
I also have a target Data table with 12 fields, called Jan, Feb, Mar, ... `Dec`.
Depending o
Subscriptions aka Jenifer wrote:
query: SELECT tblCustomer.*, tblNotes.note FROM tblCustomer LEFT
JOIN tblNotes ON tblCustomer.customerid = tblNotes.noteID WHERE
tblCustomer.customerid = 123
You are joining the customerid from the customer table to the noteID
from your notes table. You should
Arjen Lentz wrote:
[...]
While we're at it: the term "non-zero"... what does it mean? As we all
know, NULL != 0, and 0 == zero, consequently NULL must be non-zero.
Flawed logic.
Yes, I used flawed logic to illustrate my point: "non-zero" is a bad
term to use in this context.
The text from the
Martin Rytz wrote:
[...]
With which join can I show the animals with all pics for this animal (even
if there are more than one pic for an animal)?
SELECT animal,pic
FROM animal_pic,animal,pic
WHERE
animal.id = animalid AND
pic.id = picid
This will list all animals which have pictures, w
Jesper Andersson wrote:
[...]
created =VARCHAR(14)
[...]
select CREATED from SUBSCRIBER where date_sub(now(), interval 1 hour) <=
created;
What do I wrong??
The 'created' column is a normal string, the date_sub() function returns
a "time string", i.e. a string on the special format "-MM-DD
H
Joppe A wrote:
hello all,
I am a newbe working with MySQL.
I have a problem that I can't figure out how to do.
I have 2 tables that I want to take out data from, the tables looks
like below.
tableA
==
ID VARCHAR(12)
NAMEVARCHAR(255)
CREATED TIMESTAMP
tableB
==
Roger Baklund wrote:
Try something like this:
SELECT ID,NAME,COUNT(*)
FROM tableA
LEFT JOIN tableB ON
tableA.ID = tableB.ID
GROUP BY ID,NAME
Nope, sorry, that won't work, ID exists in both tables thus it must be
prefixed with table name or alias: SELECT tableA.ID,... GROUP BY
tabl
Gabriel PREDA wrote:
Let me assure you that DATETIME is the worst choice ever... because it need
8 bytes per record...
TIMESTAMP uses only 4
...but TIMESTAMP has a special behaviour which may not be wanted in all
cases: the first TIMESTAMP column of a table is updated automatically
when _any_ col
Jan Bartholdy wrote:
Dear List, I have a select case question
SELECT CASE WHEN `Species_1_l` > 0
THEN 'intern'
when 'Species_3_e' > 0
'Species_3_e' is surrounded by single quotes, not backticks... thus it
is treated as a string, numeric value is 0, which is never > 0.
BTW, th
Jan Bartholdy wrote:
Thanks Roger, but it does not work:
SELECT CASE
when Species_1_e > 0
THEN 'extern'
when Species_3_e > 0
THEN 'intern'
ELSE ''
END AS `species_1_l` from species where statsample=1820;
--Gives at a result 'extern'
What is the value o
Reinhart Viane wrote:
Concerning datetime type:
Eg. in a forum if someone posts a message the date and the time is stored
and shown of that message.
I suppose they use timestamp in that case?
They could, but because of the 'magic' behaviour of TIMESTAMP a DATETIME
is often used. To conserve space,
Tim Johnson wrote:
I would like to construct a query that searces on a variable list of
primary keys.
Example: Lkeys = [12, 23, 15, 17]## python - style list of integers
Select column from table where ID in Lkeys; ## mysql statement?
Is this possible, or does one have to generate a quer
Clarence wrote:
I have a log table that records certain transactions on one of my sites.
I'm using a timestamp field to mark the date/time of each transaction.
I'm trying to run a query that will display the transactions by date
using the following SQL:
SELECT COUNT(log_id) AS total,
WEEK(FROM_UN
Scott Klarenbach wrote:
I have a client that wants to search table fields for strings, and
ignore any-non alphanumeric character in the field. (match only the
alphanumeric portion of the field, and discard the rest)
for example, a search for apple would return true on the following record
a**__-p p
Patrick Marquetecken wrote:
I seems not to figure out how to import a xml file into mysql 4.x
I'm working on, Linux, help would he fine.
XML is an hierarchical format, it does not map directly to a relational
database, which has a tabular format. I don't know if there are any
general purpose tool
David Smithson wrote:
Hi all. Can somebody explain to me why the following SELECT doesn't work?:
SELECT COUNT(DISTINCT(CONCAT(contact_firstname,' ',contact_lastname)
as contact_name)) as count FROM Contacts GROUP BY contact_ident ORDER
BY contact_name;
The error returned is:
ERROR 1064: You have a
Brian Erickson wrote:
We have a table that has two datetime fields (start_time and
end_time). We'd like to be able to calculate the number of seconds
between these two fields in a query. However, a simple "end_time -
start_time" does not yield a correct result.
SELECT start_time, end_time, end_time
Gerald Preston wrote:
[...]
I get "DBI connect<'club','gjwpp88',..> failed; Client does not support
authentication protocol requested by server"
Check this:
http://dev.mysql.com/doc/mysql/en/old-client.html >
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
mos wrote:
I've tried just about every syntax combination to try and add columns to
a table using Alter Table and I keep running into syntax errors.
Alter table MyTable add (newcol1 float after col3, newcol2 float after
col3);
or
Alter table MyTable add (newcol1 float, newcol2 float) after col3
Mattias Håkansson wrote:
Hello,
I'm using MySQL 4.0.20 on Linux and I am experiencing some problems with a
query result.
I have the following table structure:
mysql> desc gen_Lloyds_vessel;
+-+--+--+-+-++
| Field | Type
Chris Knipe wrote:
Hi,
Is it possible to left join the same data twice?
Yes.
TBL ONE:
LocationID
Location, varchar(100)
TBL TWO:
DepartureID,
ArrivalID,
Time
SELECT tlb1.DepartureLocation AS Departure, tbl1.DepartureLocation AS
Destination LEFT JOIN DepartureLocation ON
tlb2.DepartureID=tlb1.Lo
Yemi Obembe wrote:
If for example I have a table with the 3 columns: name,age,sex & I
build an index table
"index table" ? There is no such thing.
on the column 'name'. how can i get result of
the other rows (i.e age and)
other rows? You mean other columns?
from the main table
What main tabl
Yemi Obembe wrote:
learnt SQL_BIG_RESULT in the select syntax builds a temporary table
on the result (if I'm right). What will the Select statement to
access such temporary table look like?
This is an internal temporary table, the result is returned in the
normal way, and the temporary table is de
Dto. Sistemas de Unitel wrote:
[...]
something like
/indexes.id=productos.prod_id and indexes.id_termino=terminos.id_termino
and termino="computer" and termino=”intel”/ I know that is impossible,
but maybe there is another way to make that).
Yes, there is another way. You _can_ join the same tab
Dto. Sistemas de Unitel wrote:
Hi Roger,
That was just I need. The order isn’t like you say:
++-+---++---+-+-
++---+-+
| id | select_type | table | type | possible_k
Dto. Sistemas de Unitel wrote:
Hi Roger,
You are ok, there was an index problem in one table, they name of the rows
wasn't equal and MySQL didn't recognize they as the same index. I have
changed the row name and now is working fine, but I have a little question,
How can I use indexes with different
Dto. Sistemas de Unitel wrote:
You don't understand me, I refer that if in a table I use productos.prod_id
and in other table indexes.id if I can use this two fields like the same
index, because when I named the two equal, the index start to work fine.
There should be no problem with joining two ta
Dan Bolser wrote:
SELECT DISTINCT ROW(A,B) from a;
While I am on a roll (of sorts) can I ask if the above syntax should be
valid or not?
If you mean the exact syntax above, I think not... it looks like ROW()
is a function taking two parameters in this case... what does the
function return? Is it
Vaidas Zilionis wrote:
[...]
Example items are displayed 100 in page, and i display 20 pages
numbers
1 ... 4[5] 6 x
doomain.con/items.php?page=5
and i get all result here with limit 400,100
Yes, with PHP it would be something like this:
$items_per_page = 100;
$limit_clause = ((int)$page-1)*$ite
symbulos wrote:
how do you extract with a query only the first few lines from a blob field?
For instance: you have an article stored in the field. You would like to
visualise the first few lines before reading it all.
You could use the LEFT() function to return for instance the 200 first
characte
Erik Bukakis wrote:
I just learned a lot stuff at
http://dev.mysql.com/doc/mysql/en/sorting-rows.html including sorting by
number-to-text, text-to-number, names, specific values, etc.
However, the document didn't mention on how to sort by relevance.
For instance, someone search for "Ang":
COLUMN
Paul Halliday wrote:
srcaddr VARCHAR(15),
dstaddr VARCHAR(15),
Are these ip-adresses? If they are, consider using UNSIGNED INT columns
and the INET_NTOA() and INET_ATON() funtions. It will save you a lot of
space, thus increase the amount of data your hw can handle.
I have read u
Paul Halliday wrote:
srcaddr VARCHAR(15),
dstaddr VARCHAR(15),
Are these ip-adresses? If they are, consider using UNSIGNED INT columns
and the INET_NTOA() and INET_ATON() funtions. It will save you a lot of
space, thus increase the amount of data your hw can handle.
They are indeed i
Dave Shariff Yadallee wrote:
I am trying to set up a chem structures table.
column 1 is the key, column 2 is the description, column 3 is the structure
which is a blob.
In PHP the first 2 columns comes out as text as expected, but the
3rd I am trying to tell PHP please ignore this initially since
t
Andrew Braithwaite wrote:
Is there any way to get MySQL to return the results of this query with
the 'fieldname' in the order listed in the in() bit?
select fieldname from tablename where fieldname in
('B4079','B4076','B4069','B4041','A4710','58282','58220','56751','56728'
,'45003','09234','04200',
James Tu wrote:
Hi:
Let's say I want to store the following information.
Unique ID - INT(10) autoincrement
First Name - VARCHAR (25)
Last Name - VARCHAR (25)
Age - INT(3)
In general 'age' is a bad column, because you need to know what year the
data was entered to calculate the current age. I
James Tu wrote:
What does MySQL do internally when you perform a LEFT JOIN?
You can read about it here:
http://dev.mysql.com/doc/mysql/en/left-join-optimization.html >
If you need more details, you could read the source...
Let's say you have two tables:
Table A has 1,000,000 rows
Table B ha
* Rhino:
> You'll need three alter statements:
> - one to add the new column
> - one to get rid of the old primary key
> - one to set the new column as the primary key
In addition to adding the new column, there will be neccessary to populate
the column with unique values. A primary key must allwa
* Alec Smith
> I've got a database along the lines of the following
>
> --
> | Transactions | | Products | | TransDetails |
> --
> | TransID | | ProdID | | TransID |
> | TransDate| |
* Ville Mattila
> I have a table including information about my projects, the structure
> has each id and name. Then I have another table including status
> information of each project: entryid, projectid, status and timestamp.
>
> Is there any possibility to fetch a list of projects with the most
* Stéphane Bischoff
> Thank you for all your response, but my question is very simple :
>
> Example :
>
> We have company 1 that make's a product that communicate with MySQL server
> using TCP/IP.
> This product (company 1) does not use the MySQL client to connect to MySQL
> server. (Don't ask me h
* Robert
> It seems that the .FRM file for one of my largest tables has disappeared.
> 180 million rows. I am not so much concerned about finding out WHY it was
> deleted as I am trying to figure out how to recover the table.
>
> I've tried making a new table using a similar data structure (the tab
* Reverend Deuce aka Robert
> I am examining the file in a HEX editor right now and have identified the
> pattern. The table size divided by the pattern byte length is 8 bytes. The
> last byte is always one of three characters ('S', 'B', or 'U') as
> defined by
> the program that feeds this table.
* [EMAIL PROTECTED] aka Delmar
> I am using mysql 3.23.58-max. Want to create database
> Entered
>
> mysql>CREATE DATABASE[IF NOT EXISTS] db_anyname
> --
>
> -
>
> it gives me response of too many paramaters. Can
* Chris W
> I have two tables with a one to many relationship: boys and their toys.
> I want to know if there are any advantages or disadvantages for each
> of the following two ways to create the tables. I am mainly interested
> in performance. Either way the insert and select queries aren't a
* Aleksandar Bradaric
> >> select key, desc, value
> >> from your_table t1
> >> where value = (select max(value) from your_table where desc = t1.desc)
>
> > Anyway, when i execute this query, i get an error near 'select
> > max(value)'... :(
>
> It's because the subselects are supported from ve
* Alaios
> with myIsam? Does not check about integrity?
That is correct, the myisam table handler does not support foreign key
constraints. It does of course support foreign keys, but not foreign key
constraints, consequently the foreign key itegrity is not checked for myisam
tables.
> Mysql 3.2?
* Ville Mattila
> I have a table containing weather reports of different types and cities.
> The structure is following:
> - type
> - city
> - time
> - report
>
> Which kind of query should I use to select the latest reports of
> specified cities. I mean, if I had three different types of repor
* Soheil Shaghaghi
> Hello everyone,
> I need help with MySQL coding in php please if anyone can help.
I can try. :)
> I have 3 tables:
> -users, where the user info is stored.
> -awards: contains the list of all the awards for each user
> -award_types: contains different types of award
> The tab
* Bjoern Wuest
> I work on this problem for three days now and could not find any
> tip in any manual, book, tutorial or search engine.
>
> I have the following problem:
>
> Table1 'pl':
> +---+---+
> | p | o |
> +---+---+
> | 1 | 1 |
> | 2 | 1 |
> | 3 | 2 |
> +---+---+
>
> Table2 'ln':
> +---
* Roland Niederbrucker
> from the following Product-table
>
> ProductId
>
> MarketId
>
> CustomerId
>
> Type
>
> Price
>
> ...
>
> i would like to get the three highest and lowest prices
>
> for each group of ProductId,MarketId & Type.
>
> How could i do that ???
Do you use a programming language,
* Terry Riley
> Currently running 4.0.17 InnoDB on XP/Apache 2.0.47; client wants to
> investigate using capability for stored procs in v5, but doesn't have
> another machine on which to experiment. Can these two be run on the same
> machine (though not at the same time)?
You can run them on the s
* Dennis Strickland
> Just started using MYSQL. And in doing some reading about MYSQL I read
> that MYSQL does not support nested Selects.Is this true?
Depends on your definition...
The most used version (3.23) does not support nested selects.
The current version (4.0) does not support nested
* Gohaku
> I was just curious if there's a shorthand way of replicating a Table
> Schema.
> I use the following to create a new Table with the same schema.
> >create table new_table ( select * from table);
> >delete from new_table;
You can avoid the DELETE by specifying a non-true WHERE clause:
* Caroline Jen
> In case that a user has multiple roles; for example,
> John Dole is both author and editor,
>
> 1. I should have two rows for John Dole?
>
>John Dole author
>John Dole editor
>
>or. I should have only one row and use comma ',' to
>
>separate the roles?
>
>
* Veysel Harun Sahin
> The two columns of my table are name and city. I am trying to do
> a list which contains only the different names. This can be done
> this by distinct keyword. But all the same names which have
> different cities also have to be included in my list. So I can
> not do this wit
* Seamus R Abshere
> i am developing a photo gallery with php4/mysql4.0 that uses
> faceted classification.
>
> -my tables:
> photos(photoid)
> metadata(photoid,facetid)
>
> -to select all of the photoid's that are associated with either
> facetid 1 or 2:
> SELECT DISTINCT photos.*
> FROM pho
* Carlos J Souza
> Please i need comments about future of MySQL with .NET Plataform
> introduction.
If find this question a little strange... afaik .NET is a development
framework[1], while MySQL is of course a database server. The relation
between the two is only indirect via some programming lan
* Carlos J Souza
> Mysql 5.x is more quick than 4.x ?
This may seem like an easy question, but it is not.
I suppose you know the current stable version is 4.0.x, version 5.x is a
development version in an 'alpha' state. I have not tried version 5 myself,
and I am not one of the developers. This i
* Rory McKinley
[...]
* Odhiambo Washington
>> I have a query that executes well when run on MySQL-4.x, but not 3.23.x:
[...]
> I can't see what is throwing the syntax error..p'raps I am just
> being dense.
"Note that INNER JOIN syntax allows a join_condition only from MySQL 3.23.17
on. The same i
* Armin
> I've got two problem with mysql , maybe it is not a real
> 'problem' but i need help hardly ! :)
>
> 1 > in a table , we got many record ( 1400 ) , some of them are
> equal , i want to delete just one of them , in other word , i don't
> want two record equal .
Take a look at SELECT
* Hassan Shaikh
> How do I change datetime from one time zone to another? I've a
> column in one of my tables having the type DATETIME and I need to
> show date AND time to end-user based on his/her preference.
The date/time returned by the server is in the timezone of the server. If
you need to c
* Jochem van Dieten
[...]
> > The $usertimezone contains an integer between -12 and +12,
> > representing the offset in hours of the user timezone compared
> > to the server timezone. A user in the same timezone as the
> > server would have $usertimezone=0.
>
> Some locations have timezone offsets
* Hassan Schroeder
> > LAST_INSERT_ID() is connection specific, so it is safe from the
> > concurrency issue.
>
> Note: "safe" may not apply if you're using connection pooling :-)
In what situation is this unsafe? In general, you would not call
LAST_INSERT_ID() without first having done an INSERT
* Hassan Schroeder
> > In what situation is this unsafe? In general, you would not call
> > LAST_INSERT_ID() without first having done an INSERT in the
> > same session, and even with connection pooling you would usually
> > use the same connection for all statements related to a session.
> > What
... and of course the _point_ of connection pooling: one assumes that there
is overhead involved connecting to the server, thus you would avoid a lot of
"connect/one-small-session/close" and instead have fewer
"connect/many-small-sessions/close". It is relatively fast to connect to
MySQL, making c
* Jochem van Dieten
> > Woudn't the "proper way" be the way that leads to a result you can live
> > with? Of course support in the server would have been better,
> > but why can you not use a mechanism as described above?
>
> Using AT TIME ZONE is the way supported by SQL:1999, which makes
> it the
* Hassan Schroeder
[...]
> OK, but the "user" here is the servlet container (Tomcat), *not*
> the human end user.
That should not make a difference, as seen from the server a client is a
client.
> As would temporary tables, which is why I stopped using them for
> request-specific data :-)
Right.
* Hassan Schroeder
[...]
> Not errors, just the same temp table being shared across end
> user requests.
ok... If you did this:
- create temp table
- use temp table
- drop temp table
for each session, I would expect it to work. (atleast until a session
crashes before it drops the temp table.)
>
* Hassan Schroeder
> Roger Baklund wrote:
>
> > ok... If you did this:
> >
> > - create temp table
> > - use temp table
> > - drop temp table
> >
> > for each session, I would expect it to work. (atleast until a session
> > crashes before i
* Donal Murtagh
> My DB consists of INNODB tables, such as...
>
>
> CREATE TABLE user
> (
> name VARCHAR(255) NOT NULL
>
> ) TYPE = INNODB;
>
>
> The NOT NULL qualifier doesn't have the effect I expected. Although I
> can't do this...
>
> INSERT user VALUES (null);
>
>
> I can do this:
>
> INSERT u
* Hassan Schroeder
> Roger Baklund wrote:
>
> > Ouch. Very special, imo... this means the connection is
> > re-negotiated for each statement? Sounds strange. Maybe the
> > client connection is 'virtual' or 'by proxy', so that multiple
> > users a
* Harald Fuchs
[...]
> > You could also store the number of halfhours.
>
> Nope. Chatham Island has an offset of +12.75 hours.
Yeah, and Kathmandu is +5.75 hours.
Better avoid customers from Chatham Island and Kathmandu, then... ;)
Seriously, I have implemented a timezone system once, but we on
* Hassan Shaikh
> Thank you for your informative coverage regarding the captioned.
> According to your recommendations I've created a separate location
> table which contains time zone difference in (+/-) minutes. As per the
> server, my assumptions is that it's located somewhere in California,
> U
* Segis-Eresmas
> I have a table with a Text field (with texts) and Fulltext index. When
> I search a word (...) f.e. 'with match...against...', How can i do it to
> see the line and the line number of the text in that text-field?
There is no such functionality in mysql, you would have to impleme
* Aaron Gerber
> I'm new to the list, hope this is the correct mailing list.
It is. :)
> I have a new installation of MySQL 4.0.16. Default binary installation
> (apt-get). It's running on linux (morphix .4).
>
> Locally, I can connect to the MySQL server
> > mysql -h localhost -p
You are not
* David Hutchison
> I am trying to ascertain the table to which each column in a MySQL
> record set belongs in a relational search query. There may well be
> duplicate column names across tables.
>
> How can I query MySQL to tell me the parent table for each column in
> the record set? Thanks
* Matthew Stuart
> I am using version 4 of MySQL and the people who I am told to use to
> host the site are running 3 on the server I will be using.
This is probably not so unusual. 3.23.x hopefully, and x should be as big as
possible...:
3.23.47 was the last version released in 2001,
3.23.54 was
* Asbjørn Konstad
> Ive spent some day(s) probing the web to find a solution to this problem:
>
> A table-column for storing currency > float(10,2).
>
> As my users are punches the currency value like this 255,55,
> with a comma as decimal point, MySQL stores this value as zero (0.00).
>
> I qu
* Richard Davies
> I recieve measurements for a product sometimes in inches, sometimes in
> centimeters.
>
> These are stored in table1
> int not null primary key, measurement1 int, measurement2 int, type
> varchar(255)
>
> I need to extract data from this table and store it in another
> table with
* Mike Johnson
> From: Lewis, Jason [mailto:[EMAIL PROTECTED]
>
> > Didn't know if anyone else might need this but I was given
> > the solution.
> >
> > SELECT * FROM tablename
> > ORDER BY MemberLevel='Platinum' DESC,
> > MemberLevel='Gold' DESC,
> > MemberLevel='Silver' DESC,
> > MemberLe
* [EMAIL PROTECTED]
> I am beginning in mysql, and I do not obtain to create a table
> with a space column.
> some friend could help me?
>
> mysql> CREATE TABLE g1 (p1 GEOMETRY);
> Error 1064 :
The error message got lost in the mail. Beware that spatial support is
introduced in mysql version 4.1,
* Antonio De Luna
> I've a second look to de csv file and the format of the date is
> 09/14/1988, so I think it's easier to load it to the mysql date
> format, could it be done using mysqlimport, or LOAD DATA INFILE ??
You can read it into a varchar column and fix it later using something like
th
* Matthew Stuart
> Right having just got to grips with the mysqldump command, I would like
> to be able to know how to import the database back in to MySQL should
> anything happen to my PC.
Good thinking. :)
> Does mysqlimport have to be done in the command line window like
> mysqldump, and if s
* Matthew Stuart
[...]
> SELECT *
> FROM tbl_allarticles
> WHERE fld_headline OR fld_summary OR fld_body LIKE '%userinput%' AND
> fld_show = 1
This statement does not do what you probably intended it to... the above is
similar to this:
WHERE
fld_headline+0 != 0 OR
fld_summary+0 != 0 OR
fld_
* Russell Michell
> I was wondering if it's possible to perform an "elseif" in SQL Using MySQL
> 3.23.49-log running on Debian Linux?
It sure is. See below.
> My System:
> --
>
> * MySQL 3.23.49-log
> * Debian Linux
> * PHP 4.2.1
>
> The Logic:
> --
>
> IF condition1 - THEN query
* sulewski
[...]
> What I need is all records in table 1 that will
> not link to table 2 such that relid=rid and vid=46
Sounds like a job for LEFT JOIN...?
Join to the rows you do NOT want with a left join, and put as a condition in
the WHERE clause that a joined column IS NULL. Something like th
* dan
> I'm trying to query a database of speed test results for display on a php
> page. The results are fully-qualified machine names, often very
> long. What I'd like to do is trim it down so only the main domain name
> is left for display: for example, '68-65-69-187.vnnyca.adelphia.com'
>
* Ron McKeever
> I thought update is for existing records and insert is to add new records?
That is correct.
> My Scenario is if two users open an existing record with data
> already in the fields. They then add some information to the
> end of a field with data.
They "add information", you say?
* Tobias Asplund
> On Tue, 20 Jan 2004, Marco Paci wrote:
>
> > Since the process of inserting a new record and reading its PK field
> > value is a two step process implemented by:
> > 1) insert into tablename (columnnames) values()
> > 2) select last_insert_id()
> > ,and since because of the a
1 - 100 of 752 matches
Mail list logo
