| |
thread by: simplegood |
last post Jul 23 '05 by: Bill Karwin
Got any recommendations for some software that can handle table as
large as 800,000 records with joins to other tables to produce a time
base report e.g. weekly slices of data. I guess you could say is
similar to reporting a sales table but with thousands of transaction
per week. I need a cheap solution about $100 USD.
Software: PHP 4 or 5 +...
|
thread by: David M. |
last post Jul 23 '05 by: David M.
Hi,
I have this error when I am connected in mysql:
ERROR 2006: MySQL server has gone away. No connection. Trying to reconnect...
I only did this command: show databases;
and received the error.
I noticed that if I don't send a command since 25 sec, I have the error.
|
thread by: Paul Marshall |
last post Jul 23 '05 by: Bill Karwin
Hi,
I'm doing some analysis on a database of log messages and wondered if
anyone could help me pull out the data I need (I'm a MySQL newbie)
I have the following table called message which contains logged
events:
+--------------+------------------+------+-----+---------------------+-------+
| Field | Type | Null | Key |...
|
thread by: Peter Scott |
last post Jul 23 '05 by: Peter Scott
I created a table that has a column in that needs to contain a full
Unix file path. Since 2048 was too long for a VARCHAR, I made it
TEXT. I since populated the table. Now I want to make the path
column a primary key, and I can't figure out how. (I googled the
web and groups without luck, looked over the reference manual also,
especially...
|
thread by: Bruce D |
last post Jul 23 '05 by: Bruce D
I have this simple subquery...and I get an error when I try to run it??
SELECT ZipID
FROM testzip
WHERE ZipID
<> (
SELECT ZipID
FROM Zip )
any ideas?
|
thread by: Terry Richards |
last post Jul 23 '05 by: Terry Richards
mysql 4.1.9-standard
how do i find exactly what the warnings are when i only get
Query OK, 1 row affected, 1 warning (0.00 sec)
:-)^2
|
thread by: Tony W. |
last post Jul 23 '05 by: Bill Karwin
I have a MySQL question about changing the info in a table:
I am using MySQL Server version: 3.23.58
I have a table called sign_region2 and it contains thousands of
references to signs and the regions they are in.
mysql> desc sign_region2;
+-----------+---------+------+-----+---------+-------+
| Field | Type | Null | Key |...
|
| |
thread by: Shane Niebergall |
last post Jul 23 '05 by: Shane Niebergall
Hey all -
I'm trying to implement a basic log in a table. Instead of writing to a text
file on the server, I want to insert entries into a 'log' table. However, I
want to limit this table to only have the last 500 rows or so. How do I do
this?
Here's my pseudocode, but it seems as if there would be a better way:
logEntry($message){
|
thread by: nospam |
last post Jul 23 '05 by: Aggro
Is there a really fast way to see if a table is marked as crashed? It
seems check table and myisamchk are too slow large MyISAM tables (>
38GB) for such an operation.
Any suggestions, hints?
TIA
|
thread by: e_AK_05 |
last post Jul 23 '05 by: Bill Karwin
I have a question and I can't figure out how to do it.
I have a select statment :
SELECT table1.* AS table1.*, table2.* AS table2.* FROM table1, table2
WHERE 1
this does not work...for me at least...I'm trying to name my columns
tablename.fieldname....any help would be appreciated, thanks
|
thread by: Hal Halloway |
last post Jul 23 '05 by: Thomas Bartkus
Say I want to make sure that a table can not have more than 100 records
- how could I do this from MYSQl or PHP.
Thanks
|
thread by: siliconmike |
last post Jul 23 '05 by: Wouter
Hello, I'd like to implement a large 2-d array
2d array size: 5000 x 5000
each element: int 4 bytes
type: static, MYISAM
how is this done in MySQL? I'm a newbie, so details will help.
Mike
|
thread by: Kathryn Doss |
last post Jul 23 '05 by: Kathryn Doss
<html>
<body>
<div style="width:100%;height:400px;">
<table style="position:relative;z-index:0;" width="100%" height="100%" border="0" cellpadding="20" cellspacing="0">
<tr>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="64"><table width="64" border="0" cellpadding="0" cellspacing="0"...
|
thread by: siliconmike |
last post Jul 23 '05 by: siliconmike
All I know is that there are 8 bit numbers from 0 to 255 mapped to
characters like A, B, C, D and some strange looking ones (like the ones
used to make boxes in old PC text modes) all these being called ASCII
characters.
So, what in a nutshell does "character sets" mean and how are they
helpful in displaying multiple languages ?
Any simple...
|
thread by: Randell D. |
last post Jul 23 '05 by: Randell D.
Folks,
I have several tables which I would like to record when a record has
been inserted or updated (say, for example, using the unix timestamp).
Is there a method whereby on every insert or update, that I can have a
column automatically assigned a date value?
My guess is no - but I thought I'd ask before I re-invent the wheel by...
|
| |
thread by: - |
last post Jul 23 '05 by: -
i have a query as follows and is unsure whether it is mysql or php:
$result = mysqli_query("SELECT COUNT(*) > @foobar AS status ....") where
it's suppose to get a one row value of either '0' or '1' (false or true)
if i were to do a SELECT COUNT(*) FROM...
i can use the php $row to refer to the index.
if i were to do a SELECT COUNT(*) AS...
|
thread by: Dave Crypto |
last post Jul 23 '05 by: Bill Karwin
Hi There,
SUMMARY:
I need to know what the actual maximum date limit possible on a row of
a MYSQL database.
MORE DETAILS:
For example, does a MYSQL database only allow 4032 bytes of data to be
|
thread by: - |
last post Jul 23 '05 by: -
in oracle there is a '%TYPE' to reference the data type of another
column. is there an equivalent in mysql? thank you.
|
thread by: Gnurp Gnarp |
last post Jul 23 '05 by: MikeA
How do I prevent the MySQL client to scroll pages when the results of
a query exceeds the number of lines in the terminal window?
Like a MySQL equivalent to *nix 'more'.
mysql> select foo from bar;
2500 rows in set (0.00 sec)
|
thread by: bmichael... |
last post Jul 23 '05 by: bmichael...
Hi,
I've recently installed MySql 5.0.2 on a WinXp box and am always
getting the above error every time I click on a schema in the Catalog.
I can log on to the db fine, it always happens when I click on a
schema.
I've been struggling with this for hours....any and all help will be
greatly appreciated.
|
thread by: paranoid-android |
last post Jul 23 '05 by: Ashmodai
I have a personal webserver installed and wish to run a script daily on
my database. How would I achieve this??
Does anyone have any sample code??
regards
|
thread by: Paradigm |
last post Jul 23 '05 by: Jeff North
I am using Access 2K as a front end to a MYSQL database.
I am trying to run a Union query on the MYSQL database. The query is (much
simplified)
SELECT as ID from faxdata UNION
SELECT as ID from letdata UNION
SELECT as ID FROM MEMODATA;
I get an ODBC error. The same query runs when the backend files are MDB
files and it runs with...
|
thread by: Bart Van der Donck |
last post Jul 23 '05 by: Bart Van der Donck
Alan wrote:
> Just how big a file can the Text data type contain (in
> kilobytes or Megabytes)? How big a file can a MediumText
> data type contain (in kilobytes or Megabytes)?
'Text' = 64 KB
'Mediumtext' = 16384 KB = 16 MB
There are a few bytes needed to store information about the field itself.
|
| |
thread by: Michael C# |
last post Jul 23 '05 by: Michael C#
Hi all, writing a VB.NET app using the MySqlConnection client and having a
hard time with MySqlCommand Parameter queries. I create a query like this:
cmd.CommandText = "INSERT INTO Location_Lookup (Description, ID) VALUES
(@desc, @id)"
cmd.Parameters.Add("@desc", MySqlDbType.VarChar, 128).Value = val
cmd.Parameters.Add("@id",...
|
thread by: Dave Lewis |
last post Jul 23 '05 by: Bill Karwin
Hi All,
Can someone point me in the right direction?
I have a web site which uses a MySQL database to store items for sale,
client information and credit card info etc (or will be soon). I'm
|