As i am using MySQL in my project and i need and
command which is equivakent to (TABLOCKX HOLDLOCKX) in
SQLServer to lock a table while opening itself in
MySQL using Visual C++.
Please respond me soon as it is very urgent for me
Regards
Phani Kiran.A
=
Bye bye
Phani Kiran.A
Hello all
please respond to my address to, I`m not in the list!
Look at this simple code:
SELECT
FLOOR(5000 * 0.112) AS A,
FLOOR(5000 * 11.2 / 100) AS B
/* why MySQL returns A = 560 and B = 559 ? */
I`ve tested either:
SELECT
FLOOR(5000 * 0.112) AS A,
FLOOR(5000 * 11.2 * 0.01) AS B
/* why
Luc,
Luc Foisy wrote:
MySQL version 3.23.32
(please don't ask me to upgrade to the newest version of mysql as an answer)
I'm very sorry but an upgrade seems to be necessary:
if I recall this correctly we had to upgrade to 3.23.33 a year ago or so
because the changelog pointed towards a
Description:
Hi!
My name is Ales Perme. A college of mine Samo Login gave me this adress, which was
given to him by Monty, to report MySQL bugs to. The first bug report today from me is
connected with replication.
Our production comprizes of Windows and Linux machines. MySQL verson we are
Description:
Hi!
My name is Ales Perme. A college of mine Samo Login gave me this adress, which was
given to him by Monty, to report MySQL bugs to.
Production configurations:
1. Windows NT 4.0, Service pack 6a, MySQL 3.23.36
2. Slackware Linux, kernel version: SMP 2.4.18, MySQL
I'm a little bit confused about what EXPLAIN is saying about a query
I'm doing with an ORDER BY clause. I've read and re-read the parts of
the manual about how ORDER BY is optimized, but it won't sink in to my
thick skull for some reason.
I've got an index on a column called price, which is an
Greetings,
I'm having a real problem with this one, so I hoped I could seek some
guidance from the guru's inhabiting the mailing list, and then hopefully in
the future I can offer some assistance myself... (Skip down four paragraphs
if in a hurry!)
My wife, who always wanted her own bookshop,
Hello mysql,
Hello
What is .. the Got error 127 from table handwler
Pl send me error table ...
My english is very bad sory
--
Best regards,
maxim mailto:[EMAIL PROTECTED]
-
Before
root,
Thursday, April 4, 2002, 9:07:43 PM, you wrote:
r When compiling Mysql on a Dec 3000 OSF1 V4.0 I get the following error:
r sql_yacco.yy:719: Parse error before '}'
r sql_yacco.yy:1462: Parse error before '}'
r sql_yacco.yy:1689: Parse error before '}'
r sql_yacco.yy:1723: Parse error
Dan,
Friday, April 05, 2002, 3:21:46 AM, you wrote:
DE I tried to add a user to my mysql system for the MTA (exim) but am having a
DE hard time making it work.
DE I used grant to give exim permissions:
DE grant ALL PRIVILEGES on exim.* to exim@localhost IDENTIFIED BY PASSWORD
DE exim pw;
DE
maxim,
Friday, April 05, 2002, 2:35:01 PM, you wrote:
m What is .. the Got error 127 from table handwler
m Pl send me error table ...
$ perror 127
Error code 127: Unknown error 127
127 = Record-file is crashed
You can try to repair your table using myisamchk
or REPAIR TABLE
Marnix,
Friday, April 05, 2002, 10:15:56 AM, you wrote:
MV I am setting up a mysql database and have a questions about users.
MV I would like everybody to have the possibility to consult the database
MV without having to introduce a user and /or password (even not showing the
MV screen for user
prajak,
Friday, April 05, 2002, 7:50:44 AM, you wrote:
pp mysql select distinct(nexthop) ip from NameRoute
pp where OwnerIP='10.0.1.1' and
pp nexthop not in (select ip from NameIP where
pp OwnerIP='10.0.1.1');
pp ERROR 1064: You have an error in your SQL syntax near
pp 'select ip from NameIP whe
Syamala,
Friday, April 05, 2002, 7:30:47 AM, you wrote:
SS 1. Is authentication check based on user table in mysql database.
user, db and host tables are used for access control.
SS 2. If there is a unix user, then only giving password through grant
SS command will suffice ..How the
Satyanarayana,
Thursday, April 4, 2002, 9:53:53 PM, you wrote:
SVR I have installed the source code of version 3.23.47, the most stable version.
The most stable version is 3.23.49, not .47.
SVR I am working on Redhat linux 7.0 version.
SVR I have complied it, made some changes (have
Paul DuBois wrote:
You need to create another table that has a row for each date in the
range, then use that table in a LEFT JOIN to your original table
to find rows in the date table that are not represented by your original
table.
Thank you Paul, your sql table building script and
I have got a backup script that locks the MySQL tables then use cp(unix) to
copy the tables.
It then tar, then zips them up.
So my queston is what is the minimum privileges that this MySQL back user
needs just to lock tables?
Thanks
Simon Green
--
Live
Anyone seen this yet
http://www.theregister.co.uk/content/53/24714.html
good advert for MySQL if it's true!? (if you want a commercial grade, fully cross
platform database, then get MySQL)
Bob Cross.
Spam filter bypass: mysql database table query
Disclaimer: my opinion and no one
Cute story...but I have to agree with the Register when they state also
in the article, For the record, can we just add that few subjects are
as tedious or overrated as ideological purity?
-Original Message-
From: Robert Cross [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002
From: Richard Spangenberg [EMAIL PROTECTED]
Can mySQL handle... ...as well as Oracle.
MySQL is different than the big databases like Oracle, Informix, etc. MySQL is
comparatively small and fast, also cheap. As such, it doesn't come with all of the
bells and whistles that others might. You
[EMAIL PROTECTED] wrote:
I don't mean to start an opinion war, but ...
Can mySQL handle many processors, many servers (clustering), load
ballancing, etc as well as Oracle. Or should one use Oracle (some other
database) for large volume high response requirements. Is mySQL too basic
for
hello,
mysql doesn't support sub-select yet...maybe in 4.1 ;)
mysql select distinct(nexthop) ip from NameRoute
where OwnerIP='10.0.1.1' and
nexthop not in (select ip from NameIP where
OwnerIP='10.0.1.1');
ERROR 1064: You have an error in your SQL syntax near
'select ip from NameIP whe
re
hi,
in perl: [very simple code]
my $stime = time;
prepare();
execute();
fetchall_array_ref();
my $etime = time;
my $ftime = $etime - $stime;
print Your query took $ftime seconds\n;
stupid filter: sql, query, mysql, db, table, select, insert, update, delete,
join, create, left join,
I don't mean to start an opinion war, but ...
Can MySQL handle many processors, many servers (clustering), load
ballancing, etc as well as Oracle. Or should one use Oracle (some other
database) for large volume high response requirements. Is mySQL too
basic
for these capabilities?
Pros
Thanks to all the reponders. Just what I needed!
sql, query = filter pass
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Since you are writing out the file, you must select which character to
ESCAPE with. How would you expect mysql to choose?
-Original Message-
From: Cliff [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 11:46 PM
To: [EMAIL PROTECTED]
Subject: Escaped by 2 things?
Short and
Actually, according to the objective eWeek test results at the link
provided in another reply, the gap between Oracle 9i and MySQL 4.x is
rather slim...
I will look forward to hearing the response of the
well-informed to this.
However, my impression is that while the answer, for the very
For what a newbies opinion may matter,
I breifly worked with Oracle, and am working with MySQL. Fact, as it may
be, I will never look for or take a job where they are using the P.O.S.
Oracle. Oracle is not stable enough, it bombs if you make one misleading
query. MySQL just says eh, try
I have a table whose schema contains:
id INTEGER AUTO_INCREMENT,
gen_time TIMESTAMP,
rec_time TIMESTAMP,
repeats INTEGER DEFAULT 0,
PRIMARY KEY (id),
INDEX (rec_time))
When I do an:
UPDATE table SET repeats=repeats+1
gen_time gets updated as well:
mysql select id, gen_time, rec_time,
I'm currently running MySQL for a big, fast app without
problems. BUT:
I'm in the middle of specifying a new application with a high
load, and I'm consideing looking for alternatives to MySQL
because without InnoDB, it gets really slow on tables
with frequent updates and reads (no row
I'm having a bit of a problem trying to get MySQL version 4.0.1-alpha-max-nt
binary version
to accept The Command - Line Tool to run a script to create a table.
My operating system is Windows 2000 Professional. I can connect with
MyODBC-3.51.02.exe without any problem and run successful
At 21:45 -0800 4/4/02, Cliff wrote:
Short and simple, is it possible to escape by two different parameters? This
used to work:
I think you are mistaken. I just checked the grammar files for 90
versions of MySQL, and that syntax isn't legal in any of them.
I don't see how it could be legal,
just wanted to add another category of comparison:
mysql is fast, reliable and scalable. that's a fact! we don't
need to discuss this anymore.
BUT: the sql-set is too limited for most of the real use cases
out there. just think of the missing sub-selects or
multitable-updates/deletes or stored
No, this is NOT a bug.
According to the manual (you read it, right?), TIMESTAMP is created so that
when a record is UPDATEd or INSERTed, the time of the change is entered into
the record. If you want a date that does not changem use the DATE fiel
-Original Message-
From: Hihn Jason
At 18:33 +0200 4/5/02, Hihn Jason wrote:
I have a table whose schema contains:
id INTEGER AUTO_INCREMENT,
gen_time TIMESTAMP,
rec_time TIMESTAMP,
repeats INTEGER DEFAULT 0,
PRIMARY KEY (id),
INDEX (rec_time))
When I do an:
UPDATE table SET repeats=repeats+1
gen_time gets updated as well:
Of
From: Hihn Jason [EMAIL PROTECTED]
I have a table whose schema contains:
id INTEGER AUTO_INCREMENT,
gen_time TIMESTAMP,
rec_time TIMESTAMP,
repeats INTEGER DEFAULT 0,
PRIMARY KEY (id),
INDEX (rec_time))
When I do an:
UPDATE table SET repeats=repeats+1
gen_time gets updated as well:
At 10:29 -0600 4/5/02, Lenny Sorey wrote:
I'm having a bit of a problem trying to get MySQL version 4.0.1-alpha-max-nt
binary version
to accept The Command - Line Tool to run a script to create a table.
My operating system is Windows 2000 Professional. I can connect with
MyODBC-3.51.02.exe
Yes I did, but it is very long, and it was very long ago.
Could someone please explain to me why this was done? It seems more
confusing to do this than to not do this. Why when you can just say SET
field=NOW() in the update statement would anyone build this auto update of
timestamps in? (the
According to the manual, the DATETIME field can be stored As a string with
no delimiters in either 'MMDDHHMMSS' or 'YYMMDDHHMMSS' format, provided
that the string makes sense as a date. So this should provide you with the
format you require.
TIMESTAMP was created so that we would NOT have
Agreed. As soon as subselects and the Stored Procedure support is
complete I can almost ditch MSSQL entirely...
BUT: the sql-set is too limited for most of the real use cases
out there. just think of the missing sub-selects or
multitable-updates/deletes or stored procedures. i worked with
I've been having an off-list discussion with gordon52 at slingshot dot co
dot nz, who is having a problem
posting anything to the list. Apparently when he sends something, the list
manager thinks it's
got attachments and bounces it. Now when he sends me a message - no
attachments.
Can
Hey guys,
We're having a weird authentication problem. We have a .jsp (on box1) that tries to
connect to a MySQL database (on box2). The privileges have been set to give insert,
update, delete to the user.
GRANT select, insert, update
on d_name.*
to d_user IDENTIFIED by d_user;
It works
At 10:43 -0600 4/5/02, Paul DuBois wrote:
At 10:29 -0600 4/5/02, Lenny Sorey wrote:
I'm having a bit of a problem trying to get MySQL version 4.0.1-alpha-max-nt
binary version
to accept The Command - Line Tool to run a script to create a table.
My operating system is Windows 2000 Professional.
in perl: [very simple code]
my $stime = time;
prepare();
execute();
fetchall_array_ref();
my $etime = time;
my $ftime = $etime - $stime;
print Your query took $ftime seconds\n;
stupid filter: sql, query, mysql, db, table, select, insert, update,
delete,
join, create, left join,
Hello-
Is there a console app that exists for windows 2000 pro such that i can
access mysql server(at home on windows 2000 pro machine) with it from work?
Can i use the one that is ported with the server? The server is not running
on port 3306. Thanks for the help.
Brian
then you need to fix your filters
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 10:55 AM
To: john
Subject: Re: Insert ?'s
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass
We are writing a book about MySQL. There will be emphasis on using MySQL with
perl/php, .net java. The publisher needs lots of emphasis on SPs and nested
subqueries. We need to be able to write about implementing biz rules using table
constraints, which means FKs. Your site says 4.1 is to
No problem Paul, I understood what you meant.
Lenny Sorey
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Lenny Sorey [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, April 05, 2002 11:17 AM
Subject: Re: Command Line Tool
At 10:43 -0600 4/5/02, Paul DuBois wrote:
At
5:40 a.m.
MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL
MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL
(is that enough, to get past the filter ?)
(sent this via the website, got a reply re the filter...)
Original #2 message
On Friday 05 April 2002 10:16 am, john wrote:
Insert into Sellers (Logo) values ('images/helilogo.jpg') where Seller_ID =
1;
that is the command that I am attempting to issue, but states the where...
is wrong. What's wrong with that?
It isn't valid SQL. You are, I think, trying to do an
At 11:17 -0600 4/5/02, Henning, Brian wrote:
Hello-
Is there a console app that exists for windows 2000 pro such that i can
access mysql server(at home on windows 2000 pro machine) with it from work?
Can i use the one that is ported with the server? The server is not running
on port 3306. Thanks
no, you need to follow the list rules when posting. That's why you see a
lot of posts that have a line at the end that just says
mysql,sql,query
or something similar.
And to answer your question, it appears that you are actually attempting
an UPDATE, not an INSERT? i.e.
UPDATE Sellers
SET
On Friday 05 April 2002 10:29 am, [EMAIL PROTECTED] wrote:
We are writing a book about MySQL. There will be emphasis on using MySQL
with perl/php, .net java. The publisher needs lots of emphasis on SPs and
nested subqueries. We need to be able to write about implementing biz rules
using
Then you need to fix your messages so that it will pass thru the filter.
That statement is wrong because INSERT INTO statement inserts a new record
to the table so you can't have a where restriction. If you wanna change the
logo value where seller_ID=1 then use UPDATE TABLE syntax. See:
Hi,
5:40 a.m.
MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL
MYSQL SQL
MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL
MYSQL SQL
(is that enough, to get past the filter ?)
(sent this via the website, got a reply re the filter...)
Perhaps
Do not send me any more mail , please.
--- Paul DuBois [EMAIL PROTECTED] a écrit : At 11:17
-0600 4/5/02, Henning, Brian wrote:
Hello-
Is there a console app that exists for windows 2000
pro such that i can
access mysql server(at home on windows 2000 pro
machine) with it from work?
Can i
do not send me mail
I am not your friend.
Thank you
--- Gregory Junker [EMAIL PROTECTED] a
écrit : no, you need to follow the list rules when
posting.
That's why you see a
lot of posts that have a line at the end that just
says
mysql,sql,query
or something similar.
And to
why do you have to pay? I was under the impression
innodb was free as well...
-Original Message-
From: Steve Rapaport [mailto:[EMAIL PROTECTED]]
Sent: 05 April 2002 08:33
To: [EMAIL PROTECTED]
Subject: Re: MySQL Power ?
I'm currently running MySQL for a big, fast app without
I am using MySQL Manager to manage a database created with the tool a week or so ago.
Worked on the database last night and all was fine. Opened up mySQL Manager today and
any change to the tables (add or edit of columns) gives the error below:
Error on rename of:
'.\dbname\tablename.MYI' to
I agree with Chris...
Writing a book on features that do not exist yet is asking for trouble.
-Original Message-
From: Christopher Thompson [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 12:00 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: MySQL Book
On Friday 05
6:35 a.m.
(writing this on the web)MYSQL :-)
Hi - in my first PHP file, :-
- earlier this week, Ive posted a few messages about my PHP webpage which Roger
Baklund was able to help me start off..
Anyway, - Ive been to some MySql Help sites found some useful commands, which
ive been able to
um, I don't know you, I have no idea why you would take such an
attitude, and if you'll look closely, as a rule I send email to the
list, not to individuals. If you don't want emails from me filter me out
or unsubscribe from the list.
-Original Message-
From: de Chateau Thierry Axel
Hi!
- Original Message -
From: [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Friday, April 05, 2002 8:51 PM
Subject: MySQL Book
We are writing a book about MySQL. There will be emphasis on using MySQL
with perl/php, .net java. The publisher needs lots of emphasis on SPs
Steve,
With InnoDB, I'm sure this problem goes away, but as soon as we
go to InnoDB, we have to pay for backups and support,
which means we start looking around at 'pay' solutions.
I must correct that MySQL technical support is not free, whether you use
InnoDB or not. Note also that
Hi!
- Original Message -
From: Rodrigo Gonzalez [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Friday, April 05, 2002 8:59 PM
Subject: InnoDB
First of all excuse my english...I hope someone can understand me
I am thinking in converting from MyIsam to InnoDb tables.
How can I download this version?
Regards
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 05, 2002 4:07 PM
Subject: Re: InnoDB
Hi!
- Original Message -
From: Rodrigo Gonzalez [EMAIL PROTECTED]
Newsgroups:
Can you please tell me, is it possible to do queries that join MySql tables
that are in different databases?
I have a couple of Delphi database programs that use Paradox tables. I'd
like to move them over to something else that is faster. These programs are
set up so that they have a shared
I have seen many people saying that InnoDB is a great deal, that InnoDB
rocks, etc. and I am concerced about how much better InnoDB is compared to
MyISAM tables. Can someone tells me wich one is better ? I know that InnoDB
have foreign keys support, but I deal very well without then since now.
Hi,
actually I know about current problem in 3.23.49a on linux at least -
there's something weird with the cache I think. I've posted some reports
with my ideas to the bugs list already. For you:
I can get rid of such problems whenever they appear by doing :
mysqladmin flush-tables
They
Hi,
Does InnoDB use some form of group commit like BerkeleyDB and Postgresql?
In Postgresql you can specify a COMMIT_DELAY to force a wait before the
commit returns. Disk IO to the log files can be reduced quite alot if you
tweak this setting, and it can be very useful when tuning batch-like
here's the scoop:
Basically I'm listing pieces of information from a two-key table and I am
not getting the information I want.
BACKGROUND
Consider this sample table (which although goofy, does illustrate what I'm
attempting to do)
SELECT clientid, revision, name, address FROM clients;
Hi, all:
I am trying to use JDBC to connect MySQL, and use JDBC
to config the MySQL. As default root@default has the
privilege to do everything. So I use JDBC to connect
with root. I got error. [EMAIL PROTECTED]
failed.
I read a note said that this only happen to Redhat.
Any suggestion how to
[EMAIL PROTECTED] wrote:
Here is a FABRICATED table I have TYPED OUT to demonstrate the information
that I'm looking for.
I'm looking for a single query that can produce:
+--+--++---+
| clientid | revision | name |
The table has
mysql select count(*) from repository;
+--+
| count(*) |
+--+
| 5673838 |
+--+
records inside.
1. I get table a table crashed whenever I try to fix it or check it with MYISAMCHK
using -r, -o or -f parameters. And the table is
Hi,
Victoria Reznichenko wrote:
VR Martin,
VR Wednesday, April 03, 2002, 5:45:00 PM, you wrote:
VR
VR MM would anyone please explain me what are these error messages?
VR
VR MM 020327 12:29:26 mysqld started
VR MM 020327 12:29:26 Warning: listen() on TCP/IP failed with error 98
VR MM
Is there any sort of mysql load monitoring tools out there? If not how
can I get how many query's per/sec, users, etc, which I can log to a
flat file or db, and I could run rrdtool against it to get graphs?
-Jason
-
Before
(and I say again...)
-Original Message-
From: de Chateau Thierry Axel [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 1:15 PM
To: Gregory Junker; [EMAIL PROTECTED]
Subject: RE: Insert ?'s
do not send me mail
I am not your friend.
Thank you
--- Gregory Junker
Hi,
Is it possible to print a table from the database in
the same format as you can see it. I tried to export a
table to an outfile, but i dont get the column names.
I am using Linux so i don't have a print screen
option,
I think you can do using a software package called
EMS MySQL Manager,
At 01:54 PM 4/5/2002, you wrote:
I have seen many people saying that InnoDB is a great deal, that InnoDB
rocks, etc. and I am concerced about how much better InnoDB is compared to
MyISAM tables. Can someone tells me wich one is better ? I know that InnoDB
have foreign keys support, but I deal
At 10:16 AM 4/5/2002, you wrote:
Actually, according to the objective eWeek test results at the link
provided in another reply, the gap between Oracle 9i and MySQL 4.x is
rather slim...
Gregory,
A point that was sadly missing from that article was what was the
cost to create the Oracle
Lenny,
You might find it easier to use a GUI like MySQL Front from
http://www.anse.de/mysqlfront/. It will save you a great deal of time. Just
enter (or copy and paste) the SQL into their query window and press a
button. Editing your errors are also a lot easier. It is free or you can
Adriano Manocchia wrote:
Well, first off, I can't seem to get max_allowed_packet higher than 64
MB on the server using 3.23.x or 4.0.1. Changes made to /etc/my.cnf are
reflected in the system settings, but only up to 64 MB, then regardless
of what I put in there, it stays at 64 MB. But
Hello there,
anybody here has some background using InnoDB and MySQL replication feature
? If so, would you mind sharing those information with me ?
--
João Paulo Vasconcellos
Gerente de Tecnologia - NetCard
Tel. 3852-9008 Ramal 31
[EMAIL PROTECTED]
Hi,
Try to use tee command to log all the output into a file. It will have the
column names and everything you see in the screen.
See:
http://www.mysql.com/doc/m/y/mysql.html
Gurhan
-Original Message-
From: colin o [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 4:14 PM
To:
At 10:16 AM 4/5/2002, you wrote:
Actually, according to the objective eWeek test results at the link
provided in another reply, the gap between Oracle 9i and MySQL 4.x is
rather slim...
Gregory,
A point that was sadly missing from that article was
what was the
cost to create
Thanks Todd and Tyler for the encouragement,
When I searched on Mysql column types, I did not find any obviously suitable
for images. I do not suppose I can use VARCHAR, can I?
Also, I need to have very good performance on data retrieval and transport,
which means I also need to have maximum
-Original Message-
From: Phil Schwarzmann [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 4:02 PM
To: [EMAIL PROTECTED]
Subject: [PHP] MYSQL maximum query size?
Is there a maximum number of characters you can use in a query?
I have a giant query using the UPDATE command
On Friday 05 April 2002 2:54 pm, Zhao, Charles wrote:
Thanks Todd and Tyler for the encouragement,
When I searched on Mysql column types, I did not find any obviously
suitable for images. I do not suppose I can use VARCHAR, can I?
Use one of the BLOB types.
Note that if you are running a
mysql create table column_list (desc MYTABLE_NAME);
ERROR 1064: You have an error in your SQL syntax near 'desc MYTABLE_NAME)' at line 1
Anyone know how to make something like it?
-
Before posting, please check:
I believe it has to be like this:
create table column_list (MYTABLE_NAME DESC);
Thanks!
-Alex Big Al Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
Phone: 651-482-8779
Cell: 651-329-4187
Fax: 651-482-1391
ICQ:
-Original Message-
From: hong chen
Sent: Friday, April 05, 2002 5:32 PM
To: 'Alex Behrens'
Subject: RE: create tmp table of column list of a table for future use
No luck. Oracle and Sql Server have system tables to check.
mysql desc ATTRIBUTES;
Are you trying to create a new table with an existing table's structure only
? or with the structure and data? If you just wanna duplicate a table with
the data inside it you can use CREATE TABLE .. SELECT ... syntax. More info
is at: http://www.mysql.com/doc/C/R/CREATE_TABLE.html
IF you just
-Original Message-
From: hong chen
Sent: Friday, April 05, 2002 5:50 PM
To: 'Gurhan Ozen'
Subject: RE: create tmp table of column list of a table for future use
I am trying to check if a certain column exists before I try to select it from the
table.
in Oracle or Sql Server I would:
Here are a few easy philosophical questions for a change:
1) For performance or storage benefits, is there a difference between a
Unique Index and Primary Key?
2) Is there a reason why I should use Primary Key instead of a Unique Index?
3) Why isn't there a syntax for create primary index
Problem is I'm accessing mysql through scripting against a table
that may or may not have ID field,
select count(*) from (desc ATTRIBUTES) where Field ='ID';
if count(*) 0 then
select ID from ATTRIBUTES;
else
do something else;
end if;
-Original Message-
From: Gurhan Ozen
On Fri, 5 Apr 2002, BD wrote:
At 01:54 PM 4/5/2002, you wrote:
I have seen many people saying that InnoDB is a great deal, that InnoDB
rocks, etc. and I am concerced about how much better InnoDB is compared to
MyISAM tables. Can someone tells me wich one is better ? I know that InnoDB
have
Here are a few easy philosophical questions for a change:
1) For performance or storage benefits, is there a difference between a
Unique Index and Primary Key?
There can be only one primary key. There can be multiple unique indexes.
Primary keys cannot contain NULL values. Unique indexes can
I'm trying to write a query that will tell me how many abandoned carts
there are in a cart table I have.
each item in a cart is a record, so simply querying on records won't
work. What I need to count is how many distinct customerId's there
are. a sample from the table looks like:
cartItemId
It's not illogical at all. You often want (sometimes need) that field to
make sure a record has not changed when you go back to update the row. MS
Access (and others) uses this so as not to overwrite changes made since the
record was retrieved. You can't always rely on the client to set
rory oconnor [EMAIL PROTECTED] writes:
[...]
each item in a cart is a record, so simply querying on records won't
work. What I need to count is how many distinct customerId's there
are. a sample from the table looks like:
cartItemIdcustomerId productId
1944 244
1 - 100 of 115 matches
Mail list logo