File: create_table.txt

package info (click to toggle)
gnuais 0.3.3-9.2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 608 kB
  • sloc: ansic: 5,790; sql: 33; makefile: 4; sh: 3
file content (13 lines) | stat: -rw-r--r-- 374 bytes parent folder | download | duplicates (6)
1
2
3
4
5
6
7
8
9
10
11
12
13
If you have mysql installed and mysqld running you can:

Make new database (if needed) with command:
  mysqladmin create <databasename>

You can also use any existing database adding table 'ais':
  mysql <databasename>  < create_table.sql
  
Or if you have specified username and password for your database:
  mysql -u <username> -p <databasename>  < create_table.sql