Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to use gcc to build mysql database tables in batches". In daily operation, I believe many people have doubts about how to use gcc to build mysql database tables in batches. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "how to use gcc to build mysql database tables in batches". Next, please follow the editor to study!

My.c

/ /-

/ / MySQL Database Create 1/13/2001. Netkiller Chen

/ /-

# include

# include

Main ()

{

Char host [16]; / / mysql host address.

Char sid [15]; / / root user name.

Char pwd [15]; / / root password.

/ * char * table_file [] = {

"gsxx"

"bcxx"

"fgxx"

"hmbxx"

"ltxx"

NULL

}; * /

/ / char * mysql

Char mydatabase [256]

Char mysqltable [256]

Int i

Int max_table_num

Int db,status

ITunes 0

Max_table_num=4; / / max_table_num

System ("clear")

Showme (); printf ("")

Printf ("MySQL host:"); scanf ("% s", host)

Printf ("Root user:"); scanf ("% s", sid)

Printf ("Password:"); scanf ("% s", pwd)

Printf ("Loading.")

While (table_ file [I]) {

Sprintf (mydatabase, "echo" create database% s "| mysql-h% s-u% s-p% s", table_ file [I], host,sid,pwd)

Sprintf (mysqltable, "mysql-h% s-u% s-p% s% s

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.