| |
thread by: Andrew |
last post Jul 23 '05 by: Bill Karwin
Hello,
Rather complicated one im afraid.. (well for me anyway!) Background on
this one is that I have inherited a system that needs some
modification, have some basic sql knowledge but fear i've bitten off a
little bit more than I can handle.
I need to export some data which I am able to do as I have some
exporting software which can...
|
thread by: Support |
last post Jul 23 '05 by: Support
<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:w="urn:schemas-microsoft-com:office:word"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=Word.Document>
<meta name=Generator...
|
thread by: MLH |
last post Jul 23 '05 by: MLH
I am having failures processing the following command and I wonder
if you can tell me what I must do in order to have success. When I try
to run source mysql_dump.sql.txt ==> it is a problem for me.
1) I put the file in /home/mlh/public_html/credifree/sql_script/.
2) I made that directory my current directory
3) I typed mysql and...
|
thread by: MLH |
last post Jul 23 '05 by: MLH
On the subject of switching between virtual consoles to get
out of a 'hung' situation in the primary console...
What I have been doing is pressing LEFTALT-F4 to bring up
a 2nd virtual console, logging in as root and running poweroff
to close EVERYTHING down. All I really wanna do is terminate
the hung console session. Can I do that from the...
|
thread by: PW Herman |
last post Jul 23 '05 by: PW Herman
Does mySQL not like dashes or something? I seem to be getting the
following error:
"Unknown column 'etrans' in 'where clause'"
when I do the following query:
SELECT * from expense where etrans-num > 25
If I try:
|
thread by: MLH |
last post Jul 23 '05 by: Bill Karwin
I think I must be getting too old and my mind is failing.
I never knew browsers could double as word processors
or text editors. But recently I bought a book to assist in
my effort to launch an AMP application on a linux server.
I'm new to linux, Apache, MySQL and PHP. But I have an
application that's already been built, a linux box that's...
|
thread by: Joel Thacker |
last post Jul 23 '05 by: Joel Thacker
----OYSP2490997191EZZBTHJSS
Content-Type: text/plain;
Content-Transfer-Encoding: 7Bit
The new craze is finnally here - one of the bast
sites that can give you the things you've allways
wanted to get - watchees, repliccas to be correct,
of the bast brand s in the world! Impress you're lady
with tag heur, roleex, and more. You naame it - We...
|
| |
thread by: MLH |
last post Jul 23 '05 by: MLH
I have an sql script file that is supposed to create
a set of database tables for me. Supposedly I type
the following on my linux box and its all supposed
to work...
mysql (ENTER)
\. mysql_dump.sql.txt
When I type myslq <ENTER> I get a command prompt
that looks like this...
|
thread by: Mark Hargreaves |
last post Jul 23 '05 by: Duane Evenson
Hi,
Hopefully someone can help.
I am trying to establish (using a straight MySQL query in version 4.0.18)
the level of qualifications someone has, i.e. degree, postgraduate degree or
other.
To simplify things, I need to use only two tables, namely:
|
thread by: MLH |
last post Jul 23 '05 by: notbob
I am brand new both to linux and to mysql.
When I type mysql on my linux box, the mysql monitor
appears. There, I know how to type help and exit. that's
all I know. I need a book or online source that will teach
me to use the mysql monitor. Recommendations?
|
thread by: Ben |
last post Jul 23 '05 by: Ben
Dear MySQL experts,
I have a website that is using MS SQL Server 2000 with ASP scripting. I want
to switch over to MySQL, but I'm just sticking my toes in the water at the
moment to see if it makes sense.
One of my favorites things about MS SQL is being able to use the Enterprise
Manager as a GUI in constructing VIEWS that I later turn...
|
thread by: elyob |
last post Jul 23 '05 by: elyob
I've got multiple hotels listed in different towns in different countries in
a mysql database. When someone visits one, I add one to a field called
'clicked'.
What I want to do is select out the most popular towns from the database
based on this number of clicks, but this query doesn't seem to work ..
SELECT towns, country
from hotels...
|
thread by: yasaswi |
last post Jul 23 '05 by: Bill Karwin
I tried searching but to no avail. Does any one know when MySQL 5,
stable production release will come out? Also will the MySQL 5, stable,
production release include InnoDB engine?
Thanks,
Yasaswi
|
thread by: Frank Natoli |
last post Jul 23 '05 by: Frank Natoli
Is the internal format of the binary replication log files documented?
Answer appears to be "no" but would like to know for certain. Thanks.
|
thread by: Frank Natoli |
last post Jul 23 '05 by: Aggro
Decided to update my desktop with latest MySQL Server 4.1.10a and connector
3.1.6. Un-installed MySQL Server 4.0.21. Now mysql.exe is refusing to start
with error:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
Get same error when starting mysql.exe w/o user argument, except default
user is ODBC rather...
|
| |
thread by: Lorenzo Baloci |
last post Jul 23 '05 by: Lorenzo Baloci
Hi at all,
I'm an italian developer.
I'm developing a stand-alone windows application that needs to connect
to a MySql server.
The application is written in CA Visual Object, and for normal
connection use the libmysql.dll library and work very well.
For privacy issues I need to use ssl. The mysql ssl server works ok and
from linux (or with...
|
thread by: Martin |
last post Jul 23 '05 by: Martin
My installation of MySQL Administrator (Windows XP) has been working
just fine - until I installed QueryBrowser. Now, when I try to run
Administrator, I get an error message that says: Procedure entry point
myx_matchstring in libmsqlx.dll could not be located.
I subsequently re-installed MySQL Administrator and now it works OK
but Query...
|
thread by: Xarky |
last post Jul 23 '05 by: Xarky
Hi,
I am trying to initialize an instance of MySqlDateTime. I am giving
an empty constructor, but the compiler complains that no overload
takes 0 arguments.
Then in the constructor I tried to pass the MySqlDbType.Date, but the
compiler would complain that it is inaccessible due to its protection
level.
|
thread by: Eric |
last post Jul 23 '05 by: Eric
Hello,
I'm using mysql 4.1.
When I insert data with special french character with accent é, à...
and that I use select command to see the line, I can see the
characters correctly.
But when I use the outfile command the characters are not in the
correct format.
I tried several charset and collation, but it seems that it's not the
|
thread by: Rajesh Kapur |
last post Jul 23 '05 by: Bill Karwin
Hello,
We are on MySQL 4.0.21 on linux. We use InnoDB tables and foreign key
constraints extensively. The mysqldump backs up the database tables in
alphabetical order with foreign key constraints defined in the create
statement of each table. These foreign key constraints are violated at the
time of restore. We have tried the following two...
|
thread by: joey |
last post Jul 23 '05 by: Bill Karwin
I have a SQL query where I get the count of something, but what I really
want is a yes/no (boolean) answer. Here is my query:
SELECT COUNT(*) AS COUNT FROM hd_entries,hierarchy WHERE
IFNULL (BETWEEN_TIMES (b_yr, b_day, b_msec, e_yr, e_day, e_msec,
2001, 31, 0, 2001, 31, 63720000) >0, 1) AND
hd_entries.data_key=hierarchy.data_key AND...
|
thread by: David Lawson |
last post Jul 23 '05 by: Bill Karwin
The line indicated below from my php script is very slow (about 10 seconds). I have this field
indexed so I thought that it would be much faster. Could someone tell me what might be wrong?
I'm also including the dump of the table definitions. This is a cd cataloging database.
Right now the filenames table is empty and I'm trying to populate...
|
thread by: Jaclyn Elmore |
last post Jul 23 '05 by: Jaclyn Elmore
----09-66966-3457-777-08816
Content-Type: text/plain;
charset="iso-7923-9"
Content-Transfer-Encoding: 7Bit
Hi,
I sent you an email recently and I'd like to confirm everything now.
Please read the info below and let me know if you have any questions.
We are accepting your m ortgage qualifications. If you have bad cr edit,
|
| |
thread by: Robert Blackwell |
last post Jul 23 '05 by: Bill Karwin
I have log files in the form of .txt and I'm wondering if there's something
I can use to see what kind of usage my dbase is getting. I'm interestedin
mainly in bandwidth use and that kind of stuff. It would be nice to see it
in the form of bargraphs.
Anything like that available?
|
thread by: jorge |
last post Jul 23 '05 by: Bill Karwin
Hola!
No se si es posible pero no encuentro la forma de deshacer un update.
Resulta que el update lo hice sin especificar la clausula 'where' y se
ha realizado el cambio en todos los registros. Por lo que he leido
'update' no lleva implicito un commit por lo que supongo que haya
alguna forma de deshacer los cambios ¿estoy en lo cierto?
...
|