t possible to shutdown individual databases, only ALL
databases.
matthew
-Original Message-
From: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Wednesday, May 31, 2017 9:28 AM
To: mysql@lists.mysql.com
Subject: Re: mysqld_multi
Am 31.05.2017 um 17:48 schrieb Matthew Black:
> #
mysql -uroot -p --socket=/MySQLdb/cba/mysql.sock
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';
mysql> quit
I was simply seeking those three commands, but the reference manual did not
provide a real-world example.
matthew
-
efines the port, database location, log
file, port number, and user, so they don't have to be placed on the command
line.
Your response does not explain the command line steps necessary for creating a
new database.
matthew
-Original Message-
From: Reindl Harald [mailto:h.rei..
ovide a simple example of how to edit /etc/my.cnf file and command
line steps necessary for creating a new database running on, for example, port
3311?
Thanks in advance.
matthew
I've noticed a weird issue in our chained replication environment where when
setting user-defined variables, the first time the variable is used in a
session the value is NULL, but all uses thereafter work correctly.
The environment is such: we have a master (master1), which has a slave which is
The following occurs when running the Live version of GnackTrack, if you
install from the LiveDVD this issue is no longer present.
LiveDVD can be downloaded from www.gnacktrack.co.uk - this can be used to
demonstrate issue but i think it's likely somethign simple
root@root:~# mysql
ERROR 2002 (HY0
Hi all
I have this query:
SELECT n.ID, n.CatalogNumber, [...more...], d.ID, d.CatalogNumber, [...more...]
FROM newdarwincoredata n
INNER JOIN darwincoredata d ON n.CatalogNumber = d.CatalogNumber
ORDER BY n.CatalogNumber;
Both tables have exactly the same structure and indices:
mysql> SHOW CREA
I'm trying to configure and start a MySQL 5.1 service for the first time,
and I'm having trouble. The MySQL Server 5.1 system was installed on a
separate drive from the system drive (if that's an issue). My GUI tools are
on the C: drive, and the server installation is on the E: drive.
Anyway, I'm
d...
Is there a way to compile to just the .so, without the extension that
would be more portable?
Or is there a better approach to this? or do I just need to maintain a
copy that is linked to each different version ?
Thanks
Matt
--
Matthew Kettlewell
http://www.Kettlewell.net/
SEO Tu
Here is my final problem that I am struggling to overcome...
SELECT Vouchers.VoucherID, Vouchers.VoucherCode, Vouchers.StartDate,
Vouchers.EndDate, Vouchers.Discount, Vouchers.VoucherTypeID
FROM Vouchers
WHERE (((DateDiff('d',[StartDate],Date()))>=0) AND ((DateDiff('d',
[EndDate],Date()))<=0
Hi, I have several procedures that I have taken from an old Microsoft
database, and I have tired to use them in a MySQL 5.1.32 database, but
I am getting errors when trying to input them. There are three in
total that I am struggling with and would appreciate some guidance...
This is a cros
I have taken a Microsoft Access database and have basically copied the
structure of it and rebuilt it in MySQL, however, I have encountered
some problems with formatting of data. I need to ask what is the most
suitable field type to use to retain the content from Access field types
The MS A
Until recently I have been using 4.0.25 and have just upgraded to 5.1
and just wondered if MySQL now enabled me to store queries in the
database rather than have to put them all on my pages. Basically, I
want to be able to write some select statements and save them in the
database.
Thanks
I am in the process of installing MySQL and PHP on my Mac following
instruction in a book written by a chap called David Powers. I have
come to a section that is called 'Securing MySQL on Mac OSX'.
Basically it states that MySQL is up and running with a default
account of 'root' and it's no
Hi all, I am on... wait for it... version 4.0.25 and I want to upgrade
to MySQL 5.x
Is there anything special I should do in order to upgrade? Do I need
to uninstall v4 or can I just download the most current version and
double click to upgrade? I am not particularly hardcore mysql minded,
I have just loaded MySQL 5 and MySQL Front on to a new computer, and
I am now getting a MySQL-Error which is:
Connection failed:
1045 - Access denied for user 'root'@'localhost' (using password: NO)
My Old pc has exactly the same settings but that uses MySQL 4
I have done a system restore to
I am trying to display results from one or the other part of the
query, however, at the moment it is showing results from both parts.
The Replace part of the query works fine in that it chooses the
correct data to display, but the content relevant to /8/ always
displays even when I select,
I have a DB that has a field in it that currently just holds single
or double numbers - these numbers are basically a reference to a
category in which the particular record should be displayed. However
I have now been asked if I can make it so that a particular record
can be displayed in mo
Hi, I have built a site with Dreamweaver and I have a problem with a
query.
I am trying to pass a parameter from one page to another to drill
down. Basically, I have one product entry that is in multiple
categories on my website. So, say it's a dress, it is therefore
related to category 1
I've got this statement to select the last two entries in my db:
SELECT top 2 *
FROM Content
ORDER BY ContentID desc
and it works fine because it selects the last two items entered into
the db. However, I only want to be able to select item 2 rather than
both 1 and 2. How do I do that?
Tha
It seems that mysqldump on mysql 5.0 does not export my stored
procedures.
How do I dump these out so that other people can load them into their
copies of my database?
Matt
--
A better way of running series of SAS programs:
http://overlook.homelinux.net/wilsonwiki/SasAndMakefiles
--
MySQL G
I'm writing a stored procedure that gets a VARCHAR(45) as a parameter.
Inside my stored procedure, I want to create a table with a name based
on that parameter.
For example, if I do
call my_sp('XXX');
I want the stored procedure to create a table named foo_XXX.
I don't know how to do this. He
I've spent the last month building a fairly elaborate database with lots
of foreign keys.
I want to draw a diagram that maps the relationships between all the
tables, but I haven't found any software that can do that.
Does anyone have any suggestions? I want to draw a picture with a box
for eac
I wrote a fairly large query that summarizes our sales into monthly
totals by business unit, then left joins on some other information from
a bunch of other tables.
Running the query takes a long time.
I'm considering whether to store my summary data as a table, like this:
create table monthly_t
Hi everyone,
My name is Matthew Zito, and I'm the Chief Scientist for a company called
GridApp Systems based here in New York City. We're currently looking at
extending our database automation software to MySQL, and rather than assume
that MySQL users are facing the same cha
-Original Message-
From: Skarlatos, Matthew P.
To: 'mysql@lists.mysql.com'
Sent: 2/13/2006 8:37 AM
Subject: Any help with resetting the administrative password using
'mysqld_safe' w/ the --init-file option
Has anyone run into a problem with setting the root us
Has anyone run into a problem with setting the root user password in mysql
using mysqld_safe with the '--init-file' option that contains the new
password for startup?
What I'm seeing after I issue the kill command for the 'host.pid' file and
then restarting 'mysqld_safe --init-file', is a short
Hi
I need to update the 'products_id' field (shown below) by copying data from
a separate table but I can't use the 'UPDATE' query as each 'product_id'
entry relates to a specific 'products_model' row.
id / assembly_no / products_id / products_model
1 / 2313 / *** / CASEACERENTRY2
2 / 2313 /
what does the JDBC code look like that your using to do the inserts?
On Fri, 2005-11-11 at 13:56 -0800, Dhiren Bhatia wrote:
> Any ideas on how I can optimize this? Thanks.
>
> On 11/9/05, Dhiren Bhatia <[EMAIL PROTECTED]> wrote:
> >
> > This is on a development box, 1.5 GB RAM, 1CPU (1.6GHz) wi
anyone using openoffice:base to design mysql db's? back when I tried it
earlier this year it wasn't able to define relationships which made it
pretty much useless as a time saving tool.
-Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:
i think you can use -K on your mysqldump and it'll put the hints in there
for the mysql command to use as well
- Original Message -
From: "Daniel Kasak" <[EMAIL PROTECTED]>
To:
Sent: Thursday, September 29, 2005 7:45 PM
Subject: Backup / Restore database with foreign keys
Greetings
ueries on various
> large indexes causing
> MySQL to really use its key_buffer, then there would be a more
> noticeable difference
> between a 16M key_buffer and 384M.
>
> -Daniel
>
> Matthew Lenz wrote:
>
> > so the sql-bench stuff doesn't push the mysqld to
so the sql-bench stuff doesn't push the mysqld to its limits?
- Original Message -
From: "Daniel" <[EMAIL PROTECTED]>
To: "Matthew Lenz" <[EMAIL PROTECTED]>
Cc: "mysql"
Sent: Sunday, September 11, 2005 1:12 PM
Subject: Re: default my.cn
- Original Message -
From: "Gleb Paharenko" <[EMAIL PROTECTED]>
Hello.
huge.cnf example. What about that thread_concurrency setting in
huge.cnf.. it doesn't seem to show up in a 'show variables' when using
it.. is it deprecated?
In the manual it is meant that thead_concurrency is use
infact .. the default debian config (some of these are just explicit
defaults but this is what debian provides):
[mysqld]
user= mysql
pid-file= /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port= 3306
basedir = /usr
datadir
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MySQL][ODBC 3.51 Driver]Access denied for user: '@localhost' to
database 'client_db1'
I am having trouble getting any MySQL site to work on my local PC, but
they work fine remotely. I have just changed PC and now have IIS
whereas before
Is MyISAM a bad choice for this kind of table?
- Original Message -
From: "Dathan Pattishall" <[EMAIL PROTECTED]>
To: "Matthew Simpson" <[EMAIL PROTECTED]>;
Sent: Friday, May 20, 2005 1:48 PM
Subject: RE: slow DELETE query
DELETE LOW_PRIORITY
But since
I use Mysql to store call detail records from telephone calls. I have
around 20 voice switches that send the call detail records in real time
using INSERT statements.
I am having a problem where I need to delete "junk" call records that get
generated [old call records, call records with no acc
have is, how do
I SELECT out the audio and store it to a file on the local disk?
Any examples? Sample code? Specific API functions I should look at?
I've seen how this is done using ODBC, but the ODBC code is really crappy
and not at all as easy as MySQL API.
Thanks,
Matthew
--
MyS
I had managed to land a job that required me to learn
MySQL quickly. I was used to working with access
though, so what I did was find a utility for access
called MyAccess which enables you to work in access
but you are actually affecting a MySQL db - it has a
few funny things that could put you off
led everything, you can copy
config.inc.php.sample to config.inc.php to get the default
configuration file, and edit that to set up your new environment.
Cheers,
Matthew
--
Dr Matthew J Seaman MA, D.Phil. 26 The Paddocks
t trash an existing configuration. Nor will it while I
remain the port maintainer.
Cheers,
Matthew
--
Dr Matthew J Seaman MA, D.Phil. 26 The Paddocks
Savill Way
PGP: http://www.infracaninophile.co.uk/pg
Hello all,
Basic question about creating a database that will be accessed by many users. Do I
create one web user account with no password in the mysql.user table or add each user
to the mysql.user table as they join up to my site? (Lots of books and documentation
says how to create users, the
$ mysql -u mysqlusername -e ''
On Mon, 1 Nov 2004, Scott Haneda wrote:
> My query works:
> (version 4)
>
> SELECT u.id, r.user_id,
>u.first_name, u.middle_name, u.last_name,
>u.company, u.department, u.address, u.address2,
>u.city, u.state, u.country, u.zip,
>u.pho
Hi Cecep,
On Fri, 29 Oct 2004, Cecep Rosuludin wrote:
> Gleb Paharenko <[EMAIL PROTECTED]> wrote:
> > See INSTALL-BINARY in the distribution directory and follow
> > instructions in it exactly.
> > Don't forget about mysql_install_db!
You appear to have missed this part out below. Don't know if
Hi Nathan,
Subqueries are only available in MySQL as of version 4.1.
On Fri, 29 Oct 2004, Nathan Coast wrote:
> Hi
>
> apologies if this is a dumb question but can you do subqueries in mysql?
>
> select count(*) as RES from ACL_USER_GROUP_ROLE as UGR where UGR.USER_ID
> =2 and UGR.ROLE_ID = (se
What is the best way to access a specific field in C? Its really easy in
PHP...
PHP
---
$res = mysql_real_query($mysql,"SELECT col1, col2 FROM table");
while($row = mysql_fetch_row($res)) {
print $row['col1'];
print $row['col2'];
}
Is the only way/best way to do the above in C by usin
So, how do I find the server's version that I am connected to if the
function I need to use won't work on pre 4.1 and the VERSION_ID check won't
work for different client-server versions?
Thanks,
Matthew
--
----
Matt
G'day all, I was hoping to leech from your amalgamated knowledge:
I've been asked to estimate the query performance of several SQL
queries that power our Reporting system. At the moment we're
preparing to scale up enormously the amount of data we're using in our
system, and therefore I'm trying to
How are you trying to do the updates (command line, web application, etc.)?
Matthew McNicol
T UmaShankari wrote:
Hello,
Actually i am running mysql in my localpc. when i was trying to update
some contents during runtime it is not updating. But mysql is running.
Can anyone please tell me where
infile is a lot faster.
Matthew McNicol
Michael Gale wrote:
Hello,
I have a question about data loading using mysql 4.0.20. If you need to load let's say 50,000 items into a database.
Now 50,000 is not a lot for a DB.
So my question is would it be fast to load the file using the local i
timeout| 28800
$
+-+-
--------$
--
_
Matthew McNicol
yellowmarker.co.uk
PHP / MySQL web development
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ng a MySql table.
Thanks in advance, Braulio.
--
_____
Matthew McNicol
yellowmarker.co.uk
PHP / MySQL web development
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks and regards,
..matthew
[EMAIL PROTECTED] wrote:
You can test if you can "see" the server from your other user's machine by
trying to connect to it with telnet. On the other user's machine, open a
telnet session to the server's address on port 3306 and press ENTER a few
ti
Matthew Stanfield wrote:
> I'm setting up MySQL databases on 'shared server' space I've rented
> using cPanel's 'MySQL Database' interface. I can add 'access hosts'
> (it's not limited to localhost) and it says the % wildcard is allowed
vial or annoying question (I can't find the answer anywhere)
but how do I just 'allow any host'? Presumably I use % in some way maybe
'%.%.%.%' (an all encompassing IP address with wildcards instead of
numbers) or maybe it's just '%'?
Thanks,
..matthew
--
I am trying to run the MySQL that comes with Red Hat Linux 7.3.
It is MySQL 3.23.49 for Red Hat Linux on i386. I can not get it to start and then stay
on.
>From root I type : /etc/init.d/mysqld start
I get : Starting MySQL [OK]
then it immediately goes back to root: [EMAIL PROTECTED] root
For the record/list archives,
The solution seems to have been upgrading to Fedora Core 2
kernel-smp-2.6.6-1.435.x86_64.rpm. What fix it contained that affected
my case... I'm not sure :)
Been running okay for 18 hours at high volume!
- Matt
> -Original Message-
> From: M
o luck.
I'm open for suggestions.
I suppose the next step is to install core 2 32-bit and try again.
Thanks,
Matthew Kent \ SA \ bravenet.com \ 1-250-954-3203 ext 108
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
join
between ProductTag and Tag to produce the columns:
Product.product, Product.cost, Tag.tag
where most Tag.tag fields will not have values.
I would hugely appreciate any assistance in this regard.
Matthew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
7;[EMAIL PROTECTED]:3306',
replication started in log 'db2-bin.004' at position 211
and no other errors. I have test.mrztest and can insert rows on the master
but they never appear on the slave.
Did I miss a step? Is Binlog_do_db supposed to be empty?
--
matthew zeier - "
I have a home page where I need to show three news articles which are
specified by the administrator - so it might not be the latest articles
and they might not be in any order. I have designed the db to have two
tables to fulfill this function the first table 'tbl_press' holds the
news article
Why would you want to?
Although the easiest way I know of if to rename and take of
auto_increment from the one field. Then recreate the field.
Andy B wrote:
would anybody know how to reindex an auto_increment field in a table??
--
With regards,
Say_Ten
===
, 20 Mar 2004, Matthew Hodgson wrote:
> Hi,
>
> I've been having problems with segfaults under mod_auth_mysql in Apache
> 1.3, which I think i've narrowed down to the MYSQL connection structure
> getting corrupted on my particular mysql installation - specifically
> man
Hi,
I've been having problems with segfaults under mod_auth_mysql in Apache
1.3, which I think i've narrowed down to the MYSQL connection structure
getting corrupted on my particular mysql installation - specifically
manifesting itself with strange values of the free_me field, which results
in the
Hello,
Can you give an estimate of when 5.0 will be released for production?
Thanks,
Matthew Son
I am running a debian linux server and I need mysqlplus installed. There
isn't a package yet for debian (at least not to my knowledge) to install it.
So, I downloaded the mysql++ 1.7.9 source to install it. I am running
version 2.95.4 of gcc. Is there something I am doing wrong? Do I need to
in
I am running a debian linux server and I need mysqlplus installed. There
isn't a package yet for debian (at least not to my knowledge) to install it.
So, I downloaded the mysql++ 1.7.9 source to install it. I am running
version 2.95.4 of gcc. Is there something I am doing wrong? Do I need to
in
database or is it some
clever sql - or both?
Thanks
Mat
--
Matthew Stuart
11 Yew Tree Close
Middleton Cheney
Banbury
Oxon
OX17 2SU
01295 713813
07803 207734
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
I assume the INSERT statement you have suggested goes on the webpage
that has the form from which the new record will be created, Is that
correct?
Thanks.
Mat
On Saturday, February 7, 2004, at 02:24 PM, Roger Baklund wrote:
* Matthew Stuart
I am trying to get MySQL to automatically create a
I am trying to get MySQL to automatically create a date seven days from
the date a new record is created. The new records will be inserted
through an ASP, VBScript website. I have managed to get this to work in
MS Access by typing in to its default field in the database Now()+7. As
you would ex
I have just started to use PHPMy Admin in the last hour or so. How do I
upload the data and structure to a remote server. I have done a
mysqldump and have tried to upload it but I keep getting an error.
I create a statement in a window, browse to a file to upload it and
submit the form. I wait
The ISP do have the driver installed and they also know what they are
talking about. The problem is they won't talk to me because I am not
the reseller (ie their customer). The reseller I have used knows
nothing about MySQL - he knows everything else but MySQL.
Mat
On Thursday, February 5, 2
I am having problems with making a connection between my website and
the MySQL db on a different server. I have tried both hand coding and
using the MyOLEDB application for MySQL. What am I doing wrong? If you
think this looks a little strange, it is because it is a dreamweaver
connection file.
This query is working fine apart from the LIMIT part. I can’t see what
is wrong with it, I have tried it in different places and still no
luck. Does anybody know why it’s not working?
WHERE (fld_headline LIKE'%userinput%' OR fld_summary LIKE'%userinput%'
OR fld_body LIKE'%userinput%') AND fld_c
I am trying to create a html search results page with the following:
SELECT *
FROM tbl_allarticles
WHERE (fld_headline LIKE'%userinput%' OR fld_summary
LIKE'%userinput%' OR fld_body LIKE'%userinput%') AND fld_category
LIKE 'catvalue'
The above works fine, but the below code is giving me some ji
I am trying to create a html search results page with the following:
SELECT *
FROM tbl_allarticles
WHERE (fld_headline LIKE'%userinput%' OR fld_summary LIKE'%userinput%'
OR fld_body LIKE'%userinput%') AND fld_category LIKE 'catvalue'
The above works fine, but the below code is giving me some jip
I have developed a website on my PC and I am testing there too. I keep
getting script time out errors, can I stop this from happening? I am
basically having to build an identical site and test it using access.
Double the work!!
I can't believe that access is responding tens if not hundreds of t
On Friday, January 30, 2004, at 03:12 AM, [EMAIL PROTECTED] wrote:
There was some discussion in December of converting MS Access
databases to Mysql and the DBManager program was recommended.
I have recently converted access to mysql. I used access to import a
CSV file and ensured all data was in
I have built a web site and I am testing it locally on my PC. Testing
through Internet Explorer is awfully slow and most of the time I am
getting error 'ASP 0113' script timed out. The table I am calling
records from is quite text heavy (a few hundred to a 1,000+ words per
field in some places)
On Fri, 23 Jan 2004, Paul DuBois wrote:
>At 17:32 -0800 1/23/04, Matthew Bogosian wrote:
>>Although this does the trick (kind of), this just turns off integrity
>>checking for that session, right? When I turn it back on, any
>>statement that would have failed but didn&#
FOREIGN KEY (parent_id) REFERENCES test_parent (id) ON DELETE
CASCADE POSTPONE FOREIGN_KEY_CHECKS UNTIL COMMIT
) TYPE = INNODB;
Or something like that. Of course if auto-commit is on, then the
behavior would be unchanged.
--Matt
On Fri, 23 Jan 2004, Paul DuBois wrote:
>At
I searched the archives and the manual for an answer to this, but I
haven't found an answer. I have several InnoDB tables:
CREATE TABLE test_parent
(
id INTEGER NOT NULL PRIMARY KEY
) TYPE = INNODB;
CREATE TABLE test_child
(
id INTEGER NOT NULL PRIMARY KEY,
I have created a sql statement that enables me to select all entries in
to MySQL that are dated today, I am trying to do the same for all items
that are now one day old and also two days old etc
I am doing this:
SELECT *
FROM table
WHERE category = 3 AND show = 1 AND date = NOW()-1
I have it wo
ASP and VB
I have created a search web page searching a MySQL table with the
following code:
CREATE TABLE tbl_allarticles (
fld_ID mediumint(8) unsigned NOT NULL auto_increment,
fld_category tinyint(2) unsigned NOT NULL default '0',
fld_updateddate timestamp(8) NOT NULL,
fld_createddate timesta
Hi,
Quick question since I can't see to find version information online.
What version was enum first supported under?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Right having just got to grips with the mysqldump command, I would like
to be able to know how to import the database back in to MySQL should
anything happen to my PC.
Does mysqlimport have to be done in the command line window like
mysqldump, and if so, how? It's just that I tried to import st
f time was put into
> these tables' structures and I hate to lose that effort...
>
> Yes the users are kicking themselves about the backup...
>
> MTIA
> Adam
>
--
Matthew Scott <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.
command in the start menus run dialogue box:
C:\Windows\Desktop> cd C:\mysql\bin
and from there I have issued all commands in the black window.
Is this not the command line, and if not, what is?
Sorry for my ignorance, I am still a beginner.
Mat
--
Matthew Stuart
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 I ca
I have tried two ways of dumping data but it doesn't seem to be working.
One using the admin window with mysqldump dbname > dumptest.sql but I
don't know if it has done anything because all it did was return to a
new blank line. I can't find anywhere a file named dumptest.sql
The other way was
I have been given these passwords for a MySQL db on a remote server. I
have to dump the records to this volume on the remote and I am not sure
what these passwords mean to me.
SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER
username_master
password
SELECT,INSERT,UPDATE,DELETE
username_runtime
pass
I am using version 4 of MySQL and the people who I am told to use to
host the site are running 3 on the server I will be using.
I am not using any real complex table structures eg: autoincrement,
date, timestamp, medium int, small int, indexes. I have to do a dump of
data to install on remote s
Man I have been banging away at this for a week and I am only just
getting to a point where I am finding a resolution. There seems to be a
lot of info out there for this kind of thing, but very little on how to
implement it.
I use ASP and VBScript with Macromedia Dreamweaver so with asp I can
would like to be able to use MS Access
for reporting purposes.
I don't think odbc is available via the hosted webspace so I may have to export the
data periodically to the MS Access database using cron/scheduling.
Any recommendations?
Matth
I am on my first MySQL DB and it is very text heavy because it is a
news site, therefore there is a great deal of use of the apostrophe or
as MySQL would see it the single quote. I was hoping to be able to use
double quotes to overcome the need to constantly have to escape the
apostrophe/single
I have been sent a url for datetime explanations in the MySQL manual. I
have learnt a few things, but I am also more confused than ever.
I am trying to create a couple of columns (one createddate and one
updateddate) in a MySQL table that are DATETIME or TIMESTAMP values,
but I am having troubl
I have my website and MySQL db sitting locally on my PC. I need to get
it to the remote server, I know how to get the website pages and images
there, but am not sure how to transfer the data, tables and all from
the database. Can somebody help me or point me to a tutorial?
Thanks
Mat
--
MySQL
I have an access db with populated fields, some of them are date
fields. One is a created date and another is a updated date. I haven't
tried it yet, so I am not sure what I will get but I assume that if I
am asking MySQL to automatically update these fields rather than
manually have to fill th
> Hi,
>
> I am new to MySQL and old to MS Access (advanced skill level).
>
> When building Access DBs, I write VB code, SQL, develop DBs using 3rd
N.F.
> and build lovely forms for data entry, print outs, reports etc, etc.
>
> After examing MySQL's material, I don't see any forms like I use in
Acc
1 - 100 of 389 matches
Mail list logo
