I'd asked before how to convert a unix timestamp to the hour that it is
in (and got the perfect answer) :
1298999201 = 3/1/2011 11:06:41 AM
(1298999201 - (1298999201 % 3600)) = 3/1/2011 11:00:00 AM
Now getting the timestamp converted to midnight of that same day isn't
as simple as:
1298999201
It was of course a typo, and even with the correct number isn't the answer
On 03/01/2011 11:47 AM, Claudio Nanni wrote:
You can start by using 60*60*24=86400
;)
On Mar 1, 2011 6:17 PM, Bryan Cantwell bcantw...@firescope.com
mailto:bcantw...@firescope.com wrote:
I'd asked before how
, Bryan Cantwell
bcantw...@firescope.com mailto:bcantw...@firescope.com wrote:
It was of course a typo, and even with the correct number
isn't the answer
On 03/01/2011 11:47 AM, Claudio Nanni wrote:
You can start by using 60*60*24=86400
That's closer:
SELECT
UNIX_TIMESTAMP() + 86400 - (UNIX_TIMESTAMP() % 86400);
Gives me 6:00 PM today...
On 03/01/2011 12:32 PM, Singer X.J. Wang wrote:
SELECT
unix_timestamp() + 86400 - (unix_timestamp() % 86400);
--
--
MySQL General Mailing List
For list archives:
How would I go about modifying a unix timestamp to actually represent
the 'top of the hour' that it represents?
For instance:
1296158500 = 1/27/2011 2:01:40 PM
That is in the 2:00 pm hour, how can I find that out and modify it to
1296158400 which = 1/27/2011 2:00:00 PM?
--
MySQL General
Yes perfect! Thanks, I knew I was over thinking this.
On 02/24/2011 10:56 AM, Nathan Sullivan wrote:
Bryan,
Maybe something like this would work?
select 1296158500 - (1296158500 % 3600)
Hope that helps,
Nathan
On Thu, Feb 24, 2011 at 08:41:58AM -0800, Bryan Cantwell wrote:
How would I go
I have an innodb table with 200 million rows and growing.
It is a highly active table with tons of inserts and updates at all times.
I notice a select query I test on that table is 0.01 seconds or less
when all the inserts/updates are OFF.
But when I throttle up the writes to the table, the
work in spite of what
the manual says.
On Fri, 2010-10-01 at 15:42 -0700, Daevid Vincent wrote:
Did you even look at the manual?
http://lmgtfy.com/?q=mysql+set+timezone
First link.
-Original Message-
From: Bryan Cantwell [mailto:bcantw...@firescope.com]
Sent: Friday
Any way to change timezone WITHOUT mysqld restart?
It would be a lifesaver if there were some way for me not to have to
restart because if mysql restarts then I have to go through a lot of
other issues with my other apps.
I'm using mysql 5.0.51a (yes I know it's old but I cannot upgrade at the
moment) on linux.
My challenge is that mysql admin does not wait long enough for mysql
database(s) which are all innodb and VERY large (billions of rows) and
eventually just kills the db.
This causes innodb to try and repair
I have a simple table
mytable
id int
time_stamp tiemstamp
value int
tid int
I want to find the max id for each individual tid in my table.
if I did it one by one it would be:
select max(id) from mytable where tid = 12345;
but how can I do something more like:
select concat(tid,':',id) from
I am trying to produce charts for large amounts of data. I already limit
the user to a smaller time frame in order to reduce the possible data
points, but still can end up with far more data points than are clearly
plottable on a chart. Does anyone have an idea of how I can drop
insignificant
Yes, but I DON'T want eh spikes smoothed out
On Fri, 2010-08-20 at 17:16 +0200, Jangita wrote:
On 20/08/2010 5:12 p, Bryan Cantwell wrote:
I am trying to produce charts for large amounts of data. I already limit
the user to a smaller time frame in order to reduce the possible data
points
I have a very large table (over 2 billion rows) which is partitioned by
day. I'd like to archive all the data in the oldest partition to another
table before I drop that partition. Is there some way other than a
simple select statement that has parameters that match those of the
partition whic
I know that you can ignore certain databases and tables in mysql
replication, but is it possible to replicate all but a certain column or
two from a table? This is 5.1.48 on linux.
Thanks,
Bryancan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I have a stored procedure in mysql 5.1.48 that deletes old data from my
tables.
I would like to keep a running count while it does this. Here is what I
try now:
...
DECLARE dropCnt INT DEFAULT 0;
...
SET @sql = CONCAT('DELETE FROM myTable WHERE itemid = ', iID, ' AND
clock BETWEEN 0 AND ',
I have to delete old records from a very large table (1.6billion rows)
in a stored procedure.
CREATE TABLE mytable(
id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
unix_time INT(11) NOT NULL DEFAULT 0,
value DOUBLE (20, 4) NOT NULL DEFAULT 0.,
UNIQUE INDEX history_1 USING BTREE (id,
Is there a benefit to a combined index on a table? Or is multiple single
column indexes better?
If I have table 'foo' with columns a, b, and c. I will have a query
like:
select c from foo where a in (1,2,3) and b 12345;
Is index on a,b better in any way than an a index and a b index?
An explain
Perhaps someone has already accomplished this:
I have a simple table with 3 columns:
mytable(
myid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
myunixtime INT(11) NOT NULL DEFAULT 0,
myvalue BIGINT(20) UNSIGNED NOT NULL DEFAULT 0
)
It is collecting millions of rows.
The myunixtime column is a
I need to be able to get a first and last timestamp for a day a week or a
month. I have an example of what I did so far that gets me that info for a
week... but I fear that it is far more complex than it needs to be. Anyone
have a simple way to get first and last timestamp for these intervals?
Is there still no such thing anywhere for Mysql as an index analyser?
Many others have such a thing that will sit and monitor db activity over a
poeriod of time and suggest the exact indexes on each table based on what it
has seen to improve performance
Anyone got that for MySQL?
Ya, that one is helpful... just trying to land on a solution like I've seen in
other DB's that have index-advisor that listens and creates what it thinks is
the perfect indexes ... but thx...
From: mos [mo...@fastmail.fm]
Sent: Tuesday, February 23,
Is there a simple function or method to compare a value in a column to one or
more items in a comma separated list?
select * from table where value contains one of ('apple','orange','banana');
and say value may = something like 'produce(grape,orange,pear,apple,lettuce)'
--
MySQL General Mailing
: Wednesday, February 17, 2010 11:31 AM
To: Cantwell, Bryan
Subject: Re: compare column value to anything in a list of values
yes, there is... IN
SELECT * FROM tbl WHERE col IN (v1, v2, v3)
- Original Message -
From: Cantwell, Bryan
Date: Wednesday, February 17, 2010 12:25 pm
Subject
I have a function built that will get me X percentile from my history table for
last X days. It works fine as long as I hard code the certain values in where
they go... what I really need to know is how can I make dynamic sql still do a
select into a variable? simply replacing the '31' below
Anyone have information they can provide on the performance hit of using
innodb_file_per_table?
I'd assume that since there are many individual tables that this would
slow performance, but perhaps not.
In a huge database, is this not a good idea, or a better one?
--
MySQL General Mailing List
I need to find the lesser of two values provided in a list. I know I can do it
with a couple of IF's in a function, but I'd really like to know if there is
already a function that I can use.
min(12,3,1,4) of course doesnt work, but is there some other math function I
am overlooking in MySql?
I have a situation where I need to always get a row returned even if no match
is in the table (only 1 or many rows are acceptable).
I can use:
select a, b, c from mytable where a = 'yarp';
and might get 20 rows if there are matches, but I at least need 1 default row
back...
using :
select
I have a stored proc I need to call from yet another stored proc, which
then needs to use the results from the called proc ... I could probably
use temp table but really dont want to do that unless absolutely
required. I cant use OUT parameters, because the called stored proc
returns multiple
Does anyone have a suggestion on how a database link (like in Oracle)
could be established between two Mysql databases on different servers?
It would be awesome if I could write sql that will query both databases
in one query...
--
MySQL General Mailing List
For list archives:
I have an environment where upon boot of a machine I need to know if
mysql shutdown nicely or if it crashed.
How can I know for sure which was the case so that I can take action if
needed?
I notice that issuing a reboot or shutdown -r now command, (in Linux)
that the 'service mysql stop' is
I have mysql 5.0.51a running on a linux 2.6.26 box. The service my6sql
stop command fails and all that appears in the log or err log is the
following... what can I do to repair this?
091014 17:00:24guardian: instance 'mysqld' is running, set state to
STARTED.
091014 17:07:40The
...@eds.com
Pager mail:9884430...@nma.vodafone.in
-Original Message-
From: Bryan Cantwell [mailto:bcantw...@firescope.com]
Sent: Wednesday, October 14, 2009 8:40 PM
To: mysql@lists.mysql.com
Subject: Mysql service will not stop
I have mysql 5.0.51a running on a linux 2.6.26 box. The service
I have 2 - 5.0.51a mysql databases setup in a dual master scenario. A is
master of B and vise versa...
In Linux 2.6.26 (if that matters).
Everything is great while all is running normally. But, when I am
testing the system by creating disasterous scenarios, I find some
challenges I hope to get
to detect and repair with a daemon script. Even if both
machines die, it'll be a similar scenario.
Regards,
Gavin Towey
-Original Message-
From: Bryan Cantwell [mailto:bcantw...@firescope.com]
Sent: Wednesday, October 07, 2009 10:47 AM
To: mysql@lists.mysql.com
Subject: Replication
-
From: Gavin Towey [mailto:gto...@ffn.com]
Sent: Thursday, July 30, 2009 5:08 PM
To: Cantwell, Bryan; mysql@lists.mysql.com
Subject: RE: Replication recovery on restart
Hi Bryan,
Please define out of whack. Tell us exactly what you're doing when you
restart, and what the replication state
-
From: Gavin Towey [mailto:gto...@ffn.com]
Sent: Friday, July 31, 2009 1:21 PM
To: Cantwell, Bryan; mysql@lists.mysql.com
Subject: RE: Replication recovery on restart
Bryan,
How are you restarting mysql? In the case a master crashes, it's definitely
common for the slave to miss the fact
I have 2 machines 'master' and 'slave'. I have the mysql 5.0.51a-log databases
both replicating wonderfully. They are configured in a dual master scenario so
that one can take over for the other in my HA environment I've built. All is
working great until... If one or the other box reboots or
I have successfully set up a replication master/slave scenario with my MySQL
5.0.51a
Now in the event of a fail over to the slave (an identical appliance), I want
the old master to become the slave for an eventual switch back the other way.
Would it really take the same process to keep the old
I want to check all my functions and procs into my svn as individual sql files.
When I use these to create my db, the person doing this may not realize the
correct order to run these files and not have dependency challenges... How can
I have procs that depend on functions, or vice versa, get
I have a debate with someone about indexes on time columns.
So I ask the community, should you put an index on a timestamp column of a
table?
Thanks...
Do I jsut need to monitor better and manually add it should the log
and pos change?
-Bryan
On Wed, Mar 11, 2009 at 7:05 PM, Baron Schwartz ba...@xaprb.com wrote:
That's deprecated too :-)
On Wed, Mar 11, 2009 at 9:17 PM, Cui Shijun rancp...@gmail.com wrote:
hi,
#2. try adding
then need to re-run the set
master to statements when the slave comes back up? or can that be
handled automatically?
-Bryan
On Thu, Mar 12, 2009 at 10:26 AM, Rob Wultsch wult...@gmail.com wrote:
When you start up replication the data should be recorded in the
master.info in your data dir.
[r
to ... command.
TIA
-Bryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
I am trying to put the result of a function that returns MEDIUMTEXT into
a user variable in my procedure. I haven't attempted to push the limits
of the MEDIUMTEXT size, but wonder if the user variable can even handle
this?
--
MySQL General Mailing List
For list archives:
in set (0.00 sec)
You need to read up on what binlog_do_db means. And you shouldn't use
it. It is the problem.
Indeed it was a gap in my understanding. That did the trick! Many thanks!!
-Bryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
On Sun, Dec 21, 2008 at 8:35 AM, Baron Schwartz ba...@xaprb.com wrote:
Hi Bryan,
On Wed, Dec 17, 2008 at 5:35 PM, Bryan Irvine sparcta...@gmail.com wrote:
I've got a master-master set up and I'm trying to figure out the best
way to add new databases to the cluster. I've not set anything
I have a function that I built that returns a string that is really a
comma separated list of values (below). I would like to use that
returned value in an IN clause in sql. :
select * from hosts where hostid in (getHosts(10014));
The function:
CREATE FUNCTION getUserHosts(userID
? (it's not working for me if it is).
I've read the docs but didn't find what I was looking for, apologies
if is this covered elsewhere.
-Bryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
I have a procedure (proc1) that calls another procedure (proc2) several
times.
I'd like to make proc1 return the proc2 results in a single resultset.
How can this be done in mysql 5.0.51?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Below I have a function with a cursor. I have tested the cursor sql
manually and it is fine, I have put the variables into the sql inside
the cursor loop and it returns data too, BUT, executing this function
returns null even though I know the correct info is available. Am I
missing something
return a record in this pass?
thx
-Original Message-
From: Cantwell, Bryan [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2008 4:17 PM
To: mysql@lists.mysql.com
Subject: Function returns null when running sql manually works
Below I have a function with a cursor. I have tested
Message-
From: Cantwell, Bryan [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2008 5:13 PM
To: mysql@lists.mysql.com
Subject: RE: Function returns null when running sql manually works
OK, I know WHY it is returning null, just not WHAT to do about it.
In the inside sql
I've got a nagios server that checks to see if the listening port is
open. I'm getting this error:
Host 'nagios-host' is blocked because of many connection errors;
unblock with 'mysqladmin flush-hosts'
I've googled and there's options to use max_connection_errors=100
My (very rough)
numbers/binlog correct? And adding a new DB
requires reloading the MySQL server?
I've been looking around at other technologies as well like linux-ha.
What are other people using for systems that have to be up 100% of the
time but aren't complete nightmares to manage?
TIA!
-Bryan
--
MySQL General
updates again.
I'm not sure if this is the best way or not.
Do you use the drbd method? Are any of these things accounted for in
that solution?
-Bryan
On Thu, Aug 28, 2008 at 2:06 PM, Jimmy Guerrero [EMAIL PROTECTED] wrote:
Hello,
It isn't without its pros and cons (just like any other HA
updates again.
I'm not sure if this is the best way or not.
Do you use the drbd method? Are any of these things accounted for in
that solution?
-Bryan
On Thu, Aug 28, 2008 at 2:06 PM, Jimmy Guerrero [EMAIL PROTECTED] wrote:
Hello,
It isn't without its pros and cons (just like any other HA
I'm having an issue setting up a slave Where it doesn't seem to start:
mysql show master status;
+--+--+--+--+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+--+--+--+--+
|
used to get this going?
Mike
On Mon, Jul 28, 2008 at 4:14 PM, Bryan Irvine [EMAIL PROTECTED] wrote:
I'm having an issue setting up a slave Where it doesn't seem to start:
mysql show master status;
+--+--+--+--+
| File
| exampledb| |
+--+--+--+--+
1 row in set (0.00 sec)
^^^is that the correct posistion?
-Bryan
On Mon, Jul 28, 2008 at 2:05 PM, Mike [EMAIL PROTECTED] wrote:
Do you have the original mysql show slave status\G; off the master
.
If it doesn't I'd take a fresh mysqldump with the --master-data
parameter and refresh the slave, run the 'change master' statement at
the top of the backup and it should start.
-Original Message-
From: Bryan Irvine [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2008 2:11 PM
To: Mike
Cc
Is there no way to step thru a stored proc in order to debug it and see
what it is doing?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I need to create a cursor using dynamic sql. Below is a short example of
what I am trying to use in order to get the correct resultset... ignore
the rest of the proc, I just need to know how to make the cursor
declaration from @vsql
Thanks
DELIMITER $$
DROP PROCEDURE IF EXISTS
Is there a way to find out what configure arguments were used during
compile time?
-Bryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
No input on this one?
-Original Message-
From: Bryan Cantwell [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 12, 2008 11:51 AM
To: mysql@lists.mysql.com
Subject: Crashed InnoDB
We had a power outage, now the mysql wont start at all. Here is the err file
output... Any help on how
distribution on how to do that.
Number of processes running now: 0
From: Dan Rogart [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 13, 2008 12:27 PM
To: Bryan Cantwell; mysql list
Subject: Re: Crashed InnoDB
Have you tried starting mysqld with innodb_force_recovery = x ? (where
We had a power outage, now the mysql wont start at all. Here is the err file
output... Any help on how to recover?
080212 11:35:50 mysqld started
080212 11:35:50 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd
I have Mysql 5.0.45 using innodb tables.
Occasionally, I get corrupted tables. I can go into Mysql administrator
gui and see the bad table and I can repair the index or whatever is
wrong from the gui.
I need a command line way to periodically detect for issues and if it
finds one the I need a
I have the following horrible sql. I need one result that has all the
data in one row. I am currently using 3 sub queries and figure it must
be a better way...
SELECT 'FS_DEV',
ifnull(a.severity, 0) AS aseverity,
I have the following proc... when I run it I get a response that says
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'NULL' at
line 1.
I just want a programatic way to upgrade db engine to innodb where I
don't
I have a table with a varchar column that contains a timestamp like
this: 'Thu May 17 09:15:47 2007'
I need to grab this and include it in an insert sql that puts that value
in a table as a timestamp...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
I see no string to date function that does this conversion...
-Original Message-
From: Bryan Cantwell
Sent: Monday, May 21, 2007 2:08 PM
To: MySQL General
Subject: string to timestamp conversion
I have a table with a varchar column that contains a timestamp like
this: 'Thu May 17 09
I have a need to output a recordset that shows the record with the
higest value for severity within a date range. That is easy enough, but,
in the same query, I need to show that data 3 times in the same query.
Once where event_avail = 1, then again where event_perf = 1 and finally
where even_sec
I have the following sql that works for what I want to see but is
terribly slow due to the subquery. Any suggestions on how to get same
result faster? I have tried group by and cant seem to get the correct
results that way
Also is there a product that can help optimize sql and indexing?
, 2007 1:40 PM
To: Bryan Cantwell
Cc: mysql@lists.mysql.com
Subject: Re: Need sql optimization help
Bryan,
A 'Not Exists' query
http://www.artfulsoftware.com/infotree/queries.php#41 is usually
faster when coded as an exclusion join, eg for max-some-value per key,
left join on the key variable
055 06:02 AM0.08
Bryan Cantwell
Director, Development
(M) 469.361.1272
[EMAIL PROTECTED]
www.FireScope.net
Yes they are; and 22 = 3
- Original Message -
From: Jerry Schwartz [EMAIL PROTECTED]
To: 'Bryan S. Katz' [EMAIL PROTECTED];
mysql@lists.mysql.com
Sent: Wednesday, February 21, 2007 10:30 AM
Subject: RE: MySQL Daylight Savings Time Patch
Aren't the time zone tables new in 4.1.3
Running 4.1.22, on windows 98, I'm having trouble getting the time zone
tables to actually work. I've loaded the tables as per:
http://dev.mysql.com/downloads/timezones.html, and followed the diagnostics
as per: http://lists.mysql.com/mysql/205115
.
It appears that my results from said
. Which means that they
were never being used.
Any ideas?
- Original Message -
From: Bryan S. Katz [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, February 20, 2007 7:50 PM
Subject: MySQL Daylight Savings Time Patch
Running 4.1.22, on windows 98, I'm having trouble getting
Trying to migrate to MySql 5 from Sybase asa. I have a tables that have
column values that are calculated based on other columns in the table. How can
I accomplish the same in MySql?
Here is sample of my asa table:
CREATE TABLE DBA.OpptyDetail
(
OpptyDetailID
numeric(40,0)
NOT
Thanks Leo,
However, remember that the key returns quickly on index-only queries, so the
conditions in the WHERE are not my delay at this time. I want to know why
it takes 5
mins to scan 2 rows from the MYD
Bryan
- Original Message -
From: Bryan Heitman [EMAIL PROTECTED]
To: leo [EMAIL
|
++--+---+---+-+---+---+-+
| matrix | ref | myKey | myKey | 9 | const,const,const |
56909 | Using where |
++--+---+---+-+---+---+-+
- Original Message -
From: leo [EMAIL PROTECTED]
To: Bryan Heitman [EMAIL PROTECTED]
Sent
.disk2/SQL/search/'
- Original Message -
From: Sergio Salvi [EMAIL PROTECTED]
To: Bryan Heitman [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Thursday, December 23, 2004 10:08 AM
Subject: Re: scanning 2 rows slow index fast 26GB MyISAM
Bryan,
Can you send the output of show create table
| | BTREE | |
+++--+--+-+---+-+--++--++-+
5 rows in set (0.00 sec)
- Original Message -
From: Sergio Salvi [EMAIL PROTECTED]
To: Bryan Heitman [EMAIL PROTECTED]
Cc
(*) is a different query. My point is the
only difference is a SELECT locationid must retrieve the results as
locationid is not in the index. It should not however take 5 mins to return
2 rows from the table.
Bryan
- Original Message -
From: Donny Simonton [EMAIL PROTECTED]
To: 'Bryan
` (`LocationID`,`AccountID`,`Date`)
) TYPE=MyISAM MAX_ROWS=10 AVG_ROW_LENGTH=300 DATA
DIRECTORY='/home/SQL/' INDEX DIRECTORY='/home/SQL/'
Best regards,
Bryan Heitman
FuseMail Team
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Mark,
You may have a corrupt table. I would recommend printing the $query just
before mysql_query() is ran. This will give you the query that is failing
and the table that it is attempting to write to. May want to try a check
table on this table.
Bryan
- Original Message -
From
help or a point in the right direction in this situation would be
helpful
Bryan Heitman
FuseMail
- Original Message -
From: Dathan Vance Pattishall [EMAIL PROTECTED]
To: 'Bryan Heitman' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, April 01, 2004 12:15 AM
Subject: RE: InnoDB
= innodb_additional_mem_pool_size=20M
set-variable= innodb_log_file_size=256M
set-variable= innodb_log_files_in_group=3
Any help would be appreciated.
Best,
Bryan Heitman
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Posted this yesterday, but it never showed up...?
Hi,
I have the following table (sorry if the formatting gets tweaked) and
query. The table is around 36k rows long, and the query returns about
350 rows. The query takes 12.15 seconds.
Is there any way I can speed this up?
Thanks,
Bryan
Has anyone had any experiences running MySQL on a Xserve G5 with Macintosh
OSX?
We are thinking of purchasing some new hardware to run our MySQL server. The
64-bit architecture is something we would like to take advantage of.
Is this good, bad, otherwise? Any comments would be
.
- Bryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
there is something simple that I've
missed... but I can't find any documentation of what it could be.
--Bryan
Hi Chris,
My apologies, I didn't correctly explain what I was looking for. I mean
more of a solution to creating a client program. I'm thinking of php-gtk
but not sure how well this works under windows, especially for printing
reports.
Thanks,
Bryan
On Sat, 17 Jan 2004, Chris Nolan
Hello,
I run an ISP where our web customers have access to the MySQL server. When
they want a database, they request it through me and I add it. I was just
curious if this is the common way it is done, or if there is a safe way
they can add their own?
Thanks,
Bryan
--
MySQL General
sees what MySQL can do) so I'll probably be
trying to do it myself.
So if anyone knows of a way to get a full interface under windows (that
can print nice invoices) and has a direct brain-input for learning, let me
know :)
Thanks again,
Bryan
--
MySQL General Mailing List
For list
really
appreciate it.
Thanks,
Bryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
would still be gone from account 32146
---
Is this actually correct, or is it correct but there is a different way to
do this with MySQL?
Thanks,
Bryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
I'm pretty new to MySQL, but I already like it. Kudos to the developers!
I recently did a mysqlimport on a few data files, and it came back with over
4000 warnings. How can I actually see what the warnings were? I'm still
not sure what it was upset about...
You can't.
From 4.1.1 you
I had tips from some people here to install the complete MySQL from Server
Logistics
on my Mac OS X 10.2 and so I did (I also installed Apache 2 and PHP from
them).
Now I'm on Step one, but got stuck here. (I always get stuck while trying
this MySQL).
In the pdf-file that came along
1 - 100 of 187 matches
Mail list logo