On Sun, 19 May 2002, Jule wrote:
> Hey guys and gals,
>
> is there a query that selects all comuns from a table, except the one's i
> have defined?
>
> Jule
No, there isn't. It is safter if you name the columns you want.
If you use a select * in your code instead of naming the particular
column
Dear all,
I have some large MySQL tables and II want to delete for example month
2-2002
entirelly from an sql table.
I use now ...
delete from table_name where year(data)=2002 and month(data)=2;
I have almost 25.000.000 row and something like 7-8 mil is from month 2.
Seems to make it for 2 hou
Hey guys and gals,
is there a query that selects all comuns from a table, except the one's i
have defined?
Jule
--
|\/\__/\/|
| Jule Slootbeek |
| [EMAIL PROTECTED]|
| http://blindtheory.cjb.net |
| __ |
|/\/
You would need to put "useUnicode=true&characterEncoding=UTF-8" in your JDBC
url, like the README directs. See
http://java.sun.com/j2se/1.4/docs/guide/intl/encoding.doc.html for a list of
supported encodings.
-mark
- Original Message -
From: "John D. Stein" <[EMAIL PROTECTED]>
To: <[
We are using VB6 to access the MYSQL, while we use ADO OCX to
connect to the database, we are able control the timeout, but using
connection string, we are unable to .
As our current applications perform minimum of one update/addnew
per second and sometime, even more. There are at least 10 appli
Richard,
can you upload via ftp gzipped dumps of the two tables in the UNION to
/pub/mysql/secret at support.mysql.com?
About the crashes which occur in 5 - 7 days: please send me the error log
of MySQL 'hostname'.err so that I can resolve the stack dumps, if they
exist. 4.0.1 is already a rath
I have been battling with a complex query that us giving me a tremendous
headache..
I have a MASTER table with 7 other tables (I can not change the database)
The master table contains values (Key's) which I then need to lookup in
another table that has 2 fields, the Key and a Description field.
E
Well this is a stand alone operation. I don't currently have the ability to
copy files to another machine.
And we do have a UPS. The problem turned out to be a bad power cord into
the computer itself. Never had that happen before.
Now my question is thishow can the 7 days of backups also
Not to add insult to injury, but keeping backups on the same machine and
media your databases are installed on is asking for trouble. And power
outages are predictable, so UPS protection is critical. Enough said.
I would speculate that one or more of the files in the /data/mysql/ folder
were open
Hi,
this is a feature. see
http://www.mysqldeveloper.com/manual/index.pcgi?section=Silent_column_changes
;-)
Buff Smith wrote:
>
> To Whom It May Concern:
>
> I have reported the following symptoms in UNIX using 'mysqlbug' character
> mode utility. I am including the text of that problem sta
To Whom It May Concern:
I have reported the following symptoms in UNIX using 'mysqlbug' character
mode utility. I am including the text of that problem statement with this
email. Additionally, I am attaching several sample DDL input files, and
the results of SHOW COLUMNS FROM output.
Voila
On Saturday 18 May 2002 18:00, you wrote:
> yeah i tried doing that in phpMyAdmin, and it gave me an error
> and when i use
>
> SELECT * FROM 4172_questions ORDER BY RAND() LIMIT $row
>
> ($row being the number of rows)as my query it gives me the:
>
> Warning: Supplied argument is not a valid MySQ
Hey guys,
i have a db and a table with id and questions
now i want these questions to be listed in a random order, is there a way to
format my SQL query or do i need some PHP work to?
i can ofcourse select a random one, that's no problem, but how do i make sure
that that one does not get chosen
Not a direct answer to your question here, but why keep backups on the same
server and in the same storage medium?
Ric.
- Original Message -
From: "kibserv-FtS Setiqueue" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Saturday, May 18, 2002 9:44 PM
Subject: Database and
1)
CREATE TABLE `summary_rts` (
`cid` int(11) NOT NULL default '0',
`hits` int(10) unsigned default '0',
`uniq` int(10) unsigned default '0',
`reload` int(10) unsigned default '0',
`hourly` int(10) unsigned default '0',
`daily` int(10) unsigned default '0',
`mtime` datetime NOT NULL
> Fra: Richard Clarke [mailto:[EMAIL PROTECTED]]
> Sendt: 18. maj 2002 22:29
> Emne: 4.0.1 Bugs
>
>
> List,
> I wondered if any movement has been made to determine the cause of the
> following "bugs" that I have come across using Mysql 4.0.1.
>
> 1) selectunion causes a temporary table ful
This is an odd one. I seem to have lost all databases and backups
simultaneously.
I keep daily backups for upto 7 days. This morning after a power outage I
noted I was unable to login. Every user and password I tried was denied. I
checked the files in the mysql data folder and they were all t
List,
I wondered if any movement has been made to determine the cause of the
following "bugs" that I have come across using Mysql 4.0.1.
1) selectunion causes a temporary table full type error when the
datasets aren't even that large and when there is bags of disk space.
2) Under FreeBSD
Sorry, my mistake in not explaining in details
I have problem on 'Multiple-step operation generated errors. Check
each status value'. when i use Visual Basic ADODC OCX to addnew. This is
the sample of my source code. The problem crop up when the bookmark value > 1.
againxxx1:
Form1.DtaOut.Reco
Hi,
I'm converting my tables from MyISAM to InnoDB. One of them returns an
error
"Error: 1114 - The table '#sql-7b67_321' is full" - How can i avoid this
error?
Table Structure->
wmkt_client,CREATE TABLE `wmkt_client` (
`idclient` int(11) NOT NULL auto_increment,
`realname` varchar(8
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, May 18, 2002 5:17 AM
> To: [EMAIL PROTECTED]
> Subject: VC++6.0 MFC app with MyODBC 2.50 "no cursor name avb."
>
>
>
> I get a "No cursor name available" window in an Visual C++ 6.0 MFC
> appl
Hi, hope somebody can help me - what I want to do is simple I'm sure, but I
can't work out how to do it: I want to replace a column in a table,
containing text, with a key to another new table which holds the text.
Example:
Given a table, 'people', which contains two columns, name, and town, lik
I am trying to store UTF-8 encoded text with MM.MySQL 2.0.13 driver. I am
using MySQL 3.23.49, MM.MySQL 2.0.13 JDBC driver, j2sdk1.4.0.
I have had success with the code below (which stores the UTF-8 as a binary
stream), but am wondering if there is an easier way. Specifically I am
wondering
Installed MySQL using Fink to the Mac X OS. When attempting to run, I
am getting this error.
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock'
Help in explaining this error and how to fix the installation would be
appreciated.
Thanks in advance.
Jeffrey
---
×𾴵Ŀͻ§£¬ÄúºÃ£¡
ʱ´´ÍøÂçJSP PHPÐéÄâÖ÷»úÈ«ÃæÉý¼¶³É¹¦£¬Ö§³Ö×î¸ß°æ±¾£¬¸øÓè
¸ü¶àÖ§³Ö£¬¸ßËÙ¡¢Îȶ¨£¡Êǽ¨Á¢ÆóÒµ¡¢¸öÈËÍøÕ¾µÄ×î¼ÑÑ¡Ôñ:
²ÉÓÃ×îÐÂCatalina ÄÚºË Ö§³ÖServlet 2.3 and JSP 1.2
JDBC mm.mysql-2.0.12 JDBC microsoft.jdbc.sqlserver J2SDK1.4.0
ÖйúµçÐÅ2GÖ±½Ó½ÓÈëCHINANETÖ÷¸É!
I get a "No cursor name available" window in an Visual C++ 6.0 MFC
application whenever i try to make updates to the database. I use a
CRecordset class to connect to the database trough MyODBC 2.50.39. MySQL
server is 3.23.49 stable release on Windows 2000 Pro.
I'm kinda new in the area of
Hi!
> I am getting real interested too. :) I took a look at the manual, but I
did
> not see answers to a simple question like whether innodb files are
> compatible (query-wise) with MyISAM tables, for instance, or whether I
need
> to rewrite all queries. Perhaps a guru here could explain this.
Y
Federico,
Friday, May 17, 2002, 8:23:35 PM, you wrote:
FC> After installing MySql Client Version 1.75 on my Win98 Pc, I tried to
FC> connect to mysql database on a Linux Box.
FC> this is the error message
FC> Host not allowed to connect to this MySQL server.
FC> This is my configuration file
[
Doug,
Saturday, May 18, 2002, 6:45:20 AM, you wrote:
DC> Please forgive this easy question from a newbie:
DC> I was given a MySQL database file from a client with a .sql extension. I
DC> already have several databases setup and running under MySQL on our server.
DC> But how would I copy this ne
Norris,
Saturday, May 18, 2002, 12:19:33 AM, you wrote:
Neoen> On my unix box when I use mysql I can spawn vi and edit the sql statement or
Neoen> save it out for reuse.
Neoen> This feature does not appear to be present on the windows version - or did I
Neoen> miss something?
I can use it on Wi
Hi,
My opinion:
If you design your DataBase in correspondence with Boyce-Codd rules i think
you can avoid all this complications.
Good luck,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
### CHANGES ###
--- version 16.1 ---
- in Edit menu, added New Page entry, renamed New entry to New Viewer
- allowed page deletion through drop and drop from page tab into
eraser, only if page is empty or if it is the last remaining page
- when a new page is created, automatically open its tab
Thanks for this response, it is one way round the problem but is going to
require copying the tables, some of them very large a number of times over
and over. Is their no way of simply adding the data alongside the existing
columns?
Alex
--
Alexander
Hi there,
I have some trouble with the syntax of join query and some perfomance isues.
I did split my data due to the rules of normalisation. So there is a website
table and a comment table and I would like to find out if the user with the
id '10215' has a stored comment or website.
Here is my
34 matches
Mail list logo
