* h...@tbbs.net [150401 15:22]:
> On 2015/04/01 16:09, Tim Johnson wrote:
> >Using Mysql 5 on darwin (OS x).
> >This command
> >SELECT schema_name FROM information_schema.schemata WHERE
> >schema_name NOT IN
> >('mysql','information_schema'
Using Mysql 5 on darwin (OS x).
This command
SELECT schema_name FROM information_schema.schemata WHERE
schema_name NOT IN
('mysql','information_schema','performance_schema');
as executed from the mysql prompt gives me a dump of all databases
except those not included in the tuple.
This command
mys
* Reindl Harald [141005 13:12]:
>
> Am 05.10.2014 um 21:29 schrieb Tim Johnson:
> >I have a dual-boot OS X/Ubuntu 12.04 arrangement on a mac mini. The
> >ubuntu system has failed and I am unable to boot it.
> >
> >I have one database on the ubuntu partition that
* Jan Steinman [141005 13:12]:
> > So, this is a "Help me before I hurt myself" sort of question: Are
> > there any caveats and gotchas to consider?
> Do you know if the database was shut down properly? Or did Ubunto
> crash and die and your partition become unbootable while the
> database was i
I have a dual-boot OS X/Ubuntu 12.04 arrangement on a mac mini. The
ubuntu system has failed and I am unable to boot it.
I have one database on the ubuntu partition that was not backed up.
I am able to mount the ubuntu partion with fuse-ext2 from Mac OS X,
thus I can read and copy the mysql dat
* h...@tbbs.net [140407 23:09]:
> >>>> 2014/04/07 08:02 -0800, Tim Johnson >>>>
> 2)mysqldump forces all database names to lower case in the "CREATE
> DATABASE" statement. I know, one shouldn't use upper case in
> database names, but :) t
* shawn l.green [140407 07:05]:
> Hello Tim,
>
> On 4/4/2014 10:27 PM, Tim Johnson wrote:
> >* Tim Johnson [140404 17:46]:
> >>Currently I'm running mysql on a Mac OSX partition.
> >>
> >>I have installed an ubuntu dual-booted partition and put
* Tim Johnson [140404 17:46]:
> Currently I'm running mysql on a Mac OSX partition.
>
> I have installed an ubuntu dual-booted partition and put mysql on
> it. I have already set up a mysql user on the ubuntu OS.
>
> In the past I have used mysqldump with just the --al
Currently I'm running mysql on a Mac OSX partition.
I have installed an ubuntu dual-booted partition and put mysql on
it. I have already set up a mysql user on the ubuntu OS.
In the past I have used mysqldump with just the --all-databases
option to transfer data across different linux partition
* Reindl Harald [121031 17:22]:
>
>
> Am 01.11.2012 01:54, schrieb Tim Johnson:
> > * Reindl Harald [121031 08:12]:
> >> you MUST NOT use "localhost" if you want to connect to
> >> a different mysqld-port because "localhost" is unix-s
* Reindl Harald [121031 08:12]:
>
>
> Am 31.10.2012 16:34, schrieb Tim Johnson:
> > * Johan De Meersman [121031 07:10]:
> >
> >> Given the different location of the datafiles and assuming the
> >> actual drupal does work, I'm starting to suspect t
* Johan De Meersman [121031 07:10]:
> Tim Johnson wrote:
>
> >* Ananda Kumar [121030 09:48]:
> >> why dont u create a softlink
> > From /opt/local/var/db/mysql5/ to /opt/local/var/db/mysql5/ ???
> >
> > I can try that, but I am doing things to MySQL tha
* Johan De Meersman [121031 07:10]:
> Given the different location of the datafiles and assuming the
> actual drupal does work, I'm starting to suspect that whatever
> installer you used created a second instance of mysql. Your drupal
> configfile should hold the necessary data to connect to it
* Tim Johnson [121030 10:40]:
> OP :
> * Tim Johnson [121029 16:28]:
<...snip>
> > I want to back up the mysql data for drupal.
> > However, I can't locate those databases and tables using MySQL
> > server or PHPMyAdmin, even if I start mysql on port 3307.
&l
OP :
* Tim Johnson [121029 16:28]:
> I've recently unstalled drupal 7.15 on Mac OS X 10.7.
>
> I want to back up the mysql data for drupal.
> However, I can't locate those databases and tables using MySQL
> server or PHPMyAdmin, even if I start mysql on port 3307.
>
* Hassan Schroeder [121030 08:25]:
> On Tue, Oct 30, 2012 at 9:12 AM, Tim Johnson wrote:
>
> > I might try cp -p -r, but need a second opinion.
>
> If you want to dump one or more databases, presumably you know
> the name(s); just use the mysqldump utility. Copying files
* Ananda Kumar [121030 09:48]:
> why dont u create a softlink
From /opt/local/var/db/mysql5/ to /opt/local/var/db/mysql5/ ???
I can try that, but I am doing things to MySQL that I have never
done before and I am reluctant to risk clobbering a complex
development environment that has nothing t
* Kishore Vaishnav [121030 08:25]:
<...snip>
> Or the other option to install a module in Drupal "Backup &
> Restore" which can you just login thru drupal and you can take a
> dump of the existing database if you have admin credentials.
OK. Use drupal directly? That makes sense. I see from
htt
* Reindl Harald [121030 08:49]:
> >The drupal mysql datafiles are located at
> > /Applications/drupal-7.15-0/mysql/data
> >
> > as opposed to /opt/local/var/db/mysql5 for
> > 'customary' mysql.
>
> this crap is outside your mysqldata
I don't know what you mean by "crap". Sorry.
Actually I do .
* Shawn Green [121030 09:01]:
> On 10/30/2012 12:34 PM, Tim Johnson wrote:
> >... snip ...
> >
> > Clearly, I have failed to pose my question clearly, because the
> > responses indicate that I have not been understood
* Tim Johnson [121030 08:37]:
> *
> I remain as dumb as ever, but I hope I have made myself clearer
> regards
To elaborate further : See this entry from mysql --help
"""
Default options are read
* Reindl Harald [121030 08:25]:
> if it are MyISAM tables it is the best way because all data
> are in a folder with the database name - i never in my life
> used a dump to migrate mysql-databases while started with
> MySQL-3.x long years ago and moved them between Linux,
> Windows and MacOSX and
* 小刀 <13488684...@163.com> [121029 18:43]:
> You can the the /etc/my.cnf and file the parameter about the data_dir
I'm sorry. I don't understand.
I might try cp -p -r, but need a second opinion.
BTW: No need to CC me.
thanks
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot com
h
I've recently unstalled drupal 7.15 on Mac OS X 10.7.
I want to back up the mysql data for drupal.
However, I can't locate those databases and tables using MySQL
server or PHPMyAdmin, even if I start mysql on port 3307.
The drupal mysql datafiles are located at
/Applications/drupal-7.15-0/mysql/d
* Arthur Fuller [120119 07:09]:
> You might want to have a look at our free utility called The_Usual, so
> named because it's what a regular customer says in a bar or restaurant.
> It's written in PHP and it does all the usual things such as Add, Edit,
> Search, and goes a bit further (master-deta
* Michael Dykman [120118 16:04]:
> Tim,
>
> I'm a dyed-in-the-wool console user myself.
:) As am I. Great minds run in the same gutter!
> I find the GUI tools make
> it quicker getting a project started, slower getting a project done
> so, no, I can't recommend a thing.
I find that to be g
* Claudio Nanni [120118 15:49]:
> Hi Tim,
Hi Again Claudio:
> Excuse me but still I don't understand exactly what is the product you want
> to build.
I'm sorry, I'm not expressing myself well, I know it!
I build all sorts of web-based products...
> One thing is a tool (IDE) to work and one
* Michael Dykman [120118 13:00]:
> Mysql is a backend service and has no such application-level tools.
>
> You can, however, use MS-Access (or any other such tool) and use MySL
> as a backend via an ODBC driver.
Thanks Michael. I have use MS-Access in the past, but we no longer
use Windows he
* Claudio Nanni [120118 14:15]:
> Tim,
>
> are you designing a client/server application or a web based one?
Hi Claudio :
I am asking a general question. I have developed web-based apps
with mysql editing features for over 10 years now, but I am a
little lazy. Or to be m
Are there any utilities available that will enable the quick design
and implementation of forms for editing and adding records?
I.E. something like M$-Access or OpenOffice form designer/wizards.
thanks
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com
--
My
* Martin Mueller [12 13:42]:
<..>
> In short, in my installation there seems a gap between mysql and mysql, and
> I can't find any good explanations for what I might have done wrong or how I
> could fix it.
>
> I'll be grateful for any help.
I am probably not going to be very useful, but
* Reindl Harald [111018 23:24]:
> Am 19.10.2011 01:36, schrieb Tim Johnson:
> >> try "mysql -u tim -p"
> > Same error:
> > ERROR 1045 (28000): Access denied for user 'tim'@'localhost' (using
> > password: NO)
> >> > and
* Tim Johnson [111018 17:47]:
Got this...
mysql> select host,user,password from user;
+-+--+---+
| host| user | passw
* Claudio Nanni [111018 17:02]:
> FLUSH PRIVILEGES is not needed when you use GRANT/REVOKE/CREATE USER
> etc,
>
> Usually this problem comes when you have the anonymous user in the grant
> tables (''),
> MySQL has a tricky way of processing the grant tables.
>
> Sometimes you can be surprise
* Reindl Harald [111018 15:14]:
>
>
> Am 19.10.2011 01:03, schrieb Tim Johnson:
> > Now when I try to log in with host as localhost, user as tim
> > with 'secret' password:
> > linus:~ tim$ mysql --host=localhost --user=tim --password=secret
> > ERRO
* Mark [111018 15:14]:
> Did you issue a 'FLUSH PRIVILEGES;' before quitting the mysql session?
Not originally, but I repeated the grant then
issued
flush privileges;
quit
and have the same problem
thanks
--
Tim
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebs
using 5.1.57 on Mac Lion.
I've done this a dozen times, but I've missed something.
Am setting up a new mysql installation ...
I have granted a user as follows (between lines of asterisks)
linus:~ tim$ sudo mysql
Password:
Welcome to the
* Brandon Phelps [111011 07:43]:
> Tim,
> Just a reminder, as I am not sure if it is documented or not;
> After you get MySQL up and running via the DMG package be sure to
> install the System Preferences pane (it didn't use to install by
> default, not sure if it does now) which should be one o
* Tim Johnson [111010 15:37]:
> I familiar with mysql on linux, as of late - ubuntu.
> I am installing mysql on a mac mini, with the Lion - osx 10.7
> operating system.
>
> mysql-server was downloaded and built with macports.
> Following instructions included has not result
I familiar with mysql on linux, as of late - ubuntu.
I am installing mysql on a mac mini, with the Lion - osx 10.7
operating system.
mysql-server was downloaded and built with macports.
Following instructions included has not resulted in a successful
startup.
I have recorded error messages, but it
* Dan Nelson [110618 16:33]:
> In the last episode (Jun 18), Tim Johnson said:
> > Is there an optimal 'alignment' for column widths for
> > varchar types?
> >
> > I.E., divisible by 8 or 10 or by powers of 2?
>
> No. Varchar fields are sto
Is there an optimal 'alignment' for column widths for
varchar types?
I.E., divisible by 8 or 10 or by powers of 2?
URLs to documentation would be more than sufficient.
Version 5+, linux platforms.
thanks
--
Tim
tim at johnsons-web dot com or akwebsoft dot com
http://www.akwebsoft.com
--
MyS
* Tim Johnson [101118 12:58]:
> * Tim Johnson [101118 11:05]:
> > using
> > mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu
> >
> > I have root access to the mysql command line.
> >
> > I need to grant access to user 'username' for al
* Tim Johnson [101118 11:05]:
> using
> mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu
>
> I have root access to the mysql command line.
>
> I need to grant access to user 'username' for all databases
> except for the mysql database for both onsite (
using
mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu
I have root access to the mysql command line.
I need to grant access to user 'username' for all databases
except for the mysql database for both onsite (cgi script) and
remote access.
What is the syntax?
--
Tim
tim at johnsons-web.c
* Bob Cole [100515 06:58]:
> You might get closer to what you want if you put your command in a text file
> and run it from the command line.
> On a Mac OS X, I put a similar command:
> select count(*) from testTable;
> into a small text file:
> testCount.txt
> and ran this command fro
* Dan Nelson [100514 21:38]:
>
> You can't do it with one function call, but you can do it, since the MySQL
> cli was able to print "16" in your example above, and it was written in C.
> Take a look at mysql_store_result(), mysql_num_fields(),
> mysql_field_count(), mysql_fetch_row(), and mysql_
I have MySQL version 5.0.84 on linux slackware 13.0 32-bit.
I am working with a relatively new API written in a programming
language with a small user base (newlisp). The newlisp API imports a
number of C API functions from the system MySQL shared object.
If I were to issue a count(*) query fr
Since MySQL is one of our tools, we would like to have
a logo that we can use at our website. And we will use
it to link back to the MySQL site.
Can someone point me to MySQL logos that I can legitimately
use?
Thanks
Tim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
Hi:
Using mysql 5.0.45 on linux 2.6.22-15 (ubuntu).
I can create tab-deliminated text files using mysqldump -T, but
I haven't found a way to include a header with column names.
Any ideas?
It's any easy task for me to extract them with a script, but if
mysqldump can do it, so much for the better.
TI
On Thursday 12 June 2008, David Giragosian wrote:
> The same is true of mysql_real_escape_string() in PHP. You escape
> special characters upon update or insertion, but upon viewing the data
> in the DB or retrieving it programmatically, the data simply appear as
> it was originally before use of
On Thursday 12 June 2008, Warren Young wrote:
> Tim Johnson wrote:
> > Not sure what you mean by "directly usable".
>
> I mean "directly usable". :)
>
> > If I do an insert statement with a backslash, for example:
> > "headline\one"
On Thursday 12 June 2008, Warren Young wrote:
> Tim Johnson wrote:
> > I can not locate a C api function to _unescape_ strings.
>
> Why do you believe you need one?
>
> You need to escape strings when building SQL query strings to avoid
> problems with quote characters,
Using MySQL 5.0.45 on linux.
For the first time I am using the C API directly. I am using
mysql_real_escape_string() - see
http://dev.mysql.com/doc/refman/5.1/en/mysql-real-escape-string.html
I can not locate a C api function to _unescape_ strings. If there were one,
I would use it. If I have over
redhat machines, I'm
going to avoid doing this in the future for ubuntu if I can.
On Tuesday 30 October 2007, Warren Young wrote:
> Tim Johnson wrote:
> >> It isn't "broken," per se.
> >
> > When you say that it isn't "broken", coul
On Tuesday 30 October 2007, Warren Young wrote:
> Tim Johnson wrote:
> >> It isn't "broken," per se.
> >
> > When you say that it isn't "broken", could you please elaborate?
>
> Once again: It seems to me that you're seeing a purp
On Tuesday 30 October 2007, Warren Young wrote:
> Tim Johnson wrote:
> > Is there a possible repair routine to run?
>
> It isn't "broken," per se.
When you say that it isn't "broken", could you please elaborate?
And thanks in advance, because, f
On Tuesday 30 October 2007, Warren Young wrote:
> Tim Johnson wrote:
> > The file pattern is *not* as I expressed it above.
>
> Yeah, I figured that out, and ignored the error in my reply.
>
> The answer remains the same: unless you're purposefully doing something
> w
On Tuesday 30 October 2007, Warren Young wrote:
> Tim Johnson wrote:
> > Can't find file: './mysql/(database_name).frm' for numerous databases.
>
> That's the file the actual table data is stored in. Unless you're on a
> shared machine and are trying to
using Distrib 5.0.45 on ubuntu 7.04, mysql was installed via adept manager.
I'm getting many error messages on the type:
Can't find file: './mysql/(database_name).frm' for numerous databases.
The mysql database was installed automatically during installation, and
I'm getting them for ./mysql/time
Hello:
I am preparing to install the latest mysql server on ubuntu - I think it will
be version 5+. It has been some time since I have done a setup and I would
appreciate updated instructions.
The ubuntu install via Adept Manager will ask for a root password.
Following that I know that I must add
On Thursday 02 August 2007, Tim Johnson wrote:
> Hi:
> I use 5.0.38 on my ubuntu desktop
> and I have to work with ver 3.23.56 on a solaris-based server.
>
> The following update query:
> UPDATE wine_list,FRED SET wine_list.wine_ID=FRED.WMJ_ID WHERE
> wine_list.wine_ID=FRED.
Hi:
I use 5.0.38 on my ubuntu desktop
and I have to work with ver 3.23.56 on a solaris-based server.
The following update query:
UPDATE wine_list,FRED SET wine_list.wine_ID=FRED.WMJ_ID WHERE
wine_list.wine_ID=FRED.wine_ID;
works on 5.038, but on 3.23.56 I get the following:
ERROR 1064 (0): Y
On Monday 16 April 2007 07:56, Tim Johnson wrote:
> Hi:
> I have a table with a column of type char(120).
> default is NULL
> How do I a set a 'cell' back to NULL?
> Example:
> alter customers set all_colslist=NULL where ID=57;
> returns a syntax error.
> Mys
Hi:
I have a table with a column of type char(120).
default is NULL
How do I a set a 'cell' back to NULL?
Example:
alter customers set all_colslist=NULL where ID=57;
returns a syntax error.
Mysql version 4.0.20
thanks
--
Tim Johnson <[EMAIL PROTECTED]>
Palmer, Alaska, USA
-
ime.
Since it will be the weekend before I try this out, I welcome observations
and any references to meta-data approaches using MySQL /MyISAM.
Thanks to everybody for the quick responses.
regards
--
Tim Johnson <[EMAIL PROTECTED]>
Palmer, Alaska, USA
Alaska Internet Solutions (2 hair
On Wednesday 21 February 2007 17:43, Rolando Edwards wrote:
> SHOW INDEXES FROM `providers`;
>
> By the way, what version of MySQL are you using ???
4.0.20
--
Tim Johnson <[EMAIL PROTECTED]>
Palmer, Alaska, USA
--
MySQL General Mailing List
For list archives: http://lists.mys
LL default '-00-00',
`company_ID` int(11) NOT NULL default '0',
`status` int(6) default NULL,
`modified` timestamp(10) NOT NULL,
UNIQUE KEY `ID` (`ID`)
) TYPE=MyISAM
1 row in set (0.00 sec)
As you can see there is no reference info for column `status`
thanks
tim
ULL |
+---+---+--+-+++
Is there a syntax equivalent of 'describe' that can show me the references?
thanks
tim
--
Tim Johnson <[EMAIL PROTECTED]>
Palmer, Alaska, USA
--
MySQL General Mailing List
For
o relevant documentation?
thanks
tim
--
Tim Johnson <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
rl
> create table like ;
> alter table add column column-2 after
> column-1; alter table drop column column-1;
Wham! I like LIKE!
thanks
tim
> Give a try (the latter one, of course)
>
> ----- Original Message -
> From: "Tim Johnson" <
Hello:
I have a need to create two tables from imported data.
The only difference between the tables is the column names.
The data will be the same.
Can anyone propose a mysql method to create a new table
from an existing table with new column names?
thanks
tim
--
Tim Johnson <[EM
* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [060223 09:09]:
> Tim Johnson <[EMAIL PROTECTED]> wrote on 02/23/2006 12:26:35 PM:
> > I need the most efficient way to do this: examples, keywords, and
> > URLs to relevant documentation are all welcome.
<>
> First o
me value where Account.city matches City.ID.
I need the most efficient way to do this: examples, keywords, and
URLs to relevant documentation are all welcome.
thanks
tim
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
--
MySQL General Mailing List
For li
lib/mysql/. Most
> likely, user mysql is not set as the owner of /var/lib/mysql/, in which
> case you need to
>
> chown -R mysql:mysql /var/lib/mysql/
>
> as root.
Bingo! That worked and I learned *two* things. :-)
thanks
tim
--
Tim Johnson <[EMAIL PROTECTED]
e that I have a problem with permissions.
Can anyone point me to the solution?
Many Thanks
tim
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ight be provided to him to upgrade and what caveats
might be cited?
Thanks very much for the pointer to the docs.
regards
tim
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
| tim |
+---+--+
Any advice is appreciated:
Am working from the installed docs.
Thanks
tj
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
areas.
>
> Except for those areas that it doesn't.
> [/snip]
The best situation might be a combination of both.
But wait! That's what I have. Boot up linux, then
start windows in it's own desktop. Best of both
worlds!
And lately, I've been using MS-Access
* Tim Johnson <[EMAIL PROTECTED]> [050723 10:42]:
> * sol beach <[EMAIL PROTECTED]> [050723 09:15]:
> > I suspect a case problem
> Hello sol:
> I'm using a case insensitive seach.
> i.e.:
>
> [EMAIL PROTECTED] tim]$ locate -i libmysql.so
>
* sol beach <[EMAIL PROTECTED]> [050723 09:15]:
> I suspect a case problem
Hello sol:
I'm using a case insensitive seach.
i.e.:
[EMAIL PROTECTED] tim]$ locate -i libmysql.so
[EMAIL PROTECTED] tim]$
same results as root
thanks
tim
--
Tim Johnson <
with that name on either of
my linux partitions. The library developer is primarily a
windows programmer and has told me that this file should
be included with the distribution.
Can anyone clarify this matter for me? Do I need a symlink?
If so to what?
thanks
tim
--
Tim Johnson <[EM
to override the default location of the socket for the
> server,
> you will also need to add an entry for the client.
>
> [mysql]
> socket=/var/lib/mysql/mysql.sock
... of course ...
That's what I needed.
(the my.cnf was copied from a RH 9.0 partition with
mysql
ysql.com/?ref=ensita
> This email is sponsored by Ensita.NET http://www.ensita.net/
>__ ___ ___ __
> / |/ /_ __/ __/ __ \/ /Gleb Paharenko
> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
><_
ime was:
"""
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
"""
And I'm sorry to say, but I don't know what that means.
Again, advice and clarification of these instructions are welcome.
Than
;t clear as to whether
or not I should run mysql_install_db. Looks like I should, 'cuz
slack doesn't use RPM.
Cheers
tim
> 4.0.20 is rather old, use the latest release (4.1.12).
>
>
>
> Tim Johnson <[EMAIL PROTECTED]> wrote:
> > Hello All:
> >
Hello All:
I am most familiar with mysql thru RH 9.0 and win XP.
I have set up a slackware partition (ver 10.0) with
mysql ver 4.0.20.
Are there any special instructions for Post-Installation Procedures?
thanks
tim
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-in
the Slackware
partition safely?
What issues are there, if any? Pointers to docs, URLs
etc are appreciated.
Thanks
tim
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
generate
a query with multiple ORs?
This will have to be run on a *nix server with version prior to 4.0, I
believe.
Solutions, comments and pointers to relevant documentation is all welcome.
Thanks
Tim Johnson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
.10 is needed by (installed) php-mysql-4.2.2-17.2
I presume that I need other packages. What packages would that be?
thanks
tim
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my
. Just gcc (GCC) 3.2.2
Comments and pointers to docs would be appreciated.
Thanks much
tim
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
could find something with
less "extra" text, that would be great.
TIA
tim
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
* Frank Bax <[EMAIL PROTECTED]> [040615 12:59]:
> At 03:14 PM 6/15/04, Tim Johnson wrote:
> >We are importing data from 3 CSV files.
<..> >the 3 tables into 1.
> >
> >Taken as a sum, we should have about 330 columns
> >and 5000+ rows.
Hi Frank:
>
s (search in both in the WEB and GROUPS areas).
>
> Yours,
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
>
>
>
>
>
5000+ rows.
Comments would be appreciated.
Pointers to documentation on this subject
are also quite welcome.
Thanks in Advance
Regards;
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
lect LEFT(names, 1) from table
Thanks folks.
I love it!
tim
<..> > another way of asking my questions would be,
> > Is it possible to truncate columns in selection
> > set to a specific length (in the case: 1)
> >
> > Pointers to relevant documents are
length (in the case: 1)
Pointers to relevant documents are welcome.
Thanks
tim
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
k for
source and try to compile, if no other solution
offered.
Thanks
tim
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ieve that you can harness regex
directly with mysql, I haven't done anything more than simple
blobs.
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
http://www.johnsons-web.com
--
MySQL General Mailing List
For list archives: http://lists.my
* Egor Egorov <[EMAIL PROTECTED]> [030814 03:49]:
> Tim Johnson <[EMAIL PROTECTED]> wrote:
> >I would like to rename a table if it exists.
> >
> > The following query
> > IF EXISTS ALTER TABLE gwcc_members RENAME gwcc_members_bak;
> > fails.
1 - 100 of 126 matches
Mail list logo
