~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

Specifies the number of times the utility should execute\&. This is 1 when this option is not specified, but if you do use the option, you must supply an integer argument for it\&.

.RE

.sp

.RS 4

.ie n \{\

\h'-04'\(bu\h'+03'\c

.\}

.el \{\

.sp -1

.IP \(bu 2.3

.\}

.\" ndb_show_tables: parsable option

.\" parsable option: ndb_show_tables

\fB\-\-parsable\fR,

\fB\-p\fR

.sp

Using this option causes the output to be in a format suitable for use with

LOAD DATA INFILE\&.

100

.RE

101

.sp

102

.RS 4

103

.ie n \{\

104

\h'-04'\(bu\h'+03'\c

105

.\}

106

.el \{\

107

.sp -1

108

.IP \(bu 2.3

109

.\}

110

.\" ndb_show_tables: show-temp-status option

111

.\" show-temp-status option: ndb_show_tables

112

\fB\-\-show\-temp\-status\fR

113

.sp

114

If specified, this causes temporary tables to be displayed\&.

115

.RE

116

.sp

117

.RS 4

118

.ie n \{\

119

\h'-04'\(bu\h'+03'\c

120

.\}

121

.el \{\

122

.sp -1

123

.IP \(bu 2.3

124

.\}

125

.\" ndb_show_tables: type option

126

.\" type option: ndb_show_tables

127

\fB\-\-type\fR,

128

\fB\-t\fR

129

.sp

130

Can be used to restrict the output to one type of object, specified by an integer type code as shown here:

131

.sp

132

.RS 4

133

.ie n \{\

134

\h'-04'\(bu\h'+03'\c

135

.\}

136

.el \{\

137

.sp -1

138

.IP \(bu 2.3

139

.\}

140

\fB1\fR: System table

141

.RE

142

.sp

143

.RS 4

144

.ie n \{\

145

\h'-04'\(bu\h'+03'\c

146

.\}

147

.el \{\

148

.sp -1

149

.IP \(bu 2.3

150

.\}

151

\fB2\fR: User\-created table

152

.RE

153

.sp

154

.RS 4

155

.ie n \{\

156

\h'-04'\(bu\h'+03'\c

157

.\}

158

.el \{\

159

.sp -1

160

.IP \(bu 2.3

161

.\}

162

\fB3\fR: Unique hash index

163

.RE

164

.RS 4

165

Any other value causes all

166

NDB

167

database objects to be listed (the default)\&.

168

.RE

169

.sp

170

.RS 4

171

.ie n \{\

172

\h'-04'\(bu\h'+03'\c

173

.\}

174

.el \{\

175

.sp -1

176

.IP \(bu 2.3

177

.\}

178

.\" ndb_show_tables: unqualified option

179

.\" unqualified option: ndb_show_tables

180

\fB\-\-unqualified\fR,

181

\fB\-u\fR

182

.sp

183

If specified, this causes unqualified object names to be displayed\&.

184

.RE

185

.if n \{\

186

.sp

187

.\}

188

.RS 4

189

.it 1 an-trap

190

.nr an-no-space-flag 1

191

.nr an-break-flag 1

192

.br

193

.ps +1

194

\fBNote\fR

195

.ps -1

196

.br

197

.PP

198

Only user\-created Cluster tables may be accessed from MySQL; system tables such as

199

SYSTAB_0

200

are not visible to

201

\fBmysqld\fR\&. However, you can examine the contents of system tables using

202

NDB

203

API applications such as

204

\fBndb_select_all\fR

205

(see

206

\fBndb_select_all\fR(1))\&.

207

.sp .5v

208

.RE

209

.SH "COPYRIGHT"

210

.br

211

.PP

212

213

.PP

214

This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.

215

.PP

216

This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

217

.PP

218

You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.

219

.sp

220

.SH "SEE ALSO"

221

For more information, please refer to the MySQL Reference Manual,

222

which may already be installed locally and which is also available

223

online at http://dev.mysql.com/doc/.

224

.SH AUTHOR

225

Sun Microsystems, Inc. (http://www.mysql.com/).

Older »