Thought earlier that I could get by on just plain SQL.
Php needed. I'm getting a parse error on the if
line.
This is supposed to be a trigger then before
transaction counts the number of rows , id already
inserted, if exceeded , kick back error message , halt
transaction.
Not sure
How do I export from mysql into excel format?
Directly - use SELECT INTO OUTFILE and set up as a CSV, and open in excel
Indirectly - use a programming language and library to write an Excel
binary (php or perl with spreadsheetwrite_excel)
HTH
Jeff
--
MySQL General Mailing List
For list
Hmm... I use ASP.net, is there any instruction that I can use to use
ASP.net
to export into excel or is there another way?
Well, I know nothing of ASP.net, but you should be able to select from
mysql, then instantiate excel via COM to write the binary.
Jeff
How do I export from mysql
May someone please send me the link to download mysql Binary distribution
for the first time on windows XP, I have looked into mysql/downloads and
they only have X86.
Windows XP, and every other windows platform, runs on X86 architecture.
That is the download you want.
Jeff
--
I was wondering if anyone could answer a few questions for me. I have to
do
some research for a school project.
1. What is the user or connection limit for both versions of MySQL
(Database
Server and MaxDB)?
2. How much memory does MySQL take when started up?
3. Does MySQL take
Hi All
Could someone give me a clue or a snippet of PHP code I can test a romte
connection to my MySQL DB for my website please?
Just take the one you're currently using and replace 'localhost' with
'someotherserver.com'
$cnx = mysql_connect('someotherserver.com','uname','pword');
I am trying to get rid of duplicate user info entries in a database. I
am assuming that the email address is unique but other information, like
first name, last name, address, etc are not. The email field is not a
unique field in the database. I was trying something like the
following,
After spending days trying to make a PHP form for
editing my tables that actually works, I discovered a
wonderful script from www.dadabik.org. I haven't used
it online yet but I got it up and running on my
computer in about five minutes, and it appears to work
flawlessly.
There's just one
We're going through an upgrade to Novell 6.5 and would like to use mysql on
a single server to store info on who's upgraded the client and who has not.
Can the command line client only be installed on the Novell server to
connect to a foriegn mysql host? Its easy when its unix-unix, but don't
Thanks Jack and Jeremy.
But this is part of my application and I need to do
this automatically. I don't want to write a
server-client application to just to handle file
transimission and do pass the update cmd to local
server. Any idea? Thanks.
If you have ssh installed on both
No they don'tyour machine may be infected...I'd run a scan. or
download some malware fixers (adaware/spybot)
Jeff
http://www.mysql.com/portal/software/convertors/index-2.html
http://www.mysql.com/portal/software/item-266.html
Regards
Richard
--
MySQL General Mailing List
For list
Yesmy apologies...the OP made it seems like the main page. i didn't go
hunting..but i guess i should have
gerald_clark
I have just installed MySQL server v3.23.49-8.5 (downloaded from Debian
Packages Site) into my Debian v3.0r2 box! After finished installing, i had
followed the instruction here to change root's password but right after
this action, i can't login to mysql any more! I had also try to change
I intend to build up a web server that is based on Fedora Core 1.
Installation and configuration of Apache and PHP4 was pretty simple, but
there are some problems in configuration of MySQL. I installed the MySQL
server RPM included in the distribution.
Even in the MySQL pages it is mentioned
Is there any way to do the following? I get an error whenever I try this
(Invalid use of Group function).
Select Product, Sum(Qty)
From Inventory
Group By Product
Order By Sum(Qty) DESC;
This should work if you assign it an alias...it does for me on 4.018(not
exact query)
Select
n Tuesday 23 March 2004 02:15, [EMAIL PROTECTED] wrote:
tcp0 0 *:3307 *:*
LISTEN
It seems that the correct socket is used. Here is the output:
unix 2 [ ACC ] STREAM LISTENING 3303 private/relay
unix 2 [ ACC ] STREAM
I finally managed to install MySQL succesfully. I created a simple DB with
two
different tables. I also created a simple PHP script to list all DBs and
tables.
However, it seems that the PHP script cannot access MySQL server, because
the
following error message is displayed:
_
This
Hi,
-Original Message-
From: Elly Wisata [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 18, 2004 1:55 AM
To: [EMAIL PROTECTED]
Cc: 'BGLefty'
Subject: RE: php script for new database and user
I don't think php script can create database. But maybe I am wrong.
If I am, please
jose manuel
Hi can anyone tell me how to use php's mysql_last_id() or MySQL's
INSERT_LAST_ID
-
php's function is mysql_insert_id() and not mysql_last_id(), there is no
php function called mysql_last_id()...if you saw that in a manual, i'd
email the owner of the document.
Hey,
Thanks for replying.
I login with username root and a password I set in the ensim control
panel, it works perfectly.
I dont really know if I am in the mysql database...but there are a couple
of tables or dbs there...
What id are you using to create the table?
I guess root, coz thats what I
All - Running MySQL 4.0.17 under Red Hat 9, using MyISAM tables.
I'm trying to add the auto_increment attribute to column in a table that
already has a primary key defined. Here is the table I'm trying to
create:
CREATE TABLE IF NOT EXISTS dataTypes (
id int unsigned NOT NULL
Please how can I remove a RPM installation. I used
MySQL-server-4.1.1-1.i386.rpm to install MySQL, but how can I delete it.
--
if this was the exact package you installed with try
rpm -e MySQL-server-4.1.1-1.i386.rpm
you can also query for the installed packages with rpm -q
Hello,
I have a mysql database in which I run from a machine where I am
developing. I would like to take the contents of a specific database (plus
all tables) and copy all to another box (not networked). Could someone
point me out to the specifics of what I need to do, or where in the docs
this
you should be able to use STR_REPLACE.
update 02093_xdir_links SET title = REPLACE(*,,title);
hth
jeff
Bob Cohen
you should be able to use STR_REPLACE.
DOH. Sorry, there is NO STR_REPLACE its just REPLACE.
jd
update 02093_xdir_links SET title = REPLACE(*,,title);
hth
jeff
Bob Cohen
[EMAIL PROTECTED]To:
[EMAIL
wow, one post, two mistakes. how right you are. sorry.
update 02093_xdir_links SET title = REPLACE(\,,title);
you may/may not need to escape the .
hth
Jeff
[EMAIL PROTECTED]
I am really struggling with a mysqldump. I am trying to create a dump
of a complete database called csi_db01 and I am trying to save the dump
file to My Documents on the C drive.
I am sure I am doing right, but could somebody email me the full syntax
to use which comes after the mysql
if
Syed Ali
Unless i'm misunderstanding(highly possible)...if you are on the command
line, you are going to be seen by mysql as localhost and not allnet.com.
You'll only be seen as another host if you connect remotely. the webserver
running on the localmachine and the mysql client will be seen as localhost.
If that error is verbatim from the console, then DNS may be working, but it
is not who MySQL is acknowledging you as, is there a firewall in between
you and the MySQL server? looks like you'd need a grant for
202-63-167-192.exatt.com.
and i know its not working, but you really shouldn't post
since you're using PHP, you can also get this via the php function
mysql_insert_id(). directly after your insert, i think another insert would
be nearly impossible to get int he middle of these two.
$insert = mysql_query(insert stuff into table);
$last_id = mysql_insert_id($res_link); (resource
have you changed the directory to the mysql/bin directory? normally when
you get this error you're not in the correct directory. if mysql is in
C:\mysql you'll need to be in the c:\mysql\bin and then excecute C:\mysql
HTH
Jeff
is there a higher level directory that does not allow excecution? does it
work if you run it as root? can you 'vi /root/mysql/gwarancje.txt'?
just some thoughts
Jeff
i've used FROM_UNIXTIME with success. you can also supply a format.
http://www.mysql.com/doc/en/Date_and_time_functions.html
hth
jeff
email the form contents to yourself or write it to a text file and store
that on your server.
hth
jeff
Wesley Philpot
You should not need to restart , you will need to 'flush privileges'
though. has that been done?
Jeff
John Nichel
first part of your questionphpMyAdmin can export in XMLthe less
complex peice, in my mind...
www.phpmyadmin.net
[snip]
Is there a way to export/import MySQL tables in XML format?
[/snip]
Well Todd, it is a little more complex than this. How much do you know
about XML?
--
MySQL
This is exactly what i use as well.both tools have their benefits and
limitations
Julian Zottl
If most of my queries against a DB are goign to be related to when things
happened/within a date range... would it be more efficient to use
timestamps or datetime fields? I plan to index either column, as it will
be in many where clauses.
I'm currently still running 3.23.38 with plans to
This works just like doing it from table to table, just specify hte db
insert into dbname.tablename select * from db1.tablename where id 3;
HTH
Jeff
Subquerys don't become available until 4.1 Version 3.X does not support
them
From Mysql.com
For MySQL versions prior to 4.1, most subqueries can be successfully
rewritten using joins and and other methods. See section 6.4.2.11 Rewriting
Subqueries for Earlier MySQL Versions.
Also, if they
i believe you'll need to use a timestamp column, which will set to the
current date/time at each insert/update. I don't think you can set the
date default to a function.
You are also using a reserved word Date for your column name without
escaping it, i.e. `Date`, also you have two modify's in
On Wed, Nov 12, 2003 at 08:10:58PM -0600, Mike Blezien wrote:
Hello,
we've set up many displays using the Previous and Next simple linking
set up of search results. But now would like to implement the page number
style, IE. Previous [1] [2] [3] Next style format and was hoping
someone
if you want a windows client, get MySqlCC right off the home page
www.mysql.com. I'm using htis in the exact setup you mentioned.
a webclient? - http://www.phpmyadmin.net/home_page/
There are morethese are free.
hth
Jeff
You can use addslashes and stripslashes when inserting and selecting
respectively. addslashes will turn your name into O\'connel. and
stripslashes will bring it back to the displayable format.
check out
php.net/addslashes
php.net/stripslashes
hth
Jeff
You're almost there in how you worded your quesiton.
You'll need a join.
select tab1.test1, tab2.test1 from tab1 inner join tab2 on tab1.id =
tab2.id. -- this will get all columns where hte ids match.
to get all ids that are 40, add a where clause.
select tab1.test1, tab2.test1 from tab1 inner
SELECT article_num FROM $table order by article_num DESC LIMIT 75
hth
Jeff
Mark
mysqldump...lots and lots of options
http://www.mysql.com/doc/en/mysqldump.html
hth
Jeff
Erich C.
this should work
SELECT sku from [table] order by [key] desc limit 1
hth
Jeff
Hunter, Jess
to help the mysqld_safe 'finish' you'll need to append an '' to your
command, which will have the process start in the background and give you
your prompt back.
/usr/local/mysql/bin/mysqld_safe --skip-grant-tables
now you can hit the enter key, and you'll get your prompt back
you need to use $_POST['test1']
http://www.php.net/register_globals
php, by default has register_globals=off. for security reasons...so you'll
need to use $_POST, $_GET, $_FILES, $_REQUEST etc.
hth
jeff
I tend to agree with the past two posts that mysql is in fact relational,
and would like to add that if we are going to make blanket statements that
something IS or IS NOT that we qualify our responses. personlly i would
like to know why Martijn views it as being a non relational db, without
can you send the contents of your dumpfile up to this point. assuming its
line 118 of hte dumpfile and 21 of this build table query
Jeff
use timestamp_col = timestamp_col in your query, to override the NOW()
affect.
I just passed by this comment this morning
http://www.mysql.com/doc/en/DATETIME.html -- user comments at bottom of
page
hth
Jeff
SELECT DISTINCT(LEFT (product_number,5)) FROM products.
http://www.mysql.com/doc/en/String_functions.html
hth
Jeff
Personal
are you doing this insert in any sort of loop? if you emailed yourself the
final query, or printed it on the screen and then ran it directly into
mysql...do you get the same results?
Jeff
i googled your error and the first link looks like it may help
google - General error: Incorrect key file for table
www.vbulletin.com/forum/ showthread.php?t=5387goto=nextoldest
hth
Jeff
I have a query that is pulling user comments, supplied by via web
internface and creating a text file out of them. In these comments are all
sorts of carrige returns. I've tried stripping them out with the following
queries, but once imported into excel, the carrige returns are still there.
so
I have four tables that i'm trying to join together most are pretty
small(100-200 rows tops) and one, the Response table is 127,000 rows. The
query i'm currently executing is
SELECT Business_Unit.Business_Unit, Question.Text_Long, AVG(Response) from
Question
INNER JOIN Response on
I have two tables and am running a simple join between them to get
questions and their repsective response averages from a survey. The
question table has 49 rows and the Response table has 126,732. I'd like to
cut down on the time its taking to run this specific query...as i'll be
running many
ahhh yes, thanks for pointing that out. it was not origianlly designed as
such and then the codes changed. time is about the same though
Thanks
63 matches
Mail list logo
