Igor Delovski Board Forum Index Igor Delovski Board
My Own Personal Slashdot!
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

MySQL

 
Post new topic   Reply to topic    Igor Delovski Board Forum Index -> General Programming
General Programming  
Author Message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Tue Dec 18, 2007 5:06 pm    Post subject: MySQL Reply with quote

adc: MySQL on Mac OS X

If you’re running Mac OS X Server, you are in luck — MySQL is already there.
Just go to Applications/Server/MySQL Manager to access it. If you are running
Mac OS X Client, you’ll have to install MySQL.

If you have already installed a version of MySQl and want to upgrade, I can
recommend the upgrade instructions from http://www.entropy.ch. For a new
installation, follow the Mac OS X installation instructions for the MySQL
provided binary distribution ( a true Mac OS X installer package file) at
http://dev.mysql.com/doc/refman/5.0/en/mac-os-x-installation.html and be
done with it.
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Tue Dec 18, 2007 5:11 pm    Post subject: Reply with quote

MySQL GUI Tools Downloads

"This is the MySQL GUI Tools Bundle for 5.0. It includes the following products:

* MySQL Administrator 1.2 Generally Available (GA)
* MySQL Query Browser 1.2 Generally Available (GA)
* MySQL Migration Toolkit 1.1 Generally Available (GA)

The major features of the individual products are described on the product
information pages."
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Tue Dec 18, 2007 5:13 pm    Post subject: Reply with quote

MySQL C API

"The C API code is distributed with MySQL. It is included in the mysqlclient
library and allows C programs to access a database.

Many of the clients in the MySQL source distribution are written in C. If you
are looking for examples that demonstrate how to use the C API, take a look
at these clients. You can find these in the clients directory in the MySQL source
distribution."
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Tue Dec 18, 2007 5:18 pm    Post subject: Reply with quote

UCL: Calling MySQL from C

"Full details of the C API (Application Program Interface) are given in the
MySQL manual"


Mark's Blog: A Tour of the MySQL C API

"Using Eclipse, we'll develop an example application that will document key
structures, and demonstrate several API calls. This article will also cover
configuring Ubuntu and Eclipse for MySQL client development."
Back to top
View user's profile Send private message
XNote
Kapetan


Joined: 16 Jun 2006
Posts: 520

PostPosted: Tue Dec 18, 2007 7:34 pm    Post subject: Reply with quote

Forum: MySQL Forums & MySQL Forums :: C/C++
Back to top
View user's profile Send private message
delovski



Joined: 14 Jun 2006
Posts: 3522
Location: Zagreb

PostPosted: Tue Dec 18, 2007 10:12 pm    Post subject: Reply with quote

Dev Shed Forums > Databases > MySQL Help

"MySQL Help forum discussing administration, SQL syntax, and other
MySQL-related topics. MySQL is an open-source relational database
management system (RDBMS)."
Back to top
View user's profile Send private message Visit poster's website
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Fri Feb 08, 2008 8:15 pm    Post subject: Reply with quote

Dan Benjamin: Installing MySQL on Mac OS X

"What follows are instructions for building and installing MySQL 5 on Mac OS X.
These instructions should work perfectly on both Tiger and Leopard."
Back to top
View user's profile Send private message
delovski



Joined: 14 Jun 2006
Posts: 3522
Location: Zagreb

PostPosted: Sun Apr 27, 2008 12:02 am    Post subject: Reply with quote

uf - SQL tutorial?

"Does anyone know were i could find a good free sql tutorial?"
Back to top
View user's profile Send private message Visit poster's website
delovski



Joined: 14 Jun 2006
Posts: 3522
Location: Zagreb

PostPosted: Thu Oct 09, 2008 11:27 am    Post subject: Reply with quote

MF - MySQL Objective C API?

"I've found a few links about a MySQL Objective C API - however I haven't
been able to get the examples to work so far...

Question is... Anyone have any experience coding on XCode 3 and MySQL?"
Back to top
View user's profile Send private message Visit poster's website
XNote
Kapetan


Joined: 16 Jun 2006
Posts: 520

PostPosted: Thu Nov 20, 2008 1:22 pm    Post subject: Reply with quote

cboard - Accessing an SQL database through C++

"I'd like to access an SQL database from within a Win32 application using C++."
Back to top
View user's profile Send private message
delovski



Joined: 14 Jun 2006
Posts: 3522
Location: Zagreb

PostPosted: Thu Mar 12, 2009 10:18 pm    Post subject: Reply with quote

MF: Which DBMS in Obj-C?

"Basically I just want a way to use a database with Objective-C.

I could use C as a last resort. "
Back to top
View user's profile Send private message Visit poster's website
XNote
Kapetan


Joined: 16 Jun 2006
Posts: 520

PostPosted: Sun Jul 04, 2010 10:16 pm    Post subject: Reply with quote

MF - Using mysql with cocoa

"I would need to use mysql with cocoa for my app and found only the
outdated version of some library, what would you guys recommend? Is
there any new ones possibly because I read that OS X doesn't support
mysql already."
Back to top
View user's profile Send private message
delovski



Joined: 14 Jun 2006
Posts: 3522
Location: Zagreb

PostPosted: Mon Sep 20, 2010 9:39 pm    Post subject: Reply with quote

mf - How to connect mysql remote database from iphone

"Here's a blog post where someone has listed the steps to build libmysql
for iPhone. It should be exactly what you need.
...
If you want to save yourself the trouble of having to compile the static lib-
rary yourself, I have a 6 way fat version as part of my MysqlConnector for
Objective-C. You can find more details on my blog."
Back to top
View user's profile Send private message Visit poster's website
delovski



Joined: 14 Jun 2006
Posts: 3522
Location: Zagreb

PostPosted: Fri Oct 22, 2010 10:47 pm    Post subject: Reply with quote

MF - MySQL connector in Xcode

"Objective C is built on top of C and there are native OSX libraries for My-
SQL, so just include it like you would with the normal MySQL library. You
can probably practically read the instructions for using MySQL with GCC
and be good to go..."
Back to top
View user's profile Send private message Visit poster's website
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Wed Aug 03, 2011 7:29 pm    Post subject: Reply with quote

slashdot - Installation of MySQL server on Mac OS X Lion

"1) Download the latest 64-Bit DMG Archive (Apple Disk Image) from MySQL
Site...
2) ..."
Back to top
View user's profile Send private message
delovski



Joined: 14 Jun 2006
Posts: 3522
Location: Zagreb

PostPosted: Thu Nov 05, 2015 7:01 pm    Post subject: Reply with quote

cp - Accessing: MySQL Database using MySQL C API

"Today MySQL database is the world's most popular open source database
because of its fast performance, high reliability, ease of use, and dramatic
cost savings.

It is very popular in UNIX hosting packages available in all world, then in this
article, I will show how you can access this very powerful relational database
system.

We will encapsulate the provided MySQL C API in a set of C++ classes, and
in the next article, I will use these same classes to do the same thing in
PostgreSQL.

Well, by now let?s start with MySQL."
Back to top
View user's profile Send private message Visit poster's website
delovski



Joined: 14 Jun 2006
Posts: 3522
Location: Zagreb

PostPosted: Thu Nov 05, 2015 7:01 pm    Post subject: Reply with quote

cs.wichita.edu - MySQL C API by Example

"I see that lots of c/c++ authors are looking for MySQL API examples in
c/c++. So I thought to make MySQL C API examples in this web site. And
in near future I will publish this as book with a full web system as bonus."


Last edited by delovski on Fri Nov 20, 2015 10:49 pm; edited 1 time in total
Back to top
View user's profile Send private message Visit poster's website
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Wed Nov 18, 2015 11:44 pm    Post subject: Reply with quote

mysql.com - MySQL 5.5 Reference Manual

"Chapter 2 Installing and Upgrading MySQL

2.1 General Installation Guidance
2.2 Installing MySQL on Unix/Linux Using Generic Binaries
2.3 Installing MySQL on Microsoft Windows
2.4 Installing MySQL on OS X
2.5 Installing MySQL on Linux
2.6 Installing MySQL Using Unbreakable Linux Network (ULN)
2.7 Installing MySQL on Solaris and OpenSolaris
2.8 Installing MySQL on FreeBSD
2.9 Installing MySQL from Source
2.10 Postinstallation Setup and Testing
2.11 Upgrading or Downgrading MySQL
2.12 Environment Variables
2.13 Perl Installation Notes"
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Wed Nov 18, 2015 11:49 pm    Post subject: Reply with quote

mysql.com - 2.4 Installing MySQL on OS X

"2.4.1 General Notes on Installing MySQL on OS X
2.4.2 Installing MySQL on OS X Using Native Packages
2.4.3 Installing a MySQL Launch Daemon
2.4.4 Installing and Using the MySQL Preference Pane"
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Sat Nov 21, 2015 2:56 am    Post subject: Reply with quote

4.7.2 mysql_config ? Display Options for Compiling Clients

"mysql_config provides you with useful information for compiling your
MySQL client and connecting it to MySQL. It is a shell script, so it is available
only on Unix and Unix-like systems."
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Fri Nov 27, 2015 12:46 am    Post subject: Reply with quote

https://code.google.com/p/mysql-cocoa-framework/downloads/list

This program is a standard API for connecting Cocoa applications to MySQL.

The codebase was originally written by Serge Cohen and found at https://sourceforge.net/projects/mysql-cocoa/. He seems to have abandoned the project. The latest release of the project was in February 2006 and there was for PPC only. I wanted to make sure there was a Universal Binary version was available to anyone who wanted to use this library. It's a Universal Binary with support for PPC, PPC64, i386, and x86_64.
Back to top
View user's profile Send private message
delovski



Joined: 14 Jun 2006
Posts: 3522
Location: Zagreb

PostPosted: Sat May 21, 2016 6:18 pm    Post subject: Reply with quote

so - dyld: Library not loaded: libmysqlclient.18.dylib

"dyld: Library not loaded: libmysqlclient.18.dylib

trying:

sudo ln -s /usr/local/mysql/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib

I got:

ln: /usr/lib/libmysqlclient.18.dylib: Operation not permitted"
Back to top
View user's profile Send private message Visit poster's website
delovski



Joined: 14 Jun 2006
Posts: 3522
Location: Zagreb

PostPosted: Wed Dec 28, 2016 4:52 pm    Post subject: Reply with quote

github - mysql_store_use_result_stmt_cursor.c

"mysql api example, include store_result, use_result, stmt, server cursor,
fetch row setting"
Back to top
View user's profile Send private message Visit poster's website
delovski



Joined: 14 Jun 2006
Posts: 3522
Location: Zagreb

PostPosted: Wed Dec 28, 2016 5:03 pm    Post subject: Reply with quote

lgallardo - MySQL Prepared statements for C

"Although the book explains how to execute a SQL sentence with prepared
parameters (prepared statements) and how to get data from a query, at the
end you can't see the whole thing together so I decided to post a complete
example.

The important thing here is the fact that there are two special structures from
the MySQL API: param which set the parameters fro the query, and result
which will be used to store the data retrieved from the database."
Back to top
View user's profile Send private message Visit poster's website
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Fri Jul 31, 2020 8:00 pm    Post subject: Reply with quote

Official - Chapter 23 Connectors and APIs

23.8 MySQL C API

... 23.8.8 C API Prepared Statements
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Fri Jul 31, 2020 8:13 pm    Post subject: Reply with quote

Tim Cotten - A Taste of MySQL in C

"This article discusses the type of C code necessary to use the standard MySQL
C library wrappers. Examples are provided in an Ubuntu environment using the
libmysqlclient-dev and libmysqlclient20 packages."
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Tue Aug 11, 2020 7:04 pm    Post subject: Reply with quote

Why doesn't MySQL use the primary key on JOIN plus ORDER?

"I'm never using anything except the primary key in the customer_order table
for ordering, and the primary key in the customer_invoice table for the JOIN.

So then, in the name of all that is good and right, why does it switch to filesort
all of a sudden?! And more importantly, how do I avoid this?"


Code:
SELECT
    corder.id,
    corder.public_id,
    CONCAT(buyer.fname," ",buyer.lname) AS buyer_name,
    ...
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Tue Aug 11, 2020 7:43 pm    Post subject: Reply with quote

Using mysql concat() in WHERE clause?

"select * from table where concat_ws(' ',first_name,last_name) like '%$search_term%';"
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Wed Aug 12, 2020 9:02 am    Post subject: Reply with quote

so - MySQL : Concat in where clause not working

"select * from postal_address where concat(address1, ' ', address2) = 'ABC DEF';"
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Mon Aug 17, 2020 3:13 pm    Post subject: Reply with quote

10.2 Character Sets and Collations in MySQL

mysql> SHOW CHARACTER SET;

10.3.5 Column Character Set and Collation

Code:
col_name {CHAR | VARCHAR | TEXT} (col_length)
    [CHARACTER SET charset_name]
    [COLLATE collation_name]
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Mon Aug 17, 2020 3:39 pm    Post subject: Reply with quote

https://info.sice.indiana.edu/~dingying/Teaching/I590SQL/order.txt

(script from the book Beginning databases with MySQL)

Found here:

https://info.sice.indiana.edu/~dingying/S511Fall2012.html
https://info.sice.indiana.edu/~dingying/Z511Spring2017.html
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Thu Aug 27, 2020 5:20 pm    Post subject: Reply with quote

Archive - Index of /pub/mysql/

[DIR] Connector-C/ 13-Jan-2015 15:50 1K
[DIR] Connector-C++/ 26-Nov-2014 11:29 1K
[DIR] Connector-J/ 04-Nov-2014 03:00 1K
[DIR] ...
[DIR] MySQL-4.1/ 15-Oct-2013 16:58 1K
[DIR] MySQL-5.0/ 08-Oct-2012 08:32 1K
[DIR] MySQL-5.1/ 06-Nov-2014 11:23 1K
[DIR] MySQL-5.2/ 08-Oct-2012 09:00 1K
[DIR] MySQL-5.4/ 08-Oct-2012 09:00 1K
[DIR] MySQL-5.5/ 27-Nov-2014 04:51 1K
[DIR] MySQL-5.6/ 01-Feb-2015 14:58 1K
[DIR] MySQL-5.7/ 25-Sep-2014 09:05 1K
[DIR] MySQL-6.0/ 08-Oct-2012 08:59 1K
[DIR] ...
[DIR] NT/ 28-Aug-2002 14:01 1K
[DIR] SCO/ 06-Apr-2006 18:27 1K
[DIR] Win32/ 01-Feb-2007 04:54 1K
[DIR] eventum/ 08-Oct-2012 08:46 1K
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Thu Aug 27, 2020 6:42 pm    Post subject: Reply with quote

git - OHMySQL

"The library supports Objective-C and Swift, iOS and macOS. You can connect to
your remote MySQL database using OHMySQL API. It allows you doing queries
in easy and object-oriented way. Common queries such as SELECT, INSERT,
DELETE, JOIN are wrapped by Objective-C code and you don't need to dive into
MySQL C API."


git - mysql-ios

"This repo is a convenience project for building mysql for iOS (in particular
mysqlclient). It contains the mysql source at version 8.0.12 and generated
or modified XCode project for building mysqlclient for iOS."
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Fri Aug 28, 2020 10:21 pm    Post subject: Reply with quote

Resetting MySQL Root Password on Mac OS

"Here's the text for the temporary password that you can search on your mac.
[Note] A temporary password is generated for root@localhost: rt4rvI,%lfr<"
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Wed Sep 30, 2020 3:28 pm    Post subject: Reply with quote

so - c program to add a user to mysql

"You can however use the mysql_change_user() call of the API.

syntax:

my_bool mysql_change_user(MYSQL *mysql, const char *user, const char *password, const char *db)

More info in the respective api description here, it's implemented since MySQL 3.23.3."
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Mon Oct 05, 2020 1:59 pm    Post subject: Reply with quote

so - How to get next/previous record in MySQL?

"next record:

SELECT * FROM foo WHERE id > 4 ORDER BY id LIMIT 1;

previous record:

SELECT * FROM foo WHERE id < 4 ORDER BY id DESC LIMIT 1;"
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Thu Oct 15, 2020 4:02 pm    Post subject: Reply with quote

git - krglaws / 3rd-Place

"Basic HTTP server + frontend

My end goal is to have something like a text only reddit. For now it can only
handle GET requests."
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Mon Dec 14, 2020 9:34 pm    Post subject: Reply with quote

r - How to check if indexes are created correctly

"Use:
> SHOW INDEXES FROM table_name;
To list the indexes.
Use:
> EXPLAIN the_query;
To check if your query utilize the indexes;"
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Fri Feb 12, 2021 5:27 pm    Post subject: Reply with quote

so - Proper place to store description about a MySQL database

"Is there a proper place to store a high level description of a database?"
"Comment metadata is not available for MySQL databases, but you can
create a table to store some comments: (I have this table in a generic tools
database)"
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Sat Feb 27, 2021 6:11 pm    Post subject: Reply with quote

MySQL C API Handle TEXT field

"... how to be with TEXT fields where data length can vary from small sizes to
megabytes?"


"Accomplish this ... Before invoking mysql_stmt_fetch() to retrieve individual
rows, pass STMT_ATTR_UPDATE_MAX_LENGTH to mysql_stmt_attr_set(), then
invoke mysql_stmt_store_result() to buffer the entire result on the client side.
Setting the STMT_ATTR_UPDATE_MAX_LENGTH attribute causes the maximal
length of column values to be indicated by the max_length member of the
result set metadata returned by mysql_stmt_result_metadata()."


Code:
my_bool  aBool = 1;

mysql_stmt_attr_set (stmt, STMT_ATTR_UPDATE_MAX_LENGTH, &aBool);
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Mon Mar 08, 2021 5:10 pm    Post subject: Reply with quote

so - Troubleshooting 'Illegal mix of collations' error in mysql

"This is generally caused by comparing two strings of incompatible collation or
by attempting to select data of different collation into a combined column.

Your solution is to specify a shared collation for the two columns within the
query. Here is an example that uses the COLLATE clause. Another option is to
use the BINARY operator"


Code:
WHERE 'A' COLLATE latin1_general_ci = 'A' COLLATE latin1_general_cs;
SELECT * FROM table ORDER BY key COLLATE latin1_general_ci;
SELECT * FROM table WHERE BINARY a = BINARY b;
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Tue Mar 23, 2021 9:45 pm    Post subject: Reply with quote

r - MySQL Database, User/Password Creator

"This Script helps you to create a new MySQL database with specific user
and password with just a single command."
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Fri Mar 26, 2021 6:59 pm    Post subject: Reply with quote

arctype.com - Search MySQL Like Google Using Match and Full-Text Search

"You can have Google-like superpowers to find words and phrases across your
entire database. Search engines use Full-Text Search to find results in data-
bases. These databases often contain a lot of textual data."

Code:
MATCH (column1,column2,column3...) AGAINST (expression [search_modifier])
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Sat Sep 25, 2021 12:51 pm    Post subject: Reply with quote

r - A single person answered 76k questions about SQL on
StackOverflow. Averaging 22.8 answers per day, every day,
for the past 8.6 years.


"He also literally wrote a book on SQL. Several of them, actually. And on
datamining as well."
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Sat Oct 09, 2021 10:23 am    Post subject: Reply with quote

jetbrains - DataGrip - Many databases, one tool

"Meet DataGrip, our new database IDE that is tailored to suit the specific needs
of professional SQL developers.
Allows you to execute queries in different modes and provides a local history
that keeps track of all your activity and protects you from losing your work.
DataGrip provides context-sensitive code completion, helping you to write SQL
code faster. Completion is aware of the tables structure, foreign keys, and even
database objects created in code you're editing."
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Tue Nov 16, 2021 10:29 pm    Post subject: Reply with quote

https://dev.mysql.com/doc/refman/8.0/en/integer-types.html

https://downloads.mysql.com/archives/c-c/
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Wed Nov 17, 2021 12:03 am    Post subject: Reply with quote

so - Signed or unsigned in MySQL

"Warning, there is an issue with Unsigned Int (UINT) and Entity Framework or ADO.NET. It might involve an integration problem by MySql Connector version 6."
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Wed Dec 01, 2021 9:22 pm    Post subject: Reply with quote

https://dev.mysql.com/doc/refman/8.0/en/macos-installation-pkg.html

https://downloads.mysql.com/archives/community/
Back to top
View user's profile Send private message
Ike
Kapetan


Joined: 17 Jun 2006
Posts: 2528
Location: Europe

PostPosted: Tue Jan 04, 2022 10:12 pm    Post subject: Reply with quote

so - Easiest way to copy a table from one database to another?

Code:
INSERT INTO database2.table2 SELECT * from database1.table1
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Igor Delovski Board Forum Index -> General Programming All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Delovski.hr
Powered by php-B.B. © 2001, 2005 php-B.B. Group